• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

data-sources with oracle

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, Please help I am learning to struts frame work.
Can any body tell me why I am getting this error.
Like where i have to define the database connection and which class i have to mention for data base related things.If possible pls send me the step wise code .

I am using oracle10g

here is my struts-config
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<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="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url" value="jdbc racle:thin:@xyz:1521:abc"/>
<set-property property="username" value="123"/>
<set-property property="password" value="123"/>
<set-property property="valida" value="SELECT SYSDATE FROM DUAL"/>
</data-source>
</data-sources>


inside my code

Double price = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
DataSource dataSource = null;
try {
System.err.println("---->ssdataSource<----");
dataSource = getDataSource(request);
System.out.println("dataSource :"+ dataSource);
conn = dataSource.getConnection();
System.out.println("myConnection:"+ conn);
.
.

I got this error on servlet

503 Service Unavailable
Servlet error: Initializing application data source org.apache.struts.action.DATA_SOURCE


and in java side i got this error

SEVERE: Initializing application data source org.apache.struts.action.DATA_SOURCE
java.lang.NullPointerException
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:545)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:381)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:259)
at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2094)
at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4523)
at com.evermind.server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2561)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:640)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am going to move this to the more appropriate Struts forum.

Mark
 
reply
    Bookmark Topic Watch Topic
  • New Topic