My Config.
<ConnectionInfo>
<ConnectionProperties
driverClass="net.sourceforge.jtds.jdbc.Driver"
databaseURL="jdbc:jtds:sqlserver://************/cr"
userName="*****"
password="*******"
loginTimeout="600"/>
</ConnectionInfo>
<Command name="all contacts" SQL="select ID,LAST_NAME from CONTACTS"
kind="Select">
<ResultDescriptor columnName="ID" tableName="CONTACTS"
columnType="commonj.sdo.Int"/>
<ResultDescriptor columnName="LAST_NAME" tableName="CONTACTS"
columnType="commonj.sdo.String"/>
</Command>
<Table tableName="CONTACTS">
<Column columnName="ID" primaryKey="true" generated="true"/>
</Table>
With the JTDS driver, I get the following exception.
Exception in thread "main" java.lang.ClassCastException: The value of type
'class net.sourceforge.jtds.jdbc.ClobImpl' must be of type 'class
java.lang.String'
at
org.eclipse.emf.ecore.impl.EStructuralFeatureImpl$InternalSettingDelegateSin
gleDataUnsettableStatic.validate(EStructuralFeatureImpl.java:2195)
at
org.eclipse.emf.ecore.impl.EStructuralFeatureImpl$InternalSettingDelegateSin
gleDataUnsettable.dynamicSet(EStructuralFeatureImpl.java:2116)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eDynamicSet(BasicEObjectImpl.jav
a:709)
at
org.apache.tuscany.sdo.impl.DynamicDataObjectImpl.eDynamicSet(DynamicDataObj
ectImpl.java:160)
at org.apache.tuscany.sdo.impl.DataObjectImpl.eSet(DataObjectImpl.java:1459)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eSet(BasicEObjectImpl.java:654)
at org.apache.tuscany.sdo.impl.DataObjectImpl.set(DataObjectImpl.java:142)
at
org.apache.tuscany.das.rdb.graphbuilder.impl.DataObjectMaker.createAndAddDat
aObject(DataObjectMaker.java:90)
at
org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.addRowToGrap
h(ResultSetProcessor.java:127)
at
org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.processResul
tSet(ResultSetProcessor.java:91)
at
org.apache.tuscany.das.rdb.graphbuilder.impl.ResultSetProcessor.processResul
ts(ResultSetProcessor.java:77)
at
org.apache.tuscany.das.rdb.impl.ReadCommandImpl.buildGraph(ReadCommandImpl.j
ava:309)
at
org.apache.tuscany.das.rdb.impl.ReadCommandImpl.executeQuery(ReadCommandImpl
.java:277)
at
com.p21csi.cr.service.contact.ContactDASTest.getContacts(ContactDASTest.java
:22)
at
com.p21csi.cr.service.contact.ContactDASTest.printContacts(ContactDASTest.ja
va:28)
at com.p21csi.cr.service.contact.ContactDASTest.main(ContactDASTest.java:41)
But, with the MS Driver, I get no exception and it executes correctly?
I'm not sure if this has anything to do with Tuscany and DAS directly, but I
was just wondering if anyone had any idea why this is happening?
-Jason Clark
