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 #56883] Tue, 09 June 2009 14:16 Go to next message
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
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 21:43 Go to previous messageGo to next message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
Registered: July 2009
Senior Member
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 #57075 is a reply to message #56993] Mon, 22 June 2009 06:03 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Brian Payton wrote:
> 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.

https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030
Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #57180 is a reply to message #56993] Mon, 29 June 2009 07:59 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Hi,

Brian Payton wrote:
> 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.

https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030

Do you have an idea where the problem originates?

Can I do something to aid in diagnosing this problem?

Thanks,
Wolfgang
Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #498537 is a reply to message #57180] Tue, 17 November 2009 11:51 Go to previous message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Wolfgang Röckelein wrote:
> Brian Payton wrote:
>> 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.)
>>
>
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030
>
> Do you have an idea where the problem originates?
>
> Can I do something to aid in diagnosing this problem?

any news on this?

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 21:43 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 152
Registered: July 2009
Senior Member
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 #595997 is a reply to message #56993] Mon, 22 June 2009 06:03 Go to previous message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Brian Payton wrote:
> 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.

https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030
Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #596028 is a reply to message #56993] Mon, 29 June 2009 07:59 Go to previous message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Hi,

Brian Payton wrote:
> 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.

https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030

Do you have an idea where the problem originates?

Can I do something to aid in diagnosing this problem?

Thanks,
Wolfgang
Re: Problems with db2e access with DTP 1.6.2 on Windows through Generic JDBC [message #596792 is a reply to message #57180] Tue, 17 November 2009 11:51 Go to previous message
Eclipse UserFriend
Originally posted by: w.roeckelein.begis.com

Wolfgang Röckelein wrote:
> Brian Payton wrote:
>> 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.)
>>
>
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=281030
>
> Do you have an idea where the problem originates?
>
> Can I do something to aid in diagnosing this problem?

any news on this?

Thanks,
Wolfgang
Previous Topic:looking for connectivity.ui.dse.1.1.1v2008
Next Topic:Is there an ODA datasource visualizer available?
Goto Forum:
  


Current Time: Wed Nov 26 06:38:06 GMT 2014

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

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