[jira] [Updated] (DERBY-6884) SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE can't import more than Integer.MAX_VALUE bytes of blob data

2016-04-28 Thread Bryan Pendleton (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-6884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Bryan Pendleton updated DERBY-6884:
---
Attachment: firstTryAtTest.diff

Attached is my first try at writing a regression test for these problems.

Unfortunately, although this regression test appears to demonstrate
the problem with "clob" data when the external file exceeds Integer.MAX_VALUE
in size, the test is problematic: it takes more than 1 hour to run.

I hope that I can improve the test program, because obviously
a test that takes an hour is not appropriate to put into our
test suite.

My first ideas are (a) to not commit so often, and (b) to write a
smaller number of larger clob objects.

I'll try some of those ideas, and see if the runtime of the test
is improved at all.

Once I get a reliable test, including the "blob" version should
be straightforward.

> SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE can't import more than Integer.MAX_VALUE 
> bytes of blob data
> 
>
> Key: DERBY-6884
> URL: https://issues.apache.org/jira/browse/DERBY-6884
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.11.1.1
>Reporter: Edward Howe
> Attachments: DerbyIssue.java, firstTryAtTest.diff, trivial.diff
>
>
> Using SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE to export a table containing a blob 
> column, SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE  will fail with a 
> NumberFormatException if the offset for a blob record is > Integer.MAX_VALUE. 
>  This is because ImportReadData.initExternalLobFile() is parsing the offset 
> as an Integer.
> The stack trace and a program to reproduce are below.
> java.lang.NumberFormatException: For input string: "2147483770"
>   at 
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) 
> ~[na:1.8.0_45]
>   at java.lang.Integer.parseInt(Integer.java:583) ~[na:1.8.0_45]
>   at java.lang.Integer.parseInt(Integer.java:615) ~[na:1.8.0_45]
>   at 
> org.apache.derby.impl.load.ImportReadData.initExternalLobFile(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.load.ImportReadData.getBlobColumnFromExtFile(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.load.ImportAbstract.getBlob(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.load.Import.getBlob(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.iapi.types.SQLBlob.setValueFromResultSet(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.NoPutResultSetImpl.getNextRowFromRowSource(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.store.access.heap.HeapController.load(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.store.access.heap.Heap.load(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.store.access.RAMTransaction.loadConglomerate(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.store.access.RAMTransaction.recreateAndLoadConglomerate(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.InsertResultSet.bulkInsertCore(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   ... 36 common frames omitted
> ==
> package blob;
> import java.io.BufferedInputStream;
> import java.io.File;
> import java.io.FileInputStream;
> import java.io.IOException;
> import java.sql.*;
> public final class DerbyIssue {
> // derby url
> public static final String DBURL = "jdbc:derby:testdb;create=true";
> // any random binary file such as a large image or document
> public static final String BLOB_DATA_FILE = "...";
> public static final String EXPORT_TABLE_FILE = "table-data";
> public static final String EXPORT_BLOB_FILE = "blob-data";
> public static void

[jira] [Commented] (DERBY-6884) SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE can't import more than Integer.MAX_VALUE bytes of blob data

2016-04-28 Thread Bryan Pendleton (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-6884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15263398#comment-15263398
 ] 

Bryan Pendleton commented on DERBY-6884:


I finally got some time to try to develop a "clob" version of the repro
program, and, as I think we all expected, it fails in a similar fashion:

Caused by: java.lang.NumberFormatException: For input string: "2147487744"
at 
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.parseInt(Integer.java:615)
at 
org.apache.derby.impl.load.ImportReadData.initExternalLobFile(ImportReadData.java:1040)
at 
org.apache.derby.impl.load.ImportReadData.getClobColumnFromExtFileAsString(ImportReadData.java:953)
at 
org.apache.derby.impl.load.ImportAbstract.getString(ImportAbstract.java:167)
at org.apache.derby.impl.load.Import.getString(Import.java:45)
at 
org.apache.derby.iapi.types.SQLChar.setValueFromResultSet(SQLChar.java:1466)
at 
org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(VTIResultSet.java:688)
at 
org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(VTIResultSet.java:461)
at 
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:287)
at 
org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(NormalizeResultSet.java:188)
... (I truncated the stack trace)

So there is clearly more work to be done, to address the issues on the CLOB 
side.

> SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE can't import more than Integer.MAX_VALUE 
> bytes of blob data
> 
>
> Key: DERBY-6884
> URL: https://issues.apache.org/jira/browse/DERBY-6884
> Project: Derby
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 10.11.1.1
>Reporter: Edward Howe
> Attachments: DerbyIssue.java, trivial.diff
>
>
> Using SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE to export a table containing a blob 
> column, SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE  will fail with a 
> NumberFormatException if the offset for a blob record is > Integer.MAX_VALUE. 
>  This is because ImportReadData.initExternalLobFile() is parsing the offset 
> as an Integer.
> The stack trace and a program to reproduce are below.
> java.lang.NumberFormatException: For input string: "2147483770"
>   at 
> java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) 
> ~[na:1.8.0_45]
>   at java.lang.Integer.parseInt(Integer.java:583) ~[na:1.8.0_45]
>   at java.lang.Integer.parseInt(Integer.java:615) ~[na:1.8.0_45]
>   at 
> org.apache.derby.impl.load.ImportReadData.initExternalLobFile(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.load.ImportReadData.getBlobColumnFromExtFile(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.load.ImportAbstract.getBlob(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.load.Import.getBlob(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.iapi.types.SQLBlob.setValueFromResultSet(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.NoPutResultSetImpl.getNextRowFromRowSource(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.store.access.heap.HeapController.load(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.store.access.heap.Heap.load(Unknown Source) 
> ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.store.access.RAMTransaction.loadConglomerate(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.store.access.RAMTransaction.recreateAndLoadConglomerate(Unknown
>  Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.execute.InsertResultSet.bulkInsertCore(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown 
> Source) ~[derby-10.11.1.1.jar:na]
>   at

[Java DB - testing] Failure nightly 10.11 (rev 1741388)

2016-04-28 Thread ingemar . aberg 
Java DB testing and reporting infrastructure.

Failure nightly 10.11 (rev 1741388)

There were 1 failures.

Build failed in Jenkins: Derby-trunk-suites.All #77

2016-04-28 Thread Apache Jenkins Server 
See 

Changes:

[bpendleton] DERBY-6880: Update failing with java.sql.SQLDataException

This change reverts part of the changes made by revision 1628596 for DERBY-6742.

Specifically, the section of code added to UpdateResultSet.collectAffectedRows
is removed. That code caused problems with certain SQL UPDATE statements
which were compiled with Statement.RETURN_GENERATED_KEYS. The new test cases
added by this change include several examples of such SQL statements.

The JDBC documentation for the intended behavior of UPDATE statements with the
RETURN_GENERATED_KEYS option is unclear; the intended behavior is much
clearer with INSERT statements. Given that I don't understand the intended
behavior, it seems safer to me to return Derby to the previous state for
UPDATE statements; namely, that no attempt is made to compute the set of
generated keys for an UPDATE statement.

--
[...truncated 6891 lines...]
AU10.4.1.3/derbyLocale_cs.jar
AU10.4.1.3/derbyLocale_ko_KR.jar
AU10.4.1.3/derbyLocale_pt_BR.jar
AU10.4.1.3/derbynet.jar
AU10.4.1.3/derbyLocale_es.jar
AU10.4.1.3/derbyLocale_fr.jar
AU10.4.1.3/derbyLocale_pl.jar
AU10.4.1.3/derbyLocale_it.jar
AU10.4.1.3/derbyLocale_hu.jar
A 10.6.2.1
AU10.6.2.1/derbyLocale_zh_TW.jar
AU10.6.2.1/derbyTesting.jar
AU10.6.2.1/derbyclient.jar
AU10.6.2.1/derby.jar
AU10.6.2.1/derbyLocale_de_DE.jar
AU10.6.2.1/derbyLocale_zh_CN.jar
AU10.6.2.1/derbyLocale_cs.jar
AU10.6.2.1/derbyLocale_ko_KR.jar
AU10.6.2.1/derbyLocale_pt_BR.jar
AU10.6.2.1/derbynet.jar
AU10.6.2.1/derbyLocale_es.jar
AU10.6.2.1/derbyLocale_fr.jar
AU10.6.2.1/derbyLocale_pl.jar
AU10.6.2.1/derbyLocale_it.jar
AU10.6.2.1/derbyLocale_hu.jar
AU10.6.2.1/derby.war
AU10.6.2.1/derbytools.jar
AU10.6.2.1/derbyLocale_ja_JP.jar
AU10.6.2.1/derbyrun.jar
AU10.6.2.1/derbyLocale_ru.jar
A 10.2.1.6
AU10.2.1.6/derbyLocale_pt_BR.jar
AU10.2.1.6/derbyLocale_es.jar
AU10.2.1.6/derbyLocale_fr.jar
AU10.2.1.6/derbynet.jar
AU10.2.1.6/derbyLocale_zh_TW.jar
AU10.2.1.6/derbyLocale_it.jar
AU10.2.1.6/derby.war
AU10.2.1.6/derbyclient.jar
AU10.2.1.6/derby.jar
AU10.2.1.6/derbyLocale_de_DE.jar
AU10.2.1.6/derbyLocale_zh_CN.jar
AU10.2.1.6/derbytools.jar
AU10.2.1.6/derbyLocale_ja_JP.jar
AU10.2.1.6/derbyLocale_ko_KR.jar
AU10.2.1.6/derbyrun.jar
A 10.7.1.1
AU10.7.1.1/derbytools.jar
AU10.7.1.1/derbyLocale_ja_JP.jar
AU10.7.1.1/derbyrun.jar
AU10.7.1.1/derbyLocale_ru.jar
AU10.7.1.1/derbyLocale_zh_TW.jar
AU10.7.1.1/derbyTesting.jar
AU10.7.1.1/derbyclient.jar
AU10.7.1.1/derby.jar
AU10.7.1.1/derbyLocale_de_DE.jar
AU10.7.1.1/derbyLocale_zh_CN.jar
AU10.7.1.1/derbyLocale_cs.jar
AU10.7.1.1/derbyLocale_ko_KR.jar
AU10.7.1.1/derbyLocale_pt_BR.jar
AU10.7.1.1/derbynet.jar
AU10.7.1.1/derbyLocale_es.jar
AU10.7.1.1/derbyLocale_fr.jar
AU10.7.1.1/derbyLocale_pl.jar
AU10.7.1.1/derbyLocale_it.jar
AU10.7.1.1/derbyLocale_hu.jar
A 10.9.1.0
AU10.9.1.0/derbyLocale_zh_CN.jar
AU10.9.1.0/derbyLocale_cs.jar
AU10.9.1.0/derbyLocale_ko_KR.jar
AU10.9.1.0/derbyLocale_pt_BR.jar
AU10.9.1.0/derbynet.jar
AU10.9.1.0/derbyLocale_es.jar
AU10.9.1.0/derbyLocale_fr.jar
AU10.9.1.0/derbyLocale_pl.jar
AU10.9.1.0/derbyLocale_hu.jar
AU10.9.1.0/derbyLocale_it.jar
AU10.9.1.0/derby.war
AU10.9.1.0/derbytools.jar
AU10.9.1.0/derbyLocale_ja_JP.jar
AU10.9.1.0/derbyrun.jar
AU10.9.1.0/derbyLocale_ru.jar
AU10.9.1.0/derbyLocale_zh_TW.jar
AU10.9.1.0/derbyTesting.jar
AU10.9.1.0/derbyclient.jar
AU10.9.1.0/derby.jar
AU10.9.1.0/derbyLocale_de_DE.jar
A 10.8.1.2
AU10.8.1.2/derbyLocale_zh_TW.jar
AU10.8.1.2/derbyTesting.jar
AU10.8.1.2/derbyclient.jar
AU10.8.1.2/derby.jar
AU10.8.1.2/derbyLocale_de_DE.jar
AU10.8.1.2/derbyLocale_zh_CN.jar
AU10.8.1.2/derbyLocale_cs.jar
AU10.8.1.2/derbyLocale_ko_KR.jar
AU10.8.1.2/derbyLocale_pt_BR.jar
AU10.8.1.2/derbynet.jar
AU10.8.1.2/derbyLocale_es.jar
AU10.8.1.2/derbyLocale_fr.jar
AU10.8.1.2/derbyLocale_pl.jar
AU10.8.1.2/derbyLocale_it.jar
AU10.8.1.2/derbyLocale_hu.jar
AU10.8.1.2/derby.war
AU10.8.1.2/derbytools.jar
AU10.8.1.2/derbyLocale_ja_JP.jar
AU10.8.1.2/derbyrun.jar
AU10.8.1.2/derbyLocale_ru.jar
A 10.8.3.0
AU10.8.3.0/derby.war
AU

Build failed in Jenkins: Derby-10.11-suites.All #33

2016-04-28 Thread Apache Jenkins Server 
See 

Changes:

[kahatlen] DERBY-6827: Errors in LocalizedDisplayScriptTest on jdk 9

Merged revision 1692008 from trunk.

--
[...truncated 6955 lines...]
AU10.11.1.1/derbyLocale_es.jar
AU10.11.1.1/derbyLocale_fr.jar
AU10.11.1.1/derbyLocale_pl.jar
AU10.11.1.1/derbyLocale_it.jar
AU10.11.1.1/derbyLocale_hu.jar
AU10.11.1.1/derby.war
AU10.11.1.1/derbytools.jar
AU10.11.1.1/derbyLocale_ja_JP.jar
AU10.11.1.1/derbyrun.jar
AU10.11.1.1/derbyLocale_ru.jar
AU10.11.1.1/derbyoptionaltools.jar
A 10.12.1.1
AU10.12.1.1/derbyLocale_pl.jar
AU10.12.1.1/derbyLocale_it.jar
AU10.12.1.1/derbyLocale_hu.jar
AU10.12.1.1/derby.war
AU10.12.1.1/derbytools.jar
AU10.12.1.1/derbyLocale_ja_JP.jar
AU10.12.1.1/derbyrun.jar
AU10.12.1.1/derbyLocale_ru.jar
AU10.12.1.1/derbyoptionaltools.jar
AU10.12.1.1/derbyLocale_zh_TW.jar
AU10.12.1.1/derbyTesting.jar
AU10.12.1.1/derbyclient.jar
AU10.12.1.1/derby.jar
AU10.12.1.1/derbyLocale_de_DE.jar
AU10.12.1.1/derbyLocale_zh_CN.jar
AU10.12.1.1/derbyLocale_cs.jar
AU10.12.1.1/derbyLocale_ko_KR.jar
AU10.12.1.1/derbyLocale_pt_BR.jar
AU10.12.1.1/derbynet.jar
AU10.12.1.1/derbyLocale_es.jar
AU10.12.1.1/derbyLocale_fr.jar
A 10.1.1.0
AU10.1.1.0/derbyLocale_zh_TW.jar
AU10.1.1.0/derbyLocale_it.jar
AU10.1.1.0/derby.war
AU10.1.1.0/derbyTesting.jar
AU10.1.1.0/derbyclient.jar
AU10.1.1.0/derby.jar
AU10.1.1.0/derbyLocale_de_DE.jar
AU10.1.1.0/derbyLocale_zh_CN.jar
AU10.1.1.0/derbytools.jar
AU10.1.1.0/derbyLocale_ja_JP.jar
AU10.1.1.0/derbyLocale_ko_KR.jar
AU10.1.1.0/derbyLocale_pt_BR.jar
AU10.1.1.0/derbyLocale_es.jar
AU10.1.1.0/derbyLocale_fr.jar
AU10.1.1.0/derbynet.jar
A 10.0.2.1
AU10.0.2.1/derbyLocale_zh_TW.jar
AU10.0.2.1/derbyLocale_it.jar
AU10.0.2.1/derby.war
AU10.0.2.1/derby.jar
AU10.0.2.1/derbyLocale_de_DE.jar
AU10.0.2.1/derbyLocale_zh_CN.jar
AU10.0.2.1/derbytools.jar
AU10.0.2.1/derbyLocale_ja_JP.jar
AU10.0.2.1/derbyLocale_ko_KR.jar
AU10.0.2.1/derbyLocale_pt_BR.jar
AU10.0.2.1/derbyLocale_es.jar
AU10.0.2.1/derbyLocale_fr.jar
AU10.0.2.1/derbynet.jar
A 10.1.2.1
AU10.1.2.1/derbyLocale_es.jar
AU10.1.2.1/derbyLocale_fr.jar
AU10.1.2.1/derbynet.jar
AU10.1.2.1/derbyLocale_zh_TW.jar
AU10.1.2.1/derbyLocale_it.jar
AU10.1.2.1/derby.war
AU10.1.2.1/derbyTesting.jar
AU10.1.2.1/derbyclient.jar
AU10.1.2.1/derby.jar
AU10.1.2.1/derbyLocale_de_DE.jar
AU10.1.2.1/derbyLocale_zh_CN.jar
AU10.1.2.1/derbytools.jar
AU10.1.2.1/derbyLocale_ja_JP.jar
AU10.1.2.1/derbyLocale_ko_KR.jar
AU10.1.2.1/derbyLocale_pt_BR.jar
A 10.2.2.0
AU10.2.2.0/derbyLocale_cs.jar
AU10.2.2.0/derbyLocale_ko_KR.jar
AU10.2.2.0/derbyLocale_pt_BR.jar
AU10.2.2.0/derbyLocale_fr.jar
AU10.2.2.0/derbyLocale_es.jar
AU10.2.2.0/derbynet.jar
AU10.2.2.0/derbyLocale_pl.jar
AU10.2.2.0/derbyLocale_hu.jar
AU10.2.2.0/derbyLocale_it.jar
AU10.2.2.0/derbytools.jar
AU10.2.2.0/derbyLocale_ja_JP.jar
AU10.2.2.0/derbyrun.jar
AU10.2.2.0/derbyLocale_ru.jar
AU10.2.2.0/derbyLocale_zh_TW.jar
AU10.2.2.0/derbyTesting.jar
AU10.2.2.0/derbyclient.jar
AU10.2.2.0/derby.jar
AU10.2.2.0/derbyLocale_de_DE.jar
AU10.2.2.0/derbyLocale_zh_CN.jar
A 10.1.3.1
AU10.1.3.1/derby.war
AU10.1.3.1/derbyTesting.jar
AU10.1.3.1/derbyclient.jar
AU10.1.3.1/derby.jar
AU10.1.3.1/derbyLocale_de_DE.jar
AU10.1.3.1/derbyLocale_zh_CN.jar
AU10.1.3.1/derbytools.jar
AU10.1.3.1/derbyLocale_ja_JP.jar
AU10.1.3.1/derbyLocale_ko_KR.jar
AU10.1.3.1/derbyLocale_pt_BR.jar
AU10.1.3.1/derbyLocale_es.jar
AU10.1.3.1/derbyLocale_fr.jar
AU10.1.3.1/derbynet.jar
AU10.1.3.1/derbyLocale_zh_TW.jar
AU10.1.3.1/derbyLocale_it.jar
A 10.3.2.1
AU10.3.2.1/derbytools.jar
AU10.3.2.1/derbyLocale_ja_JP.jar
AU10.3.2.1/derbyrun.jar
AU10.3.2.1/derbyLocale_ru.jar
AU10.3.2.1/derbyLocale_zh_TW.jar
AU10.3.2.1/derbyTesting.jar
AU10.3.2.1/derbyclient.jar
AU10.3.2.1/derby.jar
AU10.3.2.1/derbyLocale_de_DE.jar
AU10.3.2.1/derbyLocale_zh_CN.jar
AU10.3.2.1/derbyLocale_cs.jar
AU10.3.2.1/derbyLocale_ko_KR.jar
AU10.3.2.1/derbyLocale_pt_BR.jar
AU10.3.2.1/derbynet.jar
AU

[jira] [Commented] (DERBY-6880) Update failing with java.sql.SQLDataException

2016-04-28 Thread Simon Zee (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-6880?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15262027#comment-15262027
 ] 

Simon Zee commented on DERBY-6880:
--

Bryan, thanks for your persistence and diligence on this issue!

I think you've made the right call. While there was clearly an intention behind 
the code changes that were made, the regression caused seems worse than 
whatever subtle feature of the JDBC APIs they were intended to implement.

> Update failing with java.sql.SQLDataException 
> --
>
> Key: DERBY-6880
> URL: https://issues.apache.org/jira/browse/DERBY-6880
> Project: Derby
>  Issue Type: Bug
>Affects Versions: 10.12.1.1
>Reporter: Simon Zee
>Assignee: Bryan Pendleton
> Fix For: 10.13.0.0
>
> Attachments: repro.diff, standalone.java, undo6742.diff, 
> undoMoreTests.diff
>
>
> When updating a single column in a table using executeUpdate() via Vert.x I 
> am receiving the following exception:
> java.sql.SQLDataException: Invalid character string format for type long.
>   at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:84)
>   at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:233)
>   at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
>   at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
>   at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2405)
>   at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:88)
>   at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1432)
>   at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1709)
>   at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(EmbedPreparedStatement.java:320)
>   at 
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:309)
>   at 
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
>   at io.vertx.ext.jdbc.impl.actions.JDBCUpdate.execute(JDBCUpdate.java:50)
>   at io.vertx.ext.jdbc.impl.actions.JDBCUpdate.execute(JDBCUpdate.java:34)
>   at 
> io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:48)
>   at 
> io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:33)
>   at 
> io.vertx.core.impl.ContextImpl.lambda$executeBlocking$15(ContextImpl.java:296)
>   at 
> io.vertx.core.impl.OrderedExecutorFactory$OrderedExecutor.lambda$new$261(OrderedExecutorFactory.java:91)
>   at 
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>   at 
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: ERROR 22018: Invalid character string format for type long.
>   at 
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290)
>   at 
> org.apache.derby.iapi.error.StandardException.newException(StandardException.java:285)
>   at org.apache.derby.iapi.types.SQLChar.getLong(SQLChar.java:447)
>   at 
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(UpdateResultSet.java:534)
>   at 
> org.apache.derby.impl.sql.execute.UpdateResultSet.open(UpdateResultSet.java:272)
>   at 
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:473)
>   at 
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:352)
>   at 
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1340)
>   ... 13 more
> Further details and discussion can be found here:
> https://mail-archives.apache.org/mod_mbox/db-derby-user/201603.mbox/%3CCAHbUnCXkHMKE1u9R3D-z9Njp8goAV7%2B0vPOmgafH8DCqG8mSpQ%40mail.gmail.com%3E
> Notably, I have tried executing the same update via other means (for example, 
> manually via SquirrelSQL, and via the ORMLite framework) and the update 
> succeeds. This may be due to the exact JDBC APIs they are using (for example, 
> SquirrelSQL is not using a prepared statement, and ORMLite updates all the 
> columns when it updates a table rather than just some of them).
> I have created a complete but minimal example that illustrates the problem in 
> the following GitHub project:
> https://github.com/ssadedin/DerbyDebug
> My derby / system information is as follows:
> $ java -cp 'lib/*' org.apache.derby.tools.sysinfo
> -- Java Information --
> Java Version:

[Java DB - testing] Failure continuous 10.11 (rev 1741324)

2016-04-28 Thread ingemar . aberg 
Java DB testing and reporting infrastructure.

Failure continuous 10.11 (rev 1741324)

There were 1 failures.

Build failed in Jenkins: Derby-branch-10.11 #36

2016-04-28 Thread Apache Jenkins Server 
See 

Changes:

[kahatlen] DERBY-6827: Errors in LocalizedDisplayScriptTest on jdk 9

Merged revision 1692008 from trunk.

--
[...truncated 4623 lines...]
A plugins/eclipse/org.apache.derby.plugin.doc/topics
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/derby_app.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/ij_toc.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/java_project.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/resources.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/remove_nature.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/server_toc.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/stop_server.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/start_server.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/ij2.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/sysinfo.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/properties.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/nature.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/ij.html
A plugins/eclipse/org.apache.derby.plugin.doc/topics/images
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/create_file.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/shutdown_success.gif
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/start_server_console.gif
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/add_nature.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/run_javaapp.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/sysinfo_start.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/stop_popup.gif
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/sysinfo_output.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/remove_nature.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/create_restaurant.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/stop_server.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/restaurant_script.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/property_sheet.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/new_class.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/completed_javaapp.GIF
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/images/start_ij.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/start_server.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/ij_commands.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/create_class.GIF
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/server_popup.gif
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/properties.gif
AU
plugins/eclipse/org.apache.derby.plugin.doc/topics/images/restaurant_editor.GIF
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/start_toc.html
AUplugins/eclipse/org.apache.derby.plugin.doc/topics/nature_toc.html
A plugins/eclipse/org.apache.derby.plugin.doc/LICENSE
AULICENSE
AUSTATUS
A maven2
A maven2/derbyLocale_fr
AUmaven2/derbyLocale_fr/pom.xml
A maven2/derbyLocale_es
AUmaven2/derbyLocale_es/pom.xml
A maven2/client
AUmaven2/client/pom.xml
A maven2/derbyLocale_pl
AUmaven2/derbyLocale_pl/pom.xml
A maven2/derbyLocale_hu
AUmaven2/derbyLocale_hu/pom.xml
A maven2/derbyLocale_it
AUmaven2/derbyLocale_it/pom.xml
A maven2/net
AUmaven2/net/pom.xml
A maven2/derbyLocale_ja_JP
AUmaven2/derbyLocale_ja_JP/pom.xml
A maven2/war
AUmaven2/war/pom.xml
AUmaven2/pom.xml
A maven2/derbyLocale_ru
AUmaven2/derbyLocale_ru/pom.xml
A maven2/tools
AUmaven2/tools/pom.xml
A maven2/derbyLocale_zh_TW
AUmaven2/derbyLocale_zh_TW/pom.xml
A maven2/engine
AUmaven2/engine/pom.xml
A maven2/derbyLocale_de_DE
AUmaven2/derbyLocale_de_DE/pom.xml
A maven2/optionaltools
AUmaven2/optionaltools/pom.xml
A maven2/derbyLocale_zh_CN
AUmaven2/derbyLocale_zh_CN/pom.xml
AUmaven2/SetDerbyVersion.java
A maven2/derbyLocale_cs
AUmaven2/derbyLocale_cs/pom.xml
A maven2/derbyLocale_ko_KR
AUmaven2/derbyLocale_ko_KR/pom.xml
A maven2/derbyLocale_pt_BR
AUmaven2/derbyLocale_pt_BR/pom.xml
AUmaven2/README.txt
AUREADME
AUreleaseSummary.xml
AU

[jira] [Updated] (DERBY-6827) Errors in LocalizedDisplayScriptTest on jdk 9

2016-04-28 Thread Knut Anders Hatlen (JIRA) 

 [ 
https://issues.apache.org/jira/browse/DERBY-6827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Knut Anders Hatlen updated DERBY-6827:
--
Fix Version/s: 10.11.1.3

> Errors in LocalizedDisplayScriptTest on jdk 9
> -
>
> Key: DERBY-6827
> URL: https://issues.apache.org/jira/browse/DERBY-6827
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Reporter: Rick Hillegas
> Fix For: 10.11.1.3, 10.12.1.1
>
> Attachments: derby-6827-01-aa-addProperty.diff, 
> derby-6827-01-ab-omitColumn.diff, z.out
>
>
> LocalizedDisplayScriptTest raises errors when run with the latest early 
> access build of JDK 9. This is due to a backward incompatibility introduced 
> into JDK 9 by this issue: https://bugs.openjdk.java.net/browse/JDK-8008577. 
> The fix may be simply to set the following java property when running this 
> test:
> java.locale.providers=JRE,SPI



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (DERBY-6827) Errors in LocalizedDisplayScriptTest on jdk 9

2016-04-28 Thread ASF subversion and git services (JIRA) 

[ 
https://issues.apache.org/jira/browse/DERBY-6827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15261652#comment-15261652
 ] 

ASF subversion and git services commented on DERBY-6827:


Commit 1741388 from [~knutanders] in branch 'code/branches/10.11'
[ https://svn.apache.org/r1741388 ]

DERBY-6827: Errors in LocalizedDisplayScriptTest on jdk 9

Merged revision 1692008 from trunk.

> Errors in LocalizedDisplayScriptTest on jdk 9
> -
>
> Key: DERBY-6827
> URL: https://issues.apache.org/jira/browse/DERBY-6827
> Project: Derby
>  Issue Type: Bug
>  Components: Test
>Reporter: Rick Hillegas
> Fix For: 10.12.1.1
>
> Attachments: derby-6827-01-aa-addProperty.diff, 
> derby-6827-01-ab-omitColumn.diff, z.out
>
>
> LocalizedDisplayScriptTest raises errors when run with the latest early 
> access build of JDK 9. This is due to a backward incompatibility introduced 
> into JDK 9 by this issue: https://bugs.openjdk.java.net/browse/JDK-8008577. 
> The fix may be simply to set the following java property when running this 
> test:
> java.locale.providers=JRE,SPI



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)