• Sign In
  1. Messages

Oracle DB connection

LabKey Support Forum (Inactive)

View Message

view list print
Oracle DB connection Matthew Walker  2017-03-07 14:24
Status: Closed
 
I'm trying to configure labkey to retrieve/display data from a 10g oracle database. I went through the documentation for External Oracle Data Sources and went to the set up external schema step but there's never anything new. I've tried various iterations of url setting and restart tomcat every time. I can tnsping the oracle database from the server. Should the oracle database appear as a new data source when I go to define the external schema?
 
 
adam responded:  2017-03-07 16:01
Yes, if you've configured an Oracle DataSource correctly in your labkey.xml file then that database should appear as an option on the external schema page. Look at messages logged at server startup; there should be a detailed message for each DataSource, showing all the configuration parameters and whether the connection was successful or not. What information is logged for your new DataSource?

Adam
 
Matthew Walker responded:  2017-03-09 13:57
It appears to not be compatible with oracle 10g. Confirmed?
 
Jon (LabKey DevOps) responded:  2017-03-09 14:13
Hi Matthew,

I believe this is the case.

Checking our older docs, it looks like our earliest records show that Oracle 11g was the most earliest version that we've worked with that we verified works with past iterations of LabKey.

If you're trying to run Java 8, Oracle 12c Release 1 JDBC driver is the only one that supports Java 8.

Regards,

Jon