| Author |
Struts DB Error
|
Mano haran
Greenhorn
Joined: Nov 30, 2006
Posts: 15
|
|
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
Joined: Jul 02, 2007
Posts: 4
|
|
please check below link http://www.roseindia.net/struts/strutsdatasourcemanagerontomcat5.shtml
|
 |
Merrill Higginson
Ranch Hand
Joined: Feb 15, 2005
Posts: 4864
|
|
|
Read quetion 7 of the JavaRanch Struts FAQ
|
Merrill
Consultant, Sima Solutions
|
 |
 |
|
|
subject: Struts DB Error
|
|
|