jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lars Janssen <lars-listm...@ukmix.net>
Subject Re: How to use MySQL persistence manager with Jackrabbit standalone
Date Mon, 04 Mar 2013 15:52:37 GMT
Hi all,

Thanks to everyone who offered help with this MySQL connection issue.

In the end I managed to get it working under Tomcat instead of the
standalone version, with the instructions here:

https://github.com/jackalope/jackalope/wiki/Running-jackrabbit-in-tomcat-with-mysql

I could probably also have got it working using the steps described
by Christoph Läubrich, given that in both cases there seems to be a need to
put classes into the Java library rather than using $CLASSPATH or -cp. But
anyway it's working fine under Tomcat now. :)

Best regards,

Lars.



On Fri, Mar 1, 2013 at 6:24 PM, Ron Wheeler
<rwheeler@artifact-software.com>wrote:

> Response to my first question is
> "bad configuration - wrong class name in the Jackrabbit configuration"
> org.gjt.mm.mysql.Driver is not com.mysql.jdbc.Driver.class
>
>
>
> On 01/03/2013 12:27 PM, Lars Janssen wrote:
>
>> It does appear to be:
>>
>> $ unzip -l /usr/share/java/mysql-**connector-java-5.1.16.jar | grep
>> Driver
>>         21  2011-09-06 19:35   META-INF/services/java.sql.**Driver
>>        648  2011-09-06 19:35   com/mysql/jdbc/Driver.class
>>      15550  2011-09-06 19:35   com/mysql/jdbc/**
>> NonRegisteringDriver.class
>>        690  2011-09-06 19:35
>> com/mysql/jdbc/**NonRegisteringReplicationDrive**r.class
>>        687  2011-09-06 19:35   com/mysql/jdbc/**ReplicationDriver.class
>>        336  2011-09-06 19:35   org/gjt/mm/mysql/Driver.class
>>
>> I am specifying the class path with java -cp, is this the right way?
>>
>>      java -cp /usr/share/java/mysql-**connector-java-5.1.16.jar
>>
>> For putting the connector into my jre library, in my case I believe
>> that's /usr/lib/jvm/java-6-openjdk-**amd64/jre/lib. Unfortunately this
>> hasn't
>> made any difference.
>>
>> I'm wondering if changing to a different JRE is likely to help? (e.g. the
>> Oracle one) Also, does it make any difference that I'm using the
>> standalone
>> JAR version of Jackrabbit?
>>
>> Sorry for so many questions!
>>
>>
>> On Fri, Mar 1, 2013 at 4:52 PM, Ron Wheeler
>> <rwheeler@artifact-software.**com <rwheeler@artifact-software.com>>wrote:
>>
>>  Is the missing class in the jar?
>>> - if not - wrong jar or bad configuration of the connector in your
>>> jackrabbit
>>> - If it is, you don't have the classpath specified correctly. You could
>>> just add the connector jar to your java jre library.
>>> Not the best long term solution since you will have to do it again when
>>> you switch java version but at least you can get to the next step and ten
>>> come back to classpath issues.
>>>
>>>
>>>
>>> On 01/03/2013 11:42 AM, Lars Janssen wrote:
>>>
>>>  I've also just tried downloading mysql-connector-java-5.1.23-****
>>>> bin.jar
>>>>
>>>> from
>>>> the Oracle MySql site, same problem.
>>>>
>>>>
>>>>
>>>> On Fri, Mar 1, 2013 at 4:30 PM, Lars Janssen <lars@fazy.net> wrote:
>>>>
>>>>   Still getting the same problem... :(
>>>>
>>>>> I wasn't sure if it was picking up the CLASSPATH variable, so I used
>>>>> -cp
>>>>> on the java command:
>>>>>
>>>>> java -cp /usr/share/java/mysql-****connector-java-5.1.16.jar
>>>>>
>>>>> -XX:MaxPermSize=128m -Xmx512M -Xms128M -Dcom.sun.management.jmxremote
>>>>> -Dcom.sun.management.****jmxremote.port=1111
>>>>> -Dcom.sun.management.****jmxremote.authenticate=true
>>>>> -Dcom.sun.management.****jmxremote.ssl=false
>>>>> -Dcom.sun.management.****jmxremote.password.file=/opt/****
>>>>> jackrabbit/startup/jmx.user
>>>>> -Dcom.sun.management.****jmxremote.access.file=/opt/**
>>>>> jackrabbit/startup/jmx.role
>>>>> -jar /opt/jackrabbit/jackrabbit-****standalone-2.6.0.jar
>>>>>
>>>>>
>>>>> I hope I'm using the right connector, this one from Debian APT:
>>>>>       libmysql-java - Java database (JDBC) driver for MySQL
>>>>>
>>>>> The apt-file command confirms that it's providing this file:
>>>>>       /usr/share/java/mysql-****connector-java-5.1.16.jar
>>>>>
>>>>>
>>>>> Thanks,
>>>>> Lars.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Fri, Mar 1, 2013 at 4:02 PM, Stefan Guggisberg <
>>>>> stefan.guggisberg@gmail.com> wrote:
>>>>>
>>>>>   here's the culprit:
>>>>>
>>>>>> Caused by: java.lang.****ClassNotFoundException:
>>>>>> org.gjt.mm.mysql.Driver
>>>>>>
>>>>>>
>>>>>> make sure you've added the mysql jdbc driver to the classpath.
>>>>>>
>>>>>> cheers
>>>>>> stefan
>>>>>>
>>>>>> On Fri, Mar 1, 2013 at 4:40 PM, Lars Janssen <lars@fazy.net>
wrote:
>>>>>>
>>>>>>  Hi Stefan,
>>>>>>>
>>>>>>> Thanks for replying. I cleared the log file and started Jackrabbit
>>>>>>>
>>>>>>>  again,
>>>>>>
>>>>>>  here is the entire log from the startup operation:
>>>>>>>
>>>>>>> 2013-03-01 15:35:26.586 INFO  [main] RepositoryImpl.java:256
>>>>>>> Starting repository...
>>>>>>> 2013-03-01 15:35:26.588 INFO  [main] LocalFileSystem.java:164
>>>>>>>    LocalFileSystem initialized at path jackrabbit/repository
>>>>>>> 2013-03-01 15:35:26.664 INFO  [main] NodeTypeRegistry.java:870
>>>>>>>
>>>>>>>  no
>>>>>>
>>>>>>  custom node type definitions found
>>>>>>> 2013-03-01 15:35:26.683 INFO  [main] LocalFileSystem.java:164
>>>>>>>    LocalFileSystem initialized at path jackrabbit/version
>>>>>>> 2013-03-01 15:35:27.717 ERROR [main] RepositoryImpl.java:366
>>>>>>> failed to start Repository: Cannot instantiate persistence manager
>>>>>>> org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>>> MySqlPersistenceManager
>>>>>>> javax.jcr.RepositoryException: Cannot instantiate persistence
manager
>>>>>>> org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>> MySqlPersistenceManager
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.**
>>>>>>>
>>>>>> createPersistenceManager(****RepositoryImpl.java:1353)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.****
>>>>>>> createVersionManager(**
>>>>>>>
>>>>>> RepositoryImpl.java:486)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.<init>(**
>>>>>>>
>>>>>> RepositoryImpl.java:311)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.create(**
>>>>>>>
>>>>>> RepositoryImpl.java:589)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryContext.create(**
>>>>>>>
>>>>>> RepositoryContext.java:149)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.servlet.****jackrabbit.**
>>>>>>>
>>>>>> JackrabbitRepositoryServlet.****init(****
>>>>>> JackrabbitRepositoryServlet.**
>>>>>> java:109)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at javax.servlet.GenericServlet.****
>>>>>>> init(GenericServlet.java:241)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.servlet.****ServletHolder.initServlet(**
>>>>>>>
>>>>>> ServletHolder.java:440)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.jetty.servlet.****ServletHolder.doStart(**
>>>>>>> ServletHolder.java:263)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.servlet.****ServletHandler.initialize(**
>>>>>>>
>>>>>> ServletHandler.java:685)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>  org.mortbay.jetty.servlet.****Context.startContext(Context.***
>>>>>> *java:140)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.webapp.****WebAppContext.startContext(**
>>>>>>>
>>>>>> WebAppContext.java:1250)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****ContextHandler.doStart(**
>>>>>>>
>>>>>> ContextHandler.java:517)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.jetty.webapp.****WebAppContext.doStart(**
>>>>>>> WebAppContext.java:467)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****HandlerWrapper.doStart(**
>>>>>>>
>>>>>> HandlerWrapper.java:130)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****RequestLogHandler.doStart(**
>>>>>>>
>>>>>> RequestLogHandler.java:115)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****HandlerWrapper.doStart(**
>>>>>>>
>>>>>> HandlerWrapper.java:130)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.mortbay.jetty.Server.****doStart(Server.java:224)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.apache.jackrabbit.****
>>>>>>> standalone.Main.run(Main.java:****
>>>>>>> 173)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.apache.jackrabbit.****standalone.Main.main(Main.**
>>>>>>> java:60)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>> Caused by: javax.jcr.RepositoryException: Could not load JDBC
driver
>>>>>>>
>>>>>>>  class
>>>>>>
>>>>>>  org.gjt.mm.mysql.Driver
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDriverClass(****ConnectionFactory.java:265)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> createDataSource(****ConnectionFactory.java:233)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDataSource(****ConnectionFactory.java:169)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> BundleDbPersistenceManager.****getDataSource(**
>>>>>> BundleDbPersistenceManager.****java:569)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> BundleDbPersistenceManager.****init(****BundleDbPersistenceManager.**
>>>>>> java:537)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> MySqlPersistenceManager.init(****MySqlPersistenceManager.java:****51)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.**
>>>>>>>
>>>>>> createPersistenceManager(****RepositoryImpl.java:1349)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>>           ... 23 common frames omitted
>>>>>>> Caused by: java.lang.****ClassNotFoundException:
>>>>>>> org.gjt.mm.mysql.Driver
>>>>>>>           at java.net.URLClassLoader$1.run(**
>>>>>>> **URLClassLoader.java:217)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.security.****AccessController.doPrivileged(**
>>>>>>> **Native
>>>>>>> Method)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.net.URLClassLoader.****
>>>>>>> findClass(URLClassLoader.java:****
>>>>>>> 205)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.ClassLoader.****loadClass(ClassLoader.java:**
>>>>>>> **321)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at sun.misc.Launcher$****AppClassLoader.loadClass(**
>>>>>>>
>>>>>>> Launcher.java:294)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.ClassLoader.****loadClass(ClassLoader.java:**
>>>>>>> **266)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.Class.forName0(****Native Method)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.Class.forName(Class.****java:186)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDriverClass(****ConnectionFactory.java:260)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>>           ... 29 common frames omitted
>>>>>>> 2013-03-01 15:35:27.718 INFO  [main] RepositoryImpl.java:1060
>>>>>>>    Shutting down repository...
>>>>>>> 2013-03-01 15:35:27.719 INFO  [main] RepositoryImpl.java:1165
>>>>>>>    Repository has been shutdown
>>>>>>> 2013-03-01 15:35:27.720 WARN  [main] Slf4jLog.java:89
>>>>>>>    unavailable
>>>>>>> javax.jcr.RepositoryException: Cannot instantiate persistence
manager
>>>>>>> org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>> MySqlPersistenceManager
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.**
>>>>>>>
>>>>>> createPersistenceManager(****RepositoryImpl.java:1353)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.****
>>>>>>> createVersionManager(**
>>>>>>>
>>>>>> RepositoryImpl.java:486)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.<init>(**
>>>>>>>
>>>>>> RepositoryImpl.java:311)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.create(**
>>>>>>>
>>>>>> RepositoryImpl.java:589)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryContext.create(**
>>>>>>>
>>>>>> RepositoryContext.java:149)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.servlet.****jackrabbit.**
>>>>>>>
>>>>>> JackrabbitRepositoryServlet.****init(****
>>>>>> JackrabbitRepositoryServlet.**
>>>>>> java:109)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at javax.servlet.GenericServlet.****
>>>>>>> init(GenericServlet.java:241)
>>>>>>> ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.servlet.****ServletHolder.initServlet(**
>>>>>>>
>>>>>> ServletHolder.java:440)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.jetty.servlet.****ServletHolder.doStart(**
>>>>>>> ServletHolder.java:263)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.servlet.****ServletHandler.initialize(**
>>>>>>>
>>>>>> ServletHandler.java:685)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>  org.mortbay.jetty.servlet.****Context.startContext(Context.***
>>>>>> *java:140)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.webapp.****WebAppContext.startContext(**
>>>>>>>
>>>>>> WebAppContext.java:1250)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****ContextHandler.doStart(**
>>>>>>>
>>>>>> ContextHandler.java:517)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.jetty.webapp.****WebAppContext.doStart(**
>>>>>>> WebAppContext.java:467)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****HandlerWrapper.doStart(**
>>>>>>>
>>>>>> HandlerWrapper.java:130)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****RequestLogHandler.doStart(**
>>>>>>>
>>>>>> RequestLogHandler.java:115)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.mortbay.jetty.handler.****HandlerWrapper.doStart(**
>>>>>>>
>>>>>> HandlerWrapper.java:130)
>>>>>>
>>>>>>  [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.mortbay.jetty.Server.****doStart(Server.java:224)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>> org.mortbay.component.****AbstractLifeCycle.start(**
>>>>>>> AbstractLifeCycle.java:50)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.apache.jackrabbit.****
>>>>>>> standalone.Main.run(Main.java:****
>>>>>>> 173)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at org.apache.jackrabbit.****standalone.Main.main(Main.**
>>>>>>> java:60)
>>>>>>> [jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>> Caused by: javax.jcr.RepositoryException: Could not load JDBC
driver
>>>>>>>
>>>>>>>  class
>>>>>>
>>>>>>  org.gjt.mm.mysql.Driver
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDriverClass(****ConnectionFactory.java:265)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> createDataSource(****ConnectionFactory.java:233)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDataSource(****ConnectionFactory.java:169)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> BundleDbPersistenceManager.****getDataSource(**
>>>>>> BundleDbPersistenceManager.****java:569)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> BundleDbPersistenceManager.****init(****BundleDbPersistenceManager.**
>>>>>> java:537)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>> MySqlPersistenceManager.init(****MySqlPersistenceManager.java:****51)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****RepositoryImpl.**
>>>>>>>
>>>>>> createPersistenceManager(****RepositoryImpl.java:1349)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>>           ... 23 common frames omitted
>>>>>>> Caused by: java.lang.****ClassNotFoundException:
>>>>>>> org.gjt.mm.mysql.Driver
>>>>>>>           at java.net.URLClassLoader$1.run(**
>>>>>>> **URLClassLoader.java:217)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.security.****AccessController.doPrivileged(**
>>>>>>> **Native
>>>>>>> Method)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.net.URLClassLoader.****
>>>>>>> findClass(URLClassLoader.java:****
>>>>>>> 205)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.ClassLoader.****loadClass(ClassLoader.java:**
>>>>>>> **321)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at sun.misc.Launcher$****AppClassLoader.loadClass(**
>>>>>>>
>>>>>>> Launcher.java:294)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.ClassLoader.****loadClass(ClassLoader.java:**
>>>>>>> **266)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.Class.forName0(****Native Method)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at java.lang.Class.forName(Class.****java:186)
>>>>>>> ~[na:1.6.0_24]
>>>>>>>           at
>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****util.db.ConnectionFactory.**
>>>>>>>
>>>>>> getDriverClass(****ConnectionFactory.java:260)
>>>>>>
>>>>>>  ~[jackrabbit-standalone-2.6.0.****jar:na]
>>>>>>>
>>>>>>>           ... 29 common frames omitted
>>>>>>> 2013-03-01 15:35:27.721 INFO  [main] RepositoryAccessServlet.java:**
>>>>>>> **98
>>>>>>>
>>>>>>> RepositoryAccessServlet initialized.
>>>>>>> 2013-03-01 15:35:27.727 INFO  [main] AbstractWebdavServlet.java:169
>>>>>>>    authenticate-header = Basic realm="Jackrabbit Webdav Server"
>>>>>>> 2013-03-01 15:35:27.727 INFO  [main] AbstractWebdavServlet.java:174
>>>>>>>    csrf-protection = null
>>>>>>> 2013-03-01 15:35:27.727 INFO  [main] AbstractWebdavServlet.java:181
>>>>>>>    createAbsoluteURI = true
>>>>>>> 2013-03-01 15:35:27.728 INFO  [main] SimpleWebdavServlet.java:144
>>>>>>>    resource-path-prefix = '/repository'
>>>>>>> 2013-03-01 15:35:27.838 INFO  [main] AbstractWebdavServlet.java:169
>>>>>>>    authenticate-header = Basic realm="Jackrabbit Webdav Server"
>>>>>>> 2013-03-01 15:35:27.838 INFO  [main] AbstractWebdavServlet.java:174
>>>>>>>    csrf-protection = null
>>>>>>> 2013-03-01 15:35:27.838 INFO  [main] AbstractWebdavServlet.java:181
>>>>>>>    createAbsoluteURI = true
>>>>>>>
>>>>>>>
>>>>>>> Best regards,
>>>>>>>
>>>>>>> Lars.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Mar 1, 2013 at 3:19 PM, Stefan Guggisberg <
>>>>>>> stefan.guggisberg@gmail.com> wrote:
>>>>>>>
>>>>>>>   hi lars,
>>>>>>>
>>>>>>>> On Fri, Mar 1, 2013 at 4:08 PM, Lars Janssen <
>>>>>>>> lars-listmail@ukmix.net
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>  Hi all,
>>>>>>>>>
>>>>>>>>> I've been successfully using Apache Jackrabbit 2.4.3
and now 2.6.0
>>>>>>>>> (standalone server in both cases) using the default configuration,
>>>>>>>>>
>>>>>>>>>  so the
>>>>>>>>
>>>>>>>   repository is stored on the filesystem.
>>>>>>>
>>>>>>>> How can I make it connect to a MySQL back end instead? I
don't need
>>>>>>>>>
>>>>>>>>>  to
>>>>>>>>
>>>>>>>   worry about migration, just set it up as a fresh install.
>>>>>>>
>>>>>>>> After trying the steps below, Jackrabbit fails to start correctly
or
>>>>>>>>> populate the DATASTORE table in the database, and I find
this error
>>>>>>>>>
>>>>>>>>>  in
>>>>>>>>
>>>>>>> the
>>>>>>>
>>>>>>>> logs:
>>>>>>>>>
>>>>>>>>> ERROR [main] RepositoryImpl.java:366
>>>>>>>>>              failed to start Repository: Cannot instantiate
>>>>>>>>> persistence
>>>>>>>>> manager
>>>>>>>>>
>>>>>>>>>  org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>>
>>>>>>>> MySqlPersistenceManager
>>>>>>>>
>>>>>>>>        javax.jcr.RepositoryException: Cannot instantiate
persistence
>>>>>>>>>
>>>>>>>>>  manager
>>>>>>>>
>>>>>>>   org.apache.jackrabbit.core.****persistence.pool.**
>>>>>>>
>>>>>>>  MySqlPersistenceManager
>>>>>>>>>       [... oodles of backtrace cut ...]
>>>>>>>>>
>>>>>>>>>  could you please provide the full stack trace, or, even
better,
>>>>>>>> the
>>>>>>>> complete error log?
>>>>>>>>
>>>>>>>> cheers
>>>>>>>> stefan
>>>>>>>>
>>>>>>>>   What I've done so far:
>>>>>>>>
>>>>>>>>> I've created the Jackrabbit database/user, which I can
connect to
>>>>>>>>> no
>>>>>>>>> problem:
>>>>>>>>>
>>>>>>>>> mysql -D jackrabbit -u jackrabbit -h localhost -pjackrabbit
>>>>>>>>> I started with a clean slate (empty /var/jackrabbit directory),
>>>>>>>>>
>>>>>>>>>  except
>>>>>>>>
>>>>>>> the
>>>>>>>
>>>>>>>> configuration file comes from here:
>>>>>>>>> https://raw.github.com/wiki/****jackalope/jackalope/files/**<https://raw.github.com/wiki/**jackalope/jackalope/files/**>
>>>>>>>>> repository.xml<https://raw.**github.com/wiki/jackalope/**
>>>>>>>>> jackalope/files/repository.xml<https://raw.github.com/wiki/jackalope/jackalope/files/repository.xml>
>>>>>>>>> **>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Here's the startup script I'm using:
>>>>>>>>> https://github.com/sixty-nine/****Jackrabbit-startup-script<https://github.com/sixty-nine/**Jackrabbit-startup-script>
>>>>>>>>> <ht**tps://github.com/sixty-nine/**Jackrabbit-startup-script<https://github.com/sixty-nine/Jackrabbit-startup-script>
>>>>>>>>> >
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> And here's the java process that runs:
>>>>>>>>>
>>>>>>>>> java -XX:MaxPermSize=128m -Xmx512M -Xms128M
>>>>>>>>>
>>>>>>>>>  -Dcom.sun.management.jmxremote
>>>>>>>>
>>>>>>>>  -Dcom.sun.management.****jmxremote.port=1111
>>>>>>>>> -Dcom.sun.management.****jmxremote.authenticate=true
>>>>>>>>> -Dcom.sun.management.****jmxremote.ssl=false
>>>>>>>>>
>>>>>>>>>   -Dcom.sun.management.****jmxremote.password.file=/opt/****
>>>>>>>>>
>>>>>>>> jackrabbit/startup/jmx.user
>>>>>> -Dcom.sun.management.****jmxremote.access.file=/opt/**
>>>>>> jackrabbit/startup/jmx.role
>>>>>>
>>>>>>    -jar /opt/jackrabbit/jackrabbit-****standalone-2.6.0.jar -h
>>>>>>> 127.0.0.1
>>>>>>>
>>>>>>>  -p
>>>>>>>>>
>>>>>>>>>  8080
>>>>>>>>
>>>>>>>   I don't think I get far enough for it to matter, but I'm using
>>>>>>> MySQL
>>>>>>>
>>>>>>>> 5.5.28-1.
>>>>>>>>>
>>>>>>>>> I'm having the above problem with both 2.4.3 and 2.6.0.
>>>>>>>>>
>>>>>>>>> Also:
>>>>>>>>>
>>>>>>>>> java version "1.6.0_24"
>>>>>>>>> OpenJDK Runtime Environment (IcedTea6 1.11.5) (6b24-1.11.5-1)
>>>>>>>>> OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)
>>>>>>>>> Plus I subsequently installed the MySQL JDBC library
on Debian:
>>>>>>>>>
>>>>>>>>> apt-get install libmysql-java
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>>
>>>>>>>>> Lars.
>>>>>>>>>
>>>>>>>>>  --
>>> Ron Wheeler
>>> President
>>> Artifact Software Inc
>>> email: rwheeler@artifact-software.com
>>> skype: ronaldmwheeler
>>> phone: 866-970-2435, ext 102
>>>
>>>
>>>
>
> --
> Ron Wheeler
> President
> Artifact Software Inc
> email: rwheeler@artifact-software.com
> skype: ronaldmwheeler
> phone: 866-970-2435, ext 102
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message