[JBoss JIRA] Created: (JBAS-4251) JMS persistance configuration for db2 (db2-jdbc2-service.xml)
by Rajesh Rajasekaran (JIRA)
JMS persistance configuration for db2 (db2-jdbc2-service.xml)
-------------------------------------------------------------
Key: JBAS-4251
URL: http://jira.jboss.com/jira/browse/JBAS-4251
Project: JBoss Application Server
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Components: JMS service
Reporter: Rajesh Rajasekaran
Assigned To: Adrian Brock
Fix For: JBossAS-4.2.0.GA, JBossAS-4.0.5.SP1
We need a db2-jdbc2-service.xml to be ship with jboss-4.2.x (and also jboss-4.0.x) to support DB2 databases.
To start with i copied oracle-jdbc2-service.xml to db2-jdbc2-service.xml and made a few SQL changes.
1.) With DB2 all primary keys should be explicitly mentioned NOT NULL
I added NOT NULL to TXID column.
CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER NOT NULL, PRIMARY KEY (TXID) )
WIth this persistance configurations work with DB2 8.0
2.) With DB2 7.2 the following query throws an error:
db2 => CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0604N The length, precision, or scale attribute for column, distinct type,
structured type, attribute of structured type, function, or type mapping
"MESSAGEBLOB" is not valid. SQLSTATE=42611
--
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
17 years, 10 months
[JBoss JIRA] Created: (JBAS-4240) SQL error in uuid-key-generator.sar jboss-service.xml against DB2 7.2
by Rajesh Rajasekaran (JIRA)
SQL error in uuid-key-generator.sar jboss-service.xml against DB2 7.2
---------------------------------------------------------------------
Key: JBAS-4240
URL: http://jira.jboss.com/jira/browse/JBAS-4240
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Reporter: Rajesh Rajasekaran
Assigned To: Rajesh Rajasekaran
Fix For: JBossAS-5.0.0.Beta2, JBossAS-4.2.0.GA, JBossAS-4.0.5.SP1
The spaces at the end of each line of the SQL doesn not work with DB2 7.2
<!-- Create table DDL -->
<attribute name="CreateTableDdl">
create table HILOSEQUENCES (
SEQUENCENAME varchar(50) not null,
HIGHVALUES integer not null,
constraint hilo_pk primary key (SEQUENCENAME)
)
</attribute>
The following error occurs on server startup:
2007-03-23 14:34:47,234 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Executing DDL: create table HILOSEQUENCES (
SEQUENCENAME varchar(50) not null,
HIGHVALUES integer not null,
constraint hilo_pk primary key (SEQUENCENAME)
)
2007-03-23 14:34:47,437 DEBUG [org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory] Starting failed jboss:service=KeyGeneratorFactory,type=HiLo
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -7, SQLSTATE: 42601, SQLERRMC:
;able HILOSEQUENCES (
at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
at com.ibm.db2.jcc.c.fg.b(fg.java:1160)
at com.ibm.db2.jcc.b.gb.h(gb.java:217)
at com.ibm.db2.jcc.b.gb.b(gb.java:46)
at com.ibm.db2.jcc.b.w.b(w.java:40)
at com.ibm.db2.jcc.b.vb.f(vb.java:118)
at com.ibm.db2.jcc.c.fg.m(fg.java:1155)
Going through the db2 reference says:
db2 => ? sql0007
SQL0007N The character "<character>" following "<text>" is
not valid.
Explanation: The specified "<character>" is not a valid
character in SQL statements. The "<text>" field indicates the 20
characters of the SQL statement that preceded the character that
is not valid.
Hence I am wrapping up the SQL in a single line.
However this problem does not exist with DB2 8.0
--
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
17 years, 10 months
[JBoss JIRA] Closed: (JBPM-603) create ui component for comments
by David Lloyd (JIRA)
[ http://jira.jboss.com/jira/browse/JBPM-603?page=all ]
David Lloyd closed JBPM-603.
----------------------------
Resolution: Duplicate Issue
Duplicates JBPM-567
> create ui component for comments
> --------------------------------
>
> Key: JBPM-603
> URL: http://jira.jboss.com/jira/browse/JBPM-603
> Project: JBoss jBPM
> Issue Type: Task
> Components: Web Interface
> Reporter: Tom Baeyens
> Assigned To: David Lloyd
> Fix For: jBPM 3.3
>
>
> 2 jsf UI components should be created based on the dataTable for showing comments.
> 1 component/tag for taskInstance comments and 1 for token comments.
> This should be a shortcut for something like this:
> <c:if test="#{taskBean.comments != null}">
> <h:dataTable var="comment" value="#{taskBean.comments}">
> <f:facet name="header">Comments</f:facet>
> <h:column>
> <f:facet name="header">Actor</f:facet>
> <h:outputText value="#{comment.actorId}"/>
> </h:column>
> <h:column>
> <f:facet name="header">Time</f:facet>
> <h:outputText value="#{comment.time}">
> <f:convertDateTime type="both" />
> </h:outputText>
> </h:column>
> <h:column>
> <f:facet name="header">Message</f:facet>
> <h:outputText value="#{comment.message}"/>
> </h:column>
> </h:dataTable>
> </c:if>
--
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
17 years, 10 months
[JBoss JIRA] Created: (JBPM-897) add feedback when navigating to the next task
by Tom Baeyens (JIRA)
add feedback when navigating to the next task
---------------------------------------------
Key: JBPM-897
URL: http://jira.jboss.com/jira/browse/JBPM-897
Project: JBoss jBPM
Issue Type: Task
Components: Web Interface
Reporter: Tom Baeyens
Assigned To: Tom Baeyens
Fix For: jBPM jPDL 3.2
when executing the process creates a new task after a task has been closed, the console navigates to the new task. currently, i think this is too confusing as there is no feedback. saying why the user navigated to this screen instead of the task list.
i think it is better to navigate to the task list always and generate feedback saying: 'these tasks were created for you during the process execution:...' with links that can take you to these tasks.
--
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
17 years, 10 months