Orbeon - MySql

Hello I'm a new user with Orbeon, I have tried to connect Orbeon with my MySql Database.

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

tomcat5.5/shared/lib/ and
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://localhost:3306:prueba</uri>
        <username>prueba</username>
        <password>prueba</password>
</datasource>

And put in the directory tomcat\webapps\orbeon\WEB-INF\resources\config

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/db</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:



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

Can Anybody help me?

Thanks.

pepinblanco schrieb: seems you define the name of the resource to be "jdbc/mydb", but
reference it in the resource-ref as "jdbc/db".

René


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

I changed that, but doesn't work
Can you tell what do you do to connect orbeon with mysql.

Can you show me an example.

Thanks

Rene Single wrote

pepinblanco schrieb:
> <resource-ref>
>         <description>DataSource</description>
>         <res-ref-name>jdbc/db</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:
>
>
>
>     <Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"
>               maxActive="100" maxIdle="30" maxWait="10000"
>               username="prueba" password="prueba"
>               driverClassName="com.mysql.jdbc.Driver"
>               url="jdbc:mysql://localhost:3306:prueba"/>
>
> Can Anybody help me?
>
>  
I could be well off, as I haven't used this before, but...
seems you define the name of the resource to be "jdbc/mydb", but
reference it in the resource-ref as "jdbc/db".

René


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

pepinblanco schrieb:
> I changed that, but doesn't work
> Can you tell what do you do to connect orbeon with mysql.
>  
I haven't used it at all so far as I stated in the last post.
I just spotted what I thought might be an issue.
So if it doesn't help I have no idea how to fix it, sorry.

René

--
----------------------------------------------------
TANNER AG
René Single
Kemptener Straße 99
D-88131 Lindau
Germany

tel +49 8382 272-199
fax +49 8382 272-900
mailto:[hidden email]
http://www.tanner.de

Vorsitzender des Aufsichtsrats: Helmut Tanner
Vorstand: Stefan Kuegel (Vorsitzender), Georg-Friedrich Blocher
Aktiengesellschaft, Lindau (B)
Registergericht Kempten, HRB 7199
----------------------------------------------------

Die TANNER AG ist Träger des Bayerischen Qualitätspreises 2008!



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