A simple thing!

[Doug]

Hello
It has been some years since I used Mysql. How
could I forget so much?!

I can connect to my (4.x-Connector/J 3.0.17-ga) (using password
123456) test db with:

mysql -u dkr -h localhost -p ARPWS

I cannot create a connection with:

Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/ARPWS?user=dkr&password=123456");

The runtime returns an exception:
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.ConnectException: Connection refused

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.java:143)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1805)
at com.mysql.jdbc.Connection.<init>(Connection.java:4 52)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:411)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:193)
at MySqlDB.<init>(Unknown Source)
at UserActions.<init>(Unknown Source)
at UserButtonHandler.<init>(Unknown Source)
at UserDataPanel.<init>(Unknown Source)
at PainFull.<init>(Unknown Source)
at Main.init(Unknown Source)
at Main.main(Unknown Source)
class 'com.mysql.jdbc.Driver' not found java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.ConnectException: Connection refused

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
OK - I'm getting old. What have I forgotten this time?

Thank you for your time!
dkr

[Bill Karwin]

"Doug" <dk*****@XXXtelus.planet.net> wrote in message
news:pa****************************@XXXtelus.plane t.net...

Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/ARPWS?user=dkr&password=123456");

The runtime returns an exception:
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.SocketException: java.net.ConnectException: Connection refused

Frequently I see the JDBC getConnection using the three-String method
signature, for example:

DriverManager.getConnection("jdbc:mysql://localhost/ARPWS", "dkr",
"123456");

Even though javax.sql.DriverManager includes a single-String method
signature for getConnection, and the MySQL Connector/J docs imply your usage
should work, it seems folks don't use that form much. Searching Koders.com,
I see only usage of the three-String method signature, for MySQL connections
(and also for other RDBMS brands)

Regards,
Bill K.

[Doug]

On Mon, 30 Jan 2006 17:27:36 -0800, Bill Karwin wrote:

"Doug" <dk*****@XXXtelus.planet.net> wrote in message
news:pa****************************@XXXtelus.plane t.net...

Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/ARPWS?user=dkr&password=123456");

The runtime returns an exception:
java.sql.SQLException: Unable to connect to any hosts due to exception:
java.net.SocketException: java.net.ConnectException: Connection refused

Frequently I see the JDBC getConnection using the three-String method
signature, for example:

DriverManager.getConnection("jdbc:mysql://localhost/ARPWS", "dkr",
"123456");

Even though javax.sql.DriverManager includes a single-String method
signature for getConnection, and the MySQL Connector/J docs imply your usage
should work, it seems folks don't use that form much. Searching Koders.com,
I see only usage of the three-String method signature, for MySQL connections
(and also for other RDBMS brands)

Regards,
Bill K.

Thanks for the advice - I will give it a try as soon as I can!

dkr