Hi Carsten, currently, I've problems to get your error reproduced, so I need some more information. Would it be possible to send the schema of the 'productive' system, as this has (as you said) increased an complexity (foreign keys etc.), which may (as your observations already seem to show) trigger that error.
BTW - I'm still just curious what do you want to achieve with this sequence of statements. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Carsten Sprenger - MediaTransfer AG Netresearch & Consulting > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 26, 2003 2:04 PM > To: Sapdb. General > Subject: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3102]: > Error > > > Hello List. > In my example (TestStatement) i have two columns (ID FIXED > PRIMARY KEY, XXX > TIMESTAMP). > The table TEST contains 20000 rows. > > One of our productive table contains 18000 rows but the TABLE have six > Fixed(13,0), > three TIMESTAMP,one DATE, two Varchar(32) ASCII, four Float > and one Fixed > (2,0) fields and > five foreign keys. > > If i run the example (TestStatment), it works fine, but > if i run the example with our prductive table, following exception was > thrown. > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3102]: Error > at > com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPa > cket.java:69) > at > com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSa > pDB.java:758) > at > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:424) > at > com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:318) > at > com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableSta > tementSapDB.ja > va:382) > at > com.sap.dbtech.jdbc.CallableStatementSapDB.execute(CallableSta > tementSapDB.ja > va:291) > at > com.sap.dbtech.jdbc.CallableStatementSapDB.executeUpdate(Calla > bleStatementSa > pDB.java:697) > at TestStatement.main(TestStatement.java:68) > > Can you explain me the behavior in both identical operations? > In both tests, i want only set a timestamp to null. > I use Driver version: package com.sap.dbtech.jdbc, SAP DB > JDBC Driver, SAP > AG, 7.4.4 Build 001-000-156-754. > > <----schnipp----> > public class TestStatement { > > static String server = "xxxx.xxxxxxx.de"; > static String db = "DB"; > static String user = "USER"; > static String password = "PASSWORD"; > > public static void main(String[] args) { > String url = "jdbc:sapdb://" + server + "/"+ db; > try { > Class.forName("com.sap.dbtech.jdbc.DriverSapDB"); > Connection conn = DriverManager.getConnection(url, > user, password); > conn.setAutoCommit(false); > > // Driver information > DatabaseMetaData meta = conn.getMetaData(); > System.out.println("Driver version: " + > meta.getDriverVersion()); > > Timestamp timestamp = new > Timestamp(Calendar.getInstance().getTime().getTime()); > > int counter = 0; > > PreparedStatement stmt = conn.prepareStatement("SELECT > ID FROM TEST"); > ResultSet result = stmt.executeQuery(); > > System.out.println("SELECT ALL ROWS FROM TEST\n"); > Vector keys = new Vector(); > while(result.next()){ > keys.addElement(result.getObject(1)); > } > stmt.close(); > conn.commit(); > > counter = 0; > System.out.println("SELECT AND LOCK ALL ROWS"); > stmt = conn.prepareStatement("SELECT * FROM TEST WHERE > ID = ? WITH > LOCK (NOWAIT) EXCLUSIVE ISOLATION LEVEL 1"); > for(int i = 0; i < keys.size(); i++){ > BigDecimal key = (BigDecimal)keys.elementAt(i); > stmt.setInt(1, key.intValue()); > stmt.execute(); > counter++; > // if (counter % 5000 == 0) > // System.out.println("LOCKED ROWS: " + counter); > } > System.out.println("LOCKED ROWS: " + counter); > stmt.close(); > > counter = 0; > System.out.println("\nUPDATE ALL LOCKED ROWS"); > stmt = conn.prepareStatement("UPDATE TEST SET XXX = > NULL WHERE ID = > ?"); > for(int i = 0; i < keys.size(); i++){ > BigDecimal key = (BigDecimal)keys.elementAt(i); > stmt.setInt(1, key.intValue()); > stmt.executeUpdate(); > counter++; > // if (counter % 5000 == 0) > // System.out.println("UPDATED ROWS: " + counter); > } > System.out.println("UPDATED ROWS: " + counter); > stmt.close(); > conn.commit(); > } catch (Throwable t){ > t.printStackTrace(); > } > } > } > <----schnapp----> > > Best regards > > Carsten Sprenger > ____________________________________ > MediaTransfer AG > Netresearch & Consulting > Rothenbaumchaussee 38, 20148 Hamburg > Tel: (040) 669 625 16 > Fax: (040) 669 625 29 > URL: http://b2b.mediatransfer.de > ____________________________________ > > This email is printed with 100% recycled electrons. > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
