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.
