As usual i was searching to little before posting :)
found it just after i pressed send.
To make jms and mysql without this error you only need to configure this:
In jbossmq-service.xml replace the MESSAGEBLOB OBJECT with BLOB in this line:
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (
MESSAGEID INTEGER NOT NULL, \
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
-Jon
> -----Original Message-----
> From: Jon Finanger [mailto:[EMAIL PROTECTED]]
> Sent: 16. januar 2003 14:40
> To: [EMAIL PROTECTED]
> Subject: A 32RC1 error
>
>
> During startup jboss throws this error (below).
> It indicates that a table is missing. The only configuration i've done is to remove
>hsqldb-ds.xml with mysql-ds.xml and
> added the mysql driver jar to lib.
> The only table i can see jms has created is: jms_transactions
>
> Anything i'm missing?
>
> -Jon
>
> 14:19:52,211 INFO [DefaultDS] Bound connection factory for resource adapter for
> ConnectionManager 'jboss.jca:service=LocalTxCM,name=DefaultDS to JNDI name
>'java:/DefaultDS'
> 14:19:52,241 INFO [LocalTxConnectionManager] Started
> 14:19:52,241 INFO [PersistenceManager] Starting
> 14:19:53,103 ERROR [PersistenceManager] Starting failed
> org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Messag
> e recovery may not be accurate; - nested throwable: (java.sql.SQLException: Gene
> ral error: Table 'smartpool.jms_messages' doesn't exist)
-------------------------------------------------------
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
