tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gregor <rc4...@googlemail.com>
Subject Re: DataSource from Context files - doesn't work
Date Wed, 01 Apr 2009 10:04:49 GMT
your log is useless.
please post the complete stacktrace incl. the type of the exception

rds

gregor

Am 01.04.2009 um 11:57 schrieb Mighty Tornado  
<mighty.tornado@gmail.com>:

> 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.tornado@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.
>>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message