how to know the location of JDBC Driver/ connection

[Former Member]

unable to find JDBC driver and connection location

How can I know the location of "JDBC Driver" for the input box JDBC Driver to confrigure this in ID.

The same for "Connection" too.

urgent input (no links please) will help me.

Thanks

SY

[moorthy · Accepted solution]

Hi,

You can ask basis person to get the location of JDBC driver.

http://help.sap.com/saphelp_nw2004s/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Hope this helps.

Regards,

Moorthy

[Former Member]

The value for JDBC driver corresponds to the fully qualified class name of your database driver and the value for connection is the JDBC url for connection to the database which actually specifies the IP of the db server / SID / Database name etc depending on the type of database you use.

You can get the relevant information in the product documentation and / or vendor web site.

~ Amol

[Former Member]

Hi,

For you to configure the commincation for JDBC adapter in Integration Directory , you dont have to know where the driver is actually located on the file system.

when providing the connection properties

JDBC Driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:oci8:userid/pwd@server

these are very generic to the database provider. above are the parameter formats for oracle. you can find similiar for sqlserver/sybase on their sites.

cheers,

NAveen

[bhavesh_kantilal]

hi suresh,

which database are you trying to connect to?

regards,

Bhavesh

[Former Member]

Hi Naveen,

I am trying to connect to ORACLE 8i database can u please tell me the connection parameters for this.

regards,

Keith.

[bhavesh_kantilal]

Hi Keith,

Connection : <b>jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)></b>

Driver <b>oracle.jdbc.driver.OracleDriver</b>

Regards,

Bhavesh