jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Connect to MySql with JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connect to MySql with JDBC" Watch "Connect to MySql with JDBC" New topic

Connect to MySql with JDBC

Aidan Mooney

Joined: Sep 04, 2003
Posts: 1
I am trying to connected to a MySql database using jdbc. I have set up the database that I am trying to connect to. I have some Java code which is simply trying to connect to the database. However I get the following error and was hoping someone would be able to help me out with it.
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net
.SocketException: Option unsupported by protocol: create
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1622)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DataSource.<init>(DataSource.java:33)

Any help is appreciated.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15302

If you could supply us with your code, we can help. Error messages don't mean much without the associated code that goes with them.
Be sure and use the UBB Code Block tags to make things easier to read.

GenRocket - Experts at Building Test Data
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
Things to check for:
  • Make sure that the "mysql" JDBC drivers are in your class path
  • In your code, register the driver:

  • Class.forName("com.mysql.jdbc.Driver"); // new driver
    ... or ...
    Class.forName("org.gjt.mm.mysql.Driver"); // old driver
  • Make sure the URL is correctly specified:

  • "jdbc:mysql://ip-address/database"

    You can register the drivers explicitly (as in above example), or as a run-time attribute when you start the program.
    You can use the IP address or DNS name in the URL, and the database is optional, though I like to specify it.
    If these suggestions don't work, please provide a code snippet and information about where the databse is.
    I agree. Here's the link: http://aspose.com/file-tools
    subject: Connect to MySql with JDBC
    It's not a secret anymore!