|Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #595939]
||Tue, 09 June 2009 14:16
Originally posted by: w.roeckelein.begis.com|
I was successfully able to connect to a DB2e ( http://www.ibm.com/software/data/db2/everyplace/ )database with DTP 1.6.2 on Windows by
- making the native DLLs available via -Djava.library.path on Eclipse startup parameters
- defining a driver by using Generic JDBC template with the db2ejdbc.jar
- defining a database connection with a correct URL and the option ENABLE_SHARED_DATABASE_ACCESS=true (apparently necessary because DTP make more than one concurrent database connection)
I get the "already loaded in another classloader" on changing the database connection but from other messages here I assume this will be corrected in the future.
The DB2e Version is successfully retrieved as "DB2 Everyplace: 220.127.116.11 BUILD 2008-09-25", but the available technology on the tab says "JDBC: 9.1.0"....
However: when I try to execute eg a select statement, like select * from NOTICATALOG, the execution does not stop
and when I abort it, I get the errors:
select * from NOTICATALOG
[SQLState:42601, error code:-104]
(0 rows affected)
(the last line is repeated over and over again)
42601 means syntax error, if I use a non-existent table, I get 42704 which means table does not exist, so the syntax error can't be with the statement itself IMHO.
With an insert statement, the behavior is the same.
There is nothing in the error log.
What is wrong? What can I do to further diagnose the problem?
Powered by FUDForum
. Page generated in 0.01664 seconds