Difference between revisions of "Connecting To AS400 / iSeries"
Line 11: | Line 11: | ||
The settings for your SQL Database Resource in Presence should be:- | The settings for your SQL Database Resource in Presence should be:- | ||
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png |
Note, the driver class is:- | Note, the driver class is:- | ||
Line 31: | Line 31: | ||
After hitting test and using the correct username and password you should see the following:- | After hitting test and using the correct username and password you should see the following:- | ||
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/sqlconnect.png |
You can then use the Resource withing Presence in the SQL node. | You can then use the Resource withing Presence in the SQL node. | ||
− | http://www.international-presence.com/images/docs/jdbc/ | + | http://www.international-presence.com/images/docs/jdbc/sqlresults.png |
Presence Version 3.5.4 uses the java 1.5 JVM which in turn will need the sqljdbc.jar | Presence Version 3.5.4 uses the java 1.5 JVM which in turn will need the sqljdbc.jar |
Revision as of 16:15, 12 January 2010
com.ibm.as400.access.AS400JDBCDriver
which can be found in the jt400.jar which is included in the presence install
connection url, eg:-
jdbc:as400://192.168.65.18;prompt=false;translate binary=true
The settings for your SQL Database Resource in Presence should be:-
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png
Note, the driver class is:- com.microsoft.sqlserver.jdbc.SQLServerDriver
This can be found in the sqljdbc.jar (or sqljdbc4.jar for Java version 6 which Presence 3.5.5 uses).
These jars can in turn be found in the Microsoft SQL Server 2005 driver for JDBC which can be downloaded from:- http://www.microsoft.com/downloads/
Import the jar via Presence - Tools - Jar Manager and then browse to the SQLServerDriver class.
The connection URL takes the form:- jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
Note if you are using Microsoft SQL Server 2000 driver for JDBC then the driver class is com.microsoft.jdbc.sqlserver.SQLServerDriver (i.e. the jdbc and the sqlserver are swapped around)
After hitting test and using the correct username and password you should see the following:-
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png
You can then use the Resource withing Presence in the SQL node.
http://www.international-presence.com/images/docs/jdbc/sqlresults.png
Presence Version 3.5.4 uses the java 1.5 JVM which in turn will need the sqljdbc.jar
Presence Version 3.5.5 uses the java 1.6 JVM which in turn uses sqljdbc4.jar
As the Presence Jar Manager caches the classes you should restart the server if you have changed the location of a class.