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

Problems Setting up Oracle DataSource

41 Views

Hello,

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)

Driver: 
    name = 'ORACLE_DRIVER'
    jar = C:OracleOra81jdbclibclasses12.zip

DataSource:
    application = 'sap.com/EtiRegisterOracle'
    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();
    conn.setAutoCommit(false);

I get the following exception @ ds.getConnection()

com.sap.engine.services.dbpool.exceptions.BaseSQLException:
ResourceException in method ConnectionFactoryImpl.getConnection():
    com.sap.engine.services.dbpool.exceptions.BaseResourceException:
SQLException thrown by the physical connection:
com.sap.sql.log.OpenSQLException: 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.