Hello,
i can not use a DataSource for jdbc- Connection. I tested it with sapdb
and sql server 2000. No one works. But it is no problem, to connect the
database over the jdbc directly.
My Equipment:
Windows XP, JDK 1.4.1, Tomcat 4.1.18 LE.
When I use it, i get some http error 500?!?
org.apache.jasper.JasperException:
org/apache/commons/pool/impl/GenericObjectPool
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:248)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
Can some help me?
The context from server xml
<Context path="/wolf" docBase="wolf" debug="0"
reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>dba</value>
</parameter>
<parameter>
<name>password</name>
<value>dba</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.sap.dbtech.jdbc.DriverSapDB</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:sapdb://127.0.0.1/wolf</value>
</parameter>
</ResourceParams>
</Context>
Web.xml
<resource-ref>
<description>Datenquelle fuer Wolf-Plantafel</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
The java code:
try {
initCtx = new InitialContext();
dummy = "Nach Initial Context";
ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/TestDB");
/* This point will execute the error, ds can not be initializied!
*/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
