Article

Example using Java toolbox driver and naming = system

Jim Mason and Dave Slater

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())

Back to top