JDBC driver for oracle 11g xe

[Joe Ridener]

I downloaded the ojdbc6.jar executable jar file and the Oracle 11g XE from Oracle... had some issues with my last database as far as drivers were concerned. I am a Java programmer before a SQL coder and could use a couple pointers with the driver as well as getting to the apex file ( I think it is) where you can create tables and other things to initialize the database. Any help on these two issues would be appreciated.

[K. Tsang]

Have you checked out the Java JDBC tutorial here?

Not sure what's the apex file you referring to? By the way, a database should already be created with proper user/password before Java program can connect.

I personally never tried connecting Oracle as sysdba in Java program.

[Joe Ridener]

Once you install the 11g xe db it will have you create a password but username. You can do this from the console but there is an easier way to do it with 11g xe. You create tables and new databases from this admin console whcch is browser based. I have done it before so I have a clue but it has been so long I forgot. Also needed the name of the best overall driver when I am doing online discussion forms , createing user account records ( from a standard web site) .. what driver works best? The most technical data type I will use is serialized objects, clobs and blobs. The Oracle 11g xe driver best suited for this might be? (probably the most standard beginner one)

[K. Tsang]

Joe Ridener wrote:Once you install the 11g xe db it will have you create a password but username. You can do this from the console but there is an easier way to do it with 11g xe. You create tables and new databases from this admin console whcch is browser based. I have done it before so I have a clue but it has been so long I forgot. Also needed the name of the best overall driver when I am doing online discussion forms , createing user account records ( from a standard web site) .. what driver works best? The most technical data type I will use is serialized objects, clobs and blobs. The Oracle 11g xe driver best suited for this might be? (probably the most standard beginner one)

Ah the Oracle jdbc driver, which you downloaded before (ojdbc6.jar). All java needs to connect to databases is that JDBC driver.

About creating users, tables what not in java inside, you can do that too. Just put in the sql to "create user ..." or "create table ..." accordingly. The only issue is the jdbc connected user would need to be granted admin rights or full privileges.