Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | DB - Apache Derby |
| Version | 14.0 |
Apache Derby 10.10.1 Scripting tables gives java.sql.SQLException: Error marshalling or unmarshalling a user defined type
To reproduce,
1. Connect to Apache Derby at 10.10.1
2. Open Schema Script Generator and Script all tables in Apache Derby APP schema and you get the below exception
3. Can also be reproduced if you use Query Builder and Add a table and execute a query
java.sql.SQLException: Error marshalling or unmarshalling a user defined type: org.apache.derby.iapi.services.io.FormatableHashtable; local class incompatible: stream classdesc serialVersionUID = -5731031189493188802, local class serialVersionUID = 9217193027129228620
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ResultSet.getString(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.yꌁ́ꃺꐈ finally.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.Jꊦꀣꋷꁷ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.c?ꌋꊚꈪ.c(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.c?ꌋꊚꈪ.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简??한\\.c?ꌋꊚꈪ.run(Unknown Source)
Caused by: org.apache.derby.client.am.SqlException: Error marshalling or unmarshalling a user defined type: org.apache.derby.iapi.services.io.FormatableHashtable; local class incompatible: stream classdesc serialVersionUID = -5731031189493188802, local class serialVersionUID = 9217193027129228620
at org.apache.derby.client.am.Cursor.get_UDT(Unknown Source)
at org.apache.derby.client.am.Cursor.getString(Unknown Source)
... 6 more
Caused by: java.io.InvalidClassException: org.apache.derby.iapi.services.io.FormatableHashtable; local class incompatible: stream classdesc serialVersionUID = -5731031189493188802, local class serialVersionUID = 9217193027129228620
at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:560)
at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1580)
at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1493)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1729)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1326)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348)
at org.apache.derby.catalog.types.IndexDescriptorImpl.readExternal(Unknown Source)
at java.io.ObjectInputStream.readExternalData(ObjectInputStream.java:1795)
at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1754)
at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1326)
at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348)
... 8 more
DataStudio is currently bundled with derby.jar version 10.9.x and this version of derby 10.10.1 needs derby.jar version 10.10.x. I will attach the new jar file to the issue but we will need to do regression testing on the new jar file to bundle it with DataStudio 14. <file is to large to attach, will just email it to sachin>
Also I am not sure what was added for derby 10.10.1 and I will need to go through and see if there is anything we need to discuss adding. Issues would need to filed at an individual level.
New task is to evaluate apache derby 10.10 changes
New task is to evaluate apache derby 10.10 changes
Should be fixed by using the new Apache Derby JDBC Driver.
@Tariq - pls log a new issue for adding boolean data type for Derby for v14
Should be fixed by using the new Apache Derby JDBC Driver.
@Tariq - pls log a new issue for adding boolean data type for Derby for v14
Issue #9381 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 14.0.0-beta-19 |
| No time estimate |
DataStudio is currently bundled with derby.jar version 10.9.x and this version of derby 10.10.1 needs derby.jar version 10.10.x. I will attach the new jar file to the issue but we will need to do regression testing on the new jar file to bundle it with DataStudio 14. <file is to large to attach, will just email it to sachin>
Also I am not sure what was added for derby 10.10.1 and I will need to go through and see if there is anything we need to discuss adding. Issues would need to filed at an individual level.