hai,
I deployed an application in
tomcat 4.1.30 . the application uses a datasource for getting database connection.
I am getting the following exception when starting the server and i am unable to access the application.
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory, cause:
984391 [MailMan] DEBUG netreturn.com.ConnectionManager - ***The JNDI properties
are :***1
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2324)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
627)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingSt
atement.java:188)
at org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(
PoolableConnectionFactory.java:338)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:839)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:518)
at netreturn.com.ConnectionManager.getConnection(ConnectionManager.java:
55)
at netreturn.com.NRSql.getConnection(NRSql.java:500)
at netreturn.com.NRSql.<init>(NRSql.java:78)
at netreturn.com.NRSql.<init>(NRSql.java:53)
at imany.job.JobMonitor.run(JobMonitor.java:181)
at java.lang.Thread.run(Thread.java:536)
java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:
651)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:2110)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2324)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
627)
IN server.xml, the code for datasource is
<Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" displayName="rk" docBase="C:\Program Files\Apache Group\Tomcat 4.1\webapps\gp" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/gp" privileged="false" reloadable="false" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
<Environment name="gp-ver" override="true" type="java.lang.String" value="3.1.2"/>
<Resource name="jdbc/upgradeJNDI" scope="Shareable" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/upgradeJNDI">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>validationQuery</name>
<value>select * from details;</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>50</value>
</parameter>
<parameter>
<name>password</name>
<value>gp311</value>
</parameter>
<parameter>
<name>url</name>
<value>
jdbc racle:thin:@10.11.12.223:1521:surevy</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
<parameter>
<name>username</name>
<value>gp311</value>
</parameter>
</ResourceParams>
</Context>
can someone help me in solving this problem.
regards
ravikiran