Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC
Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #595939] Tue, 09 June 2009 14:16
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Hi,

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: 9.1.3.0 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?

Thanks,
Wolfgang
Previous Topic:SQLModel doesn't use containment references ?
Next Topic:Unable to connect to a DB2 8.x database
Goto Forum:
  


Current Time: Mon Dec 11 05:57:47 GMT 2017

Powered by FUDForum. Page generated in 0.01249 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software