Connecting iseries to Oracle using Java program

[Dave Price]

I have been testing a Java program to connect from my iSeries to an Oracle database.
If I hard code the connection string, everything works fine.
If I pass the details of the connection string as parameters and then build the connection string inside the Java program, I receive a driver error.
The hard coded connection string (which works) is..
 

 

 Connection conn = DriverManager.getConnection
    		("jdbc:oracle:thin:@10.65.7.124:1521:XXXRQT","USERID", "Passwd");

When I pass the IP address, sysname, userId & password in, I receive a driver error.
 The Java program is this.....

   import java.sql.*;
    import com.ibm.as400.access.*;
    import java.sql.Clob;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.util.Properties;
    import java.io.*;
    import java.io.File;
    import java.io.FileReader;
    import java.io.FileWriter;
    import java.io.IOException;
    import java.io.PrintWriter;
    import java.util.*;
    import java.lang.*;
    
    class TST19 
    {
      public static void main (String[] args) throws Exception
      {		
    			
    
    
    	String IPad=args[0];
    	String Oserver=args[1] + '"';
    	String UserName='"' +args[2] + '"';
    	String Passw='"' +args[3] + '"';
    	String ID='"' +args[4] + '"';
    	String PortNo= ":1521:";
            String url1= '"' + "jdbc:oracle:thin:@";
            String url2= url1 + IPad + PortNo + Oserver + ',' + UserName + ',' + Passw;
    	
    
     
    
    
    //Let's get a connection to the Oracle server
    
    		DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
    		
    
    
    
    
    
    	System.out.println(url1);
            System.out.println(url2);		
    
    		Connection conn = DriverManager.getConnection(url2);
    		
    		
    		System.out.println(args[0]);
       		System.out.println(args[1]);
    		System.out.println(args[2]);
    		System.out.println(args[3]);
    		System.out.println(args[4]);
      
    		Statement stmt = conn.createStatement();
    
    	conn.close();
    		
    		System.out.println ("DONE!"); 
      }
      
    }

I simply want the connection to work (ie get the Done message!)
This is the error I receive...

   

 "jdbc:oracle:thin:@                                                      
     "jdbc:oracle:thin:@10.67.7.124:1521:XXXRQT","USERID","Passwd"   
     Exception in thread "main" java.sql.SQLException: No suitable driver     
             at java.sql.DriverManager.getConnection(DriverManager.java:446)  
             at java.sql.DriverManager.getConnection(DriverManager.java:374)  
             at Phone_TST19.main(Phone_TST19.java:52)                         
     Java program completed with exit code 1          

                       

[Paul Clapham]

Hi Dave, welcome to the Ranch!

Looks like there are several things you did differently when you tried to build your own connection parameters. In your hard-coded version you used a getConnection() method which had three parameters -- the URL, the user ID, and the password. But in your other version you used a getConnection() method with only one parameter. I think you tried to jam all three parameters into that one string, including some extra quotes to make it look like the original code.

So the URL you need is built from IPad and PortNo and OServer only. Don't put extra quotes around that. Then the code you need is like this:

Connection conn = DriverManager.getConnection(URL, arg[3], arg[4]);