-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: DB2 UDB: SYSIBM.METADATA not found.
PostPosted: Fri Aug 18, 2006 10:25 am 
Newbie

Joined: Wed Jan 11, 2006 12:59 pm
Posts: 11
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.