Connecting to UDB (DB2)

Home for older / inactive topics

Connecting to UDB (DB2)

Postby Jan Aleman » Mon May 22, 2006 3:44 pm

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:
Attachments
Picture 19.png
UDB, DB2 jdbc configuration connection
Picture 19.png (45 KiB) Viewed 10950 times
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Postby vincent » Wed May 24, 2006 2:50 am

Thanks :)
vincent
 
Posts: 16
Joined: Thu Apr 20, 2006 10:57 am
Location: malaysia

DB2 connection

Postby roberto » Sat Jun 03, 2006 1:29 pm

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
roberto
 
Posts: 8
Joined: Fri May 28, 2004 1:09 pm

Re: DB2 connection

Postby Jan Aleman » Sat Jun 03, 2006 5:27 pm

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?
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

DB2

Postby roberto » Mon Jun 05, 2006 12:22 am

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
roberto
 
Posts: 8
Joined: Fri May 28, 2004 1:09 pm

Postby Jan Aleman » Mon Jun 05, 2006 6:34 pm

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.
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Thanks

Postby roberto » Mon Jun 05, 2006 11:10 pm

Thanks Jan,
I try immediately, then I post something.
Rob
roberto
 
Posts: 8
Joined: Fri May 28, 2004 1:09 pm


Return to Archive

Who is online

Users browsing this forum: No registered users and 0 guests