Page 1 of 1

Connecting to UDB (DB2)

PostPosted: Mon May 22, 2006 3:44 pm
by Jan Aleman
In this example we connect to UDB Express Edition on Windows, but connecting to other version and platforms should work similar.

1. On the machine where UDB is installed copy the files db2java.zip, db2jcc.jar, db2jcc_license_cu.jar. You can find these files in your Java directory of your main UDB install. Copy these files into the drivers directory of your Servoy install and relaunch Servoy.
2. Open your preferences and configure your connection as shown in the image below:

PostPosted: Wed May 24, 2006 2:50 am
by vincent
Thanks :)

DB2 connection

PostPosted: Sat Jun 03, 2006 1:29 pm
by roberto
Ciao,
I configured mu db2 connection exactly in the same way, however I have the following error

"Could not create a validated object"

What does it mean?
Thanks
Roberto

Re: DB2 connection

PostPosted: Sat Jun 03, 2006 5:27 pm
by Jan Aleman
roberto wrote:"Could not create a validated object"

What does it mean?


I have no idea, I havn't seen it before. What version of UDB are you using? On what server? What JDBC drivers?

DB2

PostPosted: Mon Jun 05, 2006 12:22 am
by roberto
The server I need to be connected is the EuResist integrated database runs on a DB2 Viper server, located in the IBM Haifa Research Lab.
To access it, you need to install a DB2 Viper run time client and catalog the remote database as a local one. Then you can use your preferred API (Java, C++, Perl, etc.) to access the database, with the proper permissions.
I usually connect to the db using Aqua Data Studio. Then I copied the db2java.jar db2jcc.jar and db2jcc_license_cu.jar in the driver folder for Servoy. And I had the error.

Since I am working on a predictive model for HIV population dynamics it could be nice to develop a java module for servoy to this purpose.
Ciao
Rob

PostPosted: Mon Jun 05, 2006 6:34 pm
by Jan Aleman
If you are connecting to Viper I recommend downloading the connect pack for it:

http://www-306.ibm.com/software/data/db ... nload.html

apart from the JDBC drivers it will also contain the exact URL/connect string to connect to your database.

Thanks

PostPosted: Mon Jun 05, 2006 11:10 pm
by roberto
Thanks Jan,
I try immediately, then I post something.
Rob