Wandora

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.

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

Yes, it worked! Thank you very much!