minor tip: we never use the pre-installed version. i can't remember why now, but we had problems with it. it's much more straightforward to download the latest binary from mysql.

make sure your connection dictionary looks like this:

url: jdbc:mysql://127.0.0.1/yourdb? capitalizeTypeNames=true&zeroDateTimeBehavior=convertToNull
driver: com.mysql.jdbc.Driver
plugin: (none)

and of course make sure you have the right username/password :-)

the exception looks like a permissions issue to me so worth checking is that you have set permissions in mysql correctly. you'll need to grant permissions to the user that you are connecting with and to the domain - ie. if you are connecting local make sure you have given the user local permission to do so. if you are on a dev machine might be easiest to grant all permissions to [EMAIL PROTECTED] and [EMAIL PROTECTED] just to get yourself moving, but you'll need to get it right for production to ensure you don't leave a potential back door open...

Simon


On 27 Nov 2008, at 03:11, Eleni Manou wrote:

Hello dear,


 Details of my system is :


Mac OS X Server, version 10.5.5, WebObjects version 5.4, Eclipse 3.3.2, WOLips

MySQL is pre installed and working since using NAVICAT I connect and work normally.

The error message I get when trying to generate SQL from WOLips is :

Failed to generate SQL. Communications link failure due to underlying exception:
**BEGIN NESTED EXCEPTION**

java.net.ConnectException
MESSAGE: Connection refused


STACKTRACE:
java.net.ConnectException: Connection refused
                at java.net.PlainSocketImpl.socketConnect(Native Method)
                -----
                ----

There is no problem when I generate SQL for  Openbase and Frontbase.

Can anyone help me on this?


Many thanks in advance



Stavros Panidis

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/simon_mclean%40mac.com

This email sent to [EMAIL PROTECTED]

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to