7:37 a.m.
Document the Sybase related issue - page size
---------------------------------------------
Key: JBPM-1176
URL: http://jira.jboss.com/jira/browse/JBPM-1176
Project: JBoss jBPM
Issue Type: Feature Request
Components: Documentation
Affects Versions: jBPM jPDL 3.2.2
Reporter: Jiri Pechanec
Assigned To: Tom Baeyens
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:43 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size
[ http://jira.jboss.com/jira/browse/JBPM-1176?page=all ]
Thomas Diesler updated JBPM-1176:
---------------------------------
Assignee: (was: Tom Baeyens)
Document the Sybase related issue - page size
---------------------------------------------
Key: JBPM-1176
URL: http://jira.jboss.com/jira/browse/JBPM-1176
Project: JBoss jBPM
Issue Type: Feature Request
Components: Documentation
Affects Versions: jBPM jPDL 3.2.2
Reporter: Jiri Pechanec
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:53 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
1:44 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Thomas Diesler updated JBPM-1176:
---------------------------------
Fix Version/s: jBPM 3.3.0 CR1
(was: jBPM 3.3.0)
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: jBPM 3.2.2
Reporter: Jiri Pechanec
Fix For: jBPM 3.3.0 CR1
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
1:46 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Thomas Diesler updated JBPM-1176:
---------------------------------
Assignee: Alejandro Guizar
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: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: jBPM 3.3.0 CR1
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
2:38 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar commented on JBPM-1176:
----------------------------------------
From the Sybase reference manual (1):
Adaptive Server stores text and image data in a linked list of data pages that are
separate from the rest of the table. Each text or image page stores one logical page size
worth of data (2, 4, 8, or 16K). All text and image data for a table is stored in a single
page chain, regardless of the number of text and image columns the table contains.
For us, this means that changing the varchar(4000) columns to text [JBPM-701] will also
address the page size issue with no further limitations.
(1) http://download.sybase.com/pdfdocs/asg1250e/refman1.pd
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: SOA 4.2 CP03, jBPM 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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
2:38 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar updated JBPM-1176:
-----------------------------------
Comment: was deleted
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: SOA 4.2 CP03, jBPM 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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
2:38 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar commented on JBPM-1176:
----------------------------------------
From the Sybase reference manual (1):
Adaptive Server stores text and image data in a linked list of data pages that are
separate from the rest of the table. Each text or image page stores one logical page size
worth of data (2, 4, 8, or 16K). All text and image data for a table is stored in a single
page chain, regardless of the number of text and image columns the table contains.
For us, this means that changing the varchar(4000) columns to text [JBPM-701] will also
address the page size issue with no further limitations.
(1) http://download.sybase.com/pdfdocs/asg1250e/refman1.pdf
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: SOA 4.2 CP03, jBPM 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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
4:14 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar commented on JBPM-1176:
----------------------------------------
Page size documentation available at http://www.jboss.org/community/docs/DOC-12936
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: SOA 4.2 CP03, jBPM 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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
4:48 a.m.
New subject: [JBoss JIRA] Resolved: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar resolved JBPM-1176.
------------------------------------
Resolution: Done
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: SOA 4.2 CP03, jBPM 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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
1:43 a.m.
New subject: [JBoss JIRA] Closed: (JBPM-1176) Document the Sybase related issue - page size
[
https://jira.jboss.org/jira/browse/JBPM-1176?page=com.atlassian.jira.plug...
]
Alejandro Guizar closed JBPM-1176.
----------------------------------
Closing issues that I resolved in already released versions.
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: Productization
Affects Versions: jBPM 3.2.2
Reporter: Jiri Pechanec
Assignee: Alejandro Guizar
Fix For: jBPM 3.3.0 GA, SOA 4.2 CP03
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__...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15...
--
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
5615
days inactive
5849
days old
10 comments
3 participants
participants (3)
-
Alejandro Guizar (JIRA) -
Jiri Pechanec (JIRA)
-
Thomas Diesler (JIRA)