Column Not Found

I am writting this simple code to get the maximum no of value from a column.The code is ResultSet = statement.executeQuery("SELECT MAX(column-name) FROM Table ");but tomcat is showing me an error thatColumn Not FoundWhat is wrong here

[297 byte] By [qasims_1] at [2007-9-26 4:32:11]

«« CORBA ERROR
»» storing image/data in a DB table

# 1

Hi ,

> but tomcat is showing me an error that

?-What u are getting as the error messge is what the DB driver returns to ur java application.Nothin to do with Tomcat.

One way to find the problem is to print the stack trace and the get the SQLException vendor code .And then u can check up with the error message document for ur DB.

Assuming ofcourse that u have already checked the table names,columnnames etc.

kk77 at 2007-6-29 17:46:24 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Column Not Found

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified