Hi , I downloaded the latest version and i receive a message stating
could not detemine which hibernate dialect to use to write to the destination DB . pls select .
I am using DB2 .
Pls tell me how to do it .
thanks for ur help .
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry for the delayed response. I haven't added detection
support for any DB2 variant as of yet. There seems to be
three Hibernate dialects for DB2 (DB2, DB2/390 and DB2/400). I'll try to get them for a release tomorrow.
Unfortunately, I don't have access to any of those. I'll see
if I can get DB2 UE express edition installed for testing.
Rob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
By the way, what is the fully qualified class name of the
JDBC driver that you are using to connect to DB2 using
SQuirreL? And which version of DB2 ?(If I know this I can
at least set up DB Copy plugin to auto-detect the dialect
to use)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi , Thank u for ur reply . Sorry could not answer earlier , I was and still on vacation .
for db2 I usually use the following if i have a db2 client
jdbc:db2:database
COM.ibm.db2.jdbc.app.DB2Driver
from
E:\PROGRA~1\IBM\SQLLIB\java\db2java.zip
for thin driver i use
jdbc:db2://server:6789/sample
com.ibm.db2.jcc.DB2Driver
from
E:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar
Hope these info will help you
thks again
amr
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Very well. The latest version of the plugin (0.15) should
now use the DB2 dialect for the driver you listed. I don't
yet have a testbed server for DB2 to be able to run my
battery of tests against.(DB2 Express is not available for
WinXP Home edition). I have a spare linux box, just no
time recently to set up DB2 on it. I'd be interested to
hear of your experiences copying to/from DB2.
Rob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi rob , thank u for ur quick answer . I have downloaded the latest version of dbcopy and i still have the hibernate dialect problem . the only hybernate dialect that shows is the oracle ( i have an ora jar in the class path ) . by the way db2 drivers are included in Squirrel and i can get access without any problem .
Please not as well that db2 java modules are included in all clients available for download from http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_aix5.html#r9a
for tests you can download DB2 personal edition which is free and contains all the functions to test , the only restriction is that u have to have the client and server on the same machine .
thanks again
u can reach me as well on aroushdi@hotmail.com
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have tried the new version . I did not get the hibernate problem , however i got a different problem . It refuses to take "TYPE" as a clolumn . this works fine with Oracle as well as DB2 any ideas .
Thank u again for ur help
amr
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My (uneducated) guess would be that it's getting "TYPE"
as a keyword from the driver. It tries to be smart and
check the column name against the jdbc driver supplied list of keywords for the destination database and abort the copy if the column name is in that list. What's the exception that you are getting in the log? I don't have access to DB2 at the moment - can you look at the keyword list in SQuirreL for a DB2 session to see if TYPE is reported by your driver as a keyword ?
Rob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, this appears to be the case for DB2. "TYPE" is
listed by the jdbc driver as a keyword, however, DB2 is
perfectly happy to accept it as a column name. OK, so
my algorithm for detecting potential column naming problems is flawed. I'll change this behavior to be
configurable in version 0.17. I'll let you know when it's
ready.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Rob Thank u for ur help and kwic response . I tried today the latest version of dbcopy with latest version of squirrel . I cannot access dbcopy it is not int the plugin list not in the options .
thks again
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi , I downloaded the latest version and i receive a message stating
could not detemine which hibernate dialect to use to write to the destination DB . pls select .
I am using DB2 .
Pls tell me how to do it .
thanks for ur help .
Sorry for the delayed response. I haven't added detection
support for any DB2 variant as of yet. There seems to be
three Hibernate dialects for DB2 (DB2, DB2/390 and DB2/400). I'll try to get them for a release tomorrow.
Unfortunately, I don't have access to any of those. I'll see
if I can get DB2 UE express edition installed for testing.
Rob
By the way, what is the fully qualified class name of the
JDBC driver that you are using to connect to DB2 using
SQuirreL? And which version of DB2 ?(If I know this I can
at least set up DB Copy plugin to auto-detect the dialect
to use)
hi , Thank u for ur reply . Sorry could not answer earlier , I was and still on vacation .
for db2 I usually use the following if i have a db2 client
jdbc:db2:database
COM.ibm.db2.jdbc.app.DB2Driver
from
E:\PROGRA~1\IBM\SQLLIB\java\db2java.zip
for thin driver i use
jdbc:db2://server:6789/sample
com.ibm.db2.jcc.DB2Driver
from
E:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar
Hope these info will help you
thks again
amr
Very well. The latest version of the plugin (0.15) should
now use the DB2 dialect for the driver you listed. I don't
yet have a testbed server for DB2 to be able to run my
battery of tests against.(DB2 Express is not available for
WinXP Home edition). I have a spare linux box, just no
time recently to set up DB2 on it. I'd be interested to
hear of your experiences copying to/from DB2.
Rob
Hi rob , thank u for ur quick answer . I have downloaded the latest version of dbcopy and i still have the hibernate dialect problem . the only hybernate dialect that shows is the oracle ( i have an ora jar in the class path ) . by the way db2 drivers are included in Squirrel and i can get access without any problem .
Please not as well that db2 java modules are included in all clients available for download from
http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_aix5.html#r9a
for tests you can download DB2 personal edition which is free and contains all the functions to test , the only restriction is that u have to have the client and server on the same machine .
thanks again
u can reach me as well on aroushdi@hotmail.com
I have tried the new version . I did not get the hibernate problem , however i got a different problem . It refuses to take "TYPE" as a clolumn . this works fine with Oracle as well as DB2 any ideas .
Thank u again for ur help
amr
My (uneducated) guess would be that it's getting "TYPE"
as a keyword from the driver. It tries to be smart and
check the column name against the jdbc driver supplied list of keywords for the destination database and abort the copy if the column name is in that list. What's the exception that you are getting in the log? I don't have access to DB2 at the moment - can you look at the keyword list in SQuirreL for a DB2 session to see if TYPE is reported by your driver as a keyword ?
Rob
Yes, this appears to be the case for DB2. "TYPE" is
listed by the jdbc driver as a keyword, however, DB2 is
perfectly happy to accept it as a column name. OK, so
my algorithm for detecting potential column naming problems is flawed. I'll change this behavior to be
configurable in version 0.17. I'll let you know when it's
ready.
Rob Thank u for ur help and kwic response . I tried today the latest version of dbcopy with latest version of squirrel . I cannot access dbcopy it is not int the plugin list not in the options .
thks again