connecting a java program to an sql database

Hi, im kind of new to this and im getting an error that seems fairly common.

"java.sql.SQLException: No suitable driver" I downloaded MySQL Connector/J and added the location of the jar file "mysql-connector-java-5.0.5\mysql-connector-java-5.0.5-bin.jar" to my environment variable "path".

The URL i have entered is "jdbc:msql://localhost:8080/SQLProjects/mcgowap3".

I was told that using local host might be the worng way to go..

Id appreciate any help

Paul

[497 byte] By [donka] at [2007-11-27 1:38:48]

«« waiting to lock <0xc02aadb0> (a java.util.Collections$SynchronizedMap)
»» trouble getting a JMF program working with another program

# 1

You must set the driver paramater as :driver = "com.mysql.jdbc.Driver";I do not see anything wrong with your database URL.Cheers :)

newtona at 2007-7-12 0:51:05 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

I see several errors:1) path != classpath.2) msql != mysql.3) The MySQL database doesn't run on port 8080 by default. If you really have changed it so, then this was not a clever choice.

BalusCa at 2007-7-12 0:51:05 >

# 3

Hi,I had the same problem for sometime. I turned off the firewall, then right click on the project and choose resolve issues. in the library section if you still see library not found or something like that, delete it and add the jar file. I hope this helps

sgtekie@nnu.edua at 2007-7-12 0:51:05 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

connecting a java program to an sql database

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified