Microsoft Access in jsp

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:eek: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:eek: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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,067
Latest member
HunterTere

Latest Threads

Top