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
