Connection Pool

dianbo

I use jsapi to access reports deployed in iserver express.

there are two applications tomcat and iserver express that run at different servers. The .jsp files invoke jsapi are deployed in the tomcat server.

i used to put jdbc informations in the .rptlibrary file. But now i want to use connection pool to improve performance.

How can I configure iserver's Resource Factory ?

Thanks.

dianbo

i do it as the following step, but it doesn't work:

---

i add resource definition in the file <%=iServer Home%>/servletcontainer/conf/context.xml

<Resource name="jdbc/mySqlDb"
auth="Container"
type="javax.sql.DataSource"
maxActive="5" maxIdle="-1" maxWait="10000"
username="usr" password="psword"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3308/test"
description="MySQL Sfdata DB"/>

---

add resource-ref element in <%=iServer Home%>/servletcontainer/iportal/WEB-INF/web.xml

<resource-ref>
<description>Resource reference to a factory for java.sql.Connection</description>
<res-ref-name>jdbc/mySqlDb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

---

use jndi 'java:comp/env/jdbc/mySqlDb' in .rptdesign or .rptlibrary to create the connection.

Any suggestion will be helpful. Thanks.