Bug 780427 (SOA-2859) - Running the ModeShape tests via CTC framework is seeing: Caused by: java.sql.SQLException: Cannot convert String value to long
Summary: Running the ModeShape tests via CTC framework is seeing: Caused by: java.sql...
Keywords:
Status: CLOSED DUPLICATE of bug 2040112
Alias: SOA-2859
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER8
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-31 17:35 UTC by Van Halbert
Modified: 2011-02-01 12:49 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-02-01 12:49:37 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 780429 0 urgent CLOSED When using Designer to import from ModeShape, the table nt_childNodeDefinition, is exposing 2 columns (jcr_name and jcr_... 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-2859 0 None None None Never

Internal Links: 780429

Description Van Halbert 2011-01-31 17:35:44 UTC 
project_key: SOA

Running ModeShape tests that include publishing a variety of file times and then querying, is seeing the following exception:

Caused by: java.sql.SQLException: Cannot convert String value to long
	at org.modeshape.jdbc.JcrResultSet.getValueObject(JcrResultSet.java:1286)
	at org.modeshape.jdbc.JcrResultSet.getValueReturn(JcrResultSet.java:1244)
	at org.modeshape.jdbc.JcrResultSet.getLong(JcrResultSet.java:869)
	at org.modeshape.jdbc.JcrResultSet.getLong(JcrResultSet.java:859)
	at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:711)
	at org.teiid.translator.jdbc.JDBCExecutionFactory.retrieveValue(JDBCExecutionFactory.java:862)
	at org.teiid.translator.jdbc.JDBCQueryExecution.next(JDBCQueryExecution.java:101)
	... 13 more
Caused by: javax.jcr.ValueFormatException: Cannot convert String value to long
	at org.modeshape.jcr.JcrValue.createValueFormatException(JcrValue.java:100)
	at org.modeshape.jcr.JcrValue.getLong(JcrValue.java:200)
	at org.modeshape.jdbc.JcrResultSet.getValueObject(JcrResultSet.java:1280)
	... 19 more

Not sure which file type is triggering this issue, but further testing will hopefully indicate that.
Comment 1 Van Halbert 2011-02-01 12:45:02 UTC 
Link: Added: This issue is related to SOA-2861
Comment 2 Van Halbert 2011-02-01 12:47:51 UTC 
The problem is due to the duplicate columns that exist in the following tables:

Duplicate Column jcr:path in table nt:address
Duplicate Column jcr:name in table nt:childNodeDefinition
Duplicate Column jcr:name in table nt:propertyDefinition

These duplicates are being exposed by the ModeShape jdbc driver when used to import the tables to create the ModeShape.xmi model and ModeShape.vdb.
Comment 3 Van Halbert 2011-02-01 12:48:11 UTC 
Link: Added: This issue is a dependency of MODE-1088
Comment 4 Van Halbert 2011-02-01 12:49:37 UTC 
This problem is covered in SOA-2861 and its related MODE-1088.
Note You need to log in before you can comment on or make changes to this bug.