small MySQL tip

[lukecrouch]

I was having problems connecting to a MySQL database from webMethods. I would occassionally get an error stating that I couldn't connect to the database once the connection had been closed. Has anyone else had this problem?

Turning off connection pooling seems to have cleared it up for now, so if anyone else out there is struggling with this, you can try that.

[Vivian Satie]

I have the same problem, but there are no poolings.......

[mcarlson]

MySQL is not listed as a supported database vendor in the JDBC adapter user's guide. Doesn't mean you can't connect, but I would not expect much in the way of support.

Mark

[Vivian Satie]

Thanks Mark,

I had a lot of problems using Mysql... by the way I cannot create Notifications!

--The adapter does not support Automatic Notification for this database "MySQL" --

:(

[mcarlson]

Not sure which version of MySQL you are using, but triggers and stored procs were just introduced in MySQL 5.x. You should be able to use a basic notification though.

Mark

[Vivian Satie]

So.. something is wrong.

I´m using Mysql 5.0 but...

I cannot use the "com.mysql.jdbc.Driver" DataSource .. It does not work. I had to use the com.mysql.jdbc.jdbc2.optional.MysqlDataSource. Can it be the problem?

I´m using this file : mysql-connector-java-3.0.17-ga-bin.jar

Thanks