I'm getting database connection to Oracle in VB as .dll file. Using oledb the connection string will be
Expand|Select|Wrap|Line Numbers
- 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,
Expand|Select|Wrap|Line Numbers
- 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);
My question is how to use this connection for accessing my database and write query to retrive data in JSP.
Thanks,
Vigneshwari.