How to use the connection object which is made in .dll file

[vigneshwarie]

Hi,
I'm getting database connection to Oracle in VB as .dll file. Using oledb the connection string will be

Provider=OraOLEDB.Oracle.1;Password=xyz;Persist Security Info=True; User Id=xyz; Data Source=sis;Extended Properties=""

.
In JSP, I'm importing "com.jacob.com.*;" and "com.jacob.activeX.*;"
My code goes as below for accessing the .dll file,

ComThread.Release();
ComThread.InitSTA();
ActiveXComponent tb = null;
tb = new ActiveXComponent("Project2.Class2");
Object test = null;
test = tb.getObject();
Variant v1 = null;
String path_str="c://connect.properties";
v1 = Dispatch.Call(test,"makeConnection",path_str);
 

Reading the property file connection will be made in the .DLL. and Database is getting connected.
My question is how to use this connection for accessing my database and write query to retrive data in JSP.

Thanks,
Vigneshwari.