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

[jyotiva]

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#4100085

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100085