Could you please try not to configure your data source in Tomcat? Instead
try to configure your datasource only in struts-config.xml file as I've
mentioned. It should work. Please get rid of the JNDI lookup code from the
JSP and use the getDataSource(request) method which is very intelligent
enough to pick up the datasource object. Just to try this approach, comment
out the resource definitions part in Tomcat and confiure the datasource
exactly as I've mentioned. I was also facing some problems when I tried to
keep the "key" attribute and retrieve the DataSource object through JNDI
lookup. Let me know if you still face any issues.
Thanks,
Tarun.
On 4/2/06, red phoenix <[EMAIL PROTECTED]> wrote:
>
> when I start Tomcat,it raise following error:
> New org.apache.commons.dbcp.BasicDataSource
> Begin event threw exception
> java.lang.ClassNotFoundException: org.apache.commons.dbcp.BasicDataSource
> at org.apache.catalina.loader.WebappClassLoader.loadClass (
> WebappClassLoader.java:1352)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(
> WebappClassLoader.java:1198)
> at java.lang.ClassLoader.loadClassInternal(Unknown Source)
> at java.lang.Class.forName0 (Native Method)
> at java.lang.Class.forName(Unknown Source)
> at org.apache.struts.digester.ObjectCreateRule.begin(ObjectCreateRule.java
> :152)
> at org.apache.struts.digester.Digester.startElement (Digester.java:528)
> at
> com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement
> (Unknown
> Source)
> at
> com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement
> (Unknown
> Source)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement
> (Unknown
> Source)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch
> (Unknown
> Source)
> at
>
> com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument
> (Unknown
> Source)
> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse
> (Unknown
> Source)
> at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse
> (Unknown
> Source)
> at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
> Source)
> at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse
> (Unknown
> Source)
> at javax.xml.parsers.SAXParser.parse(Unknown Source)
> at javax.xml.parsers.SAXParser.parse(Unknown Source)
> at org.apache.struts.digester.Digester.parse(Digester.java:755)
> at org.apache.struts.action.ActionServlet.initMapping(ActionServlet.java
> :1332)
> at org.apache.struts.action.ActionServlet.init(ActionServlet.java:466)
> at javax.servlet.GenericServlet.init(GenericServlet.java :211)
> at org.apache.catalina.core.StandardWrapper.loadServlet(
> StandardWrapper.java
> :1105)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
> at org.apache.catalina.core.StandardContext.loadOnStartup (
> StandardContext.java:3915)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java
> :4176)
> at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:759)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>
> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java
> :910)
> at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java
> :873)
> at org.apache.catalina.startup.HostConfig.deployApps (HostConfig.java:474)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
> :310)
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent (
> LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
>
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
>
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
> at org.apache.catalina.core.StandardService.start(StandardService.java
> :450)
> at org.apache.catalina.core.StandardServer.start (StandardServer.java:700)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke (Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java :275)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> 2006-4-2 8:40:02 org.apache.coyote.http11.Http11BaseProtocol start
>
> My use Microsoff Access2000 Database,and I have configure in ODBC,why it
> still above raise error?
>
>
> On 4/2/06, Tarun Reddy <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> > First of all we need not use "key" attribute in <data-source> tag until
> we
> > have more than one data source to be configured. So, try removing the
> > "key"
> > attribute and use the getDataSource() method which is already defined in
> > DBCP.
> > DataSource db = getDataSource(request);
> > You need not worry about all the naming lookups. That method will take
> > care of retrieving DataSource object . Even if you want to keep the
> "key"
> > attribute, then try using this,
> > DataSource db= getDataSource(request,key);
> >
> > This should work for you. Let me know if you still face any issues.
> >
> > Thanks,
> > Tarun.
> >
> >
> > On 4/1/06, red phoenix <[EMAIL PROTECTED]> wrote:
> > >
> > > I use struts-1.2.9,and want to configure a connection pool,so I
> > configure
> > > struts-config.xml file
> > > <struts-config>
> > > <data-source key="bb1" type="org.apache.commons.dbcp.BasicDataSource">
> > > <set-property property="driverClassName" value="
> > > sun.jdbc.odbc.JdbcOdbcDriver" />
> > > <set-property property="url" value="jdbc:odbc:SMS"/>
> > > <set-property property="maxActive" value="5" />
> > > <set-property property="username" value="administrator" />
> > > <set-property property="password" value="123" />
> > > <set-property property="autoCommit" value="true" />
> > > </data-source>
> > > ....
> > > </struts-config>
> > >
> > > Then I use this configure in a jsp file,like follows:
> > > <[EMAIL PROTECTED] import="java.sql.*"%>
> > > <[EMAIL PROTECTED] import="javax.sql.DataSource"%>
> > > <[EMAIL PROTECTED] import="javax.naming.*"%>
> > > <html>
> > > <body>
> > > <%
> > > try{
> > > Context initCtx=new InitialContext();
> > > System.out.println("ok");
> > > DataSource db = (DataSource)initCtx.lookup("java:comp/env/jdbc/bb1");
> > > System.out.println("db="+db);
> > > Connection conn = db.getConnection();
> > > System.out.println("conn="+conn);
> > > Statement stmt = conn.createStatement();
> > > ResultSet rs = stmt.executeQuery("SELECT * FROM abc");
> > > out.println("User-list"+"<br>");
> > > while(rs.next()){
> > > out.print(rs.getString(1)+"<br>");
> > > }
> > > rs.close();
> > > stmt.close();
> > > conn.close();
> > > }catch(Exception e){
> > > out.print(e);
> > > }
> > > %>
> > > </body>
> > > </html>
> > >
> > > When I run this jsp file,it raise follow errors:
> > > javax.naming.NameNotFoundException: Name jdbc is not bound in this
> > Context
> > >
> > > Where error is in my code? Please give me some examples about how to
> > > configure connection pool in Struts and how to call this connection in
> > JSP
> > > file and JavaBean.
> > >
> > > Thanks in advance!
> > >
> > >
> >
>
>
