?
Solved

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

Posted on 2005-04-28
3
Medium Priority
?
3,037 Views
Last Modified: 2013-12-10
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
Comment
Question by:uday_kulk
1 Comment
 
LVL 7

Accepted Solution

by:
damonf earned 500 total points
ID: 13888719
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question