RE: Error creating java object

[Magne Kofoed <magne@xxxxxxxxx>]

Hi Rajesh,

1. Try changing:  public static void main(String[] arg){
to:   public static void main(String args[]){

2. Change:  Connection c = DriverManager.getConnection
("jdbc:as400://mldev400;date format= iso", "xxx", "xxx"); 
To: Connection c = DriverManager.getConnection
("jdbc:as400://mldev400/SPANAND");

3. Change: ResultSet rs   = stmt.executeQuery("select * from 
SPANAND/LNAFGBP");
To:  ResultSet rs   = stmt.executeQuery("select * from 
LNAFGBP");



Rgds,
Magne






Hi Magne, 

You are the only one who has got this working, so I 
appreciate 
your help.... 

Done all those things you mentioned... 

1. Changed the connection string, ip addr and lib in my pgm. 

2. When running the java cmd changed the version to 1.2 as 
below... 

cmds in qshell... 

1. cd /test 
2. javac  -classpath 
.:/java/jt400.jar:/java/xml/jdom-
1.0/build/jdom.jar:/java/xml/jdom-contr 
ib-1.0/build/jdom 
   -contrib.jar     /test/Test.java 
  
COMPILED OK...>>>>> 



2.  java -Djava.version=1.2 -classpath 
.:/java/jt400.jar:/java/xml/jdom-
1.0/build/jdom.jar:/java/xml/jdom-contr 
ib 
-1.0/build/jdom-contrib.jar      Test 

3. Env variables ----- /java/xml/jdom.jar 
/java/xml/jdom-contrib.jar and 
/java/jt400.jar 

4. Created demo dir in /java/demo for output. 

A copy of the code is below... 

package demo; 



import java.io.IOException; 

import java.sql.*; 

import java.text.*; 

import java.io.*; 

import java.util.*; 



import org.jdom.output.*; 

import org.jdom.input.*; 

import org.jdom.*; 

import org.jdom.transform.*; 

import org.jdom.contrib.input.*; 

import com.ibm.as400.access.*; 



public class Test { 

public static void main(String[] arg){ 

try { 

DriverManager.registerDriver(new 
com.ibm.as400.access.AS400JDBCDriver()); 
Connection c = DriverManager.getConnection
("jdbc:as400://mldev400;date 
format= iso", "xxx", "xxx"); 
Statement stmt = c.createStatement(); 

ResultSet rs   = stmt.executeQuery("select * from 
SPANAND/LNAFGBP"); 

ResultSetBuilder builder = new ResultSetBuilder(rs); 

Document doc = builder.build(); 

PrintWriter  pw = new PrintWriter(new BufferedWriter(new 
FileWriter("/java/demo/test.xml")));                 
XMLOutputter outputter = new XMLOutputter(); 

outputter.output(doc, pw); 

pw.flush(); 

pw.close(); 

c.close(); 

} catch (JDOMException e) { 

System.out.println(e); 

} 

catch (IOException e) { 

System.out.println(e); 

 } 

catch (SQLException e) { 

System.out.println(e);   
 }     
}       
}    



Many Thanks for your help and look forward to hearing from 
you... 

Cheers, 

Rajesh Anand 
Tel: + (44) (0) 207 996 1152 
Mob: + (44) (0) 7947273151 
Email:Rajesh_anand@xxxxxx