Additional info:
I get the following exception in the log when I start the server up:
==> localhost.2009-03-03.log <==
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:613)
I use the following code to get the connection:
InitialContext ic = new InitialContext();
if(ic == null)
{
System.out.println("context not found");
}
DataSource ds =
(DataSource)ic.lookup("java:comp/env/jdbc/vhousehold");
if(ds == null)
{
System.out.println("DataSource not found");
}
conn = ds.getConnection();
stat = conn.createStatement();
rs = stat.executeQuery("SELECT * FROM family_member ");
On Tue, Mar 31, 2009 at 9:36 PM, Mighty Tornado <[email protected]>wrote:
> 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.
>
