tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wade Chandler <hwadechandler-apa...@yahoo.com>
Subject RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server usin g JNDI?
Date Mon, 22 Aug 2005 16:58:02 GMT
--- "Wylie, Ian" <Ian.Wylie@Pfizer.com> wrote:

> Allistair,
> 
> My apologies for taking much longer than usual to
> get back to you but I had
> to finish some Java code that allowed us to upgrade
> our portal to PlumTree
> version 5.
> 
> To clarify and answer your points below.
> 
> 1)  I have opted not to have a context.xml file in
> the META-INF directory
> but I am using the 
> TOMCAT_HOME/conf/Catalina/localhost/webappname.xml
> file
> instead.
> 
> 2)  I  have ensured that the 3 MS JAR files for the
> JDBC connection exist
> only in TOMCAT_HOME/common/lib and not in my webapp
> lib.
> 
> 3)  I have changed the java code to use a simple
> 'DataSource' instead of a
> 'ConnectionPoolDataSource' connection.  See Java
> code snippet below :-
> 
> Unfortunately I still get the error below :-
> 
> "ERROR - NamingException - Config error with JNDI
> and
> datasource.javax.naming.NamingException: Cannot
> create resource instance
> ERROR com.webconnex.cognos.PORT.OMTLreport  : Cannot
> create resource
> instance"
> 
> I have attached my web.xml and
> TOMCAT_HOME/conf/Catalina/localhost/webappname.xml
> files for your perusal.
> 
> 
> I am of yet no further forward in solving my
> problem.
> 
> Any further insight would be appreciated, as Tomcat
> 5 allows me to do quite
> a few things better, not least of which is
> debugging!!
> 
> 
> Java Code snippet :-
> 
>
=====================================================
> 
>                 logger.debug("Before
> InitialContext.") ;
>                 InitialContext ctx = new
> InitialContext();
>                 if (ctx == null) { 
>                     log("ERROR initialising
> InitialContext.") ;  
>                     logger.error("ERROR initialising
> InitialContext.") ;
>                     }
>                 log("Before Context.") ;
>                 ds = (DataSource)
> ctx.lookup("java:comp/env/jdbc/UKportalPool");
> 
>                     log("Before initialising
> DataSource.") ;
>                     
>                     if(ds != null) {
>                         con = ds.getConnection();
>                         if (con != null) {
>                         	
>                         	if ((pType != null) &&
> (!pType.equals("")))
> {
>                         		userDetails = new
> pfUsersBean(pType,
> posName, typeCD, firstLineProduct);
>                         		userSessionDetails = new
> pfUserSessionBean();
>                         		userDetails.getPrefix(con,
> userDetails);  // See if User is in database
>                         	
> //userDetails.getPrefix(pCon,
> userDetails);  // See if User is in database
>                         		
>  
> ptpResponse.setSettingValue(SettingType.Portlet,
> "SalesCubePrefix",
> userDetails.getSalesCubePrefix() ) ;
>  
> ptpResponse.setSettingValue(SettingType.Portlet,
> "description",
> userDetails.getGeographyID() ) ;
>  
> ptpResponse.setSettingValue(SettingType.Portlet,
> "TMTLdescription",
> userDetails.getGeographyID() ) ;
>  
> ptpResponse.setSettingValue(SettingType.Portlet,
> "MSOdescription",
> userDetails.getGeographyID() ) ;
>                         	}
> 
>                         }
>                         else {
>                             log("ERROR - DB
> Connection returned was null in
> PortletHelper!") ;
>                             logger.error("ERROR - DB
> Connection returned was
> null in PortletHelper!") ;
>                         }
>                     }
>                     else {
>                         log("ERROR - Datasource
> returned was null in
> PortletHelper!") ;
>                         logger.error("ERROR -
> Datasource returned was null
> in PortletHelper!") ;
>                     }
>             }
>             
>             catch (NamingException ex){
>                 log("ERROR - NamingException -
> Config error with JNDI and
> datasource." +ex);
>                 log(ex.getMessage());
>                 logger.error("ERROR -
> NamingException - Config error with
> JNDI and datasource." +ex);
>                 logger.error(ex.getMessage());
>             } 
>             catch (NullPointerException npE) {
>             	  log(npE.getMessage());
>             	  logger.error("ERROR - Null pointer
> exception.");
>             	  logger.error(npE.getMessage());
>             	}
>             catch (SQLException ex ){
>                 log("Cannot get JNDI connection from
> datasource." +ex);
>                 logger.error("Cannot get JNDI
> connection from datasource."
> +ex);
>                 logger.error(ex.getMessage());
>             }
>             catch(IOException IOe) {
>              logger.error("ERROR - IOException
> occurred: "+IOe) ;
>              logger.error(IOe.getMessage()) ;
>              }
>             catch(Exception e) {
>                 log("ERROR - Exception occurred:
> "+e) ;
>                 logger.error("ERROR - Exception
> occurred: "+e) ;
>                 logger.error(e.getMessage()) ;      
>          
>             }
> ==================================================
> 
> -----Original Message-----
> From: Allistair Crossley
> [mailto:Allistair.Crossley@QAS.com]
> Sent: 11 August 2005 12:10
> To: Tomcat Users List
> Subject: RE: Has anyone used Tomcat 5.5.9 connecting
> to MS SQL Server
> using JNDI?
> 
> 
> Hi,
> 
> A) First, can you clarify which method you have
> opted for now of;
> 
> 1.
> 
> TOMCAT_HOME/webapps/webappname/META-INF/context.xml
> 
> or
> 
> 2.
> 
> TOMCAT_HOME/conf/Catalina/localhost/webappname.xml
> 
> B) Ensure your database JAR(s) are in
> TOMCAT_HOME/common/lib (not in your
> webapp lib).
> 
> C) Try something simpler ...
> 
> DataSource dataSource = null;
> try {
>   Context ctx = new InitialContext();
>   dataSource = (DataSource)
> ctx.lookup("java:comp/env/jdbc/UKportalPool");
> } catch (NamingException nE) {
>   log.error(nE.getMessage());
> } catch (NullPointerException npE) {
>   log.error(npE.getMessage());
> }
> 
> Allistair.
> 
> > -----Original Message-----
> > From: Wylie, Ian [mailto:Ian.Wylie@Pfizer.com]
> > Sent: 11 August 2005 12:02
> > To: Tomcat Users List
> > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS SQL Server
> > using JNDI?
> > 
> > 
> > Alistair,
> > 
> > Well I have learned something that I was doing
> wrong, but 
> > after removing the
> > webappname.xml I get the same error.
> > 
> > Any more ideas?
> > 
> > Thanks,
> > 
> > Ian
> > 
> > -----Original Message-----
> > From: Allistair Crossley
> [mailto:Allistair.Crossley@QAS.com]
> > Sent: 11 August 2005 11:53
> > To: Tomcat Users List
> > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS SQL Server
> > using JNDI?
> > 
> > 
> > Hi,
> > 
> > You can only configure a web application in 1
> place. You 
> > can't use *both*
> > context.xml AND a webappname.xml. I think the
> > TOMCAT_HOME\conf\Catalina\localhost method is
> tried first, 
> > and because this
> > does not have any of your datasources in it you
> get your 
> > problems. Decide on
> > either
> TOMCAT_HOME\conf\Catalina\localhost\webappname.xml
> or
> > META-INF/context.xml and see if you get any
> further first.
> > 
> > Cheers, Allistair
> > 
> > > -----Original Message-----
> > > From: Wylie, Ian [mailto:Ian.Wylie@Pfizer.com]
> > > Sent: 11 August 2005 11:47
> > > To: Tomcat Users List
> > > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS 
> > SQL Server
> > > using JNDI?
> > > 
> > > 
> > > Alistair,
> > > 
> > > For configuration purposes I attach the
> Context.xml, web.xml and
> > > "mininPCO-practise.xml" - which is the web
> application file 
> > > which resides in
> > > "TOMCAT_HOME\conf\Catalina\localhost" directory.
> > > 
> > > 
> > > The error message is basically "Cannot create
> resource 
> > > instance".  (Full
> > > Error message attached below.)
> > > 
> > > 
> > > The Java code above works in 4.1.31, so I am not
> really 
> > > worried about this,
> > > unless Tomcat 5.5.9 works differently.
> > > 
> > > 
> > > 
> > > Here is the code snippet from the java class
> PortletHelper 
> > > that is being
> > > executed which produces the error at the end of
> this email.
> > > 
> > > Well I think that is all that anyone needs to
> check out my app.
> > > 
> > > If anyone can offer some good advice on this, it
> would be 
> > > much appreciated.
> > > 
> > > Best Regards,
> > > 
> > > Ian
> > > 
> > > 
> > >
>
==============================================================
> > > =============
> > > JAVA CODE SNIPPET START
> > > 
> > >                 logger.debug("Before
> InitialContext.") ;
> > >                 InitialContext ctx = new
> InitialContext();
> > >                 if (ctx == null) { 
> > >                     log("ERROR initialising
> InitialContext.") ;  
> > >                     logger.error("ERROR
> initialising 
> > > InitialContext.") ;
> > >                     }
> > >                 log("Before Context.") ;
> > >                 Context envCtx = (Context) 
> > > ctx.lookup("java:comp/env");
> > > 
> > >                 if (envCtx != null) {
> > >                     log("Before initialising
> DataSource.") ;
> > >                     ConnectionPoolDataSource ds
> = 
> > >  
> > >
>
(ConnectionPoolDataSource)envCtx.lookup("jdbc/UKportalPool");
> > >                     
> > >                     if(ds != null) {
> > > 
> > >                         pCon =
> ds.getPooledConnection(); 
> > > 
> > > JAVA CODE SNIPPET END
> > >
>
====================================================================
> > > 
> > > 
> > >
>
==============================================================
> > > 
> > > ERROR MESSAGE START
> > > 
> > > 10-Aug-2005 15:26:56
> org.apache.catalina.core.ApplicationContext log
> > > INFO: OMTLreport: Before Context.
> > > 10-Aug-2005 15:26:56
> org.apache.catalina.core.ApplicationContext log
> > > INFO: OMTLreport: Before initialising
> DataSource.
> > > 10-Aug-2005 15:26:56
> org.apache.catalina.core.ApplicationContext log
> > > INFO: OMTLreport: ERROR - NamingException -
> Config error 
> > with JNDI and
> > > datasource.javax.naming.NamingException: Cannot
> create 
> > > resource instance
> > > 10-Aug-2005 15:26:56 
> > > org.apache.catalina.core.StandardWrapperValve
> invoke
> > > SEVERE: Servlet.service() for servlet OMTLreport
> threw exception
> > > java.lang.NullPointerException
> > > 	at
> > > 
> >
>
com.webconnex.portal.PortletHelper.initPortlet(PortletHelper.java:230)
> > > 	at
> > >
>
com.webconnex.cognos.PORT.OMTLreport.processRequest(OMTLreport
> > > .java:243)
> > > 	at 
> > >
>
com.webconnex.portal.PortletHelper.doGet(PortletHelper.java:321)
> > > 	at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> > > 	at
>
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > 	at
> > >
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilt
> > > er(Application
> > > FilterChain.java:252)
> > > 	at
> > >
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> > > cationFilterCh
> > > ain.java:173)
> > > 	at
> > >
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> > > rapperValve.ja
> > > va:213)
> > > 	at
> > >
>
org.apache.catalina.core.StandardContextValve.invoke(StandardC
> > > ontextValve.ja
> > > va:178)
> > > 	at
> > >
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> > > Valve.java:126
> > > )
> > > 	at
> > >
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> > > Valve.java:105
> > > )
> > > 	at
> > >
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> > > gineValve.java
> > > :107)
> > > 	at
> > >
>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap
> > > ter.java:148)
> > > 	at
> > >
>
org.apache.coyote.http11.Http11Processor.process(Http11Process
> > > or.java:856)
> > > 	at
> > >
>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandle
> > > r.processConne
> > > ction(Http11Protocol.java:744)
> > > 	at
> > >
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT
> > > cpEndpoint.jav
> > > a:527)
> > > 	at
> > >
>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(Le
> > > aderFollowerWo
> > > rkerThread.java:80)
> > > 	at
> > >
>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> > > ThreadPool.jav
> > > a:684)
> > > 	at java.lang.Thread.run(Unknown Source)
> > > 10-Aug-2005 15:30:09
> org.apache.catalina.core.ApplicationContext log
> > > 
> > > ERROR MESSAGE END
> > > 
> > >
>
=============================================================
> > > 
> > > -----Original Message-----
> > > From: Allistair Crossley
> [mailto:Allistair.Crossley@QAS.com]
> > > Sent: 11 August 2005 10:38
> > > To: Tomcat Users List
> > > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS 
> > SQL Server
> > > using JNDI?
> > > 
> > > 
> > > Hi,
> > > 
> > > Can you please send more information, such as
> error messages, 
> > > stdout logging
> > > and the configuration for your pool.
> > > 
> > > Cheers, Allistair.
> > > 
> > > > -----Original Message-----
> > > > From: Wylie, Ian [mailto:Ian.Wylie@Pfizer.com]
> > > > Sent: 11 August 2005 10:28
> > > > To: Tomcat Users List
> > > > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS 
> > > SQL Server
> > > > using JNDI?
> > > > 
> > > > 
> > > > David,
> > > > 
> > > > Thanks for the link.   I have followed the
> instructions but 
> > > > unfortunately
> > > > get similar errors to what I had previously I
> am afraid.
> > > > 
> > > > In a situation like this I am sure I could get
> the company to 
> > > > pay for some
> > > > support for this type of problem, but I am
> unsure who would 
> > > > be best to help
> > > > with this.
> > > > 
> > > > Without further help, I will have to sideline
> the upgrade to 
> > > > 5.5, until
> > > > there is more info out there for the
> connecting using JNDI 
> > > > with a MS SQL
> > > > Server example.  
> > > > 
> > > > In my opinion the people who develop Tomcat
> should provide an 
> > > > example of
> > > > JNDI for ALL major databases.  This is one of
> the things that 
> > > > makes the
> > > > Tomcat offering lacking somewhat in maturity. 
> It seems 
> > to me it is
> > > > relatively easy to get the basic JSP / Servlet
> stuff up and 
> > > > running in no
> > > > time, but it has always been a hassle to get
> JNDI to work in 
> > > > Tomcat.  The
> > > > Tomcat folks provide MySQL and an Oracle
> example but they 
> > > > need to provide
> > > > examples for MS SQL Server, DB2 and Sybase.
> > > > 
> > > > Thanks for your help though - as it may have
> worked...  :-)
> > > > 
> > > > Best Regards,
> > > > 
> > > > Ian
> > > > 
> > > > Ian Wylie
> > > > Business Intelligence Architect
> > > > Business Information & Technology (BIT)
> > > > Pfizer Global Pharmaceuticals (PGP)
> > > > 
> > > > 
> > > > -----Original Message-----
> > > > From: David Thielen
> [mailto:david@windward.net]
> > > > Sent: 10 August 2005 14:56
> > > > To: Tomcat Users List
> > > > Subject: RE: Has anyone used Tomcat 5.5.9
> connecting to MS 
> > > SQL Server
> > > > using JNDI?
> > > > 
> > > > 
> > > > 
> >
>
http://thielen.typepad.com/programming/2005/07/hibernate_on_to.html
> > > > 
> > > > 
> > > > David Thielen
> > > > 303-499-2544
> > > > www.windwardreports.com
> > > > 
> > > > 
> > > > -----Original Message-----
> > > > From: Wylie, Ian [mailto:Ian.Wylie@Pfizer.com]
> 
> > > > Sent: Wednesday, August 10, 2005 4:37 AM
> > > > To: tomcat-user@jakarta.apache.org
> > > > Subject: Has anyone used Tomcat 5.5.9
> connecting to MS SQL 
> > > > Server using
> > > > JNDI?
> > > > 
> > > > Hi All,
> > > >  
> > > > I have just installed Tomcat 5.5.9 on our Dev
> Server.  I 
> > > > managed with a bit
> > > > of work and a few searches on the web to get
> Tomcat 4.1.x 
> > > > working with MS
> > > > SQL Server using JNDI and database pooled
> connections to 
> > > > work.  This has
> > > > been working well for some time now.  However,
> there is 
> > quite a few
> > > > advantages for upgrading the current system to
> Tomcat 5.5, 
> > > > not least of
> > > > which, is improvements to the list and
> functionality of tools 
> > > > that aid with
> > > > Java debugging!
> > > >  
> > > > I cannot get Tomcat 5.5.9 working with JNDI
> and MS SQL Server 
> > > > at the moment.
> > > >  
> > > > I have already read all the various official
> docs on JNDI 
> > how-to and
> > > > searched the web but even after all that and
> changing various 
> > > > things that
> > > > others have recommended, I cannot get the JNDI
> to work.
> > > >  
> > > > Has anyone out there successfully using JNDI
> with Tomcat and 
> > > > MS SQL Server?
> > > >  
> > > > If so please can you put another professional
> out of there misery!
> > > >  
> > > > Many thanks,
> > > > 
> > > > Best Regards,
> > > > 
> > > >   _____  
> > > > 
> > > >  <http://www.pfizer.co.uk/>    Ian Wylie -
> ian.wylie@pfizer.com
> > > > <mailto:ian.wylie@pfizer.com> 
> > > >   Business Intelligence Architect
> > > >   Business Information & Technology (BIT)
> > > >   Pfizer Global Pharmaceuticals (PGP)
> > > >   Direct: +44 (0)1737 330422
> > > >   Address: Pfizer Ltd, Walton Oaks (IPC 2G),
> Dorking Road, 
> > > > Tadworth, Surrey,
> > > > KT20 7NS.
> > > > 
> > > > LEGAL NOTICE 
> > > > Unless expressly stated otherwise, this
> message is 
> > > > confidential and may be
> > > > privileged. It is intended for the
> addressee(s) only. Access 
> > > > to this e-mail
> > > > by anyone else is unauthorised. If you are not
> an addressee, 
> > > > any disclosure
> > > > or copying of the contents of this e-mail or
> any action taken 
> > > > (or not taken)
> > > > in reliance on it is unauthorised and may be
> unlawful. If you 
> > > > are not an
> > > > addressee, please inform the sender
> immediately. 
> > > > 
> > > > Pfizer Limited is registered in England under
> No. 526209 with 
> > > > its registered
> > > > office at Ramsgate Road, Sandwich, Kent CT13
> 9NJ
> > > > 
> > > >   _____  
> > > > 
> > > >  
> > > > 
> > > > 
> > > > 
> > > 
> >
>
---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail: 
> > tomcat-user-help@jakarta.apache.org
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > 
> >
>
---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail: 
> > tomcat-user-help@jakarta.apache.org
> > > > 
> > > > 
> > > 
> > > 
> > > <FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> 
> > >
>
-------------------------------------------------------
> > > QAS Ltd.
> > > Registered in England: No 2582055
> > > Registered in Australia: No 082 851 474
> > >
>
-------------------------------------------------------
> > > </FONT>
> > > 
> > > 
> > > 
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> > > 
> > > 
> > > 
> > > 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> > 
> > 
> > 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> > 
> > 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> tomcat-user-help@jakarta.apache.org
> 
> 
> 
> > <web-app xmlns="http://java.sun.com/xml/ns/j2ee"
>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
> version="2.4">
> 
> 	<display-name>Pfizer Online Reporting
> Tools</display-name>
> 	<description>
>       This is version 2.0 of Pfizer Online Reporting
> Tools for Plumtree portal version 4.5 and 5.x.
>       It was written by Igor Polyakov
> (igor.polyakov@webconnex.com) of
>       Quorum Webconnex, who should be contacted for
> more information.
>    </description>
> 
> <resource-ref>
>    <description>Connection to my DB.</description>
>    <res-ref-name>jdbc/UKportalPool</res-ref-name>
>    <res-type>javax.sql.DataSource</res-type>
>    <res-auth>Container</res-auth>
> </resource-ref>
> 
> 	<servlet>
> 		<servlet-name>OMTLreport</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.OMTLreport</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>OMTLprefs</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.OMTLprefs</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>TMTLreport</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.TMTLreport</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>TMTLprefs</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.TMTLprefs</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>MSOreport</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.MSOreport</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>MSOprefs</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.MSOprefs</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>MSDreport</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.MSDreport</servlet-class>
> 	</servlet>
> 	<servlet>
> 		<servlet-name>MSDprefs</servlet-name>
> 	
>
<servlet-class>com.webconnex.cognos.PORT.MSDprefs</servlet-class>
> 	</servlet>
> 	<servlet-mapping>
> 		<servlet-name>OMTLreport</servlet-name>
> 		<url-pattern>/OMTLreport</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>OMTLprefs</servlet-name>
> 		<url-pattern>/OMTLprefs</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>TMTLreport</servlet-name>
> 		<url-pattern>/TMTLreport</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>TMTLprefs</servlet-name>
> 		<url-pattern>/TMTLprefs</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>MSOreport</servlet-name>
> 		<url-pattern>/MSOreport</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>MSOprefs</servlet-name>
> 		<url-pattern>/MSOprefs</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>MSDreport</servlet-name>
> 		<url-pattern>/MSDreport</url-pattern>
> 	</servlet-mapping>
> 	<servlet-mapping>
> 		<servlet-name>MSDprefs</servlet-name>
> 		<url-pattern>/MSDprefs</url-pattern>
> 	</servlet-mapping>
> 	<session-config>
> 		<session-timeout>30</session-timeout>
> 	</session-config>
> 	<welcome-file-list>
> 		<welcome-file>index.jsp</welcome-file>
> 		<welcome-file>index.html</welcome-file>
> 		<welcome-file>index.htm</welcome-file>
> 	</welcome-file-list>
> </web-app>
> > <Context path="/miniPCO-practise"
> docBase="F:/Webconnex-Igor/MINIPCO-PRACTISE/web"
> debug="0" priveleged="false" reloadable="true">
>   <Resource name="jdbc/UKportalPool"
> auth="Container" type="javax.sql.DataSource"
>    username="pfuser" password="pfizer"
>
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>   
>
url="jdbc:microsoft:sqlserver://168.224.236.241:1433;DatabaseName=PfizerUsers;SelectMethod=cursor"
>    maxActive="8" maxIdle="4" maxWait="10000"
> removeAbandoned="true"
> removeAbandonedTimeout="180"/>
> </Context>
> 
> 
> >
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
tomcat-user-help@jakarta.apache.org

See JPDA in the JDK java docs.  Figure out how to
setup a TCP/IP debugger and play with the options.  I
debug in Tomcat5 all the time.  Don't try to use
shared memory, seems to never work with Tomcat, but
the TCP/IP stuff always seems to work fine for me.

Wade

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


Mime
View raw message