Need Help: the .jar executable file doesn't connect to MySQL Database

[amz]

Hello, I have a problem with my java application. the application connects to a MySQL database. When run from netbeans, the program works fine and connects to the database normally. But when I open the .jar file in the "dist" folder, the program runs but doesn't connect to the database.
Note: the MySQL database is on another computer.
Thanks in advance for all help

[bolsover]

Almost certainly a classpath issue...
Your .jar contains application classes but not the classes needed to connect to MySql which will be in one of the imported libraries.

I'm guessing that you are opening the .jar simply by double clicking rather than running it from a command prompt.

Open a command window and just type 'java' - you should get usage instrictions; you will need to use the -classpath option together with -jar and any other arguments.

db

[amz]

that's true, i am opening it by double clicking it.
But I've already added the classpath to the environment variables.
Please explain more how to open it using commands

[lanshan75]

Hello,everybody,I am just a new member of this forum,I want to make more friends here,I hope you can like me.
Cheap WOW Gold|Buy RS Gold|Diablo 3 Items

[bolsover]

Hi amz

what error do you actually get - can you post stacktrace?

my guess is that this is still a classpath issue...

[amz]

when connecting to the database i used the try to catch the exception.
the exception message was: "No suitable driver found for jdbc:mysql://192.168.1.107/MyDB"

[bolsover]

looks like a classpath issue...

have you added path the the mysqldriver .jar to classpath??

[amz]

This is the value of the CLASSPATH:
;C:\Program Files\Java\jdk1.6.0_17\jre\lib\ext\mysql-connector-java-5.1.8-bin.jar

[bolsover]

OK - so this looks like one of those Java gotchas - using java -classpath with -jar does not work... java ignores the -classpath

Instead, you need list ALL the .jar on the classpath and use a dot sparated path to your Main class:

java -classpath your-classes.jar;mysql-driver.jar dot.separated.path.to.MainClass