JDBC driver and connection

[Former Member]

Hi All

What are the Values to be filled in JDBC driver and CONNECTION fields while creating communication channel using JDBC as receiver?

we are using ojdbc14.jar as the oracle driver and have deployed it successfully

Please do the Needful

FULL POINTS WILL BE AWARDED

Regards

SATISH

Edited by: satish raj on Oct 6, 2008 10:22 AM

[dharamveer_gaur2 · Accepted solution]

user name: <Database user>

password: <user login password>

driver: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<ServerHostName>:1521:<SID>

here

1521 is default port and SID is Database global name

[Former Member]

Hi ..

Check this ...

Driver :- oracle.jdbc.driver.OracleDriver

Connection :- jdbc:oracle:thin:@<IP>:<PORT>:<Database Name>

[Former Member]

Hi All

Sorry for the Delay

Thank u One and All for ur answers

Regards

Satish

[Former Member]

Hi,

The paramters that you mention in your JDBC adapter depends on which Datbase you are trying to connect.

you will get the driver name, connection parameters from the documentaion.

Driver -- oracle.jdbc.driver.OracleDriver

Coonection --jdbc:oracle:thin:@hostip:port:globaldatabasename

Regards

Sridhar Goli

[dharamveer_gaur2]

This url is connection parameter: jdbc:oracle:thin:@<ServerHostName>:1521:<SID>

Here Server host name: your database server host name or IP address

SID:Global Oracle Databas Name

1521(Ask to your Database Admin if any other is used):This is default port

[Former Member]

Hi Satish,

all the regarding to database should filled like

database <username>

database<password>

database<connection id>

database<portno>

chk the below link it willl be more helpfull

http://help.sap.com/saphelp_nw04s/helpdata/en/43/313c13198d0d26e10000000a1553f7/frameset.htm

Regards

Sampath

[Former Member]

hi,

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1671] [original link is broken] [original link is broken] [original link is broken];

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1772] [original link is broken] [original link is broken] [original link is broken];

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1182] [original link is broken] [original link is broken] [original link is broken];

chk these links wll help to solve your issue.

Regards.

Siddhesh