Q
Quick Function
I am using Microsoft Access and jsp. It works fine if I use:
<sql:setDataSource var="xtreme" scope="application"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc
dbc:Xtreme Sample Database"/>
<sql:query var="er" dataSource="${xtreme}" sql="select * from
customer" startRow="0" maxRows="100"/>
But if I put dataSource as pool
<Resource name="jdbc/xtreme" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xtreme">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc
dbc:Xtreme Sample Database</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
and ref it in my app web.xml, and change my jsp to
<sql:query var="er" dataSource="jdbc/xtreme" sql="select * from
customer" startRow="0" maxRows="100"/>
I got the "ResultSet is Closed" error, why?
Thanks,
qq
<sql:setDataSource var="xtreme" scope="application"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc
<sql:query var="er" dataSource="${xtreme}" sql="select * from
customer" startRow="0" maxRows="100"/>
But if I put dataSource as pool
<Resource name="jdbc/xtreme" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/xtreme">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc
</parameter>
<parameter>
<name>driverClassName</name>
<value>sun.jdbc.odbc.JdbcOdbcDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
and ref it in my app web.xml, and change my jsp to
<sql:query var="er" dataSource="jdbc/xtreme" sql="select * from
customer" startRow="0" maxRows="100"/>
I got the "ResultSet is Closed" error, why?
Thanks,