The first error seems to be related to the second - for whatever
reason JDBC connection fails (and DB2 is at its best not telling why).
I don't have a specific advice, as this can be any number of things
(including permissions, etc.). Try connecting from JDBC, bypassing
Cayenne and see if you can get more info on why it fails.
Andrus
On Aug 1, 2006, at 4:49 AM, Nikolai Raitsev wrote:
> Hello all,
>
> I have a problem running Cayenne with DB2 UDB
>
> I have a following code:
>
> Setting connection properties:
>
> ///
> DataSource dataSource = new PoolManager("com.ibm.db2.jcc.DB2Driver",
> "jdbc:db2://sunlinuxdb2:60000/testjdb", 1, 1, "NRA", "xxx");
> Configuration config = Configuration.getSharedConfiguration();
> DataDomain dataDomain = config.getDomain();
>
> DataNode dataNode = dataDomain.getNode("DPVWNode");
> dataNode.setDataSource(dataSource);
>
> ///
>
> Getting DataContext:
> //
> dataContext = DataContext.createDataContext();
>
> ///and now run a query:
>
> SelectQuery selQueryInterface = new SelectQuery("TestClass");
> dataObjectsInInterface = new DataObjectList(dataContext.performQuery
> (selQueryInterface));
>
>
> On performQuery i get an exception:
> INFO QueryLogger: --- will run 1 query.
> Exception in thread "main"
> org.objectstyle.cayenne.CayenneRuntimeException:
> [v.1.2RC1 May 31 2006] Error detecting database type
> at org.objectstyle.cayenne.dba.AutoAdapter.loadAdapter
> (AutoAdapter.java
> :196)
> at org.objectstyle.cayenne.dba.AutoAdapter.getAdapter
> (AutoAdapter.java
> :166)
> at org.objectstyle.cayenne.dba.AutoAdapter.getExtendedTypes(
> AutoAdapter.java:276)
> at org.objectstyle.cayenne.access.DataNode.performQueries
> (DataNode.java
> :282)
> at org.objectstyle.cayenne.access.DataDomainQueryAction.runQuery(
> DataDomainQueryAction.java:355)
>
> ... more exceptions
>
> if i set explicitely a DB2-Adapter like this:
>
> DataNode dataNode = dataDomain.getNode("DPVWNode");
> dataNode.setAdapter(new org.objectstyle.cayenne.dba.db2.DB2Adapter());
> dataNode.setDataSource(dataSource);
>
> i get an exception again:
>
> INFO QueryLogger: --- will run 1 query.
> Exception in thread "main" INFO QueryLogger: *** error.
> com.ibm.db2.jcc.b.SQLException
> at com.ibm.db2.jcc.b.l.a(l.java:1469)
> at com.ibm.db2.jcc.a.bb.h(bb.java:541)
> at com.ibm.db2.jcc.a.bb.g(bb.java:443)
> at com.ibm.db2.jcc.a.bb.d(bb.java:276)
> at com.ibm.db2.jcc.a.bb.d(bb.java:90)
> at com.ibm.db2.jcc.a.b.a(b.java:935)
> at com.ibm.db2.jcc.a.b.a(b.java:450)
> at com.ibm.db2.jcc.a.b.a(b.java:293)
> at com.ibm.db2.jcc.a.b.<init>(b.java:207)
> at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:244)
> at org.objectstyle.cayenne.conn.DriverDataSource.getConnection(
> DriverDataSource.java:151)
> ..... more exceptions
>
> at application.run.Run.main(Run.java:167)
> org.objectstyle.cayenne.CayenneRuntimeException: [v.1.2RC1 May 31
> 2006]
> Global exception.
> at
> org.objectstyle.cayenne.access.DataDomainQueryAction.nextGlobalExcepti
> on(
> DataDomainQueryAction.java:486)
> at org.objectstyle.cayenne.access.DataNode.performQueries
> (DataNode.java
> :297)
> at org.objectstyle.cayenne.access.DataDomainQueryAction.runQuery(
> DataDomainQueryAction.java:355)
>
> ...more excepions
>
> what is a problem here?
>
> i run cayenne with 4 DBMS (MySQL, DB2/As400, Oracle, SQL Server)
> without
> problems...
>
> thanks, and best regards,
>
> Nikolai
This archive was generated by hypermail 2.0.0 : Tue Aug 01 2006 - 09:35:25 EDT