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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
