Results 1 to 4 of 4

Thread: JSP and Oracle?

  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Default JSP and Oracle?

     

    Hello,
    I'm writing jsp codes to connect mysql database with the web, and now I want to connect the web pages with the oracle database , I want to use the same jsp codes, But what should I change?
    Powered by Yahoo!

  2. #2
    Join Date
    Jan 2008
    Posts
    1

    Default

    change driver name
    and connection url
    Powered by Yahoo!

  3. #3
    Join Date
    Jan 2008
    Posts
    1

    Default

    the driver has to changed and also there is a specific syntax for connecting to a oracle database as compard to a mysql database
    Powered by Yahoo!

  4. #4
    Join Date
    Jan 2008
    Posts
    1

    Default

    Hi,
    In order to work with the Oracle,

    1) Change the Driver Class as per the Oracle DB.
    ex: Class.forName("oracle.jdbc.driver.OracleDriver");

    2) You need to Change the URL :
    ex: DriverManager.getConnection("jdbcracle:thin:@hostName:1521rcl", "scott", "tiger");


    Thats it, The Remaining things will be the same
    Powered by Yahoo!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •