<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
jBPM 4.4 on sybase
</h3>
<span style="margin-bottom: 10px;">
reply from <a href="http://community.jboss.org/people/bcrowell2">William Crowell</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/558359#558359">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>I have the same issue.  I can't move to another driver though.  Here is what I have run into:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am running into a problem with a simple database row insert into Sybase.</p><p>I could see others running into the same problem since we use the same  jconn3 driver.</p><p>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.</p><p>The problem is that you can't insert into a table if there are more than  2 text/varchar columns defined in the table.</p><p>For instance if you have a table like this:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>CREATE TABLE section( <br/> id INTEGER IDENTITY PRIMARY KEY, <br/> name text,  <br/> summary text, <br/> description text <br/> )</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And you try the configuration above, you receive the following error:</p><p>com.sybase.jdbc3.jdbc.SybSQLException: A wrong datastream has been sent  to the server. The server was expecting token 32 but got the <br/>token 33. This  is an internal error.</p><p>        at com.sybase.jdbc3.tds.Tds.a(Unknown Source) <br/>        at  com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) <br/>        at  com.sybase.jdbc3.tds.Tds.new(Unknown Source) <br/>        at  com.sybase.jdbc3.tds.Tds.doCommand(Unknown Source) <br/>        at  com.sybase.jdbc3.tds.Tds.endTransaction(Unknown Source) <br/>        at  com.sybase.jdbc3.jdbc.SybConnection.rollback(Unknown Source) <br/>... <br/>         at com.ibatis.common.jdbc.SimpleDataSource  $SimplePooledConnection.invoke(SimpleDataSource.java:958) ... <br/>         at  com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy­.java:  68) <br/>... <br/>        at  com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.rollback(JdbcTran­saction.java:  72) <br/>        at  com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionMana­ger.java:  87) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapE­xecutorDelegate.java:  734) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessio­nImpl.java:  176) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientI­mpl.java:  153) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(Sql­MapExecutorDelegate.java:  835) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorD­elegate.java:  410)        </p><p>        at  com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.ja­va:  82) <br/>        at  com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java­:  58) <br/>        at  com.xxxxxxxxxxx.dao.SectionDAO.createSection(SectionDAO.java:75) <br/>        at  com.xxxxxxxxxxx.model.SectionTest.testContext(SectionTest.java:34) <br/>... <br/>         at  org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestM­ethod.java:  160)</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Now change the table definition to leave out the description field to  <br/>this:</p><p>CREATE TABLE section( <br/> id INTEGER IDENTITY PRIMARY KEY, <br/> name text,  <br/> summary text <br/>)</p><p>Then the table insert happens.</p><p>There is not much on Google for the "The server was expecting token 32  but got the token 33" exception.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><a class="jive-link-external-small" href="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</a> <br/><a class="jive-link-external-small" href="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</a></p><p><a class="jive-link-external-small" href="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</a></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I see a bug was opened up on it on the old iBatis' Apache Support site:</p><p><a class="jive-link-external-small" href="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</a></p><p>But the bug was closed prematurely by Larry Meadors with iBatis <br/>because  they moved to Google Groups myBatis.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/558359#558359">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>