View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3821650#3821650
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3821650 Hello, I send it in [Connectors and JCA/JBoss], because [Messaging, JMS & JBossMQ] won't work, the error message is 'Cannot invoke the operation : the module threw an exception'. I want to store the message queues in an Oracle 9i (Version 9.2.0.2.0) Database, but it fails. It seems that Oracle don't like the "BLOB" in the "CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )" statement. I have allready tried to create this table manually, then I get the folowing error message: "ORA-00406: COMPATIBLE-Parameter muss 9.2.0.0.0 oder groesser sein" In english it have to: "ORA-00406: COMPATIBLE parameter needs to be 9.2.0.0.0 or greater" When I remove the BLOB it worked, so I think Oracle don't like the BLOB datatyp. Is there any solution of this Problem? Regards Bjoern PS: I used the oracle-jdbc2-service.xml from the examples directory and the Oracle 9i jdbc driver. ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
