Hi I placed the following in context.xml in META-INF.
But the result set is null, what's wrong with my set up?Can anybody please
advise?
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource
auth="Container"
description="DB Connection"
name="jdbc/vhousehold"
type="javax.sql.DataSource"
password="vhousehold"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2"
maxWait="5000"
validationQuery="select * from family_member;"
username="vhousehold"
url="jdbc:mysql://localhost:3306/vhousehold"
maxActive="4"/>
</Context>
Thanks,
Ramy.