Error message when attempting to configure Form Builder to use MySQL

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

Error message when attempting to configure Form Builder to use MySQL

Dan Overholt

Hello,

 

When I attempt to enable Form Builder to use MySQL, I get the following error message in the orbeon.log file:

 

2012-05-24 16:23:06,563 ERROR ProcessorService  - Exception at oxf:/apps/fr/persistence/mysql/search.xpl (executing XSLT transformation)

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)

        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)

        at org.orbeon.oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:56)

        at org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext.getConnection(SQLProcessorInterpreterContext.java:334)….

 

Once I get to this point, I’m no longer able to save or publish any new forms that I create.

 

I’d imagine that this is a configuration error, but I’m not sure what I configured incorrectly.

 

This is the mysql database configuration that I set up in my Tomcat /conf/server.xml file:

 

<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"

    username="orbeon"

    password="password"

    url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>

 

And this is the configuration in my properties-local.xml file:

 

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"

            xmlns:oxf="http://www.orbeon.com/oxf/processors">

 

        <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

        <property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="jdbc/mysql"/>

 

</properties>

 

I also created the database successfully, and placed the MySQL connector .jar file in the correct location.

 

Does anyone have ideas on how I can continue to troubleshoot this issue?

 

Thanks,

 

Dan

 

 



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error message when attempting to configure Form Builder to use MySQL

NOBILET Stéphane
It's the value what's wrong :

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>   

Le 25/05/2012 16:43, Dan Overholt a écrit :

Hello,

 

When I attempt to enable Form Builder to use MySQL, I get the following error message in the orbeon.log file:

 

2012-05-24 16:23:06,563 ERROR ProcessorService  - Exception at oxf:/apps/fr/persistence/mysql/search.xpl (executing XSLT transformation)

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)

        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)

        at org.orbeon.oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:56)

        at org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext.getConnection(SQLProcessorInterpreterContext.java:334)….

 

Once I get to this point, I’m no longer able to save or publish any new forms that I create.

 

I’d imagine that this is a configuration error, but I’m not sure what I configured incorrectly.

 

This is the mysql database configuration that I set up in my Tomcat /conf/server.xml file:

 

<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"

    username="orbeon"

    password="password"

    url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>

 

And this is the configuration in my properties-local.xml file:

 

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"

            xmlns:oxf="http://www.orbeon.com/oxf/processors">

 

        <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

        <property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="jdbc/mysql"/>

 

</properties>

 

I also created the database successfully, and placed the MySQL connector .jar file in the correct location.

 

Does anyone have ideas on how I can continue to troubleshoot this issue?

 

Thanks,

 

Dan

 

 


--

Stéphane NOBILET
Département Télésanté

Syndicat Interhospitalier de Bretagne (SIB)

4, rue du Professeur Jean Pecker - CS 76513
35065 Rennes Cedex


Pour formuler ou suivre vos demandes d’assistance :
- connectez vous sur le portail :
www.sib.fr > Espace membre > Vos demandes d’assistance
- contactez le Centre d’Appels et de Support (CAS) a
u 02.99.54.75.75

www.sib.fr
– tel standard : 02.99.54.75.10



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Re: Error message when attempting to configure Form Builder to use MySQL

NOBILET Stéphane
conf/Catalina/localhost/orbeon.xml

<Context path="/orbeon" docBase="orbeon" crossContext="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"
    username="root"
    password="*****"
    url="jdbc:mysql://*****:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>
             
             

</Context>


Le 25/05/2012 16:47, NOBILET Stéphane a écrit :
It's the value what's wrong :

<property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="mysql"/>   

Le 25/05/2012 16:43, Dan Overholt a écrit :

Hello,

 

When I attempt to enable Form Builder to use MySQL, I get the following error message in the orbeon.log file:

 

2012-05-24 16:23:06,563 ERROR ProcessorService  - Exception at oxf:/apps/fr/persistence/mysql/search.xpl (executing XSLT transformation)

javax.naming.NameNotFoundException: Name jdbc is not bound in this Context

        at org.apache.naming.NamingContext.lookup(NamingContext.java:770)

        at org.apache.naming.NamingContext.lookup(NamingContext.java:153)

        at org.orbeon.oxf.processor.DatabaseContext.getConnection(DatabaseContext.java:56)

        at org.orbeon.oxf.processor.sql.SQLProcessorInterpreterContext.getConnection(SQLProcessorInterpreterContext.java:334)….

 

Once I get to this point, I’m no longer able to save or publish any new forms that I create.

 

I’d imagine that this is a configuration error, but I’m not sure what I configured incorrectly.

 

This is the mysql database configuration that I set up in my Tomcat /conf/server.xml file:

 

<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"

    username="orbeon"

    password="password"

    url="jdbc:mysql://localhost:3306/orbeon?useUnicode=true&amp;characterEncoding=UTF8"/>

 

And this is the configuration in my properties-local.xml file:

 

<properties xmlns:xs="http://www.w3.org/2001/XMLSchema"

            xmlns:oxf="http://www.orbeon.com/oxf/processors">

 

        <property as="xs:anyURI" name="oxf.fr.persistence.app.uri.*.*.*" value="/fr/service/mysql"/>

        <property as="xs:anyURI" name="oxf.fr.persistence.service.mysql.datasource" value="jdbc/mysql"/>

 

</properties>

 

I also created the database successfully, and placed the MySQL connector .jar file in the correct location.

 

Does anyone have ideas on how I can continue to troubleshoot this issue?

 

Thanks,

 

Dan

 

 


--

Stéphane NOBILET
Département Télésanté

Syndicat Interhospitalier de Bretagne (SIB)

4, rue du Professeur Jean Pecker - CS 76513
35065 Rennes Cedex


Pour formuler ou suivre vos demandes d’assistance :
- connectez vous sur le portail :
www.sib.fr > Espace membre > Vos demandes d’assistance
- contactez le Centre d’Appels et de Support (CAS) a
u 02.99.54.75.75

www.sib.fr
– tel standard : 02.99.54.75.10


--

Stéphane NOBILET
Département Télésanté

Syndicat Interhospitalier de Bretagne (SIB)

4, rue du Professeur Jean Pecker - CS 76513
35065 Rennes Cedex


Pour formuler ou suivre vos demandes d’assistance :
- connectez vous sur le portail :
www.sib.fr > Espace membre > Vos demandes d’assistance
- contactez le Centre d’Appels et de Support (CAS) a
u 02.99.54.75.75

www.sib.fr
– tel standard : 02.99.54.75.10



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws