tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mighty Tornado <mighty.torn...@gmail.com>
Subject Re: DataSource from Context files - doesn't work
Date Wed, 01 Apr 2009 10:30:19 GMT
No Exception there. Even after I restart the server and call the Servlet
that is supposed to retrieve the DB data.

On Wed, Apr 1, 2009 at 6:24 AM, Yassine <elassad@users.sourceforge.net>wrote:

> catalina.out
>
>
> On Wed, Apr 1, 2009 at 12:17 PM, Mighty Tornado
> <mighty.tornado@gmail.com> wrote:
> > I have the following files in the logs directory:
> >
> > admin.2009-04-01.log
> > catalina.out
> > localhost.2009-04-01.log
> > catalina.2009-04-01.log
> > host-manager.2009-04-01.log
> > manager.2009-04-01.log
> >
> > Which one of them should I VI or LESS to find the complete stack trace
> for
> > the exception?
> >
> > Also, is there something obviously wrong with my context definition or
> > reference? I followed the Tomcat online tutorial to define them.
> > Also, previously a regular JDBC code with the same parameters was able to
> > access the DB and retrieve the data correctly.
> >
> > Thank you all.
> >
> > On Wed, Apr 1, 2009 at 6:09 AM, Yassine <elassad@users.sourceforge.net
> >wrote:
> >
> >> don't "tail -f"
> >> use less and copy the part containing the exception from its beginning
> >> to the end.
> >>
> >>
> >>
> >> On Wed, Apr 1, 2009 at 12:07 PM, Mighty Tornado
> >> <mighty.tornado@gmail.com> wrote:
> >> > Where can I obtain it?
> >> > The exception that I posted is the only exception that showed up
> >> following
> >> > "tail -f *"
> >> >
> >> > On Wed, Apr 1, 2009 at 6:04 AM, Gregor <rc46fi@googlemail.com> wrote:
> >> >
> >> >> 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
> >> >>
> >> >>
> >> >
> >>
> >>
> >>
> >> --
> >> --
> >> Yassine Elassad
> >> Bonn, Germany.
> >> Fon : +49 228 97629355
> >> Mobile : +49 157 74519666
> >>
> >> PEACE :
> >> ( P ) Positive ( E ) Energy ( A ) Always ( C ) Correct ( E ) Errors.
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> >> For additional commands, e-mail: users-help@tomcat.apache.org
> >>
> >>
> >
>
>
>
> --
> --
> Yassine Elassad
> Bonn, Germany.
> Fon : +49 228 97629355
> Mobile : +49 157 74519666
>
> PEACE :
> ( P ) Positive ( E ) Energy ( A ) Always ( C ) Correct ( E ) Errors.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message