https://sourceforge.net/p/jeeutils/bugs/2010-10-25T12:36:48ZRecent changes to bugs2010-10-25T12:36:48Z2010-10-25T12:36:48ZJakub Holýhttps://sourceforge.net/u/malyvelky/https://sourceforge.net7ce5f25f7be9b53c17764859fe8970a0f9d2e5ca

<div class="markdown_content"><p>When DB initialization fails because data for a field is larger then its schema definition allows, a misleading exception regarding nonexistant schema is thrown and the cause must be check to find the real error.:</p> <p>[WARN] EmbeddedDbTester - If the initial DB cleanup failed because of nonexistant schema (usually same as logged-in user name, for derby SA), set the System property PropertiesBasedJdbcDatabaseTester.DBUNIT_SCHEMA to an existing schema. <br /> Error: A truncation error was encountered trying to shrink CHAR 'ManagerCnum' to length 10. &lt;java.sql.SQLException: A truncation error was encountered trying to shrink CHAR 'ManagerCnum' to length 10.&gt;java.sql.SQLException: A truncation error was encountered trying to shrink CHAR 'ManagerCnum' to length 10.<br /> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)<br /> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)<br /> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)<br /> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)<br /> at org.dbunit.database.statement.SimplePreparedStatement.addBatch(SimplePreparedStatement.java:67)<br /> at org.dbunit.database.statement.AutomaticPreparedBatchStatement.addBatch(AutomaticPreparedBatchStatement.java:57)<br /> at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:187)<br /> at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)<br /> at org.dbunit.AbstractDatabaseTester.executeOperation(AbstractDatabaseTester.java:132)<br /> at org.dbunit.AbstractDatabaseTester.onSetup(AbstractDatabaseTester.java:60)<br /> at net.jakubholy.testing.dbunit.embeddeddb.impl.EnhancedDatabaseTesterDecorator.onSetup(EnhancedDatabaseTesterDecorator.java:153)<br /> at net.jakubholy.testing.dbunit.embeddeddb.EmbeddedDbTester.onSetup(EmbeddedDbTester.java:491)<br /> at com.ibm.education.saba.interfaces.batch.master.extract.jdbc.JdbcPersonExtractorImplTest.setUp(JdbcPersonExtractorImplTest.java:34)<br /> ...<br /> Caused by: ERROR 22001: A truncation error was encountered trying to shrink CHAR 'ManagerCnum' to length 10.<br /> at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)<br /> at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)<br /> at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)<br /> at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)<br /> at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)<br /> at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)<br /> at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)<br /> at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)<br /> at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)<br /> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)<br /> ... 35 more</p> <p>Version: 1.1.0</p></div>