Re: cocoon with mysql

[Derek Hohls]

Olivier

First, have a look at the tutorial:
http://www.cocooncenter.org/cc/documents/resources/db-app/index.html

There is much in there that applies to ALL databases.   Changes are:

1. setup the driver in web.xml:

  
load-class

  
  org.gjt.mm.mysql.Driver

  
  
2. set the connection info in cocoon.xconf. 

 
 
 jdbc:mysql://localhost:3306/myDatabaseName  
 guest
 guest
   

You need to set up one these for each type of connection to a 
given database (eg. one for guest, one for user, one for admin);
permissions being set at a database level (see your mySQL docs
for more on access priviledges) depending on user.

'luck
Derek

 (BTW, this shows some of the power of JDBC and Cocoons separation of
concerns;
you can see that only small changes would be needed to connect to the
same database set up on a different platform...!)

>>> [EMAIL PROTECTED] 20/03/2002 06:24:25 >>>

Hello

I have cocoon installed on my machine and an acces to a mysql
database.

Can somebody tell me how to make work together ?


Thanks

Olivier

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>


-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: cocoon with mysql

[Cédric Damioli]

as with other databases...
put a  tag in cocoon.xconf with your jdbc driver and url to 
your database : a mysql url is often (depends on the driver???) 
jdbc:mysql://host:3306/database

you also have to put the jar with the jdbc driver in the web/WEB-INF/lib 
and enjoy mysql-power!!!

Olivier GUCKERT wrote:

>Hello
>
>I have cocoon installed on my machine and an acces to a mysql database.
>
>Can somebody tell me how to make work together ?
>
>
>Thanks
>
>Olivier
>
>-
>Please check that your question has not already been answered in the
>FAQ before posting. 
>
>To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>For additional commands, e-mail: <[EMAIL PROTECTED]>
>



-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

cocoon with mysql

[Olivier GUCKERT]

Hello

I have cocoon installed on my machine and an acces to a mysql database.

Can somebody tell me how to make work together ?


Thanks

Olivier

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>