JAR files+ MySQL

[UJJAL DHAR]

I have made an simple application in which I have used MySQL to store data. When run the code in netbeansIDE,it works well.

But when I click double on the jar file,it cant access the MySQL.

How can I solve this?

Thanks in advanced

[JosAH]

I have made an simple application in which I have used MySQL to store data. When run the code in netbeansIDE,it works well.

But when I click double on the jar file,it cant access the MySQL.

How can I solve this?

Thanks in advanced

You jar file should have a manifest entry that manages the MySQL jar file in its classpath line; read the documentation.

kind regards,

Jos

[UJJAL DHAR]

I have read the documentation. I have failed to get the main point.
Please help me a bit more.

I am using Netbeans IDE 6.8 and mysql-connector-java-5.0.8-bin.jar
What should I do now?


Please help me.

[JosAH]

I have read the documentation. I have failed to get the main point.
Please help me a bit more.

I am using Netbeans IDE 6.8 and mysql-connector-java-5.0.8-bin.jar
What should I do now?


Please help me.

Are you sure you've read the documentation? It's all in there; oh well, put the following lines in your manifest entry:

Main-Class: <your main class>
Class-Path: <path to>/mysql-connector-java-5.0.8-bin.jar

Oh, and b.t.w. Netbeans has nothing to do with this; also make sure that you put the actual values for the < ... > placeholders above.

kind regards,

Jos

[UJJAL DHAR]

My manifest file is aaa.mf

Main-Class: Main
Class-Path: C:/Program Files/Java/jdk1.6.0_01/jre/lib/ext/mysql-connector-java-5.0.8-bin.jar

Here my Main class is Main.java.
Before adding Shop.jar is working without accessing database.

jar cvfm Shop.jar aaa.mf

But after adding manifest
it shows

Exception in thread "main" java.lang.NoClassDefFoundError: Main

I think I am going too silly.please help me.

[JosAH]

jar cvfm Shop.jar aaa.mf

That command doesn't add any .class files to your .jar file; check it with, say, winzip because a .jar file is simply a .zip file.

kind regards,

Jos

[UJJAL DHAR]

Oh, then what will be the commands ?
Do you have any link or anything?

[JosAH]

Oh, then what will be the commands ?
Do you have any link or anything?

I already gave you a link to the documentation for the jar command; haven't you read it?

kind regards,

Jos

[UJJAL DHAR]

this time I have executed
[code]
jar uf Shop.jar mysql-connector-java-5.0.8-bin.jar
[code]

And there was no error executing this.But still database is not accessible. Should I add more files.Then what they are?

mysql-connector-java-5.0.8-bin.jar is JDBC connector which i have used to connect netbeans with MySQL.Is it okay to add?

[JosAH]

this time I have executed

jar uf Shop.jar mysql-connector-java-5.0.8-bin.jar

And there was no error executing this.But still database is not accessible. Should I add more files.Then what they are?

mysql-connector-java-5.0.8-bin.jar is JDBC connector which i have used to connect netbeans with MySQL.Is it okay to add?

Now you have added that MySQl jar file to your own jar file; the jar tool doesn't mind but adding jars to a jar never works; never. You are supposed to add your own .class file(s) to that jar like your Main.class file; don't just guess and add all sorts of files to your .jar file hoping that it would work.

kind regards,

Jos

[UJJAL DHAR]

Now this is working if I run it with command promt writing

java -jar Shop.jar



but When clicking double database is not accessing.

In Filetypes
JAR files are executing with
"C:\Program Files\Java\jre1.6.0_01\bin\javaw.exe" -jar "%1" %*
in my pc

[JosAH]

Now this is working if I run it with command promt writing

java -jar Shop.jar



but When clicking double database is not accessing.

In Filetypes
JAR files are executing with
"C:\Program Files\Java\jre1.6.0_01\bin\javaw.exe" -jar "%1" %*
in my pc

Conclusion: your manifest entry is incorrect again; reread my first reply and the documentation I supplied.

kind regards,

Jos

[UJJAL DHAR]

No..
I just change this
"C:\Program Files\Java\jre1.6.0_01\bin\javaw.exe" -jar "%1" %*

to
"C:\Program Files\Java\jdk1.6.0_01\bin\java.exe" -jar "%1" %*

And its working.Thanks a lot.my problem is solved.

[JosAH]

No..
I just change this
"C:\Program Files\Java\jre1.6.0_01\bin\javaw.exe" -jar "%1" %*

to
"C:\Program Files\Java\jdk1.6.0_01\bin\java.exe" -jar "%1" %*

And its working.Thanks a lot.my problem is solved.

Strange, because the only difference between those two lines is the display of a console window ...

kind regards,

Jos

edit: or was that what your question was all about? Displaying the console ...

[UJJAL DHAR]

No no....lets review...
I have prepared a Restaurant management system using MySQL+Netbeans.A JAR file was created by which we can execute the system only with double click.But the jar file was not capable of accessing MySQL.
My Question was how to make sure that jar file can access database?

Your answer was to add the mysql connector to the jar.

I have added it as your direction.But when I was running the JAR file using command prompt

java -jar Shop.jar

,it works.

But it didnt work with double click.
Because of

"C:\Program Files\Java\jre1.6.0_01\bin\javaw.exe" -jar "%1" %*

Then I changed it to

"C:\Program Files\Java\jdk1.6.0_01\bin\java.exe" -jar "%1" %*

.and now its working

Thats it.

[JosAH]

No no....lets review...
I have prepared a Restaurant management system using MySQL+Netbeans.A JAR file was created by which we can execute the system only with double click.But the jar file was not capable of accessing MySQL.
My Question was how to make sure that jar file can access database?

Your answer was to add the mysql connector to the jar.

I have added it as your direction.But when I was running the JAR file using command prompt ,it works.

But it didnt work with double click.
Because of

Then I changed it to .and now its working

Thats it.

I still don't understand that changing 'javaw' to 'java' makes it work but I'm happy for you that you have working software now.

kind regards,

Jos

[UJJAL DHAR]

I m not sure also about the fact.
I will search for the answer of a question in future but not today.

What is the difference between javaw.exe of JRE and java.exe of JDK

Thanks a lot JosAh for being with me.

[Tolls]

I mentioned this on the other thread over in Databases where you were "helping" someone with a problem but:
Class-Path: C:/Program Files/Java/jdk1.6.0_01/jre/lib/ext/mysql-connector-java-5.0.8-bin.jar

You do not want to be putting anything in there.
That's a mistake, and possibly why Netbeans hasn't done what it should, which is stick them mysql connector jar into your dist directory, and a proper entry into the Manifest.

Fix that mistake, stick the jar file in a lib directory under your Netbeans project and reference it properly, and Netbeans will build you a nice jar file, with associated lib in a dist directory.