[jira] Updated: (FELIX-1975) [Karaf] Add oracle database support to Karaf jdbc locking feature.

["Jamie goodyear (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FELIX-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jamie goodyear updated FELIX-1975:
----------------------------------

    Attachment: felix-1975.patch

File: felix-1975.patch

This patch contains my first attempt at setting up an Oracle JDBC Lock class.

The nature of the patch is to provide Oracle support while not disturbing existing Derby, MySQL, or other generic JDBC environments.

Below is a sample of the system.properties file I used on the master and slave test instances.

{code}
karaf.lock=true
karaf.lock.class=org.apache.felix.karaf.main.OracleJDBCLock
karaf.lock.jdbc.url=jdbc:oracle:thin:@hostname:1521:XE
karaf.lock.jdbc.driver=oracle.jdbc.OracleDriver
karaf.lock.jdbc.user=user
karaf.lock.jdbc.password=password
karaf.lock.jdbc.table=SERVICEMIX_LOCK
karaf.lock.jdbc.clustername=smx4
karaf.lock.jdbc.timeout=30
{code}

Please note that to use this Oracle JDBC Lock class you will have to add the Oracle JDBC driver jar to the classpath of your environment. In this case I copy the ojdbc14.jar into Karaf's lib folder before starting Karaf.

Also of note, the karaf.lock.jdbc.url requires an active SID, this means that you will have to manually create a database instance before attempting to use this particular lock.

> [Karaf] Add oracle database support to Karaf jdbc locking feature.
> ------------------------------------------------------------------
>
>                 Key: FELIX-1975
>                 URL: https://issues.apache.org/jira/browse/FELIX-1975
>             Project: Felix
>          Issue Type: New Feature
>          Components: Karaf
>            Reporter: Jamie goodyear
>         Attachments: felix-1975.patch
>
>
> Add oracle database support to Karaf jdbc locking feature.
> Current default JDBC class does not work well with Oracle databases, please add support for functionality with Oracle.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.