JDBC Connection for Oracle

72 Views

Hello Experts,

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

Background:

I have setup a test Portal 7.00 SP14 with an Oracle 10.2.0.2.0 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 10.2.0.3.0 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