Orbeon Forms community mailing list

I need some help to connect xforms-sql-address-book example application with MySQL

Classic

List

Threaded

2 messages Options

Rodrigo Ojeda

I need some help to connect xforms-sql-address-book example application with MySQL

Hi group:

I tried all these steps but nothings happens with this application.
Correct what steps are wrong please:

1.- Put mysql-connector-java-5.1.5-bin.jar file in
/var/lib/tomcat5.5/sahred/lib/ and
/var/lib/tomcat5.5/webapps/orbeon/WEB-INF/lib/ directories.

2.- Create the datasource-sql.xml file and add the following lines:

<datasource>
<driver-class-name>com.mysql.jdbc.Driver</driver-class-name>
<uri>jdbc:mysql://myserver:3306:mydb</uri>
<username>myuser</username>
<password>mypassword</password>
</datasource>

3.- Uncomment and edit the following lines in the web.xml file at
/var/lib/tomcat5.5/webapps/orbeon/WEB-INF directory:

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

4.- Add the resource element in file context.xml at
/var/lib/tomcat5.5/conf/ directory:

<Context>
...
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="myuser" password="mypassword"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://myserver:3306:mydb"/>
...
</Context>

Observations: MySQL is running on server /myserver/ and the application
server (Tomcat) on other (we can call it /otherserver/ for comments :)

Thanks in advance!

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

Erik Bruchez

Re: I need some help to connect xforms-sql-address-book example application with MySQL

Administrator

Something like this should work. Do you see any exceptions in the logs?

Note that the SQL processor will use either the file datasource-
sql.xml *if* it explicitly refers to it, or the JDBC datasource
available to the web app, again *if* the SQL processor configuration
refers to that datasource.

-Erik

On Dec 20, 2007, at 1:12 PM, Rodrigo Ojeda wrote:

> Hi group:
>
> I tried all these steps but nothings happens with this application.
> Correct what steps are wrong please:
>
> 1.- Put mysql-connector-java-5.1.5-bin.jar file in /var/lib/
> tomcat5.5/sahred/lib/ and /var/lib/tomcat5.5/webapps/orbeon/WEB-INF/
> lib/ directories.
>
> 2.- Create the datasource-sql.xml file and add the following lines:
>
> <datasource>
> <driver-class-name>com.mysql.jdbc.Driver</driver-class-name>
> <uri>jdbc:mysql://myserver:3306:mydb</uri>
> <username>myuser</username>
> <password>mypassword</password>
> </datasource>
>
>
> 3.- Uncomment and edit the following lines in the web.xml file at /
> var/lib/tomcat5.5/webapps/orbeon/WEB-INF directory:
>
>
> <resource-ref>
> <description>DataSource</description>
> <res-ref-name>jdbc/mydb</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> 4.- Add the resource element in file context.xml at /var/lib/
> tomcat5.5/conf/ directory:
>
> <Context>
> ...
> <Resource name="jdbc/mydb" auth="Container"
> type="javax.sql.DataSource"
> maxActive="100" maxIdle="30" maxWait="10000"
> username="myuser" password="mypassword"
> driverClassName="com.mysql.jdbc.Driver"
> url="jdbc:mysql://myserver:3306:mydb"/>
> ...
> </Context>
>
> Observations: MySQL is running on server /myserver/ and the
> application server (Tomcat) on other (we can call it /otherserver/
> for comments :)
>
> Thanks in advance!
>
> --
> 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

--
Orbeon Forms - Web Forms for the Enterprise Done the Right Way
http://www.orbeon.com/

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