Using Oracle JDBC driver with Orion

[Vucinic, Dejan]

Greetings,

When I try connecting to an Oracle 8.1.5 database using Oracle's
pure java JDBC driver through Orion I get this exception:

java.sql.SQLException: Null user or password not supported in THIN driver
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:803)
        at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:179)
        at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:198)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
        at com.evermind.sql.DriverManagerDataSource.getConnection(JAX)
        at
com.evermind.sql.DriverManagerConnectionPoolDataSource.getPooledConnection(J
AX)
        at com.evermind.sql.OrionPooledDataSource.c7(JAX)
        at com.evermind.sql.OrionPooledDataSource.cw(JAX)
        at com.evermind.sql.OrionPooledDataSource.getConnection(JAX)
        at com.evermind.sql.OrionPooledDataSource.getConnection(JAX)
        at com.evermind.sql.DriverManagerXADataSource.df(JAX)
        at com.evermind.sql.ag.dc(JAX)
        at com.evermind.sql.ak.createStatement(JAX)
        at com.evermind.sql.ak.createStatement(JAX)
        ...

This is on Linux and with various versions of Orion up to 1.0.11.
Here is the relevant part of data-sources.xml:

        <data-source
                name="Smuggler data-source" 
                class="com.evermind.sql.ConnectionDataSource" 
                location="jdbc/ssp/Stash" 
                ejb-location="jdbc/ssp/Stash" 
                xa-location="jdbc/xa/ssp/Stash" 
                url="jdbc:oracle:thin:@localhost:1521:SMUGDB"
                connection-driver="oracle.jdbc.driver.OracleDriver"
                username="smuggler" 
                password="smuggler" 
        />

I also tried stuffing the username and password in various places on
the URL with the same result.  A stand-alone java program can
connect without trouble using this URL, username and password.

I have seen messages from people successfully connecting to Oracle,
would appreciate a hint about what magic is required to get this to
work.

Thanks,

Dejan Vucinic
[EMAIL PROTECTED]