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.DB2Connect ionPoolDat aSource
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.IllegalArgumentE xception: 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.compone nt.Applica tionServer Impl]
com.ibm.ws.exception.Runti meWarning: com.ibm.ws.exception.WsRun timeExcept ion: java.lang.IllegalArgumentE xception: resolve against non-hierarchical or relative base
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rtComponen ts(Contain erImpl.jav a:839)
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rt(Contain erImpl.jav a:649)
at com.ibm.ws.runtime.compone nt.Applica tionServer Impl.start (Applicati onServerIm pl.java:14 9)
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rtComponen ts(Contain erImpl.jav a: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.compone nt.Applica tionServer Impl]
com.ibm.ws.exception.Runti meWarning: com.ibm.ws.exception.WsRun timeExcept ion: java.lang.IllegalArgumentE xception: resolve against non-hierarchical or relative base
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rtComponen ts(Contain erImpl.jav a:839)
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rt(Contain erImpl.jav a:649)
at com.ibm.ws.runtime.compone nt.Applica tionServer Impl.start (Applicati onServerIm pl.java:14 9)
at com.ibm.ws.runtime.compone nt.Contain erImpl.sta rtComponen ts(Contain erImpl.jav a:821)
SystemErr.log :-
at com.saterisystems.sasinv1r 0.webarch. iarchie.da tabase.Con nectionPoo lForWeb.ge tConnectio n(Connecti onPoolForW eb.java:27 8)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r 0.webarch. iarchie.da tabase.Con nectionPoo lForWeb.ge tConnectio n(Connecti onPoolForW eb.java:27 8)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r 0.webarch. iarchie.da tabase.Con nectionPoo lForWeb.ge tConnectio n(Connecti onPoolForW eb.java:27 8)
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r 0.webarch. iarchie.da tabase.Con nectionPoo lForWeb.ge tConnectio n(Connecti onPoolForW eb.java:27 8)
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.Runti meWarning: com.ibm.ws.exception.WsRun timeExcept ion: java.lang.IllegalArgumentE xception: resolve against non-hierarchical or relative base
I Hope your next response must be resolve this issue? Please look into this.
Regards
Uday
OS : Windows 2003 Server
Database : IBM UDB DB2 V8.1
AppServer :- IBM WebSphere 6.0 APP Server
Driver : com.ibm.db2.jcc.DB2Connect
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.IllegalArgumentE
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.compone
com.ibm.ws.exception.Runti
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
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.compone
com.ibm.ws.exception.Runti
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
at com.ibm.ws.runtime.compone
SystemErr.log :-
at com.saterisystems.sasinv1r
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r
[4/28/05 19:57:39:060 IST] 00000029 SystemErr R at com.saterisystems.sasinv1r
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.Runti
I Hope your next response must be resolve this issue? Please look into this.
Regards
Uday
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.