Hi
I am getting following exception when i execute the struts with jdbc .
<Apr 27, 2003 3:58:28 PM IST> <Error> <HTTP> <101018> <[ServletContext(id=821981
0,name=SimpleStruts,context-path=/SimpleStruts)]
Servlet failed with ServletExce
ption
javax.servlet.UnavailableException: Initializing application data source org.apa
che.struts.action.DATA_SOURCE
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionSe
rvlet.java:1089)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:471)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(Servl
etStubImpl.java:1075)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:744)
at weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubIm
pl.java:899)
at weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStub
Impl.java:833)
at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubI
mpl.java:773)
at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppS
ervletContext.java:2763)
at weblogic.servlet.internal.WebAppServletContext.preloadServlets(WebApp
ServletContext.java:2708)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAp
pServletContext.java:2681)
at weblogic.servlet.internal.HttpServer.preloadResources(HttpServer.java
:552)
at weblogic.servlet.internal.WebService.preloadResources(WebService.java
:476)
at weblogic.t3.srvr.ServletInitRunner$1.run(ServletInitRunner.java:50)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:744)
at weblogic.t3.srvr.ServletInitRunner.run(ServletInitRunner.java:46)
at java.lang.Thread.run(Thread.java:479)
>
I make entries struts-config.xml for data source
<data-sources>
<!-- configuration for commons BasicDataSource -->
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="oracle.jdbc.driver.OracleDriverr" />
<set-property
property="url"
value="jdbc
racle:thin:@22.12.2.10:1521:fc"/>
<!-- value="jdbc
ostgresql://localhost/mydatabase" />-->
<set-property
property="username"
value="work" />
<set-property
property="password"
value="work" />
<set-property
property="maxActive"
value="10" />
<set-property
property="maxWait"
value="5000" />
<set-property
property="defaultAutoCommit"
value="false" />
<set-property
property="defaultReadOnly"
value="false" />
<set-property
property="validationQuery"
value="SELECT COUNT(*) FROM IP" />
</data-source>
</data-sources>
java code
----------
public ActionForward perform(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
javax.sql.DataSource dataSource;
java.sql.Connection myConnection=null;
try {
dataSource = getDataSource(request);
System.out.println("dataSource :"+ dataSource);
myConnection = dataSource.getConnection();
System.out.println("myConnection:"+ myConnection);
} catch (SQLException sqle) {
getServlet().log("Connection.process", sqle);
} finally {
try {
myConnection.close();
} catch (SQLException e) {
getServlet().log("Connection.close", e);
}
}
whats wrong wth the above code .I am using oracle 9i database