File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Struts DB Error

 
Mano haran
Greenhorn
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

i am new to struts, now i exploring struts with database access,i am getting error in my datasource,
my code snippet,

String user=null;
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;

ServletContext ctx=servlet.getServletContext();
DataSource ds=(DataSource)
ctx.getAttribute(Action.DATA_SOURCE_KEY);
try
{
conn=ds.getConnection();
stmt=conn.createStatement();
//some other codes here
}
here Action.DATA_SOURCE_KEY this is giving error to me,also i have pasted my struts-config.xml data source configuration

<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url"
value="jdbc racle:thin:@mac-0314:1521 RCL" />
<set-property property="username" value="scott" />
<set-property property="password" value="tiger" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="500" />
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
</data-source>
</data-sources>

please help me ...
 
Ramesh Satya Venkata
Greenhorn
Posts: 4
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
please check below link

http://www.roseindia.net/struts/strutsdatasourcemanagerontomcat5.shtml
 
Merrill Higginson
Ranch Hand
Posts: 4864
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Read quetion 7 of the JavaRanch Struts FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic