hi,

i am executing a native sql to get a value.

this query fails the first time i call the web page.

second time, it produces correct result.


List list = session.createSQLQuery(" select max(CAST(substring(p1.part_category_id,9,25) as int)) as {p1.part_category_id} from part_category_master {p1} where p1.part_category_id like 'partcat%' ","p1",part_category_master.class).list();

meaning: substring a field to get integer and then return its max value in table. (so i can create new key)

error message on console is :

Hibernate: select max(CAST(substring(p1.part_category_id,9,25) as int)) as part_category_id0_ from part_category_master p1 where p1.part_category_id like 'partcat%'
WARN [HttpProcessor[8080][4]] (JDBCExceptionReporter.java:38) - SQL Error: 0, SQLState: 42S22
ERROR [HttpProcessor[8080][4]] (JDBCExceptionReporter.java:46) - [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: part_cat2_0_
WARN [HttpProcessor[8080][4]] (JDBCExceptionReporter.java:38) - SQL Error: 0, SQLState: 42S22
ERROR [HttpProcessor[8080][4]] (JDBCExceptionReporter.java:46) - [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: part_cat2_0_
ERROR [HttpProcessor[8080][4]] (JDBCException.java:38) - SQLException occurred
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: part_cat2_0_

where is this part_cat2_0_ coming from the first time ?

is it because of MS Sql , i am using Microsoft driver.

any tips are welcome.

thanks in advance.