Establish connection to db2 using the jt400.jar

Question

I have tried using the db2jcc.jar and I successfully establish connection to db2 but now I am trying to use the jt400.jar

I have tried to use the driver com.ibm.db2.jdbc.app.DB2Driver but I keep getting the class not found exception.

I tried using the com.ibm.as400.access.AS400JDBCDriver but I can't establish connection.

Can anyone help me or provide a sample code with the connection string connecting to a db2 with jt400.jar.

Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Properties prop = new Properties();

prop.setProperty("user", "current");
prop.setProperty("password", "current");

con = DriverManager.getConnection("jdbc:as400://server/database", prop);

What exception do you get? Are you connecting to an IBM i? Have you started the hosts servers on the IBM i? — jweberhard, Feb 10 '15 at 00:20
i keep getting the java.net.ConnectException: Connection refused: connect. I have a db2 database installed in my pc. I have successfully connected to my db2 using the db2jcc.jar but now I want to try to connect to my db2 using the jt400.jar. — aeycee, Feb 10 '15 at 03:08
jt400.jar can only connect to DB2 on IBM i (aka AS/400). It does not connect to DB2 for windows, unix, linux, or z. — jweberhard, Feb 11 '15 at 12:31

score 8 · Accepted Answer · answered Mar 31 '15 at 09:12

8

I use this code to connect to my db2 database with jt400 :

Class.forName("com.ibm.as400.access.AS400JDBCDriver");
        connection = DriverManager.getConnection(
                "jdbc:as400:" + iseries + ";database name=" + iasp + ";prompt=false;translate binary=true;naming=system", login, password);

For exemple, if I try to connect to the server "server1" and the database "database1", the url is "jdbc:as400:server1;database name=database1;prompt=false;translate binary=true;naming=system"

answered Mar 31 '15 at 09:12

YLombardi

1,755
5
24
45

@YLombardi, the "server1" here has to be an IBM iSeries server? I am asking because I am not able to connect to "DB2 installed on my MacOS using docker". – Pranav Kevadiya Jul 02 '18 at 09:50
@PranavKevadiya, Yes for me it was an IBM iSeries server. – YLombardi Jul 02 '18 at 09:57
Thanks @YLombardi, that answers my question. :) – Pranav Kevadiya Jul 04 '18 at 06:14

score 0 · Answer 2 · answered Jan 12 '16 at 19:39

0

I know I am late to this party but just wanted to point out a tutorial that might aid others when using Spring Framework and connecting to a DB2 dataSource. In my example, I was using Tomcat Server but it should be applicable to other web servers as well. Anyways, I hope this helps: https://avaldes.com/spring-mvc-with-jndi-datasource-for-db2-on-as400-using-tomcat/

answered Jan 12 '16 at 19:39

Amaury Valdes

1

If possible, cite the most relevant parts, even if it's your blog. URL's go down and the knowledge in answers should be preserved. – Johannes Jander Jan 12 '16 at 19:57
Good idea. Will do. – Amaury Valdes Jan 15 '16 at 14:56
` ` – Amaury Valdes Jan 15 '16 at 15:00
You can also set up a configuration bean instead of XML config. – Amaury Valdes Jan 15 '16 at 15:07
`@Configuration public class dataSourceConfiguration { // get config from properties files ... dataSource.setDriverClassName(driverClassName); dataSource.setUrl(url); dataSource.setUsername(username); dataSource.setPassword(password); return dataSource; }` – Amaury Valdes Jan 15 '16 at 15:07

Establish connection to db2 using the jt400.jar

2 Answers2