WebSphere Application Server - websphere data source configuration?

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Application Server > April 2005 > websphere data source configuration?





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 websphere data source configuration?

2005-04-28, 6:01 pm

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
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com