What is the column type in database for LAST_NAME? If it is varchar, what is the length if any specified?
Regards, Amita On 11/3/07, Jason Clark <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > >
