activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ErinO <ErinOc...@hotmail.com>
Subject error using MySql
Date Tue, 11 Apr 2006 17:56:56 GMT

Hi, 

I am trying to config the ActiveMQ 4.0 RC1 to use mysql, I tried both
mysql-connector-java-3.1.12-bin.jar and
mysql-connector-java-5.0.0-beta-bin.jar, and got the same error message:

Failure was: CREATE TABLE ACTIVEMQ_ACKS(CONTAINER VARCHAR(250) NOT NULL,
CLIENT_ID VARCHAR(250) NOT NULL, SUB_NAME VARCHAR(250) NOT NULL, SELECTOR
VARCHAR(250), LAST_ACKED_ID INTEGER, PRIMARY KEY ( CONTAINER, CLIENT_ID,
SUB_NAME)) Message: Specified key was too long; max key length is 1024 bytes
SQLState: 42000 Vendor code: 1071

This is part of the config file related to db setup:
 <persistenceAdapter>
      <journaledJDBC journalLogFiles="5" dataDirectory="../activemq-data"
dataSource="#mysql-ds" useJournal="true">
        <adapter><bytesJDBCAdapter/></adapter>
      </journaledJDBC>      
    </persistenceAdapter>
 
<bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url"
value="jdbc:mysql://localhost/boe120?relaxAutoCommit=true"/>
    <property name="username" value="sa"/>
    <property name="password" value="password"/>
    <property name="poolPreparedStatements" value="true"/>
</bean>

Please let me know what I did wrong.

Thanks.

Erin
--
View this message in context: http://www.nabble.com/error-using-MySql-t1433357.html#a3867047
Sent from the ActiveMQ - User forum at Nabble.com.


Mime
View raw message