Problem with JDBC

Hi friends,

Recently, I have downloaded Netbeans and JDK1.6. I have made a DSN from control panel connecting to oracle databse HR (sample database provided with Oracle XE 10g) and the connection tests to be successful.

However, when in the netbeans, I try to connect to the HR database using JDBC-ODBC Bridge using the JDBCODBC driver the connection gets established, but when I try to expand the tables, it gives an error message "Unable to read databse structure; Null" and the connection gets broken.

Simlarly, when I try to connect to Access database using another DSN the error I receive inside netbeans is "Please check the URL, username and password". However the URL here I have given is the DSN made in the control panel, username - I have tried blank space as well as admin and password as blank space. But the problem persists.

Kindly help.

[882 byte] By [Friendlyananda] at [2007-11-27 9:18:47]
# 1

Friendly,

As far as I know, you can't use the JDBC-ODBC driver with an Oracle XE database.

And by the way, you don't need to create a DSN, either.

Also, I'm curious to know why you posted this same question to three different forums.

Please explain.

Good Luck,

Avi.

abramiaa at 2007-7-12 22:10:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

I am new to these forums so previously i was not knowing that there is a separate jdbc forum and posted the question in the first two forums.

I have obtained connection to oracle xe by using native driver.

even i was getting connection with jdbc-odbc-bridge and it was showing the views and procedures, but the connection was getting broken the moment i used to populate the tables saying that unable to read the database structure, connection broken, null;.

Thanx anyway.

Friendlyananda at 2007-7-12 22:10:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
Add the class12.jar to netbeans
lincolnrosea at 2007-7-12 22:10:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...