finally oracle thin driver working but...

Harry

unread,

Sep 19, 2003, 6:21:52 AM9/19/03

to

having got no errors starting up wl 6.1 I assume the connection pool was
created sucessfully - running java utils.dbping ORACLE_THIN etc... works but
now how can I get a connection from the pool from within a java program?

Tried this -

String defaultPool = "LWInterrogatorPool";

try
{
Context ctx = new InitialContext();

javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup(
defaultPool );

Connection conn = ds.getConnection();

return conn;
}
catch ( Exception e )
{
e.printStackTrace();
}

which works fine when using the thick driver but with the thin I get this -

java.sql.SQLException: Error accessing jdbc driver: driverURL =
jdbc:weblogic:pool:LWInterrogatorPool, props =
{connectionPoolID=LWInterrogatorPool, enableTwoPhaseCommit=false}.Nested
Exception: java.sql.SQLException: Pool connect failed:
weblogic.common.ConnectDeadException: failed to make new pool connection:
weblogic.common.Resource
Exception:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: invalid arguments in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:933)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:189)
at
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
.
.

These are my config.xml settings -

any ideas? - so fed up messing about with this about to give up!

thanks

harry

Joseph Weinstein

unread,

Sep 19, 2003, 11:22:29 AM9/19/03

to Harry

Harry wrote:

Remove the 'Name=abc' in the driver properties. The thin driver is complaining
about some property it doesn't know anything about.
Joe

>
>
> thanks
>
> harry

Slava Imeshev

unread,

Sep 19, 2003, 1:20:58 PM9/19/03

to

Hi Joe,

"Joseph Weinstein" <big...@bea.com> wrote in message news:3F6B1F35...@bea.com...
> Harry wrote:

[eaten]

> > These are my config.xml settings -
> >
> > <JDBCConnectionPool DriverName="oracle.jdbc.driver.OracleDriver"
> > InitialCapacity="3" MaxCapacity="10" Name="LWInterrogatorPool"
> > Password="{3DES}ti/QgvdzWRQLyYELoxJiTQ=="
> > Properties="Name=abc" Targets="MyServer"
> > TestTableName="dual" URL="jdbc:oracle:thin:@p1900:1521:dev"/>
> >
> > <JDBCTxDataSource JNDIName="LWInterrogatorPool"
> > Name="LWInterrogatorPool" PoolName="LWInterrogatorPool"
> > Targets="MyServer"/>
> >
> > any ideas? - so fed up messing about with this about to give up!
>
> Remove the 'Name=abc' in the driver properties. The thin driver is complaining
> about some property it doesn't know anything about.

Also, I'd add a user to the properties:

Properties="user=<user-for-which-the-password-is-given>" Targets="MyServer"

Regards,

Slava Imeshev

Harry

unread,

Sep 21, 2003, 6:45:14 AM9/21/03

to

Wow! thanks chaps - the bloody actually, finally works - yippee!!!!!!!!!!

"Slava Imeshev" <ime...@yahoo.com> wrote in message
news:3f6b...@newsgroups.bea.com...

Slava Imeshev

unread,

Sep 22, 2003, 12:48:06 PM9/22/03

to

"Harry" <a...@abc.com> wrote in message news:3f6d...@newsgroups.bea.com...

> Wow! thanks chaps - the bloody actually, finally works - yippee!!!!!!!!!!

Glad to help.

Regards,

Slava Imeshev