[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - jboss with postgres database using hibernate and spring

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 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:65) 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. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100085#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...