0 Replies Latest reply on Oct 30, 2007 3:07 AM by jyoti Venkatesh

    jboss with postgres database using hibernate and spring

    jyoti Venkatesh Newbie

      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.