Skip to Content
0
Former Member
Jan 11, 2011 at 06:29 AM

JDBC Connection Creation URL Change at Run time

41 Views

Hi All,

I am using BOE XI 3.1.

I have changed the Generic JDBC datasource connection setting in jdbc.sbo file in order to support my own driver class.

My sample Connection Detail :

JDBC Class=com.oracle.jdbc.DriverImpl

I have created the Generic JDBC Connection and gave

Username : Admin

Password : Admin

URL=jdbc:oracle:<dbname>

in the Connection Parameter screen of universe designer.I tested the connection and connection was successful.

I have created the report in WebI rich client by connecting the modified connection URL.I got the data successfully.

My Problem is ,

I need to sort the data based on changing the connection at run time.

I set the some variable in thread and passed into connection URL along with new parameter.The name value is changed for each login,

so that i can get the data from database based on name value.

My Sample Connection URL at run time :

jdbc:oracle:<dbname>:name=india;

My assumption :

This connection is passed to some Business object .dll file along with a

parameter to append with the connection URL. But output from the .dll file

shows the parameter passed is null as a result null is append with the connection

URL.So i couldn't able to get the thread value. Hence unable to proceed

So please how can i get the thread value and passed into connection URL.

Thanks in advance,

A.yousuf alam.