I have not tried teh XADataSource, but I had no luck with the regular
MySQL data source until I used the following format in my config file:
<database name="imagedata" engine="mysql" >
<driver class-name="org.gjt.mm.mysql.MysqlDataSource"
url="jdbc:mysql://192.168.1.9:3306/dfdb1?user=user&password=secret" />
<mapping href="castor_mapping.xml" />
</database>
Perhaps you have already tried this, but if not I hope it helps.
- David Franzen
On Wednesday, June 12, 2002, at 12:19 AM, Ben Wilcock wrote:
> Hi All,
>
> Thanks for the suggestions on getting over the rollback problem. I
> thought I would try and use the XADataSource that comes with Mark
> Matthews MySQL JDBC Driver to overcome the Transaction Rollback issue,
> but I've hit another problem. Anyone had this before?
>
> I get a PersistenceException with the root cause being an SQL Exception
> from the MySql driver claiming that there was "No Database Specified".
>
> The database.xml I am using looks something like this...
>
> <database name="configManager" engine="mysql">
> <data-source class-
> name="org.gjt.mm.mysql.jdbc2.optional.MysqlXaDataSource">
> <params user="user" password="secret" serverName="localhost"
> port="3306" databaseName="configManager" />
> </data-source>
> <mapping href="mapping.xml" />
> </database>
>
> I used to use the Driver config rather than the Datasource config for
> the same databse, and with the same params everything worked OK. The
> attribute names I used in the params tag (serverName, port and
> databaseName) are the accessor methods for the datasource.
>
> Just a thought, but is it that I need to use specific param names
> specified by castor rather than by the driver as I have done? (like you
> have in the examples for Sybase and PostgreSQL) for example...
>
> <params server-name="host" port-number="5432" database-name="db"
> user="user" password="secret" />
>
> Any other suggestions are most welcome?
>
> Cheers
>
> Ben
>
> PS. Just a small thing I noticed - in the documentation in this area
> (database-conf.html), the data-source example has the params in a param
> tag, but the DTD forced me to use the params tag for datasources. The
> "s" would seem to be missing in the docs.
>
> The DataSource implementation class name is specified by the class-name
> attribute and configured through Bean-like accessor methods specified
> for the param element. The DTD for the param element is undefined and
> depends on the DataSource being used.
> <data-source class-name="org.postgresql.PostgresqlDataSource">
> <param server-name="host" port-number="5432" database-name="db"
> user="user" password="secret" />
> </data-source>
>
>
>
>
> Ben Wilcock
> Application Developer
>
> Symularity Limited
> 1 John Charles Way,
> Geldered Road,
> Leeds, LS12 6LY
>
> Email: [EMAIL PROTECTED]
> Tel: 0113 220 5460
>
> PRIVACY & CONFIDENTIALITY NOTICE
>
> The information contained in this e-mail is intended for the named
> recipients only. It may contain privileged and confidential
> information. If you are not the addressee or the person responsible for
> delivering this to the addressee, you may not copy, distribute or take
> action in reliance on it. If you have received this e-mail in error,
> please notify us immediately by returning the original message to the
> sender by e-mail.
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
