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.