You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Sridhar n <sr...@gmail.com> on 2008/11/18 19:07:04 UTC
problem with Connection pooling in tomcat 5.5
Hello friends,
I am doing small web application ,in that I am doing connection pooling.I
followed these steps:
*1.In Conf/server.xml - added below code*
<Server port="8005" shutdown="SHUTDOWN">...
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"
description="Oracle 9i database that can be updated and saved"
factory="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:oci9:@oracle"
username="scott" password="tiger" maxActive="20" maxIdle="10"
maxWait="-1""/>
....
</Server>
*2. In web.xml of my web application:*
<web-app>...
<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
...</web-app>
*3.In my class :*
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection con = ds.getConnection();
*4. I started tomcat 5.5 server , it is not starting and getting error in
log file like:
*
Nov 18, 2008 11:31:22 PM org.apache.tomcat.util.digester.Digester fatalError
SEVERE: Parse Fatal Error at line 42 column 85: Element type "Resource" must
be followed by either attribute specifications, ">" or "/>".
org.xml.sax.SAXParseException: Element type "Resource" must be followed by
either attribute specifications, ">" or "/>".
at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)
at
com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown
Source)
at
com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(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 org.apache.tomcat.util.digester.Digester.parse(Digester.java:1561)
at org.apache.catalina.startup.Catalina.load(Catalina.java:475)
at org.apache.catalina.startup.Catalina.load(Catalina.java:512)
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.load(Bootstrap.java:243)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:408)
I am not able to run tha server.Could you please help inthis concern.
thanks & regards
Sri
Re: problem with Connection pooling in tomcat 5.5
Posted by Filip Hanik - Dev Lists <de...@hanik.com>.
the factory
factory="oracle.jdbc.driver.OracleDriver"
should not be a driver, but a factory object for a javax.sql.DataSource
Filip
Felix Schumacher wrote:
> Am Dienstag, den 18.11.2008, 23:37 +0530 schrieb Sridhar n:
>
>> Hello friends,
>> I am doing small web application ,in that I am doing connection pooling.I
>> followed these steps:
>> *1.In Conf/server.xml - added below code*
>> <Server port="8005" shutdown="SHUTDOWN">...
>>
>> <Resource name="jdbc/myoracle" auth="Container"
>> type="javax.sql.DataSource"
>> description="Oracle 9i database that can be updated and saved"
>> factory="oracle.jdbc.driver.OracleDriver"
>> url="jdbc:oracle:oci9:@oracle"
>> username="scott" password="tiger" maxActive="20" maxIdle="10"
>> maxWait="-1""/>
>>
>
> There seems to be surplus " after -1", which would explain the excellent
> error message:
>
>
>> Nov 18, 2008 11:31:22 PM org.apache.tomcat.util.digester.Digester fatalError
>> SEVERE: Parse Fatal Error at line 42 column 85: Element type "Resource" must
>> be followed by either attribute specifications, ">" or "/>".
>> org.xml.sax.SAXParseException: Element type "Resource" must be followed by
>> either attribute specifications, ">" or "/>".
>>
>
> bye
> Felix
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: problem with Connection pooling in tomcat 5.5
Posted by Felix Schumacher <fe...@internetallee.de>.
Am Dienstag, den 18.11.2008, 23:37 +0530 schrieb Sridhar n:
> Hello friends,
> I am doing small web application ,in that I am doing connection pooling.I
> followed these steps:
> *1.In Conf/server.xml - added below code*
> <Server port="8005" shutdown="SHUTDOWN">...
>
> <Resource name="jdbc/myoracle" auth="Container"
> type="javax.sql.DataSource"
> description="Oracle 9i database that can be updated and saved"
> factory="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:oci9:@oracle"
> username="scott" password="tiger" maxActive="20" maxIdle="10"
> maxWait="-1""/>
There seems to be surplus " after -1", which would explain the excellent
error message:
> Nov 18, 2008 11:31:22 PM org.apache.tomcat.util.digester.Digester fatalError
> SEVERE: Parse Fatal Error at line 42 column 85: Element type "Resource" must
> be followed by either attribute specifications, ">" or "/>".
> org.xml.sax.SAXParseException: Element type "Resource" must be followed by
> either attribute specifications, ">" or "/>".
bye
Felix
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: problem with Connection pooling in tomcat 5.5
Posted by Sridhar n <sr...@gmail.com>.
>
> Hello friends,
> I am doing small web application ,in that I am doing connection pooling.I
> followed these steps:
> *1.In Conf/server.xml - added below code*
> <Server port="8005" shutdown="SHUTDOWN">...
>
> <Resource name="jdbc/myoracle" auth="Container"
> type="javax.sql.DataSource"
> description="Oracle 9i database that can be updated and saved"
> driverClassName="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@127.0.0.1:1521:oracle"
> username="scott" password="tiger"/>
> ....
> </Server>
>
> *2. In web.xml of my web application:*
> <web-app>...
> <resource-ref>
> <description>Oracle Datasource example</description>
> <res-ref-name>jdbc/myoracle</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
> ...</web-app>
>
> *3.In my class :*
>
> Context initContext = new InitialContext();
> Context envContext =
> (Context)initContext.lookup("java:/comp/env");
> DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
> Connection con = ds.getConnection();
>
>
> *4. I started tomcat 5.5 server , it is not starting and getting error in
> log file like:
> *
> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver
> of class '' for connect URL 'null'
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
> at com.sri.struts.RegisterDAO.getConnect(RegisterDAO.java:61)
> at com.sri.struts.RegisterDAO.isEmployee(RegisterDAO.java:160)
> at com.sri.struts.LoginAction.execute(LoginAction.java:50)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Unknown Source)
> Caused by: java.sql.SQLException: No suitable driver
> at java.sql.DriverManager.getDriver(Unknown Source)
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773)
> ... 24 more
> java.lang.NullPointerException
> at com.sri.struts.RegisterDAO.isEmployee(RegisterDAO.java:160)
> at com.sri.struts.LoginAction.execute(LoginAction.java:50)
> at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Unknown Source)
>
> I am not able to run tha server.Could you please help inthis concern.
>
>
> thanks & regards
> Sri
>
>
>
>
>
>