Skip to Content
0
Former Member
Jan 11, 2011 at 03:04 PM

Generic JDBC Connection URL change at runtime

59 Views

Hi All,

I am using BusinessObjects Enterprise XI 3.1.

I have created the Generic JDBC datasource Connection in jdbc.sbo file in order to support

my own driver class.

My sample Connection Detail :

JDBC Class=com.myoracle.jdbc.DriverImpl

I have created the Generic JDBC Connection and give

Username : Admin

Password : Admin

URL=jdbc:myoracle:<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.

My Problem is ,

My New sample Connection URL should be change at run time :

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

The name value is used to sort the data in the report generation.

I have created the filter and set name value into thread and passed into connection URL along with new parameter.

but i couldn't able to get the name value from thread.

So please let me know how to get the thread value and make the connection URL append with thread value.

Thanks in advance,

Yousuf