Skip to Content
Former Member
Jul 28, 2005 at 05:24 PM

Problems Setting up Oracle DataSource



I am trying to set up an Oracle DataSource for a Web Dynpro App using a Stateless Session Bean for database access. I want to use Connection Pooling i.e. I don't want to use straight JDBC. Following the instructions in the Admin. Manual, I setup a new Driver and DataSource for Oracle 8i (8.1.7)

    name = 'ORACLE_DRIVER'
    jar =

    application = ''
    name = 'ORAJ2EDB'
    aliases = none
    jdbc version = 1.x
    driver = oracle.jdbc.driver.OracleDriver
    URL = jdbc:oracle:thin:@localhost:1521:orcl817
    SQL Engine = Vendor_SQL

I do not want to use OpenSQL which as far as I can tell is for SAPDB only(?)


Using this code (in a try/catch block)

    // Get a connection using a DataSource
    InitialContext ctx = new InitialContext();
    DataSource ds = (DataSource) ctx.lookup("jdbc/ORAJ2EDB");
    conn = ds.getConnection();

I get the following exception @ ds.getConnection()
ResourceException in method ConnectionFactoryImpl.getConnection():
SQLException thrown by the physical connection: JDBC driver not supported for ORACLE database.

which I don't understand at all. I can't find any mention of "JDBC driver not supported" anywhere. And why is it an OpenSQLException?? Remember, I'm trying to use Vendor_SQL.

There seems to be very little little information in these forums of how to use any database other than SAPDB (MaxDB).

Help, please.