Re: Sybase and Enhydra

Thanks Vladimir

This worked ok.

Now I am get another problem:

2005-07-15 10:31:51,343: Problem while initializing caches !!!
com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed 
within mu
lti-statement transaction.

        at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:3069)
        at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2373)
        at 
com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
        at 
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
        at 
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
        at 
com.sybase.jdbc3.jdbc.SybStatement.updateLoop(SybStatement.java:1811)
        at 
com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(SybStatement.java:17
94)
        at 
com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(SybPreparedS
tatement.java:116)
        at com.sybase.jdbc3.tds.Tds.setOption(Tds.java:1344)
        at 
com.sybase.jdbc3.jdbc.SybConnection.setAutoCommit(SybConnection.java:
1011)
        at 
com.lutris.appserver.server.sql.standard.StandardDBConnection.setAuto
Commit(StandardDBConnection.java:669)
        at 
com.lutris.appserver.server.sql.standard.StandardDBTransaction.<init>
(StandardDBTransaction.java:120)
        at 
com.lutris.appserver.server.sql.standard.StandardDBTransactionFactory
.getTransaction(StandardDBTransactionFactory.java:31)
        at 
com.lutris.appserver.server.sql.standard.StandardLogicalDatabase.crea
teTransaction(StandardLogicalDatabase.java:560)
        at 
com.lutris.appserver.server.sql.StandardDatabaseManager.createTransac
tion(StandardDatabaseManager.java:732)
        at 
org.enhydra.shark.transaction.DODSTransactionFactory.createTransactio
n(DODSTransactionFactory.java:37)
        at 
org.enhydra.shark.SharkUtilities.createTransaction(SharkUtilities.jav
a:686)
        at org.enhydra.shark.Shark.initCaches(Shark.java:317)
        at org.enhydra.shark.Shark.init(Shark.java:299)
        at org.enhydra.shark.Shark.configure(Shark.java:120)
        at 
org.enhydra.shark.swingclient.SharkClient.findWorkflowServer(SharkCli
ent.java:93)

Is there a fix for this or I have to look in the source?

Regards
Aaron

Vladimir Puskas wrote:

> Hello Aaron
>
> you wrote:
>
>> Hi
>>
>> Finally I managed to fix this by extracting the contents of 
>> jconn2.jar and adding the path to java.ext.dirs in this way:
>>
>>    cd $(dirname $0)/..
>>    /installed/j2sdk1.4.1_06/bin/java \
>>        -Xmx128M -verbose 
>> -Djava.ext.dirs=lib:lib/engine:lib/client:lib/contrib:lib/wrapper:/home/aaron/shark/jConnect-6_0/classes 
>> \
>>        org.enhydra.shark.swingclient.workflowadmin.SharkAdmin \
>>        conf/Shark.conf
>>
>> Now I am having a different problem. The error being reported is the 
>> following:
>>
>> com.lutris.appserver.server.sql.ObjectIdAllocationError: 
>> ObjectIdAllocator:
>>  Failed to allocate object id.  Caused by SQLException:
>>    SQLState = 42000
>>    SQLError = 208
>>    SQLMsg   = objectid not found. Specify owner.objectname or use 
>> sp_help to check whether the object exists (sp_help may produce lots 
>> of output).
>>
>> Does anyone know what this error is about? It seems that the OID 
>> allocator is failing. Which class is responsible  for sybase to 
>> create such oids?
>
>
> Here DODS complains about "ObjectId" table. Did you create it, having 
> to fix our scripts (sorry 'bout that), you might have missed to
>
> create table ObjectId
>     (
>         next DECIMAL (19,0) NOT NULL PRIMARY KEY
>     );
>
> hope this helps
>
>------------------------------------------------------------------------
>
>
>--
>You receive this message as a subscriber of the [email protected] mailing list.
>To unsubscribe: mailto:[email protected]
>For general help: mailto:[email protected]?subject=help
>ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  
>

---
[This E-mail was scanned for spam and viruses by NextGen.net.]

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws