Hi, I thought I made all the necessary changes to assign MYSQL as the default Database
for JBOSS (all). and I removed all the hsqldb configuration files
However, at startup, jboss tries to create a table with warchar(256) fields that
MySQL doesn't support (hypersonic SQL did support them)
Following is a snippet of the error log.
It doesn't stop JBOSS (all) to start, and the jmx console to show up, but it doesn't
seem nice, and I don't know what the consequences could be to leave it like that.
any help appreciated
here comes the snippet
====================================
2004-07-08 18:32:08,343 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.MetaDataEntity] Executing SQL: CREATE
TABLE JBOSS_METADATA_ENTITY_BEANS (IDENTITY VARCHAR(256) NOT NULL, XML VARCHAR(256),
NAME VARCHAR(256), LAST_MODIFIED BIGINT NOT NULL, previous_identity_fk VARCHAR(256),
child_identity_fk VARCHAR(256), CONSTRAINT pk_JBOSS_METADATA_ENTITY_BEANS PRIMARY KEY
(IDENTITY))
2004-07-08 18:32:08,359 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.MetaDataEntity] Could not create
table JBOSS_METADATA_ENTITY_BEANS
2004-07-08 18:32:08,359 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
2004-07-08 18:32:08,359 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
2004-07-08 18:32:08,359 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
2004-07-08 18:32:08,359 ERROR [org.jboss.ejb.EntityContainer] Starting failed
jboss.j2ee:jndiName=ejb/media/MetaDataEntity,service=EJB
org.jboss.deployment.DeploymentException: Error while creating table
JBOSS_METADATA_ENTITY_BEANS; - nested throwable: (java.sql.SQLException: Invalid
argument value, message from server: "Too big column length for column 'IDENTITY'
(max = 255). Use BLOB instead")
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:495)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:184)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:492)
at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:157)
at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:346)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3841393#3841393
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3841393
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
