MY SQL Connection

I cannot get orbeon to connect to mysql  when clicking the save button on the form it says there was an error communicating with the database

/orbeon/WEB-INF/resource/config/properties-local.xml

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"
            xmlns:oxf="http://www.orbeon.com/oxf/processors">
<property as="xs:string" name="oxf.fr.persistence.provider.*.*.*.*" value="mysql"/>
<property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql"/>
</properties>

orbeon\WEB-INF\web.xml

   <resource-ref>
        <description>DataSource</description>
        <res-ref-name>jdbc/mysql</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

tomcat/config/context.xml

 <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
    initialSize="3" maxActive="10" maxIdle="20" maxWait="30000"
    driverClassName="com.mysql.jdbc.Driver"
    poolPreparedStatements="true"
    validationQuery="select 1 from dual"
    testOnBorrow="true"
    username="orbeon"
    password="mypassword"
    url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>

I think I have narrowed it down to this error log. I still cannot figure out what needs to be done to fix it.

Jun 12, 2015 2:51:04 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Jun 12, 2015 2:51:04 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 503 ms
Jun 12, 2015 2:51:04 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jun 12, 2015 2:51:04 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.28
Jun 12, 2015 2:51:04 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor /etc/tomcat7/Catalina/localhost/host-manager.xml
Jun 12, 2015 2:51:04 PM org.apache.naming.NamingContext lookup
WARNING: Unexpected exception resolving reference
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1431)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1373)
        at org.apache.commons.dbcp.BasicDataSource.getLogWriter(BasicDataSource.java:1100)
        at org.apache.commons.dbcp.BasicDataSourceFactory.createDataSource(BasicDataSourceFactory.java:350)
        at org.apache.commons.dbcp.BasicDataSourceFactory.getObjectInstance(BasicDataSourceFactory.java:156)
        at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:143)
        at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:321)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:843)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:154)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:831)
        at org.apache.naming.NamingContext.lookup(NamingContext.java:168)
        at org.apache.catalina.core.NamingContextListener.addResource(NamingContextListener.java:1061)
        at org.apache.catalina.core.NamingContextListener.createNamingContext(NamingContextListener.java:671)
        at org.apache.catalina.core.NamingContextListener.lifecycleEvent(NamingContextListener.java:270)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5172)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:618)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:650)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1582)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)
        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1422)
        ... 28 more
Jun 12, 2015 2:51:04 PM org.apache.catalina.core.NamingContextListener addResource
WARNING: Failed to register in JMX: javax.naming.NamingException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Hi Joshua,

Just checking: did you put the MySQL driver (e.g. mysql-connector-java-5.1.30-bin.jar) in your Tomcat's lib directory?

Alex

Yes I tried it in the tomcat library and in the Web Apps lib.

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

Yes I tried it in the tomcat library and in the Web Apps lib.

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].

Any more ideas? Im still stumped on this.

Orbeon is trying to use exist vs mysql.....

How can I change this or does it need to use both?


2015-06-22 09:39:52,160 WARN  BrokerPool  - Cannot write to symbols.dbx. Switching to read-only mode.
2015-06-22 09:39:52,160 WARN  Paged  - Cannot write to file ngram.dbx. Switching to read-only mode.
2015-06-22 09:39:52,160 INFO  IndexManager  - Registered index org.exist.indexing.ngram.NGramIndex as ngram-index
2015-06-22 09:39:52,160 ERROR BrokerPool  - Unable to initialialize database instance 'exist': Exception while reading lucene index directory: Permission denied
org.exist.util.DatabaseConfigurationException: Exception while reading lucene index directory: Permission denied
        at org.exist.indexing.lucene.LuceneIndex.open(LuceneIndex.java:89)
        at org.exist.indexing.IndexManager.<init>(IndexManager.java:86)
        at org.exist.storage.BrokerPool.initialize(BrokerPool.java:771)
        at org.exist.storage.BrokerPool.<init>(BrokerPool.java:654)
        at org.exist.storage.BrokerPool.configure(BrokerPool.java:216)
        at org.exist.storage.BrokerPool.configure(BrokerPool.java:188)
        at org.exist.http.servlets.EXistServlet.startup(EXistServlet.java:672)
        at org.exist.http.servlets.EXistServlet.init(EXistServlet.java:113)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:857)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:136)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:701)
Caused by: java.io.IOException: Permission denied
        at java.io.UnixFileSystem.createFileExclusively(Native Method)
        at java.io.File.createNewFile(File.java:959)
        at org.apache.lucene.store.SimpleFSLock.obtain(SimpleFSLockFactory.java:124)
        at org.apache.lucene.store.Lock.obtain(Lock.java:73)
        at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:1550)
        at org.apache.lucene.index.IndexWriter.init(IndexWriter.java:1525)
        at org.apache.lucene.index.IndexWriter.<init>(IndexWriter.java:1290)
        at org.exist.indexing.lucene.LuceneIndex.getWriter(LuceneIndex.java:144)
        at org.exist.indexing.lucene.LuceneIndex.open(LuceneIndex.java:87)
        ... 24 more
2015-06-22 09:39:52,161 INFO  EXistServlet  - registering XMLDB driver
2015-06-22 09:39:52,227 ERROR XFormsServer  - xforms-submit-error - setting throwable {throwable: "

--
You received this message because you are subscribed to the Google Groups "Orbeon Forms" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].