Mysql configuration question

[13037376]

i used to configure repository.xml file. and it can conncet to mysql
but i show tables in mysql , only 4 tables in database openkm
mysql> show tables;
+------------------+
| Tables_in_openkm |
+------------------+
| version_binval |
| version_bundle |
| version_names |
| version_refs |
+------------------+
4 rows in set (0.03 sec)

what`s wrong with it?



i also configure it in oracle,but there is a SQL error: miss a right bracket

[13037376]

jboss log:

2009-02-06 15:24:18,843 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting jboss.mq:service=PersistenceManager
2009-02-06 15:24:18,843 DEBUG [org.jboss.mq.pm.jdbc2.PersistenceManager] Creating Schema
2009-02-06 15:24:18,843 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: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:95)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at org.jboss.mq.pm.jdbc2.PersistenceManager.createSchema(PersistenceManager.java:273)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1789)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

but there is not a table JMS_MESSAGES in database

and many errors like this in server.log file

[pavila]

This JBoss exception is only a debug warning. It refers to a table used by JBoss and does not relate to OpenKM.

[13037376]

thanks for helping me

there also have jboss error

2009-02-06 15:24:57,609 INFO [org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager] Driver: MySQL-AB JDBC Driver / mysql-connector-java-5.0.3 ( $Date: 2006-07-26 17:26:47 +0200 (Wed, 26 Jul 2006) $, $Revision: 5553 $ )
2009-02-06 15:24:57,609 ERROR [org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager] could not execute statement, reason: Unknown column \'NODE_ID_HI\' in \'where clause\', state/code: 42S22/1054
2009-02-06 15:24:57,609 ERROR [org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager] failed to read bundle: deadbeef-face-babe-cafe-babecafebabe: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column \'NODE_ID_HI\' in \'where clause\'
2009-02-06 15:24:57,609 ERROR [org.apache.jackrabbit.core.RepositoryImpl] failed to start Repository: failed to read bundle: deadbeef-face-babe-cafe-babecafebabe: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column \'NODE_ID_HI\' in \'where clause\'
javax.jcr.RepositoryException: failed to read bundle: deadbeef-face-babe-cafe-babecafebabe: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column \'NODE_ID_HI\' in \'where clause\': failed to read bundle: deadbeef-face-babe-cafe-babecafebabe: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column \'NODE_ID_HI\' in \'where clause\'
at org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:172)
at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:400)
at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:294)

[13037376]

if it works, how many tables would be created in mysql?

[pavila]

Try to delete the database and create a new empty one: Jackrabbit will create the needed tables.

[13037376]

I drop all table in oracle database and restart jboss,it works now

I never use jackrabbit before ,so i want to store username,role in database.

and use other application download file by user or path.

may i configure some file to do that ?