I have an application based on springs and hibernate, which is working fine with Mysql database on
jboss 4.0.3. I am trying to change the database from mysql to postgres. The database porting has been successful and i have generted the hibernate files. Jboss configuration has also been modified w.r.t the newdatabase. When i start the jboss, i get the following error:
11:25:31,115 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42703
11:25:31,115 ERROR [JDBCExceptionReporter] ERROR: column usersadapt0_.user_id do
es not exist
11:25:31,130 INFO [STDOUT] org.springframework.orm.hibernate3.HibernateJdbcExce
ption: JDBC exception on Hibernate data access; nested exception is org.hibernat
e.exception.SQLGrammarException: could not execute query
11:25:31,130 INFO [STDOUT] Caused by:
11:25:31,130 INFO [STDOUT] org.hibernate.exception.SQLGrammarException: could n
ot execute query
the above column exists in the database..but it is not able to recognize.
I have - postgres 8.3
Postgres driver PostgreSQL 7.4 JDBC3 with SSL (build 210)
The 8.3 driver is giving some error.