Hello!
I'm developing a java application using derby database (with embedded driver) in Eclipse. And when I build and run it from Eclipse everythings works fine but when I want to run it from the command line (with java command) I get such an error:
java.sql.SQLSyntaxErrorException: Table/View 'USERS' does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unkn
own Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source
)
The problem is that table USERS exists - from Eclipse everything works fine. What's more, when I tried to run my program with java command at the first time, I got such an information:
java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
so I set the classpath like that:
set
CLASSPATH=C:\eclipse-java-europa-win32\eclipse\plugins\org.apache.derby.core_10.3.2\derby.ja
r;C:\eclipse-java-europa-win32\eclipse\plugins\org.apache.derby.core_10.3.2\derbytools.jar;.
And after that I'm in the situation as decribed above. Can anyone help?
Kind regards,
John.