Bug 780427 (SOA-2859)

Summary:	Running the ModeShape tests via CTC framework is seeing: Caused by: java.sql.SQLException: Cannot convert String value to long
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Van Halbert <vhalbert>
Component:	EDS	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED DUPLICATE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.1.0.ER8	CC:	vhalbert
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-2859
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-02-01 12:49:37 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

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.