tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allistair Crossley" <Allistair.Cross...@QAS.com>
Subject RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server usin g JNDI?
Date Tue, 23 Aug 2005 15:04:53 GMT
Hi Wade,

Can you perhaps resend the configuration files

server.xml
web.xml
yourapp.xml
listing of files in common/lib
listing of files in yourapp/WEB-INF/lib

Again?

Cheers, Allistair.

> -----Original Message-----
> From: Wade Chandler [mailto:hwadechandler-apache@yahoo.com]
> Sent: 22 August 2005 17:58
> To: Tomcat Users List
> Subject: RE: Has anyone used Tomcat 5.5.9 connecting to MS SQL Server
> usin g JNDI?
> 
> 
> --- "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;DatabaseN
> ame=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
> 
> 

---------------------------------------------------------------------
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