Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I define a JDBC 2.0 Datasource to use Oracle OCI Driver?

April 26, 2017DataSource define driver JDBC OCI Oracle

0

Posted

How do I define a JDBC 2.0 Datasource to use Oracle OCI Driver?

1 Answer

0

Posted

Definition of a JDBC Datasource that use an Oracle OCI driver for communication with a remote database involves specification of additional properties. Driver property driverType must be defined to reflect the OCI driver type. It can be specified in the XML section of jndi-definitions.xml in a Data ARchive (DAR) module. The value for driverType depends on the version of Oracle; for Oracle 7 its ‘oci7’; for Oracle 8 its ‘oci8’ and for Oracle 9 its simply ‘oci’. In addition to driverType, driver property TNSEntryName can be specified with the database name for target database as maintained in Oracle’s tnsnames.ora file. Alternatively, the database name can be supplied in driver property databaseName, if TNSEntryName is not specified, but properties serverName (host machine name) and portNumber must also be set for this approach. For more details of these and other Oracle driver properties refer to: http://www.princeton.edu/~storacle/jdbc8_doc/oracle.jdbc.pool.OracleDa