OJB / MS SQL Server [re post]

[LAURENT Stephane <bi...@sportmalin.com>]

The only driver working fine with MS SQL Server 7 is JSQLConnect.
Try jtds from source forge, seems to work, can get collection by query but
have exception when try to get object by query (working fine with
JSQLConnect)
Why ? Any idea ?

here is my repository_database.xml :
(ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryN
otPooledImpl )

<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="MsSQLServer"
jdbc-level="4.0"
driver="net.sourceforge.jtds.jdbc.Driver"
protocol="jdbc"
subprotocol="jtds:sqlserver"
dbalias="//localhost:1433/Perso"
username="test"
password="ultrabill"
batch-mode="false"
useAutoCommit="2"
ignoreAutoCommitExceptions="false" >
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="1"/>
</sequence-manager>
</jdbc-connection-descriptor>


and here is the exception ::
java.lang.ClassCastException
at net.sourceforge.jtds.jdbc.PreparedStatement_base.setObject(UnknownSource)
at net.sourceforge.jtds.jdbc.PreparedStatement_base.setObject(UnknownSource)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Unknow
n Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindSelectionCriteria(Unk
nown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
atorg.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkn
own Source)
atorg.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unkn
own Source)
at
com.mps.safari.util.dbaccess.PersistenceManager.getObjectById(PersistenceMan
ager.java:109)
at
com.mps.annuaire.actions.DetailUpdatePersonneAction.prepareData(DetailUpdate
PersonneAction.java:44)
at
com.mps.safari.actions.detail.DetailAction.performAction(DetailAction.java:4
3)
at com.mps.safari.actions.SecuredAction.execute(SecuredAction.java:81)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:446)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.mps.annuaire.servlet.ContactActionServlet.process(ContactActionServlet.j
ava:158)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
...
at java.lang.Thread.run(Thread.java:536)

rethrown as org.apache.ojb.broker.PersistenceBrokerException
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(UnknownSou
rce)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unkn
own Source)
at
com.mps.safari.util.dbaccess.PersistenceManager.getObjectById(PersistenceMan
ager.java:109)
at
com.mps.annuaire.actions.DetailUpdatePersonneAction.prepareData(DetailUpdate
PersonneAction.java:44)
at
com.mps.safari.actions.detail.DetailAction.performAction(DetailAction.java:4
3)
at com.mps.safari.actions.SecuredAction.execute(SecuredAction.java:81)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:446)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at
com.mps.annuaire.servlet.ContactActionServlet.process(ContactActionServlet.j
ava:158)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
...
at java.lang.Thread.run(Thread.java:536)

Caused by: java.lang.ClassCastException
at net.sourceforge.jtds.jdbc.PreparedStatement_base.setObject(UnknownSource)
at net.sourceforge.jtds.jdbc.PreparedStatement_base.setObject(UnknownSource)
at
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Unknow
n Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.bindSelectionCriteria(Unk
nown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(UnknownSource)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
...



Thanks.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org