Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC driver for oracle 11g xe

 
Joe Ridener
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic