[jboss-jira] [JBoss JIRA] Commented: (JBAS-4251) JMS persistance configuration for db2 (db2-jdbc2-service.xml)

Thu Mar 29 05:13:32 EDT 2007

    [ http://jira.jboss.com/jira/browse/JBAS-4251?page=comments#action_12357741 ] 

Dimitris Andreadis commented on JBAS-4251:
------------------------------------------

Rajesh, what you want to do with this?

> 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: Rajesh Rajasekaran
>             Fix For: JBossAS-4.0.5.SP1 , JBossAS-4.2.0.GA
>
>
> 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