Trouble connecting to Oracle DB 12c

Forum is for miscellaneous user help requests.

Trouble connecting to Oracle DB 12c

Postby efang » Tue Sep 20, 2016 10:00 am

Hi all,

I'm trying to use the Database SQL Extractor to connect to a Oracle DB 12c. I'm able to write a simple Java app. to establish connection, hence I'm positive the database URL, user name and pwd are correct. However, when trying to connect in Wandora, it always returns Invalid Database Address error. I have downloaded the source code, set up wandora project in Netbeans and located SQLExtractor.java class. I manually force the connection url to be the one that worked successfully in my own app.; and the result was the same - it still complains the database address is invalid.

Why is that? Please help! Thank you.
efang
 
Posts: 4
Joined: Tue Sep 20, 2016 2:07 am

Re: Trouble connecting to Oracle DB 12c

Postby akivela » Tue Sep 20, 2016 10:12 am

Hi Efang

I suspect the invalid address error is caused by a missing Java library (JAR) for the Oracle DB. Wandora requires database specific library in order to connect the database. Wandora doesn't contain a database library for the Oracle DB by default. To proceed locate the JAR for the Oracle DB, put it into Wandora's dist/lib folder and restart Wandora application. That should do it.

Kind Regards,
Aki / Wandora Team
akivela
Site Admin
 
Posts: 260
Joined: Tue Sep 18, 2007 10:20 am
Location: Helsinki, Finland

Re: Trouble connecting to Oracle DB 12c

Postby efang » Wed Sep 21, 2016 4:37 am

Yes, it worked! Thank you very much! :)
efang
 
Posts: 4
Joined: Tue Sep 20, 2016 2:07 am


Return to How to... and problems

Who is online

Users browsing this forum: No registered users and 0 guests

cron