Hello Users,
I am using Jboss 4.0.0RC2 with an MS Access database.
Apparently Jboss does not provide the datatype mappings for MS Access so I have tried to create my own, which may be part of the problem.
Ths issue is when I start up JBoss I get the following error:
2004-12-20 14:58:40,203 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Could not create table with SQL:CREATE CACHED TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
<category name="org.jboss.ejb.plugins"> <priority value="TRACE" class="org.jboss.logging.XLevel"/> </category>