Difference between revisions of "Connecting To AS400 / iSeries"

From PresenceWiki
Jump to: navigation, search
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
com.ibm.as400.access.AS400JDBCDriver
+
{{DatabaseConnectivityHeader}}
  
which can be found in the jt400.jar which is included in the presence install
 
  
 +
The settings for your AS400 Database Resource in Presence should be:-
  
connection url, eg:-
+
[[file:as400details.png]]
 
+
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:-
 
Note, the driver class is:-
com.microsoft.sqlserver.jdbc.SQLServerDriver
+
com.ibm.as400.access.AS400JDBCDriver
  
This can be found in the sqljdbc.jar (or sqljdbc4.jar for Java version 6 which Presence 3.5.5 uses).
+
Which can be found in the jt400.jar which is included in the presence install
  
These jars can in turn be found in the Microsoft SQL Server 2005 driver for JDBC which can be downloaded from:-
+
The connection URL takes the form:-
http://www.microsoft.com/downloads/
+
jdbc:as400://192.168.65.18;prompt=false;translate binary=true
  
Import the jar via Presence - Tools - Jar Manager and then browse to the SQLServerDriver class.
+
prompt=false tells it <b>not</b> to pop up a connection dialog (which is often undesired) if it can't connect.
  
The connection URL takes the form:-
+
For an extensive list of properties see:-
jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
+
  
Note if you are using Microsoft SQL Server 2000 driver for JDBC then the driver class is
+
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html
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:-
 
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  
+
[[file:as400connect.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/sqlresults.png  
+
[[file:as400results.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
+
{{DatabaseConnectivityHeader}}
location of a class.
+

Latest revision as of 13:21, 21 August 2015

Database Connectivity > Connecting To AS400 / iSeries


The settings for your AS400 Database Resource in Presence should be:-

As400details.png

Note, the driver class is:- com.ibm.as400.access.AS400JDBCDriver

Which can be found in the jt400.jar which is included in the presence install

The connection URL takes the form:- jdbc:as400://192.168.65.18;prompt=false;translate binary=true

prompt=false tells it not to pop up a connection dialog (which is often undesired) if it can't connect.

For an extensive list of properties see:-

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html

After hitting test and using the correct username and password you should see the following:-

As400connect.png

You can then use the Resource withing Presence in the SQL node.

As400results.png


Database Connectivity > Connecting To AS400 / iSeries