SQL Power Software Forum

Wabit XE connection fails 2009-08-10

Hi,
I have locally installed Oracle XE (which is a simple form of 10g) and connect well with it using MS Access 2007 and their XE driver. The XE database is the "HR" tutorial that is made by new Oracle users. Using the same user and password, and Wabit's Oracle 10g driver, I can't connect Wabit to XE. The messages are attached.

The system is Vista Business X86 and I am using the latest JRE (not JDK) as I want to emulate an user. I must be missing something simple, but what? Regards, David

This message was edited 2 times. Last update was at 2009-08-10 08:19:01

Hi David,

The reason for the error is because the Oracle JDBC driver was not found.

We felt that Oracle's terms for redistributing their JDBC driver were too strong (my understanding is that we would be required to collect certain personal information from each downloader), so we decided not to include it. You can download the Oracle JDBC driver from their website.

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

You would then use the User Preferences, using the JDBC Drivers tab to point the Wabit to the location of the driver file. I believe all the details should be in the User Guide (which you can download as a PDF at http://wabit.googlecode.com/files/WabitUserGuide-0.9.7.pdf, or access 'Help' in the Wabit itself)

Hope that helps!

Hi Jeff,
This did help to take me some way further. Thnak you. It may be a good idea to add to the Wabit note where Wabit does not find a JDBC connector, something like that ithe driver is shown in the GUI but is not included and the user must find and download it manually. BTW, the term "the Oracle driver" is deceptively simple. Faced with a large page of options at the Oracle 10g driver site, I hopefuly chose the correct option - ojdbc14.jar. This may be wrong as the database is running and yet the listener is not finding a database with the SID of HR or ORCL. Any thoughts on the next debugging steps would be appreciated.

Also, I am starting to feel a long way from "Wabit just works". Is that after an Oracle DBA has set it up with a JDBC driver and made the connection, or is there some easy way to reduce this pain with a database connection that I am missing? Am I being too ambitious in starting with Oracle XE?

Maybe I should gain more confidence through starting with data held in a default installed Wabit database, if you can suggest some tools to do so?

Regards
David

Hi David,

I think I can help you out, but I'll need more detail on the nature of the new error that you're getting.

This may be wrong as the database is running and yet the listener is not finding a database with the SID of HR or ORCL.

Typically, you would've seen another error dialogue similar to the one that told you the JDBC driver was missing. If so, there should be a button on that dialogue that says something like 'Show more details'. Click on that button, and a detailed error message should appear.

You can try copying and pasting the contents of that error message into a reply to this thread. Also, the error message would usually have a corresponding Oracle error code. (ORA-#####)