Re: DataSource from Context files - doesn't work

[Mighty Tornado]

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 <mighty.torn...@gmail.com>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.
>