[jbpm-issues] [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size

Mon Aug 25 06:53:38 EDT 2008

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

Thomas Diesler updated JBPM-1176:
---------------------------------

    Fix Version/s: JBossBPM-3.3.0.GA

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] 

> Document the Sybase related issue - page size
> ---------------------------------------------
>
>                 Key: JBPM-1176
>                 URL: https://jira.jboss.org/jira/browse/JBPM-1176
>             Project: JBoss jBPM
>          Issue Type: Feature Request
>          Components: Documentation
>    Affects Versions: jPDL 3.2.2
>            Reporter: Jiri Pechanec
>             Fix For: JBossBPM-3.3.0.GA
>
>
> The Sybase does not allow table row be longer than the page size. Unfortuantely by default the page size is just 2 KB and e.g. See the relathe table that stores variable instances can store strings with size 4000.
> This limitation should be documented.
> See the related documentation
> http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/15288;pt=15335
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.commands/html/commands/commands16.htm
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.utility/html/utility/utility203.htm

-- 
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