Re: MySQL connection problem

> Included now are the log-files
>
> Hello
>
> Orbeon was working well. The next step was to connect to a MySQL-database.
>
> I followed the following instructions:
> http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer
>
> 1. Creation database + tables for the user "orbeon" and "orbeon" as a
> password
>
> 2. Placed "mysql-connector-java-5.1.13-bin.jar" in
> "/etc/apache-tomcat-5.5.31/common/lib"
>
> 3. Tested the jdbc-driver with the following instructions (MySQL DBCP
> Example
> on http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html).
> this example worked fine, so I concluded that there is nothing wrong with
> the JDBC-driver.
>
> 4. Added the following to "server.xml" in "etc/apache-tomcat-5.3.1/conf"
>
>    <Context path="/orbeon" docBase="orbeon"
>         debug="5" reloadable="true" 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="orbeon"
>           password="orbeon"
>          url="jdbc:mysql://localhost:3306/orbeon"/>
>
>    </Context>
>
> 5. Created a new file "properties-local.xml" on
> "etc/apache-tomcat-5.3.1/webapps/orbeon/WEB-INF/config" and added the
> following line:
>
>    <property as="xs:anyURI"  name="oxf.fr.persistence.app.uri.*.*.*"
> value="/fr/service/mysql"/>
>
> When I shutdown and restart tomcat there is no problem, the problems start
> when I want to add data to an existing form or want to add a new form
> definition.
>
> I'm looking 4 hours on this allready and I can't solve it.
>
> Does someone knows the problem?
>
> Many thx.
>
> Koen
>
> --
> 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
>
>