I am testing hibernate with the DB2 Connect JDBC driver from IBM. I am trying to connect to DB2 UDB located on an iSeries (AS/400). Hibernate connects and fetches the data from the database allright, except that it logs a warning while connecting. The warning is:
08:13:25,663 WARN SettingsFactory:103 - Could not obtain connection metadata
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SYSIBM.METADATA;
I only get the error when connecting using hibernate. If I call the JDBC directly and run the same generated query I do not get this error.
I checked in the iSeries, and there is not any object in the SYSIBM library named METADATA is this a possible bug in the DB2Dialect? If anyone could shed any light on this it would be appreciated.
Hibernate version:
3.1
Mapping documents:
Full stack trace of any exception that occurs:
08:13:24,194 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
08:13:24,194 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
08:13:24,194 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
08:13:24,335 INFO DriverManagerConnectionProvider:80 - using driver: com.ibm.db2.jcc.DB2Driver at URL: jdbc:db2://fbmas270:446/FBMAS270
08:13:24,335 INFO DriverManagerConnectionProvider:83 - connection properties: {user=jfrankman, password=xyz123}
08:13:24,335 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
08:13:24,335 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
08:13:25,491 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:db2://fbmas270:446/FBMAS270, Isolation Level: 2
08:13:25,491 INFO SettingsFactory:77 - RDBMS: AS, version: V05R02M00
08:13:25,491 INFO SettingsFactory:78 - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 2.7.58
08:13:25,647 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
08:13:25,663 WARN SettingsFactory:103 - Could not obtain connection metadata
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SYSIBM.METADATA;
at com.ibm.db2.jcc.a.hd.d(hd.java:1392)
at com.ibm.db2.jcc.c.jb.l(jb.java:366)
at com.ibm.db2.jcc.c.jb.e(jb.java:102)
at com.ibm.db2.jcc.c.w.e(w.java:72)
at com.ibm.db2.jcc.c.cc.i(cc.java:202)
at com.ibm.db2.jcc.a.hd.q(hd.java:1359)
at com.ibm.db2.jcc.a.id.d(id.java:2336)
at com.ibm.db2.jcc.a.jd.X(jd.java:188)
at com.ibm.db2.jcc.a.t.ge(t.java:8266)
at com.ibm.db2.jcc.a.t.c(t.java:8184)
at com.ibm.db2.jcc.a.t.supportsResultSetType(t.java:5172)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:80)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1004)
at com.idfbins.service.dao.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:40)
at com.idfbins.service.dao.hibernate.ClientDAO.findByQuery(ClientDAO.java:171)
at com.idfbins.service.dao.hibernate.ClientDAO.findPolicyHoldersByName(ClientDAO.java:96)
at com.idfbins.jamestests.TestClientServices.main(TestClientServices.java:31)
08:13:25,913 INFO Dialect:92 - Using dialect: org.hibernate.dialect.DB2400Dialect
Name and version of the database you are using:
DB2 UDB 400 V5R2
|