• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3052
  • Last Modified:

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
0
uday_kulk
Asked:
uday_kulk
1 Solution
 
damonfCommented:
I recommend creating your datasource at server level, not node level.

I have seen cases where "test connection" failed but that application worked fine.  So you may wish to try your app even though test connection failed.

You have to create resource ref entries in your web.xml in order for the datasource mappings to show up on the deployment wizard.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now