Re: Problem with SQL Server and Ojb

Armin Waibel Thu, 17 Feb 2005 13:23:03 -0800

Hi Kevin,

which driver do you use, Sun's JdbcOdbc bridge? If yes, this could lead to problems, try a "real" (don't use type 1 driver) jdbc-driver instead. Sorry can't help more, never used MSSQL.

regards,
Armin

Kevin Viet wrote:

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]

Re: Problem with SQL Server and Ojb

Reply via email to