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
Ken Hygh

2005-04-28, 6:01 pm

uskulkarni@hotmail.com wrote:

>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.
>
>

Either will work from the application, but I believe that if you want to
use the admin console's Test Connection button you'll want to configure
the data source at a level higher than server. The samples are
configured at the server level because it is VERY unlikely that you'll
want to cluster the sample applications :-).

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

I'm confused. Farther down in your post you state that you don't have
any EJBs, yet here you're trying to to EJB stuff. I believe that the
pages to configure these things only show up if there are EJBs in your
application.

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

You configure data sources for a WAR within the deployment descriptor
inside the WAR, not in the admin console.

>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 to you :-) this is coming from your code. What are you trying to do?

>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)
>
>

Did you restart the server?

> 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 don't know what this particular error message means, sorry

>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