Bug#471646: libmysql-java: strange SQL Exceptions with Version 5.1.5+dfsg-2: all
On Wed, Mar 19, 2008 at 10:40:59AM +0100, [EMAIL PROTECTED] wrote: Package: libmysql-java Version: 5.1.5+dfsg-2 Severity: important *** Please type your report below this line *** I'm using the OpenMMS software packet. It's a rdb management system for crystal protein structures. With the reported version of libmysql-java i got the following execption: Load Started Wed Mar 19 10:26:51 CET 2008 Loading PDB_ID: 3b9c Read time: 1.514 s. ** LOAD ENTRY FAILED ** SQL Exception in DBLoader.loadEntries() while loading Entry PDB_ID=3b9c Exception Description: java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 SQL Message: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 SQL State: 01004 SQL ErrorCode: 0 Stack Trace java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085) at org.rcsb.openmms.dbinsert.InsertEntry.insert_ATOM_SITE(InsertEntry.java:2821) at org.rcsb.openmms.dbinsert.InsertEntry.insertEntryData(InsertEntry.java:766) at org.rcsb.openmms.apps.rdb.InsertEntryFinal.buildAndInsertEntry(InsertEntryFinal.java:156) at org.rcsb.openmms.apps.rdb.DBLoader.insertSingleEntry(DBLoader.java:462) at org.rcsb.openmms.apps.rdb.DBLoader.processSingleEntry(DBLoader.java:391) at org.rcsb.openmms.apps.rdb.DBLoader.loadSingleEntry(DBLoader.java:265) at org.rcsb.openmms.apps.rdb.DBLoader.loadEntries(DBLoader.java:184) at org.rcsb.openmms.apps.rdb.PanelSet$LoadManifestButtonObserver$1.construct(PanelSet.java:482) at org.rcsb.openmms.apps.rdb.SwingWorker$2.run(SwingWorker.java:111) at java.lang.Thread.run(Thread.java:595) ** end of exception report ** ** There is no excpetion with Version: 5.0.4+dfsg-2: all . May be its note worthy that i had the same problem former, when i updated first time from version 3.x to 5.x. A downgrade fixed that problem that time , too. It's strange, that the problem now occures again. Can you please create a smaller testcase just involving a test app using libmysql-java and a database? That would be of great help to track that down. Cheers, Michael -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Bug#471646: libmysql-java: strange SQL Exceptions with Version 5.1.5+dfsg-2: all
Package: libmysql-java Version: 5.1.5+dfsg-2 Severity: important *** Please type your report below this line *** I'm using the OpenMMS software packet. It's a rdb management system for crystal protein structures. With the reported version of libmysql-java i got the following execption: Load Started Wed Mar 19 10:26:51 CET 2008 Loading PDB_ID: 3b9c Read time: 1.514 s. ** LOAD ENTRY FAILED ** SQL Exception in DBLoader.loadEntries() while loading Entry PDB_ID=3b9c Exception Description: java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 SQL Message: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 SQL State: 01004 SQL ErrorCode: 0 Stack Trace java.sql.BatchUpdateException: Data truncation: Out of range value adjusted for column 'occupancy_esd' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1669) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1085) at org.rcsb.openmms.dbinsert.InsertEntry.insert_ATOM_SITE(InsertEntry.java:2821) at org.rcsb.openmms.dbinsert.InsertEntry.insertEntryData(InsertEntry.java:766) at org.rcsb.openmms.apps.rdb.InsertEntryFinal.buildAndInsertEntry(InsertEntryFinal.java:156) at org.rcsb.openmms.apps.rdb.DBLoader.insertSingleEntry(DBLoader.java:462) at org.rcsb.openmms.apps.rdb.DBLoader.processSingleEntry(DBLoader.java:391) at org.rcsb.openmms.apps.rdb.DBLoader.loadSingleEntry(DBLoader.java:265) at org.rcsb.openmms.apps.rdb.DBLoader.loadEntries(DBLoader.java:184) at org.rcsb.openmms.apps.rdb.PanelSet$LoadManifestButtonObserver$1.construct(PanelSet.java:482) at org.rcsb.openmms.apps.rdb.SwingWorker$2.run(SwingWorker.java:111) at java.lang.Thread.run(Thread.java:595) ** end of exception report ** ** There is no excpetion with Version: 5.0.4+dfsg-2: all . May be its note worthy that i had the same problem former, when i updated first time from version 3.x to 5.x. A downgrade fixed that problem that time , too. It's strange, that the problem now occures again. -- System Information: Debian Release: lenny/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 2.6.22-3-amd64 (SMP w/2 CPU cores) Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages libmysql-java depends on: ii gij-4.1 [java2-runtime] 4.1.2-16 The GNU Java bytecode interpreter ii java-gcj-compat [java2-runtim 1.0.77-4 Java runtime environment using GIJ ii sun-java5-jre [java2-runtime] 1.5.0-14-3 Sun Java(TM) Runtime Environment ( libmysql-java recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
