I access to AS/400 with driver=
"com.ibm.as400.access.AS400JDBCDriver"
and URL="jdbc:as400://XXX/FFPRODLIB";
I have a file (outside of JBoss 2.4.6) and i do
...
String sql="select count(*) from fichero2";
Class.forName(driver);
con = DriverManager.getConnection(url, uid, pwd);
PreparedStatement select = con.prepareStatement(sql);
...