[MySQL][Jar] Problems outside the IDE

**JosAH** · 09-06-2011, 02:39 PM

Originally Posted by Revoke

Norm
I'm using this to run the .jar file

java -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

How do I add the jar file to the classpath?

Simply do this for now:

Java Code:

java -cp/path/to/jar/that/contains/your/sqldriver -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

kind regards,

Jos

**Revoke** · 09-06-2011, 02:46 PM

Originally Posted by JosAH

Simply do this for now:

Java Code:

java -cp/path/to/jar/that/contains/your/sqldriver -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

kind regards,

Jos

Thanks for the tip Jos but I got the same errors

I tried

Java Code:

java -cp "/home/lsa/Downloads/mysql-connector-java-5.1.17" -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

**JosAH** · 09-06-2011, 02:49 PM

Originally Posted by Revoke

Thanks for the tip Jos but I got the same errors

I tried

Java Code:

java -cp "/home/lsa/Downloads/mysql-connector-java-5.1.17" -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

Doesn't that file end with the extension ".jar"?

kind regards,

Jos

**Tolls** · 09-06-2011, 02:51 PM

OK, so this is nothing to do with the jar file not being found.
Presumably your classpath in the MANIFEST is now OK?

Because if it isn't then I would ask where this code thinks it's getting its driver from...

**Revoke** · 09-06-2011, 02:52 PM

Originally Posted by JosAH

Doesn't that file end with the extension ".jar"?

kind regards,

Jos

Oh yeah sorry, but still the same errors

Java Code:

java -cp "/home/lsa/Downloads/mysql-connector-java-5.1.17-bin.jar" -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

**Tolls** · 09-06-2011, 02:54 PM

Originally Posted by JosAH

Doesn't that file end with the extension ".jar"?

kind regards,

Jos

Does -cp work with -jar?
Quoting the docs:

When you use this option, the JAR file is the source of all user classes, and other user class path settings are ignored.

I would always use the manifest for executable jar files.

**JosAH** · 09-06-2011, 02:55 PM

Originally Posted by Revoke

Oh yeah sorry, but still the same errors

Java Code:

java -cp "/home/lsa/Downloads/mysql-connector-java-5.1.17-bin.jar" -jar "/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar"

What errors? null for the Connection? Or is it something else now?

kind regards,

Jos

**Revoke** · 09-06-2011, 03:01 PM

Originally Posted by JosAH

What errors? null for the Connection? Or is it something else now?

kind regards,

Jos

these errors

Exception in thread "main" java.lang.RuntimeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
at cadastro.dao.ConnectionDataBase.getConnection(Conn ectionDataBase.java:48)
at cadastro.dao.GenericDao.<init>(GenericDao.java:19)
at cadastro.dao.DadosDao.<init>(DadosDao.java:16)
at cadastro.controller.DadosController.listaDados(Dad osController.java:65)
at cadastro.Principal.<init>(Principal.java:33)
at cadastro.Cadastro.main(Cadastro.java:12)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1049)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2619)
at com.mysql.jdbc.ConnectionImpl.configureClientChara cterSet(ConnectionImpl.java:1881)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromS erver(ConnectionImpl.java:3496)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2385)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2154)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:792)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:377)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:305)
at java.sql.DriverManager.getConnection(libgcj.so.11)
at java.sql.DriverManager.getConnection(libgcj.so.11)
at cadastro.dao.ConnectionDataBase.getConnection(Conn ectionDataBase.java:26)
...5 more

Tolls

How do I check the classpath in the MANIFEST ?
I really don't know what it is

**Norm** · 09-06-2011, 03:23 PM

I don't think you can mix the -cp and the -jar options. Put the jar files on the classpath and explicitly invoke your class. I used the : for separator here. Change it to what is correct on your OS

java -cp /home/lsa/Downloads/mysql-connector-java-5.1.17-bin.jar:/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar cadastro.Cadastro

**Tolls** · 09-06-2011, 03:36 PM

Originally Posted by Revoke

Tolls

How do I check the classpath in the MANIFEST ?
I really don't know what it is

Read the Manifest, as suggested by Norm earlier in the thread.
It's a file inside the jar file, in the META-INF directory.

Or run it as Norm is suggesting.

