News
Stay informed about the latest enterprise technology news and product updates.
Example using Java toolbox driver and naming = system
Example using Java toolbox driver and naming = system
// define parameters for the JDBC code String jdbcDriverName = "com.ibm.as400.access.AS400JDBCDriver"; String naming = "system"; String dataSourceName = "192.168.1.15"; String aUser = "jem"; String aPassword = "jem"; String tableName = "EMPLOYEE"; String schemaName = "CCBS"; // load the JDBC driver class, create statement and set connection properties Class.forName(jdbcDriverName).newInstance(); String aUrl = "jdbc:as400:" + dataSourceName; String stmt = "SELECT * FROM " + tableName; String cmdStmt = "SET SCHEMA = " + schemaName; java.util.Properties properties = new java.util.Properties(); properties.put("user", aUser); properties.put("password", aPassword); properties.put("language", "Java"); properties.put("libraries", "COMWARE CCBS"); properties.put("naming", naming); if (naming.equals("sql")) { aUrl = aUrl + "/"+ schemaName; } else { properties.put("naming", naming); }; StringBuffer sb = new StringBuffer(); sb.append("n report for SQL: " + stmt + " from " + aUrl + " naming = " + naming + "n"); int colCount = 0; int rowCount = 0; String aColName; boolean metaDataDefined = false; java.sql.Statement aQryStmt = null; java.sql.Connection aDbConnection = null; try { // "connect to url" java.sql.Driver aDriver = java.sql.DriverManager.getDriver(aUrl); aDbConnection = aDriver.connect(aUrl, properties); // "create a select query statement" aQryStmt = ((java.sql.Statement) aDbConnection.createStatement()); java.sql.ResultSet resultSet = aQryStmt.executeQuery(stmt); // "access rows" while (resultSet.next()) { // START: do this to list column headings on selected columns in result set if ( ! metaDataDefined ) { colCount = resultSet.getMetaData().getColumnCount(); sb.append("n"); for ( int i = 1; i <= colCount; i++) { sb.append(" " + resultSet.getMetaData().getColumnName(i)); }; sb.append("n"); metaDataDefined = true; }; // END: do this to list column headings on selected columns in result set sb.append("n"); for ( int i = 1; i <= colCount; i++) { sb.append(" " + resultSet.getObject(i)); }; }; } catch (Exception ex) { sb.append("n ERROR: " + ex); sb.append("n SQL WARNINGS: " + aDbConnection.getWarnings()); ex.printStackTrace(); } finally { aQryStmt.close(); aDbConnection.close(); System.out.println(sb.toString()); }; System.out.println(sb.toString())