|
Home > Archive > WebSphere Application Server > March 2007 > WAS JDBC Connection Pool Data Source problem....DSRA0010E: SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
WAS JDBC Connection Pool Data Source problem....DSRA0010E: SQL
|
|
|
| The problem is
1. I have setting up a data source on WAS, and if I test it from the WAS admin console,and it's ok.
2.I use below try to get the pooled connection from WAS, I can get the DataSource but once I try to get the Connection from the DataSource , it failed with error as below, it looks like I did not set the user/password for my connection pool...
-----------------------------------------------------------------------
java.sql.SQLException: The application server rejected the connection. (Password is not set.)DSRA0010E: SQL State = 08004???? = -99,999DSRA0010E: SQL State = 08004???? = -99,999
------------------------------------------------------------------------
3.I check the WAS JCA setting again, and it's ok, and I still can connect to the DB from WAS, if I test it from WAS Admin console...
-------------------------------------------------------------------------
env.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
env.put(Context.PROVIDER_URL, "corbaloc:iiop:localhost:2809");
Context initialContext = new InitialContext(env);
DataSource ds = (DataSource) initialContext.lookup('JNDI Name for my pool');
Connection conn = ds.getConnection();
----------------------------------------------------------------------
| |
| Ken Hygh 2007-03-29, 7:21 am |
| andrewwang1@yahoo.com wrote:
> The problem is
> 1. I have setting up a data source on WAS, and if I test it from the WAS admin console,and it's ok.
> 2.I use below try to get the pooled connection from WAS, I can get the DataSource but once I try to get the Connection from the DataSource , it failed with error as below, it looks like I did not set the user/password for my connection pool...
> -----------------------------------------------------------------------
> java.sql.SQLException: The application server rejected the connection. (Password is not set.)DSRA0010E: SQL State = 08004???? = -99,999DSRA0010E: SQL State = 08004???? = -99,999
> ------------------------------------------------------------------------
>
> 3.I check the WAS JCA setting again, and it's ok, and I still can connect to the DB from WAS, if I test it from WAS Admin console...
> -------------------------------------------------------------------------
> env.put(Context.INITIAL_CONTEXT_FACTORY,"com.ibm.websphere.naming.WsnInitialContextFactory");
> env.put(Context.PROVIDER_URL, "corbaloc:iiop:localhost:2809");
> Context initialContext = new InitialContext(env);
> DataSource ds = (DataSource) initialContext.lookup('JNDI Name for my pool');
> Connection conn = ds.getConnection();
> ----------------------------------------------------------------------
>
>
>
>
>
Testing from the admin console doesn't actually try to do a transaction,
so if the password's not set it may not fail.
How did you configure the password on your DataSource?
Ken
|
|
|
|
|