Connecting Orbeon 4.7 PE with mysql database issue

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Connecting Orbeon 4.7 PE with mysql database issue

samoo
This post was updated on .
I'm trying to setup Orbeon 4.7 PE with mysql database (Orbeon running on tomcat 7). I have followed the instructions on this link but it doesn't work, I keep getting this error message:

Name [jdbc] is not bound in this Context. Unable to find [jdbc].    

here is my configrations:
server.xml
<GlobalNamingResources>
                             
        <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="orbeon"
                        url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>
  </GlobalNamingResources> 

properties-local.xml

<property as="xs:string" name="oxf.fr.persistence.provider.*.*.*" value="mysql"/>
<property as="xs:string" name="oxf.fr.persistence.mysql.datasource" value="mysql"/>


Any idea what's wrong!
Reply | Threaded
Open this post in threaded view
|

Re: Connecting Orbeon 4.7 PE with mysql database issue

samoo
the context (inside server.xml) should look like this (if you running on tomcat 7), so if any one has the same problem, the solution is below:

<Context path="/orbeon"
                        docBase="F:/apache-tomcat-7.0.56/webapps/orbeon.war"
                        crossContext="true"  reloadable="false" override="true" allowLinking="true">
                       
                        <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="orbeon"
                        url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>
                </Context>