However, if you are getting the above exceptions then the jar file must already be accessible, otherwise you would not see that stack trace.

Now...if the manifest does not have the driver jar file listed, then I can only think you have unzipped the jar file, which is not a good idea.

**Revoke** · 09-06-2011, 03:37 PM

I tried this

Java Code:

CLASSPATH=.:$CLASSPATH:/home/lsa/Downloads/mysql-connector-java-5.1.17/mysql-connector-java-5.1.17-bin.jar
CLASSPATH=.:$CLASSPATH:/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar
java -cp /home/lsa/Downloads/mysql-connector-java-5.1.17/mysql-connector-java-5.1.17-bin.jar:/home/lsa/NetBeansProjects/Cadastro/dist/Cadastro.jar cadastro.Cadastro

but I keep getting this

Can't connect to database
Exception in thread "main" java.lang.RuntimeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
at cadastro.dao.ConnectionDataBase.getConnection(Conn ectionDataBase.java:48)
at cadastro.dao.GenericDao.<init>(GenericDao.java:19)
at cadastro.dao.DadosDao.<init>(DadosDao.java:16)
at cadastro.controller.DadosController.listaDados(Dad osController.java:65)
at cadastro.Principal.<init>(Principal.java:33)
at cadastro.Cadastro.main(Cadastro.java:12)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1049)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2619)
at com.mysql.jdbc.ConnectionImpl.configureClientChara cterSet(ConnectionImpl.java:1881)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromS erver(ConnectionImpl.java:3496)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2385)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2154)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:792)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:377)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:305)
at java.sql.DriverManager.getConnection(libgcj.so.11)
at java.sql.DriverManager.getConnection(libgcj.so.11)
at cadastro.dao.ConnectionDataBase.getConnection(Conn ectionDataBase.java:26)
...5 more

**Norm** · 09-06-2011, 03:41 PM

Can't connect to database

Your code must be running.
Now its a SQL usage error.

If it works in the IDE then what is different?

**Tolls** · 09-06-2011, 03:45 PM

Is the IDE on the same box?
Do you have the same driver jar file on the runtime classpath in the IDE?

**JosAH** · 09-06-2011, 03:45 PM

Originally Posted by Revoke

these errors

Exception in thread "main" java.lang.RuntimeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorExceptio n: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1

I have to repeat the question from reply #24 then ...

kind regards,

Jos

**Revoke** · 09-06-2011, 03:59 PM

Originally Posted by JosAH

I have to repeat the question from reply #24 then ...

kind regards,

Jos

I don't know how to check that

Tolls

I believe so

**Tolls** · 09-06-2011, 04:00 PM

I just told you how to check the manifest.
Look in your jar file (the one with your code in it) and find the MANIFEST.MF file in the META-INF directory.
Post its contents here.

**Revoke** · 09-06-2011, 04:02 PM

Originally Posted by Tolls

I just told you how to check the manifest.
Look in your jar file (the one with your code in it) and find the MANIFEST.MF file in the META-INF directory.
Post its contents here.

Sorry I'm really new to this :D

Manifest-Version: 1.0

Ant-Version: Apache Ant 1.8.2

Created-By: 1.6.0_26-b03 (Sun Microsystems Inc.)

Class-Path: lib/mysql-connector-java-5.1.17-bin.jar

X-COMMENT: Main-Class will be added automatically by build

Main-Class: cadastro.Cadastro

**Tolls** · 09-06-2011, 04:09 PM

Right.
And when you ran the jar file, using java -jar <your jar file here> did you get the above exception?
If so, then is there a lib directory there, containing the MySQL driver jar?

If so...then we can ignore all the above stuff about class paths.

**Revoke** · 09-06-2011, 04:13 PM

Originally Posted by Tolls

Right.
And when you ran the jar file, using java -jar <your jar file here> did you get the above exception?
If so, then is there a lib directory there, containing the MySQL driver jar?

If so...then we can ignore all the above stuff about class paths.

Yes, I get the exception
and yes the directory exists and it contains the driver jar

**Tolls** · 09-06-2011, 04:16 PM

OK.
We've got somewhere (which we might have got to quicker if you'd not been eating exceptions).

And running this in your IDE works?

What IDE is it?