[jbpm-issues] [JBoss JIRA] Reopened: (JBPM-702) Use non-nullable binary fields instead of varbinary on Sybase

[Thomas Diesler (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBPM-702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Diesler reopened JBPM-702:
---------------------------------



FYI, I've asked Goldman which issues they are still facing with getting jBPM to work on Sybase, and this was their reply:

"All the JIRA items [see below] are necessary. The database version we are using are Sybase 12.5 and UDB version is 9.1.5. We are using jconn2.jar and jconn3.jar for Sybase, db2jcc.jar for UDB."

Sybase related JIRA items:
1. Usage of 'CLOB' columns instead of 'VARCHAR(4000)' [JBPM-701]
2. Usage of 'BINARY NOT NULL' columns instead of 'VARBINARY' [JBPM-702]
3. Avoid truncation of large context data by using the JCONNECT_VERSION=6 option [JBPM-703]
4. Increase the default page size [JBPM-1176] 

> Use non-nullable binary fields instead of varbinary on Sybase
> -------------------------------------------------------------
>
>                 Key: JBPM-702
>                 URL: https://jira.jboss.org/jira/browse/JBPM-702
>             Project: JBoss jBPM
>          Issue Type: Sub-task
>          Components: Core Engine
>            Reporter: Ryan Campbell
>            Assignee: Tom Baeyens
>             Fix For: jBPM 3.1.3, JBossBPM-3.3.0.GA
>
>
> Sybase truncates trailing zeros of blobs which prevents blog retrieval.  These fields need to be created as non-nullable binary fields, not varbinary.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira