Creating Data Source for Oracle in WSO2 Data Services Server

Question

I have a Oracle Database 12c and I want to create a Data source for that in WSO2 Data Services Server.

I have downloaded ojdbc7.jar and copied into repository/components/lib folder of WSO2 Data Services Server

While Creating Data source from DSS UI, it is asking for jdbc:oracle:[drivertype]:[username/password]@[host]:[port]/[database]

I am confused with "drivertype" what should be the value of drivertype?

Answer 1

It should be one of one of oci, thin, or kprb (server-side internal).

Read this for more information: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#05_04