Hi all, The only driver working fine (for me, using PB API) with MS SQL Server 7 is JSQLConnect. Try last 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" (<= tested with 2.0, same exception) driver="net.sourceforge.jtds.jdbc.Driver" protocol="jdbc" subprotocol="jtds:sqlserver" dbalias="//localhost:1433/Perso" username="test" password="password" 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003
