Thread: calling a java a class connected to derby from a batch file

Hi all,

I've created a java class that is connected to a database (derby). It works perfectly when run from netbeans. After that I created a batch file that calls this class and put them in a folder in the C.When tested, it is clear in the cmd that all lines are excuted until the connection to the database part:
Connection con;
Class.forName("org.apache.derby.jdbc.ClientDriver" );
con = DriverManager.getConnection("jdbc:derby://localhost:1527/demntiaDB", "reem", "pass");

I get those errors:
classNotFoundException
URLClassLoader.run$

this is my main:
public static void main(String[] args) throws ClassNotFoundException {

SwingUtilities.invokeLater(new Runnable(){
public void run() {
try {

regulation r = new regulation();

} catch (ClassNotFoundException ex) {
Logger.getLogger(regulation.class.getName()).log(L evel.SEVERE, null, ex);

} catch (SQLException ex) {
Logger.getLogger(regulation.class.getName()).log(L evel.SEVERE, null, ex);

}
}
});}

what do i have to write exactly in the batch file? This is what i have right now:
cd\
cd "HourlyTempReg" <---- folder in which java class and batch file are placed
java regulation.regulation <----- java java package.java class

Thank you very much

Please do not double post your question to the forums, your other post has been removed.

Does the database driver accompany your class and batch file? This must be on the classpath for your program to connect to the database.

I am using netbeans to and the database connection is done within the java class to derby.In what form must i write the classpath?
I tried this but it didnt work:
cd\
cd "HourlyTempReg"
java -classpath C:\HourlyTempReg\regulation;C:\Program Files (x86)\Sun\JavaDB\lib\derby.jar;C:\Program Files (x86)\Sun\JavaDB\lib\derbyclient.jar;C:\Program Files (x86)\Sun\JavaDB\lib\derbynet.jar;C:\Program Files (x86)\Sun\JavaDB\lib\derbyrun.jar;C:\Program Files (x86)\Sun\JavaDB\lib\derbytools.jar;C:\Program Files (x86)\Sun\JavaDB\lib\register.jar; regulation.regulation

Your file paths have spaces...try placing the paths in quotes

It worked! thanx a million...just added the quoutes