View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3820286#3820286
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3820286 I defined these tables in Oracle DB and is running ok : -- Create table create table JMS_MESSAGES ( MESSAGEID NUMBER not null, DESTINATION VARCHAR2(255) not null, TXID NUMBER, TXOP CHAR(1), MESSAGEBLOB BLOB ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table JMS_MESSAGES add constraint SYS_PK_JMS_MESSAGES primary key (MESSAGEID,DESTINATION) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table JMS_TRANSACTIONS ( TXID NUMBER ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
