Consultor Eletrônico

Solution ID: P6442

FACT(s) (Environment):

IBM AIX
Progress 9.1C

SYMPTOM(s):

SQL-92 causing Progress database to crash

More than 100 SQL INSERT statements on a table with LVARBINARY field

CAUSE:

This code crashes the database with 9.1C on AIX:
for( int n = 0; n < 200 ; n++ )
{
PreparedStatement ps = con.prepareStatement( "INSERT INTO TESTING VALUES ( ? )" );

String sData = "testing";
InputStream isData = new ByteArrayInputStream( sData.getBytes() );
ps.setBinaryStream( 1, isData, isData.available() );
ps.executeUpdate();
ps.close();
System.out.print( "Rows inserted: " + n + " \r" );
}

FIX:

Upgrade to Version 9.1D or, if available, apply Patch 9.1C18 or later.