Learn more
 

Ready to get started?

Download a free trial of the Oracle SCM Driver to get started:

 Download Now

Learn more:

Oracle SCM Icon Oracle SCM JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with Oracle SCM.

In this article

Related articles

Connect to Oracle SCM Data in JRuby


Create a simple JRuby app with access to live Oracle SCM data.

JRuby is a high-performance, stable, fully threaded Java implementation of the Ruby programming language. The CData JDBC Driver for Oracle SCM makes it easy to integrate connectivity to live Oracle SCM data in JRuby. This article shows how to create a simple JRuby app that connects to Oracle SCM data, executes a query, and displays the results.

Configure a JDBC Connection to Oracle SCM Data

Before creating the app, note the installation location for the JAR file for the JDBC Driver (typically C:\Program Files\CData\CData JDBC Driver for Oracle SCM\lib).

JRuby natively supports JDBC, so you can easily connect to Oracle SCM and execute SQL queries. Initialize the JDBC connection with the getConnection function of the java.sql.DriverManager class.

The following connection properties are required to connect to Oracle SCM data.

  • Url: The URL of the account that you want to connect to. Typically, this will be the URL of your Oracle Cloud service. For example, https://servername.fa.us2.oraclecloud.com.
  • User: The username of your Oracle Cloud service account.
  • Password: The password of your Oracle Cloud service account.

Built-in Connection String Designer

For assistance in constructing the JDBC URL, use the connection string designer built into the Oracle SCM JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

java -jar cdata.jdbc.oraclescm.jar

Fill in the connection properties and copy the connection string to the clipboard.

Below is a typical JDBC connection string for Oracle SCM:

jdbc:oraclescm:Url=https://myinstance.oraclecloud.com;User=user;Password=password;

Create a JRuby App with Connectivity to Oracle SCM Data

Create a new Ruby file (for example: OracleSCMSelect.rb) and open it in a text editor. Copy the following code into your file:

require 'java' require 'rubygems' require 'C:/Program Files/CData/CData JDBC Driver for Oracle SCM 2018/lib/cdata.jdbc.oraclescm.jar' url = "jdbc:oraclescm:Url=https://myinstance.oraclecloud.com;User=user;Password=password;" conn = java.sql.DriverManager.getConnection(url) stmt = conn.createStatement rs = stmt.executeQuery("SELECT CarrierId, CarrierName FROM Carriers") while (rs.next) do puts rs.getString(1) + ' ' + rs.getString(2) end

With the file completed, you are ready to display your Oracle SCM data with JRuby. To do so, simply run your file from the command line:

jruby -S OracleSCMSelect.rb

Writing SQL-92 queries to Oracle SCM allows you to quickly and easily incorporate Oracle SCM data into your own JRuby applications. Download a free trial today!