Connecting to UDB (DB2)

Classic Servoy
1

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:

Picture 19.png
Picture 19.png609×404 33.8 KB

2

Thanks :)

3

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

4

roberto:
“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?

5

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

6

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.

7

Thanks Jan,
I try immediately, then I post something.
Rob