Jdbc drivers and Connection for Database connection

[Former Member]

Hi all

i have added jdbc drivers to the aii_af_jmsproviderlib.sda .For adding drivers we have added ojdbc14.jar file .Now we want to connect a oracle database through XI and fetch data from it now my problem is while configuring communication channel for the sender JDBC adapter Now what values should be given in the Database Connection parameters ie jdbc drivers and database connection.

any help would be appreciated .

full points will be awarded

regards

Uday

[Former Member]

done

[agasthuri_doss]

Hey,

JDBC Driver - oracle.jdbc.driver.OracleDriver ( Java class of the JDBC driver that the JDBC adapter must load to be able to access the driver.The specification varies according to the JDBC driver; see documentation from the respective provider. )

Connection - dbc:oracle:thin:host: ( Address with which you can establish a database connection using the JDBC driver )

Cheers

Agasthuri Doss

[Former Member]

HI all

We have used the following DB Connection parameters and we are able to connect to DB successfully

JDBC driver: oracle.jdbc.driver.OracleDriver

Connection:jdbc:oracle:thin:@IP:port:dbname.

thankss

Regards

uday