You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Er...@mbtech-group.com on 2003/09/22 15:24:44 UTC

access to the Database mysql

Hello,

how can i configure Jetspeed for connect to the Database mysql.

Thank you.

Eric




---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org


Re: access to the Database mysql

Posted by Henry Lyons <hl...@marinepartsexpress.com>.
Eric,

I just did this for the tutorial.  It was difficult because they left many
parts out of the tutorial that you need to pay attention to.

First, you will need to download the appropriate driver from the Apache
site.

"mysql-connector-java-3.0.8-stable-bin.jar"

put it in /Jetspeed/WEB_INF/lib folder

Then you need to handle the changes to the Torque.properties file, i.e.:

torque.database.default.adapter=mssql

### MySQL
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.default.connection.user =  root
torque.dsfactory.default.connection.password =

Note that the assumption here is that you have named your database
"jetspeed" and you'll have to put your own password in for root.

This should get you on your way.  If you have more questions or this doesn't
make sense, let me know.

Henry Lyons

----- Original Message ----- 
From: <Er...@mbtech-group.com>
To: <je...@jakarta.apache.org>
Sent: Monday, September 22, 2003 9:24 AM
Subject: access to the Database mysql


> Hello,
>
> how can i configure Jetspeed for connect to the Database mysql.
>
> Thank you.
>
> Eric
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org


Re: access to the Database mysql

Posted by Henry Lyons <hl...@marinepartsexpress.com>.
Eric,

I just did this for the tutorial.  It was difficult because they left many
parts out of the tutorial that you need to pay attention to.

First, you will need to download the appropriate driver from the Apache
site.

"mysql-connector-java-3.0.8-stable-bin.jar"

put it in /Jetspeed/WEB_INF/lib folder

Then you need to handle the changes to the Torque.properties file, i.e.:

torque.database.default.adapter=mssql

### MySQL
torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
torque.dsfactory.default.connection.url =
jdbc:mysql://localhost:3306/jetspeed
torque.dsfactory.default.connection.user =  root
torque.dsfactory.default.connection.password =

Note that the assumption here is that you have named your database
"jetspeed" and you'll have to put your own password in for root.

This should get you on your way.  If you have more questions or this doesn't
make sense, let me know.

Henry Lyons

----- Original Message ----- 
From: <Er...@mbtech-group.com>
To: <je...@jakarta.apache.org>
Sent: Monday, September 22, 2003 9:24 AM
Subject: access to the Database mysql


> Hello,
>
> how can i configure Jetspeed for connect to the Database mysql.
>
> Thank you.
>
> Eric
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>