On Jan 15, 2009, at 10:01 AM, Pascal Robert wrote:
I have a really weird problem with the WOCommunity app and MySQL.
The app was connected to MySQL 5.0.XX on a different server, but
when I tried to switch it to the local MySQL installation, I got the
famous "failed to open database channel" exception. But I know that
the JDBC connection info is good, so I looked at connections, and I
saw this :
java 28028 appserver 13u IPv6
570160 TCP web1.macti.ca:53034->web1.macti.ca:3306
(CLOSE_WAIT)
Hum, good old CLOSE_WAIT problems... But it's a weird problem
because WordPress (PHP) can connect to the same database, and I
connect to the database with the MySQL tools (on my MBP) without any
problems.
I tried with both Connector/J 3.0.17 and 5.0.8, no differences. My
next step is to try with a plain JDBC connection from a Java command-
line app, but does anyone have seen this before?
Do you have Wonder handy? ERXJDBCConnectionAnalyzer (from Practical
WebObjects) should track this down for you. If not, let me know!
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list (Webobjects-deploy@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com
This email sent to arch...@mail-archive.com