I know that the Microsoft jdbc driver does not handle clob correctly. Try using jtds driver on http://jtds.sourceforge.net/
Guillaume > -----Message d'origine----- > De : Frank Renaers [mailto:[EMAIL PROTECTED] > Envoye : jeudi 19 aout 2004 12:00 > A : [EMAIL PROTECTED] > Objet : MSSQL and CLOB > > > Hi, > > > > We are using OJB1.0.0 > > It seems that it's not possible to read a MSSQL TEXT column when we use > the Jdbc CLOB datatype. > > It works when we use the LONGVARCHAR datatype, but we can't use it > because we would like to support also Oracle databases. > > We are using the following mappings : > > Java Type : String > > Jdbc Type : CLOB > > Mssql Database Type : TEXT > > We always get the following exception. > > > > rethrown as org.apache.ojb.broker.PersistenceBrokerException: Error > reading class type: > be.ikan.lib.ojb.bo.operatingsystem.OperatingSystemBean from result set, > current read field was log: [Microsoft][SQLServer 2000 Driver for > JDBC]Unsupported data conversion. > > at > org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(Un > known Source) > > at > org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readObjectArrayFr > om(Unknown Source) > > at > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(Unkno > wn Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Unknown > Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(U > nknown Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Unk > nown Source) > > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknow > n Source) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery( > Unknown Source) > > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery( > Unknown Source) > > > > Does someone have a solution for this ? > > > > Thanks, > > > > Frank Renaers > > Ikan Software > > > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
