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 #56883] |
Tue, 09 June 2009 10:16  |
Eclipse User |
|
|
|
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
|
|
|
| Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #56993 is a reply to message #56883] |
Wed, 17 June 2009 17:43  |
| Eclipse User |
|
|
|
I haven't tried DB2 Everyplace before, but I was able to get it
installed and was able to reproduce the "(0 rows affected)" problem on
both DTP 1.6.2 and 1.7. (Thanks for the tip about
ENABLE_SHARED_DATABASE_ACCESS=true; I didn't know about that.)
Please open a bug report for this in Bugzilla,
https://bugs.eclipse.org/bugs/enter_bug.cgi
DataTools project, component SQL Results View.
Wolfgang Röckelein wrote:
> 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
|
|
| | | |
| Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #595969 is a reply to message #56883] |
Wed, 17 June 2009 17:43 |
| Eclipse User |
|
|
|
I haven't tried DB2 Everyplace before, but I was able to get it
installed and was able to reproduce the "(0 rows affected)" problem on
both DTP 1.6.2 and 1.7. (Thanks for the tip about
ENABLE_SHARED_DATABASE_ACCESS=true; I didn't know about that.)
Please open a bug report for this in Bugzilla,
https://bugs.eclipse.org/bugs/enter_bug.cgi
DataTools project, component SQL Results View.
Wolfgang Röckelein wrote:
> 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
|
|
| | | |
Goto Forum:
Current Time: Wed Apr 30 16:20:31 EDT 2025
Powered by FUDForum. Page generated in 0.08890 seconds |
Home