[Cosmo-dev] MySQL configuration

[Randy Letness]

I've done this.  Here is what you need to do:

In tomcat/conf/server.xml change the db resource def to be:

  <Resource name="osafsrv/db"
              type="javax.sql.DataSource"
	      driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://[server]:3306/[db]"
      	      username="[user]"
	      password="[pass]"
	      maxActive="100"
	      maxIdle="30"
	      maxWait="10000"/>

Download MySQL jdbc driver and put in tomcat/common/lib.

Modify cosmo/WEB-INF/classes/applicationContext.xml and change
this line:

<prop key="hibernate.dialect">org.hibernate.dialect.DerbyDialect</prop>
to
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>

And fire up the server.  Also, be sure to make the default for tables
InnoDB so transactions can be supported.

-Randy



On 9/25/06, Jared Rhine <jared at wordzoo.com> wrote:
> Would anyone like to take a crack at an overview of configuring a Cosmo
> instance to talk to a MySQL instance?  I assume this is mostly Tomcat
> configuration to point at a MySQL JDBC URL, but thought it might be
> helpful to ask here for caveats or examples.
>
> --
> Jared Rhine <jared at wordzoo.com>
>
>
> _______________________________________________
> cosmo-dev mailing list
> cosmo-dev at lists.osafoundation.org
> http://lists.osafoundation.org/mailman/listinfo/cosmo-dev
>