[jboss-user] [jBPM] - jBPM 4.4 on sybase

[William Crowell]

William Crowell [http://community.jboss.org/people/bcrowell2] replied to the discussion

"jBPM 4.4 on sybase"

To view the discussion, visit: http://community.jboss.org/message/558359#558359

--------------------------------------------------------------
I have the same issue.  I can't move to another driver though.  Here is what I have run into:

I am running into a problem with a simple database row insert into Sybase.
I could see others running into the same problem since we use the same  jconn3 driver.
I am using iBatis 2.3.4.726 (the last version of iBatis 2), Sybase Thin  jconn3 version 6.5 drivers, and JUnit 4 on Java 1.6.
The problem is that you can't insert into a table if there are more than  2 text/varchar columns defined in the table.
For instance if you have a table like this:

CREATE TABLE section( 
 id INTEGER IDENTITY PRIMARY KEY, 
 name text,  
 summary text, 
 description text 
 )

And you try the configuration above, you receive the following error:
com.sybase.jdbc3.jdbc.SybSQLException: A wrong datastream has been sent  to the server. The server was expecting token 32 but got the 
token 33. This  is an internal error.
        at com.sybase.jdbc3.tds.Tds.a(Unknown Source) 
        at  com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) 
        at  com.sybase.jdbc3.tds.Tds.new(Unknown Source) 
        at  com.sybase.jdbc3.tds.Tds.doCommand(Unknown Source) 
        at  com.sybase.jdbc3.tds.Tds.endTransaction(Unknown Source) 
        at  com.sybase.jdbc3.jdbc.SybConnection.rollback(Unknown Source) 
... 
         at com.ibatis.common.jdbc.SimpleDataSource  $SimplePooledConnection.invoke(SimpleDataSource.java:958) ... 
         at  com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy­.java:  68) 
... 
        at  com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.rollback(JdbcTran­saction.java:  72) 
        at  com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionMana­ger.java:  87) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapE­xecutorDelegate.java:  734) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessio­nImpl.java:  176) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientI­mpl.java:  153) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(Sql­MapExecutorDelegate.java:  835) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorD­elegate.java:  410)        
        at  com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.ja­va:  82) 
        at  com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java­:  58) 
        at  com.xxxxxxxxxxx.dao.SectionDAO.createSection(SectionDAO.java:75) 
        at  com.xxxxxxxxxxx.model.SectionTest.testContext(SectionTest.java:34) 
... 
         at  org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestM­ethod.java:  160)

Now change the table definition to leave out the description field to  
this:
CREATE TABLE section( 
 id INTEGER IDENTITY PRIMARY KEY, 
 name text,  
 summary text 
)
Then the table insert happens.
There is not much on Google for the "The server was expecting token 32  but got the token 33" exception.

 http://www.google.com/url?sa=D&q=http://www.talendforge.org/bugs/view.php%3Fid%3D13087%26nbn%3D2&usg=AFQjCNEjDbwadOUYdJsUY9FnzeONp3gzEA http://www.talendforge.org/bugs/view.php?id=13087&nbn=2 
 http://www.google.com/url?sa=D&q=http://comments.gmane.org/gmane.comp.java.ibatisdb.user/39&usg=AFQjCNHMPIMTaPh--M1CKqEQ6NJZGi8h6Q http://www.google.com/url?sa=D&q=http://comments.gmane.org/gmane.comp.java.ibatisdb.user/39&usg=AFQjCNHMPIMTaPh--M1CKqEQ6NJZGi8h6Q
 http://www.google.com/url?sa=D&q=http://comments.gmane.org/gmane.comp.java.ibatisdb.user/39&usg=AFQjCNHMPIMTaPh--M1CKqEQ6NJZGi8h6Q http://comments.gmane.org/gmane.comp.java.ibatisdb.user/39

I see a bug was opened up on it on the old iBatis' Apache Support site:
 http://www.google.com/url?sa=D&q=http://osdir.com/ml/db.ibatis.devel/2006-04/msg00036.html&usg=AFQjCNErxvea6vo_IMZ4OoO2AD1pB-i0gQ http://osdir.com/ml/db.ibatis.devel/2006-04/msg00036.html
But the bug was closed prematurely by Larry Meadors with iBatis 
because  they moved to Google Groups myBatis.

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/558359#558359]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100820/9b9a8c00/attachment.html