hello ryan. We are not on app server configuration, just a rich client connecting to msql server database using odbc bridge. Using ojb 1.0RC6 before and HL Sequence generation works perfectly with this version and our configuration.
Sounds weird, seems ojb changed their identity creation protocol and this is incompatible with the bridge. Anyway, thanx for your response. Kevin -----Message d'origine----- De : Ryan Vanderwerf [mailto:[EMAIL PROTECTED] Envoyé : jeudi 17 février 2005 21:18 À : 'OJB Users List' Objet : RE: Problem with SQL Server and Ojb I don't think you want to use that scheme on SQL server, it's never worked well for me, especially in multiple app server farm situations. I would use the StoredProcedureSequenceImpl or the Native one (haven't tried the native one myself though). Ryan -----Original Message----- From: Kevin Viet [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 4:16 AM To: OJB-ML Subject: Problem with SQL Server and Ojb Hello I am using db-ojb-1.0.1.jar. My database is running on a server using Microsoft SQL Server. I have a problem with the high/low sequence generation with the OJB_HL_SEQ table. When I create a new object in my application, I store it immediately in the database and get the following error : [org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl] ERROR: Can't lookup new HighLowSequence for field intervenantPortailId using sequence name SEQ_G_INTERVENANTPORTAIL Error reading class type: org.apache.ojb.broker.util.sequence.HighLowSequence from result set, current read field was fieldName org.apache.ojb.broker.PersistenceBrokerException: Error reading class type: org.apache.ojb.broker.util.sequence.HighLowSequence from result set, current read field was fieldName at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(RowRea derDefaultImpl.java:208) at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readPkValuesFrom(RowR eaderDefaultImpl.java:186) at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterat or.java:421) at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:265) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Persistenc eBrokerImpl.java:1462) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele gatingPersistenceBroker.java:307) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele gatingPersistenceBroker.java:307) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.lookupStoreSe quence(SequenceManagerHighLowImpl.java:225) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(S equenceManagerHighLowImpl.java:193) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong (SequenceManagerHighLowImpl.java:145) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(A bstractSequenceManager.java:139) at org.apache.ojb.broker.util.BrokerHelper.setAutoIncrementValue(BrokerHelper.j ava:317) at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java :364) at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:176) at org.apache.ojb.broker.Identity.init(Identity.java:150) at org.apache.ojb.broker.Identity.<init>(Identity.java:119) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl .java:691) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi stenceBroker.java:175) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi stenceBroker.java:175) at mypackage.myclass.execute(CreerIntervenantClientAnonyme.java:74) at mypackage.myclass.executeService(BusinessInvoker.java:221) at mypackage.myclass.execute(BusinessInvoker.java:132) at mypackage.myclass.creationIntervenantAnonyme(AccueilPortailExitAction.java:1 07) at mypackage.myclass.appelComposant(AccueilPortailExitAction.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) ... Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]invalid descriptor index at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5702) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:356) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413) at org.apache.ojb.broker.util.JdbcTypesHelper$T_Varchar.readValueFromResultSet( JdbcTypesHelper.java:378) at org.apache.ojb.broker.util.JdbcTypesHelper$BaseType.getObjectFromColumn(Jdbc TypesHelper.java:302) at org.apache.ojb.broker.util.JdbcTypesHelper$BaseType.getObjectFromColumn(Jdbc TypesHelper.java:281) at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(RowRea derDefaultImpl.java:201) ... 36 more This error happens in the object Indentity creation protocol. Help appreciated, thanx Kévin VIET --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]