Skip to Content
Former Member
Feb 19, 2008 at 05:21 PM

JDBC Connection for Oracle


Hello Experts,

I'm having some trouble getting a JDBC connection to work correctly and I am in need of some advice.


I have setup a test Portal 7.00 SP14 with an Oracle database on a Windows 2003 X64 server. The Portal system was up and running and connecting to a WAS6.20 systems. We do not have BI or XI in our landscape.

I needed to connect to an Oracle database from visual composer to read some data from tables to do a proof of concept. From what I understand this connection will be a JDBC connection. I have setup a new system using the JDBC template, assisnged an alias, and entered the connection URL . I was unable to connect.

I read that I need to add the driver using Visual Composer. I did so with the following instructions:

Install JDBC Driver

• Start the Visual Administrator

• Logon at WebAS

• Open: Server, Services, JDBC Connector, Drivers

• Choose “Create New Driver or DataSource” on the toolbar

• Specify an arbitrary name for your driver entry such as “OracleDriver” and click OK

• Now search for the Oracle JDBC Driver JAR file on your local harddisk.

I restarted the Java instance with SMICM after completing this task Java will not start. Is there anyway to roll back that change to get Java back up and running?

Also is there a better way to go about making this oracle connection?

Best Regards,

Edited by: Troy Loseke on Feb 20, 2008 8:30 AM