Java for Jbase

Am running R10 on windows.Am want to develop java applications for jbase. Am getting the following error when i try to connect to jbase using netbeans IDE.Exception in thread "main" java.sql.SQLException: No suitable driver found.How do i set the class path so that the following error will be resolved.

it simple, goto Libraries, select the jar file that is the jbase library (usually on the jbase path).

the jbasejdbc.jar file i have put the path to it on env variables on mycomputer.that is where am getting the error.So i need to know where should i put my classpath for it to work.

is the netbeans running on the same computer as JBase?

if yes then you need to add the whole jbase folder e.g. ..../jbase526/java/lib

if no then copy the whole folder to your local PC.

i have added the following in jbase_env
@rem Script to set environment variables for jBASE 5.0
set CLASSPATH=C:\jbase5\5.0\java\lib

but its not working still giving the same err

the java code is:
import java.sql.*;
import java.io.*;

public class Tete {

/**
* @param args the command line arguments
*/
public static void main(String[] args) {
try {
Class.forName("com.jbase.jdbc.driver.JBaseJDBCDriver");
} catch (Exception e) {
System.out.println(e);
}
try {
Connection con = DriverManager.getConnection("jdbc:jbasejo:thin:@localhost:3570:MYACCOUNT", "t24", "123456");
} catch (Exception e) {
System.out.println(e);
}
}
}

Find attached a netbeans example. This is on R10, with Windows XP and Java 1.6

don't forget to start jbase_agent


Rgds

Am getting the following error when i run the program.


run:
..........................
Err Code: 0 SQL State: null mesg: ERROR in connecting to host [127.0.0.1]:[3750] Connection refused: connect
..........................
java.sql.SQLException: ERROR in connecting to host [127.0.0.1]:[3750] Connection refused: connect
at com.jbase.jdbc.JBaseJDBCSocketConnection.doConnection(Unknown Source)
at com.jbase.jdbc.driver.JBaseJDBCDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc_jbase.Main.main(Main.java:30)
BUILD SUCCESSFUL (total time: 2 seconds)

as I said before, don't forget to start jbase agent on port 3750 (thats the port showed on the error message)

the following error is showing on the agent:

C:\ModelBank_R10GA\ModelBank_R10GA>cd Temenos\bnk\bnk.run
(9792|4000) NOTICE starting up jAgent, Process Per Connection mode, listening on
port 9494, c:\src\tafc\r10\jagent\SocketAcceptor.h +107
(7348|10900) NOTICE RequestHandlerService::open: connected with VALL-HP, RequestHandlerService.cpp +221
(7348|10900) ERROR Client::authenticate:Client did not authenticate. Closing jag
ent connection., Client.cpp +236
(7348|10900) NOTICE Closing connection to VALL-HP, RequestHandlerS
ervice.cpp +127
(7348|10900) NOTICE Shutting down Connection, JAgentSocketServer.cpp +115
(9792|5708) NOTICE PID 7348 exited., WorkerProcess.cpp +102

when i run the progam on port 9494.

This worked, thanks