Link to home
Start Free TrialLog in
Avatar of uday_kulk
uday_kulk

asked on

db2 8.1 data source in websphere 6.0???????

Hello

OS : Windows 2003 Server
Database : IBM UDB DB2 V8.1
AppServer :- IBM WebSphere 6.0 APP Server
Driver : com.ibm.db2.jcc.DB2ConnectionPoolDataSource

Is it right to set the Data Source to Node:appservernode01 scope setting OR is it Server:server1 scope setting?
Becauze all sample application Data Sources configure on Server:server1 scope settings.

But I failed to setup Data Source on Server:server1 scope setting and got the following JVM log errors during test connection:-

Test connection failed for data source JDBC DataSource on server server1 at node appserverNode01 with the following exception:
java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base.
View JVM logs for further details.

4/28/05 16:24:35:045 IST] 0000000a ContainerImpl E   WSVR0501E: Error creating component null [class com.ibm.ws.runtime.component.ApplicationServerImpl]
com.ibm.ws.exception.RuntimeWarning: com.ibm.ws.exception.WsRuntimeException: java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base
      at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:839)
      at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649)
      at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149)
      at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:821)

After that I setup the datasource to Node:appserverNode01 scope setting and test connection successfully.

So I uninstall my application and again installed and restart the application.
After that I check the settings in admin console :- Applications - Enterprise Application -- click myapplication

I coudn't see following option to map datasource to myapplication in additional properties
- Provide JNDI Names for Beans
- Map data sources for all 2.x CMP beans

How do I map datasource to my application? I tried to install and uninstall war application again and again.

Whenever I go to access my Web Application, its gaves many SystemErr and SystemOut log errors regarding failed data source connection.

SystemOut.log :-
4/28/05 16:24:35:045 IST] 0000000a ContainerImpl E   WSVR0501E: Error creating component null [class com.ibm.ws.runtime.component.ApplicationServerImpl]
com.ibm.ws.exception.RuntimeWarning: com.ibm.ws.exception.WsRuntimeException: java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base
      at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:839)
      at com.ibm.ws.runtime.component.ContainerImpl.start(ContainerImpl.java:649)
      at com.ibm.ws.runtime.component.ApplicationServerImpl.start(ApplicationServerImpl.java:149)
      at com.ibm.ws.runtime.component.ContainerImpl.startComponents(ContainerImpl.java:821)

SystemErr.log :-
at com.saterisystems.sasinv1r0.webarch.iarchie.database.ConnectionPoolForWeb.getConnection(ConnectionPoolForWeb.java:278)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr     R       at com.saterisystems.sasinv1r0.webarch.iarchie.database.ConnectionPoolForWeb.getConnection(ConnectionPoolForWeb.java:278)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr     R       at com.saterisystems.sasinv1r0.webarch.iarchie.database.ConnectionPoolForWeb.getConnection(ConnectionPoolForWeb.java:278)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr     R       at com.saterisystems.sasinv1r0.webarch.iarchie.database.ConnectionPoolForWeb.getConnection(ConnectionPoolForWeb.java:278)

Note : 1) I am not using EJB in my web application.

Questions : 1) Where I can set the data source Node:appservernode01 OR Server:server1 scope setting?
          2) When I setup the data source to Node:appservernode01 and test connection successfull
             but why it is failed during access web application? (see logs)
          3) Why data source configuration failed during set to Server:server1? (see logs)
          4) How do I map data source to my web application as I am not able to see

Below is the common error which i get during access web application and even during ser the data source
com.ibm.ws.exception.RuntimeWarning: com.ibm.ws.exception.WsRuntimeException: java.lang.IllegalArgumentException: resolve against non-hierarchical or relative base

I Hope your next response must be resolve this issue? Please look into this.
Regards
Uday
ASKER CERTIFIED SOLUTION
Avatar of damonf
damonf

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial