Home » Developer & Programmer » JDeveloper, Java & XML » Connecting Java bean to Oracle?
Connecting Java bean to Oracle? [message #187423] Sun, 13 August 2006 22:52 Go to next message
Messages: 1
Registered: August 2006
Junior Member
I was working on a project and was using portSQL as my database but now I need to convert to Oracle.
Can someone tell me if I can still use the same connection method that I have that works for postgress or do I have to use a particular connection for Oracle.

The one I have is
public void MakeConnection()throws ClassNotFoundException, FileNotFoundException, IOException, SQLException
   	String url = "jdbc:postgresql:postgres";
    String usr = "postgres";
    String pwd = "dune";
    // Load the driver
    // Connect to database
    System.out.println("Connecting to Database URL = " + url);
    db = DriverManager.getConnection(url, usr, pwd);
    System.out.println("Connected...Now creating a statement");
    st = db.createStatement();

And the one people that I know when they use oracle use something like this
public websiteDAO() throws SQLException, NamingException
        Context init = new InitialContext();
    	Context ctx = (Context) init.lookup("java:comp/env");
    	DataSource ds = (DataSource) ctx.lookup("jdbc/myDatabase");
    	con = ds.getConnection();
    	System.out.println("DB Connected");
    	loginUser = con.prepareStatement("select username,password1 FROM USERS");

I would imagine that I could just use my own and just change the URL, username, password and driver class to the one needed for oracle.
Can someone please tell if my method would work, as I won't have access to Oracle for a few weeks to test it myself and I really need to know now.
Re: Connecting Java bean to Oracle? [message #187481 is a reply to message #187423] Mon, 14 August 2006 03:30 Go to previous message
Messages: 48
Registered: July 2006
Of course your method won't work until you change driver/url/user/pass.
Look here.
Second method is more acceptable due to usage of JNDI services.
The role of JNDI in J2EE
Previous Topic: xml parsing failed,, xdk is installed
Next Topic: Calling webservices in forms
Goto Forum:

Current Time: Sun Feb 26 17:40:32 CST 2017

Total time taken to generate the page: 0.11457 seconds