• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

JDBC driver for oracle 11g xe

 
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Bartender
Posts: 3648
16
Android Mac OS X Firefox Browser Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 3648
16
Android Mac OS X Firefox Browser Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic