0 Replies Latest reply on Apr 25, 2005 6:59 PM by sudhir

    schema name in  hibernate-service.xml.

    sudhir Newbie

      Im trying to setup hibernate as a service injboss 4.0.1 (db2) Is there a way to specify schema name in hibernate-service.xml? I have hibernate-service.xml as follows.


      java:/DLWSDS
      net.sf.hibernate.dialect.DB2Dialect
      java:/hibernate/SessionFactory
      net.sf.hibernate.cache.HashtableCacheProvider
      <!-- create-drop -->



      The error i get is

      Caused by: com.ibm.db2.jcc.b.SQLException: "IFMXSQL.CUSTOMER" is an undefined n
      me.
      at com.ibm.db2.jcc.b.ce.e(ce.java:1093)
      at com.ibm.db2.jcc.b.ce.a(ce.java:869)
      at com.ibm.db2.jcc.a.bd.g(bd.java:125)
      at com.ibm.db2.jcc.a.bd.a(bd.java:40)
      at com.ibm.db2.jcc.a.r.a(r.java:31)
      at com.ibm.db2.jcc.a.bp.g(bp.java:141)
      at com.ibm.db2.jcc.b.ce.h(ce.java:853)
      at com.ibm.db2.jcc.b.cf.G(cf.java:1185)
      at com.ibm.db2.jcc.b.cf.a(cf.java:1497)
      at com.ibm.db2.jcc.b.cf.executeQuery(cf.java:303)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer
      (WrappedPreparedStatement.java:296)
      at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87)
      at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
      at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
      at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollection
      (Loader.java:133)
      at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
      at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
      at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
      at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)


      The problem with this is that although IFMXSQL is the username in the datasource. this is not the schema name. This can be set in hibernate, Can anyonepoint me to the dtd for hibernate-service.xml .
      thanks in advance