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.