IBM Websphere 5.0, Oracle JDBC DataSource

Discussion in 'Java' started by Anonymous, Jul 17, 2003.

  1. Anonymous

    Anonymous Guest

    I downloaded Oracle's JDBC driver from

    I have Websphere Application Server 5.0 installed
    on my system (Windows 2000)

    I configured a JDBC Provider with the Oracle JDBC Driver.

    After configuring the JDBC Provider, I configured a DataSource.

    My servlet can lookup the DataSource via JNDI.

    However, an exception occurs when I invoke getConnection()
    on the DataSource object.

    getConnection() throws a java.sqlSQLException

    Where do I specify the JDBC URL?

    I noticed that each DataSource can have "Custom Properties" defined
    via the Admin Console.

    Should I set any Custom Properties?

    Here is the stack trace:

    Error 500: Server caught unhandled exception from servlet [myappservlet]:
    java.sql.SQLException: Invalid Oracle URL specified:
    OracleDataSource.makeURL at
    oracle.jdbc.dbaccess.DBError.throwSqlException( at
    oracle.jdbc.dbaccess.DBError.throwSqlException( at
    oracle.jdbc.dbaccess.DBError.check_error( at
    oracle.jdbc.pool.OracleDataSource.makeURL( at
    oracle.jdbc.pool.OracleDataSource.getURL( at
    java:115) at
    java:86) at$
    643) at Method) at at at
    ion( at at
    :897) at at
    60) at
    374) at
    va:205) at
    at myapplication.Util.getDBConnection( at
    Anonymous, Jul 17, 2003
    1. Advertisements

  2. Anonymous

    Anonymous Guest

    I fixed this problem by setting three "Custom Properties"
    for the DataSource in the Websphere admin console.

    1) URL
    2) user
    3) password

    The URL must be a valid Oracle JDBC URL
    Anonymous, Jul 19, 2003
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.