Database Reference
In-Depth Information
", " + errMsg );
} else {
System.out.println( "Oracle success 1)" );
sessionSecretDESSalt = stmt.getRAW( 3 );
sessionSecretDESIterationCount = stmt.getRAW( 4 );
sessionSecretDESAlgorithm = stmt.getRAW( 5 );
sessionSecretDESPassPhrase = stmt.getRAW( 6 );
rs = ( OracleResultSet )stmt.getCursor( 7 )
;
//while( rs.next() ) {
// Only show first row
if( rs.next() ) {
System.out.print( rs.getString( 1 ) );
System.out.print( ", " );
System.out.print( rs.getString( 2 ) );
System.out.print( ", " );
System.out.print( rs.getString( 3 ) );
System.out.print( ", " );
System.out.print( rs.getString( 4 ) );
System.out.print( ", " );
System.out.print( rs.getString( 5 ) );
System.out.print( ", " );
System.out.print( rs.getString( 6 ) );
System.out.print( ", " );
System.out.print( rs.getString( 7 ) );
System.out.print( ", " );
System.out.
print
( OracleJavaSecure.
getDecryptData(
rs.getRAW( 8 )
, sessionSecretDESPassPhrase,
sessionSecretDESAlgorithm, sessionSecretDESSalt,
sessionSecretDESIterationCount ) );
if ( null != rs.getRAW( 8 ) )
System.out.
print
( " (" +
rs.getRAW( 8 ).stringValue()
+
")" );
System.out.print( ", " );
// Most initial commissions in database are null
System.out.print( OracleJavaSecure.getDecryptData(
rs.getRAW( 9 ), sessionSecretDESPassPhrase,
sessionSecretDESAlgorithm, sessionSecretDESSalt,
sessionSecretDESIterationCount ) );
if ( null != rs.getRAW( 9 ) )
System.out.print( " (" + rs.getRAW( 9 ).stringValue() +
")" );
System.out.print( ", " );
System.out.print( rs.getString( 10 ) );
System.out.print( ", " );
System.out.print( rs.getString( 11 ) );
System.out.print( "\n" );
}
}
if( null != rs ) rs.close();
if( null != stmt )
stmt.close()
;