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
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3875340#3875340
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3875340
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
