Re: Informix connection pooling via JNDI resource
Current connection pool (Tyrex) provides just straight connections. Try DBCP. It's not released yet but works. You need three subprojects: collections, pool, and dbcp. All are under commons. Take nightly builds (collections is released) and put all three jars into $CATALINA_HOME/common/lib. In Jndi resource for your pool add: parameternamefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter The next question is where are going to create pool. To share connections you need something with application scope. I use bean with scope=application. As soon you destroy your datasource you lose your connection pool. [EMAIL PROTECTED] wrote: Hi, Does anybody have experience with jakarta-tomcat-4.0.2 and connection pooling setup as a jndi resource (server.xml) for Informix DB (vIDS2000) I use the informix jdbc driver (ifxjdbc.jar). In fact everything works, I get no errors, except that the application keeps opening and closing the database connectinos which is not the meaning of connection pooling. I didn't experience this behaviour with the same config and application for eg Oracle, My Sql ... so I think it isn't the configuration. did anyone manage to setup a working connection pooling for informix via jndi resource, or experienced the same problems? greetings, Erwin Ravau - This mail sent through Tiscali Webmail (http://webmail.tiscali.be) -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: NEWBIE: Passing object from Servlet to JSP with session?
Bean should have one constractor without papameters. Besides if you setup new directory (the place where you made it is for new application) you should I think put into server.xml the same staff as for examples: !-- Tomcat Examples Context -- Context path=/examples docBase=examples debug=0 reloadable=true crossContext=true /Context Ernst Bekker wrote: Hi, I am running TomCat 4, and am attempting to forward an object to a JSP from a servlet. I have set up a new directory under .../webapps and the class files for both the servlet and the class of which I am trying to send an instance of are in .../ webapps/newdir/WEB-INF/classes. The JSP file is in .../webapps/newdir. It seems that the servlet forwards the request but the JSP coughs up the following exception: The Exception: org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred between lines: 11 and 13 in the jsp file: /SessionAtempt.jsp Generated servlet error: C:\jakarta-tomcat-4.0.2\work\localhost\rd\SessionAtempt$jsp.java:60: Class org.apache.jsp.MyClass not found. MyClass sessionvars = null; ^ ... Code snippets: Servlet: Constructing the object: MyClass sessionvars = new MyClass (parm1, parm2, parm3, parmn); HttpSession ses = req.getSession(true); ses.setAttribute(Sessionvars, sessionvars); Servlet Sending the class: public void GoToPage(String addy, HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { RequestDispatcher disp = getServletContext().getRequestDispatcher(addy); disp.forward(req, res); } JSP: jsp:useBean id=sessionvars class= MyClass scope=session / Any direction would be greatly appreciated TIA Ernst Bekker [EMAIL PROTECTED] Coding Clerk +27 +11 489 4147 IS Services Confidentiality Caution and Disclaimer This message and/or any attachment thereto (the message) contains privileged and confidential information intended only for the recipient named above. If you are not the intended recipient of this message, please erase it permanently once you have notified the sender, per return e-mail, that you have received the message in error. Unless the sender is duly authorised by either the Telesure Group, or any of its subsidiary companies or I.S Services (the Group) to send this message and unless the content of this message is also duly authorised by the Group, any views expressed in this message are those of the individual sender and the Group will not accept liability therefore, nor for any consequential damage arising therefrom. Any recipient of an unacceptable communication, a chain letter or offensive material of any nature is requested to report it to [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Deployment from directories not under webapps
You are right! app-dir/WEB-INF/lib is the right place, but for some reason some classes can't find anything in the jar. THat's why I put my application jar into $CATALINA_HOME/lib. Yuval Levav wrote: Thanks. I put the jars in WEB-INF\lib. In them are my servlets and classes they use. In the log I see that the WebClassLoader deploys all the jars to the correct place, but the ContextConfig can't find them. In web.xml I declared the servlets and their class (com.xxx.xxx.xxx) which can be found in the jar. I have to work this way due to historic reasons Do you know what is wrong and what can be done ? Yuval -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 4:42 PM To: Tomcat Users List Subject: RE: Deployment from directories not under webapps Yuval Levav [EMAIL PROTECTED] on 03/19/2002 01:09:22 AM Please respond to Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] cc: Subject: RE: Deployment from directories not under webapps Thanks. My apps make use of JARs and classes that are not located under docBase\WEB-INF\lib or classes. When using tomcat 3,I added these through the classpath. Here it seems that the JARs must be under WEB-INF. Is there any way to use JARs and classes not under WEB-INF ? You could. But things could get pretty messy when the application grows and you have a heck lot of classes. Keeping track of classes and their loading could be a pain. Tomcat 4.0.x takes care of this for you. * Unpacked classes that you need visible to *only* a particular webapp go under that webapps WEB-INF/classes folder. jar files go under webapp/WEB-INF/lib folder * Unpacked classes common to all webapps should be placed under %CATALINA_HOME%/classes and common jar files under the %CATALINA_HOME%/lib directory. And if you still wish to set the classpath then see catalina.sh (catalina.bat). RS Yuval -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 7:22 PM To: Tomcat Users List Subject: Re: Deployment from directories not under webapps Yes. See docBase attribute of the Context.../ element in server.xml RS Yuval Levav [EMAIL PROTECTED] on 03/18/2002 11:10:06 AM Please respond to Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] cc: Subject: Deployment from directories not under webapps Hi, Is it possible to deploy apps from directories not under the webapps directory ? Thanks, Yuval -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: NEWBIE: Passing object from Servlet to JSP with session?
You have to put into your JSP: %@ page import = mysubdir.MyClass % before jsp:useBean... assuming that MyClass is in newdir/WEB-INF/classes/mysubdir. Ernst Bekker wrote: Bean should have one constractor without papameters. It does have that. Besides if you setup new directory (the place where you made it is for new application) The Context is set up. What am I still missing? Ernst Bekker wrote: Hi, I am running TomCat 4, and am attempting to forward an object to a JSP from a servlet. I have set up a new directory under .../webapps and the class files for both the servlet and the class of which I am trying to send an instance of are in .../ webapps/newdir/WEB-INF/classes. The JSP file is in .../webapps/newdir. It seems that the servlet forwards the request but the JSP coughs up the following exception: The Exception: org.apache.jasper.JasperException: Unable to compile class for JSP An error occurred between lines: 11 and 13 in the jsp file: /SessionAtempt.jsp -- Confidentiality Caution and Disclaimer This message and/or any attachment thereto (the message) contains privileged and confidential information intended only for the recipient named above. If you are not the intended recipient of this message, please erase it permanently once you have notified the sender, per return e-mail, that you have received the message in error. Unless the sender is duly authorised by either the Telesure Group, or any of its subsidiary companies or I.S Services (the Group) to send this message and unless the content of this message is also duly authorised by the Group, any views expressed in this message are those of the individual sender and the Group will not accept liability therefore, nor for any consequential damage arising therefrom. Any recipient of an unacceptable communication, a chain letter or offensive material of any nature is requested to report it to [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: DataSources in Tomcat 4 / Windows XP
Is Oracle driver (classes111.zip) visible to Tomcat. I had to modify (in Linux) catalina.sh script to add driver's path to the internal CLASSPATH used by catalina. Martin Miranda wrote: Hello Im having problems creating a DataSource in a StandAlone Tomcat 4.0.1 with Windows XP. The InitialContext find the DataSource but it cames null This is the Code: % InitialContext ctxinit = new InitialContext(); % %= ctxinit.lookup(java:/comp/env/jdbc/testDB) % NULL You get EnabledDataSource instance above so you have to cast. May it's be better like this: % DataSource ds = (DataSource) ctxinit.lookup(java:/comp/env/jdbc/testDB) % %= ds % Also all examples doing this way: Context ctx = new InitialContext(); Context envCtx = (Context)ctx.lookup(java:comp/env); ds = (DataSource)envCtx.lookup(jdbc/testDB); Try that just in case. So your case must work!! Though I don't advise you to use EnabledDataSource (Tyrex stuff) for production - it doesn't provide connection pool. Use commons/dbcp. I tested it - it works fine (besides Tomcat 4.0.4-b1 - nothing work there). In the web application deployment descriptor (web.xml) i have this code: resource-ref descriptionResource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file./description res-ref-namejdbc/testDB/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref In the server.xml file: Context path=/test docBase=test/ debug=1 privileged=true reloadable=true useNaming=true Resource name=jdbc/testDB auth=Container type=javax.sql.DataSource description=Default Database for Applications / ResourceParams name=jdbc/testDB parameter namedriverClassName/name valueoracle.jdbc.driver.OracleDriver/value /parameter parameter namedriverName/name valuejdbc:oracle:thin:@dir/value /parameter parameter nameuser/name valueusuario1/value /parameter parameter namepassword/name valuepassword1/value /parameter /ResourceParams /Context When i use debug level 1 in the context the logs seems normal: XmlMapper: org.apache.catalina.core.StandardContext.setSessionTimeout( 30) XmlMapper: org.apache.catalina.core.StandardContext.addMimeMapping( html, text/html) XmlMapper: org.apache.catalina.core.StandardContext.addMimeMapping( txt, text/plain) XmlMapper: org.apache.catalina.core.StandardContext.addWelcomeFile( index.jsp) XmlMapper: org.apache.catalina.core.StandardContext.addWelcomeFile( index.html) XmlMapper: new null org.apache.catalina.deploy.ContextResource resource-ref ContextResource[name=null, scope=Shareable] XmlMapper: org.apache.catalina.deploy.ContextResource.setDescription( Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file.) XmlMapper: org.apache.catalina.deploy.ContextResource.setName( jdbc/testDB) XmlMapper: org.apache.catalina.deploy.ContextResource.setType( javax.sql.DataSource) XmlMapper: org.apache.catalina.deploy.ContextResource.setAuth( Container) XmlMapper: Calling org.apache.catalina.core.StandardContext.addResource ContextResource[name=jdbc/testDB, description=Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file., type=javax.sql.DataSource, auth=Container, scope=Shareable] XmlMapper: pop resource-ref org.apache.catalina.deploy.ContextResource: ContextResource[name=jdbc/testDB, description=Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file., type=javax.sql.DataSource, auth=Container, scope=Shareable] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: question about tomcat configuration
Just keep in mind, the performance of pair Apache-Tomcat few times less then of standalone Tomcat. You can verify this using 'ab'. Christopher Bare wrote: --- Cheng Yan [EMAIL PROTECTED] wrote: Hi, all, I just installed tomcat 4.0 binary on my Solaris 8 box at home. This Solaris machine is connected to my w2k pc through a linksys router, which is connected to a cable modem. I'm a beginner, but we have very similar setups, so maybe we can help each other. I have Solaris8 on a DSL router. I'm trying to use Tomcat4, apache1.3, with mod_webapp. Have you tried to set up a connector with apache? There are two that I know of, mod_jk and mod_webapp. I am using mod_webapp, but am having probablems, so I'm thinking of switching. Have you tried integrating Tomcat with Apache yet, or are you just using tomcat by itself? I have Tomcat working by itself and mostly working with Apache via mod_webapp. -Chris __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Pls Help!! Uploading an image
Try UploadBean from http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html It's very easy for use in JSP. An exapmple is also there. Uma Maheswar wrote: Hi, I tried using O'Reilly, but it is confusing. I need a simple one than that one. Can you help me? Uma - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 2:34 AM Subject: Re: Pls Help!! Uploading an image Uma, The O'Reilly servlets book has a good example (including code) where you can upload files (including images as part of a form). See http://www.servlets.com/cos/javadoc/com/oreilly/servlet/m ultipart/MultipartP arser.html for more info. Hope this helps. Satyakant Evani - Original Message - From: Uma Maheswar [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 04, 2002 10:49 AM Subject: Pls Help!! Uploading an image HI, I need help from any of you. I need a programme to upload an image to the database while submitting a form. If any one is having the source code pls help me. Regards Uma nope i am using tomcat from my user area .. both tomcat and apache run from my user area there is some problem with a particular .so file which it is not able to find -Original Message- From: brian ally [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 11:04 PM To: Tomcat Users List Subject: Re: java.lang.UnsatisfiedLinkError: no ocijdbc8 in shared library path Are you starting tomcat as root? On my linux box, if i su to root, all manner of LD_LIBRARY_PATH problems begin. i need to su - (with the dash). Could this be your problem? /b Abhishek Pamecha wrote: it is there.. -Original Message- From: Toru Watanabe [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 2:34 PM To: Tomcat Users List Subject: Re: java.lang.UnsatisfiedLinkError: no ocijdbc8 in shared library path First, please make sure that Oracle client is installed in your machine. Abhishek Thanks buddy! Abhishek but ..i already did that Abhishek but i have a a requirement which says i have to use oci client only Abhishek any other solution ??? UnsatisfiedLinkError means JVM can't find shared library. You need to add shared library path to environment variable. If you use solaris or linux, then you should add following statement in your tomcat.sh. LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH if you use HP-UX, then SHLIB_PATH=$ORACLE_HOME/lib:$SHLIB_PATH export SHLIB_PATH if you use Windows, then you should add following to tomcat.bat. set PATH=%ORACLE_HOME%\lib;%PATH% then it will be able to find shared library. regards, Watanabe. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: JSP documentation
http://java.sun.com/products/jsp/tags/11/tags11.html explains syntax of all JSP tags (like %=). Ming wrote: Hi, I'm very new at Tomcat and JSP programming but have written some JSP scripts. Can someone tell me what's the best way to write in-program documentation? I mean the documentation that can be embedded in the program. I'm planning to write a separate documentation but heard that there might be a way that I can embed the documentation in the program and can be viewed separately. Any information will be really helpful. Thanks. Ming -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Setting up jdbc connections
Here is how I install mysql JDBC. 1. In server.xml (no need realm): Resource name=lev/DataSource auth=Container type=javax.sql.DataSource/ ResourceParams name=lev/DataSource parameternameuser/namevalue.../value/parameter !-- your login -- parameternamepassword/namevalue.../value/parameter!-- your passwd -- parameternamedriverClassName/name valueorg.gjt.mm.mysql.Driver/value/parameter parameternamedriverName/name valuejdbc:mysql://localhost:3306/WV/value/parameter /ResourceParams 2. In $CATALINA_HOME/webapps/examples/WEB-INF/web.xml: resource-ref res-ref-namelev/DataSource/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref 3. In yout JSP or Bean: Context ctx = new InitialContext(); Context envCtx = (Context)ctx.lookup(java:comp/env); DataSource _ds = (DataSource)envCtx.lookup(lev/DataSource); Connection con _ds.getConnection(); ... Statement st = con.createStatement(...); ResultSet rs = st.executeQuery(select * from bla_bla); JNDI will create instance of your DataSource (with automatic connection). But you have to have tyrex*.jar in one of common dirs. If not I advise you to switch to Tomcat 4.0.x. Also you must put your (Postgres) JDBC jar into $CATALINA_HOME/lib Good luck. Andrew Falanga wrote: Hello everyone, Setting up Tomcat is NO easy project. I've been struggling for about a week and a half to get tomcat to read a special servlet/application/I really don't know what to call it. (Unfortunately, that's my biggest problem, I'm very unfamiliar with things I'm playing around with right now.) Ok, in simplest terms possible here's the deal. I'm trying to get a working model of something my company calls a portal. Basically, it's nothing more than a product that will allow a person to use *.jsp rendered web pages to access/control/manipulate data contained withing Oracle databases. This is the long term. Right now, I need to get the application working to allow someone to log in. The database which controls user access is NOT part of Oracle. It is a PostgreSQL database. How, exactly, do I setup the JDBC stuff to interact with PostgreSQL? I've been reading through the users guide, the paper on server.xml and the FAQ. The information is comprehensive, I do think lacking in some parts, but none-the-less comprehensive. (I do not mean to start flame wars or anything else. However, for example, I downloaded and installed tomcat 3.3a via rpm for Red Hat Linux, the rpm was made by tomcat developers not red hat. After installing, I'm reading through the users guide and there are several directories meantioned that DO NOT exist. Such as, %TOMCAT_HOME/bin and many others. This is what I mean by lacking.) How exactly am I going to go about setting up the database connectivity? From what I've read, I've got to configure some kind of a JDBC Realm in the server.xml, but how exactly. I did try, following the syntax example given in one of the user guide documents, but after restarting tomcat, tomcat was broken. Absolutely, nothing was being served up. I did make syntax substitutions to allow for my database vs. the database given in the example, and yes I'm absolutely open to the fact that my syntax was wrong. Basically, what needs to be done? I'm really nearing the end of my rope on this one. Andy -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Who uses connection pool?
Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
I already looked in there. I was confused that their pool is for GSP. Tomcat uses Tyrex by default. How about that? Reynir H?bner wrote: sure check out bitmechanic.com, that´s a fine place to start. -hope it helps [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 09:09 To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7а E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
I am not sure Tyrex's connection pool really works. Do you use JNDI when you work with bitmechanics staff? If yes could you please show me that? Reynir Hubner wrote: yeah you can use that one, it is good, and you have docs on it in the jakarta website. Bitmechanics pool is not only for GSP. I've never used GSP, but I have used the JDBC-pool alot. it's good for most drivers, I've only had problems using it with DB2 drivers. hope it helps, [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 09:37 To: Tomcat Users List Subject: Re: Who uses connection pool? I already looked in there. I was confused that their pool is for GSP. Tomcat uses Tyrex by default. How about that? Reynir H?bner wrote: sure check out bitmechanic.com, thatÂs a fine place to start. -hope it helps [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 09:09 To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Ð E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: don't found packages...
You should provide JAVA_HOME environment variable pointed to your Java SDK. cyril vidal wrote: Hello! I'm a new french user of Apache Tomcat/4.0.3. The installation was successfull! But not the compilation of my first HelloWorld servlet. The compilator does not found the right classes like javax.servlet, javax.servlet.http and so although I'well configurated my classpath like SET CLASSPATH=c:\tomcat\common\lib. What do you think it's wrong? By the way, I'm under Windows Milllenium. Thanks a lot for you answers Cyril. -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Andrew, I found the following in Tyrex mailing archive: - cut here - Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0 Date: Fri, 05 Oct 2001 13:07:46 -0700 From: arkin [EMAIL PROTECTED] Subject: Re: [tyrex-dev] JDBC Pool Size in Tomcat 4.0 The connection you get from getConnection() is always a new connection. This is a logical connection, and the driver is required to always give a new logical connection when getConnection() is called. Tyrex obtains a physical connection by calling a different getConnection() method on a PooledConnectionDataSource. This returns a PooledConnection, from which any number of logical connections can be obtained without opening a new network connection. The driver must support the PooledConnectionDataSource or XADataSource interfaces, and must implement them in such a way that opening a new logical connection does not open a new physical connection. We are using Oracle 8i, Sybase 12.5 and DB2 7.1 and experiencing no problems. arkin cut here -- So they say that everything depends on your database, however I found pool related staff in the tyrex source code. Also I am surprised that people in this mailing list don't response. Though I am sure (of my experience) the real work is impossible without connection pool! Andrew Rodwell wrote: Lev, I have this impression also of Tyrex. Every servlet seems to be a new pool. Is that your experiance. Each time the servlet runs a new connection. Andrew -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 10:53 To: Tomcat Users List Subject: Re: Who uses connection pool? I am not sure Tyrex's connection pool really works. Do you use JNDI when you work with bitmechanics staff? If yes could you please show me that? Reynir Hubner wrote: yeah you can use that one, it is good, and you have docs on it in the jakarta website. Bitmechanics pool is not only for GSP. I've never used GSP, but I have used the JDBC-pool alot. it's good for most drivers, I've only had problems using it with DB2 drivers. hope it helps, [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 09:37 To: Tomcat Users List Subject: Re: Who uses connection pool? I already looked in there. I was confused that their pool is for GSP. Tomcat uses Tyrex by default. How about that? Reynir H?bner wrote: sure check out bitmechanic.com, thatÂs a fine place to start. -hope it helps [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 09:09 To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Ð E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Which one? Jim Urban wrote: We do. Jim Urban Product Manager Netsteps Inc. Suite 505E 1 Pierce Pl. Itasca, IL 60143 Voice: (630) 250-3045 x2164 Fax: (630) 250-3046 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 3:09 AM To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Hello! I followed your link and found out that example in there is slightly incorrect. Identifier dataSrc is not declared. Besides Tyrex people acknowledged that if your database doesn't support pooling then all you have is tyrex EnabledDataSource class without pool support. I personally is waiting for tyrex-1.0. King-On Yeung wrote: yes, i do. follow suggestion: http://mikal.org/interests/java/tomcat/archive/view?mesg=41226 it works for JNDI + postgesql . -- __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Good! I just found out that ConnectionPoolDataSource is not properly implemented in tyrex stuff (Tyrex people acknowledged that). Did you hardcode pool instance creation or found a way when JNDI do that? Jim Urban wrote: DBConnectionBroker http://opensource.devdaily.com/ddConnectionBroker.shtml -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 7:47 AM To: Tomcat Users List Subject: Re: Who uses connection pool? Which one? Jim Urban wrote: We do. Jim Urban Product Manager Netsteps Inc. Suite 505E 1 Pierce Pl. Itasca, IL 60143 Voice: (630) 250-3045 x2164 Fax: (630) 250-3046 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 3:09 AM To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Please help me
Seems, you need to modify catalina.sh script to add all .jar under $JAVA_HOME/lib to class path, which is passed to java. To do that you need to understand shell. Startup.sh doesn't use CLASSPATH environment variable. [EMAIL PROTECTED] wrote: Hi all, I'm an italian student: for my thesis I have to install Tomcat on a sun machine with solaris 8 because I have to do some experiments. I have tried to install Tomcat 3.3a but when I type ./startup.sh for starting tomcat I get this error: Exception in thread main java.lang.NoClassDefFoundError: org/ap ache/tomcat/startup/Main I have followed all the instructions: TOMCAT_HOME is set, JAVA_HOME is set and I exported them. I can't understand the error: where is my error? Please help me. Thanks for your help Laura -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Yes, you are partially right. The last post to their mailing list of one of the Tyrex developers was around November, 20. Julio Castillo wrote: I checked the Exolab.org website for an updated Tyrex, and noticed in their Change Log that the last version released was 0.9.7 which is more than a year old. I wonder if anyone is working on the 1.0 version. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 6:59 AM To: Tomcat Users List Subject: Re: Who uses connection pool? Hello! I followed your link and found out that example in there is slightly incorrect. Identifier dataSrc is not declared. Besides Tyrex people acknowledged that if your database doesn't support pooling then all you have is tyrex EnabledDataSource class without pool support. I personally is waiting for tyrex-1.0. King-On Yeung wrote: yes, i do. follow suggestion: http://mikal.org/interests/java/tomcat/archive/view?mesg=41226 it works for JNDI + postgesql . -- __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: [ANNOUNCEMENT] Tomcat 4.0.4 Beta 1 released
If you still use Tyrex stuff for ConnectionPoolDataSource implementation I have to tell you: 1. Tyrex classes don't provide pooling. 2. Something happened in Exolab.org - no activity in developer's mailing list. 3. The last release was more then year ago, Remy Maucherat wrote: The first beta release of Tomcat 4.0.4 has been released. This release includes bugfixes and small feature additions over Tomcat 4.0.2/4.0.3 (please refer to the release notes for the complete list). Release notes: http://jakarta.apache.org/builds/jakarta-tomcat-4.0/release/v4.0.4-b1/RELEAS E-NOTES Downloads (source and binaries): http://jakarta.apache.org/builds/jakarta-tomcat-4.0/release/v4.0.4-b1/ Remy -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Could you send me your latest server.xml fragment. Connection pool should work as a simple connection. Mark Muffett wrote: Done that, but it still doesn't work (I'm also trying JNDI + postgresql). Could you point us to a sample server.xml entry for postgres? (or anything else needed) Thanks Mark Muffett - Original Message - From: King-On Yeung [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 1:50 PM Subject: RE: Who uses connection pool? yes, i do. follow suggestion: http://mikal.org/interests/java/tomcat/archive/view?mesg=41226 it works for JNDI + postgesql . -- __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Who uses connection pool?
Jim, that's fine! But how to provide the same through JNDI to be free of particular DB? Jim Urban wrote: Here are some code fragments from our servlet (we use a single dispatcher servlet): public void init(ServletConfig iConfig) throws ServletException { super.init(iConfig); ... initializeDbConnectionBroker(iConfig); ... } private void initializeDbConnectionBroker(ServletConfig iConfig) { String dbDriver = getInitParameter(DB_DRIVER); String dbName = getInitParameter(DB_NAME); String dbUser = getInitParameter(DB_USER); String dbPassword = getInitParameter(DB_PSWD); String logfile = getInitParameter(DB_LOG_FILE); int initConn = new Integer(getInitParameter(DB_INITCONN)).intValue(); int maxConn = new Integer(getInitParameter(DB_MAXCONN)).intValue(); int connTimeOut = new Integer(getInitParameter(DB_CONNTIMEOUT)).intValue(); double maxConnTime = new Double(getInitParameter(DB_MAXCONNTIME)).doubleValue(); try { logMessage(Initializing DB connection pool.); ConnectionPool.initialize(dbDriver, dbName, dbUser, dbPassword, logfile, initConn, maxConn, connTimeOut , maxConnTime); logMessage(DB connection pool initialized.); } catch (Exception e) { logException(e, this); logMessage(ConnectionPool.init error: + e.toString()); } } public class ConnectionPool extends Object { private static DbConnectionBroker myBroker = null; private static int connTimeOut = 0; public static void initialize(String DBDriver, String DBName, String DBUser, String DBPsWd, String Logfile, int initConn, int maxConn, int iConnTimeOut, double maxConnTime) throws IOException { if (DBDriver != null DBDriver.length() 0) { myBroker = new DbConnectionBroker(DBDriver, DBName, DBUser, DBPsWd, initConn, maxConn, Logfile, maxConnTime); connTimeOut = iConnTimeOut; } } public static synchronized DbConnectionBroker getBroker() { return myBroker; } public static synchronized void shutDown() { try { myBroker.destroy(connTimeOut); } catch(SQLException e){} } } Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 9:10 AM To: Tomcat Users List Subject: Re: Who uses connection pool? Good! I just found out that ConnectionPoolDataSource is not properly implemented in tyrex stuff (Tyrex people acknowledged that). Did you hardcode pool instance creation or found a way when JNDI do that? Jim Urban wrote: DBConnectionBroker http://opensource.devdaily.com/ddConnectionBroker.shtml -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 7:47 AM To: Tomcat Users List Subject: Re: Who uses connection pool? Which one? Jim Urban wrote: We do. Jim Urban Product Manager Netsteps Inc. Suite 505E 1 Pierce Pl. Itasca, IL 60143 Voice: (630) 250-3045 x2164 Fax: (630) 250-3046 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lev Assinovsky Sent: Tuesday, March 05, 2002 3:09 AM To: 'Tomcat Users List' Subject: Who uses connection pool? Hi! Could you tell me please, does anybody successfully use database connection pool? -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web Programmer
Re: DB Connection Pool
Why? Jim, are you the owner of this mailing list? Jim Urban wrote: If anyone is currently using a third-part pool that they are well pleased with, I would greatly appreciate that information too. We just finished this discussion. Please check the archive. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: DB Connection Pool
No, Emir! Sorry, I don't agree with you. 1. My post is not off topic 2. I spent few weeks working on the problem before my first post was done. 3. We discovered that the problem isn't that simple. 4. The famous book Professional JSP doesn't recommend to use any custom pooling classes, as Jim advises. 5. We still didn't hear Tomcat/JDBC guru Sincerely, Emir Alikadic wrote: On 03/05/2002 02:59 PM, Lev Assinovsky wrote: Why? Jim, are you the owner of this mailing list? Actually, Lev, Jim is right: it's an established etiquette of public mailing lists to first search for an answer in the existing documentation before posting a question on the list. One of the venues of information is the list archive - never aske a question that was sufficiently discussed previously. Eric Raymond wrote a very nice document on asking questions on mailing lists and USENET, and it's available at http://www.tuxedo.org/~esr/faqs/smart-questions.html (pay particular attention to Before you ask section). This document is actually linked from the mailing list subscription page on http://jakarta.apache.org/site/mail.html, which you were supposed to have read before you joined this list. You did read the instructions through, right? Remember: this is a public mailing list for an Open Source Software - we are all stakeholders, not just the list operators. Jim Urban wrote: If anyone is currently using a third-part pool that they are well pleased with, I would greatly appreciate that information too. We just finished this discussion. Please check the archive. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: DB Connection Pool
Reynir Hubner wrote: Hi, Using connection pools with tomcat or any other J2EE app server or even with most Java programs is really simple. many are free, for example : - www.bitmechanic.com offer JDBC connection pool for free, you only need to write a startup servlet that suits your style. - CodeStudio offers poolman for free, available from sourceforge.com - tyrex jdbc connection pool mechanism comes with Tomcat as explained : http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.htm l Many of the comercial JDBC 2.0 drivers also offer connection pooling, sometimes more optimized than the generic solutions (above). I guess because Tyrex-connection pooling is provided with tomcat your post was probably not off topic. The problem IS simple, solve it and you become one of the Tomcat/JDBC gurus. while (lev.hasMoreQuestions()) { mailingList.ask(lev.getQuestion()); } Good joke! Really! Lev breaks out of the loop. Have a good rest! [EMAIL PROTECTED] -Original Message- From: Lev Assinovsky [mailto:[EMAIL PROTECTED]] Sent: 5. mars 2002 20:46 To: Tomcat Users List Subject: Re: DB Connection Pool No, Emir! Sorry, I don't agree with you. 1. My post is not off topic 2. I spent few weeks working on the problem before my first post was done. 3. We discovered that the problem isn't that simple. 4. The famous book Professional JSP doesn't recommend to use any custom pooling classes, as Jim advises. 5. We still didn't hear Tomcat/JDBC guru Sincerely, Emir Alikadic wrote: On 03/05/2002 02:59 PM, Lev Assinovsky wrote: Why? Jim, are you the owner of this mailing list? Actually, Lev, Jim is right: it's an established etiquette of public mailing lists to first search for an answer in the existing documentation before posting a question on the list. One of the venues of information is the list archive - never aske a question that was sufficiently discussed previously. Eric Raymond wrote a very nice document on asking questions on mailing lists and USENET, and it's available at http://www.tuxedo.org/~esr/faqs/smart-questions.html (pay particular attention to Before you ask section). This document is actually linked from the mailing list subscription page on http://jakarta.apache.org/site/mail.html, which you were supposed to have read before you joined this list. You did read the instructions through, right? Remember: this is a public mailing list for an Open Source Software - we are all stakeholders, not just the list operators. Jim Urban wrote: If anyone is currently using a third-part pool that they are well pleased with, I would greatly appreciate that information too. We just finished this discussion. Please check the archive. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
DataSource connection pool problems :(
Hi there! I give up! I can't set up DataSource connection pool. The related piece in server.xml looks as following: Resource name=lev/DataSource auth=Container type=javax.sql.ConnectionPoolDataSource/ ResourceParams name=lev/DataSource parameternameuser/namevaluexyz/value/parameter parameternamepassword/namevaluexyz/value/parameter parameternamedriverClassName/name valueorg.gjt.mm.mysql.Driver/value/parameter parameternamedriverName/name valuejdbc:mysql://localhost:3306/MyDatabase/value/parameter /ResourceParams With the code above I successfully get DataSource but not sure the connection pool works. I request the connection in the top of jsp and close it at the bottom. And I see (using netstat -a) new connection every time. HOW CAN I PASS POOL LIMITS (min, max) to the resource above? Who is responsible for pool management - tyrex.* or mysql? I use Linux and Tomcat 4.0.1. Any help will be appreciated! Thanks, -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Pls Help!! Uploading an image
I use special bean from: http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html Usually web servers don't support uploading because it's still RFC. Uma Maheswar wrote: HI, I need help from any of you. I need a programme to upload an image to the database while submitting a form. If any one is having the source code pls help me. Regards Uma -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: How to log shutting down of tomcat
You can see tomcat's shutdown in /logs/catalina.out Run tail -f $CATALINA_HOME/logs/catalina.out Keith Ng wrote: is there anyway to log the shutting down of tomcat? My tomcat server tend to auto shutdown for unknown reasons. I have been trying to trace to no avail. Currently using 1.3.1 and tomcat 4.0.2. it shuts down like after 4-5 hours and i wasnt able to track why did it shutdown. I have changed my ODBC-JDBC bridge(type 1) to type 4 drivers. It could also be my tomcat crashing... i do not know. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: URL Problem with blanks in names
A HREF=/images/a b.gifOpen/A works for me (Netscape). WebMaster wrote: Just use cascading ASCII (blank = 20): like http://www.testside.de/test%20this%20tile.html - Original Message - From: Zsolt Koppany [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 01, 2002 6:22 PM Subject: URL Problem with blanks in names Hi, how can I create a link (A HREF...) to a file with blank in either the directory or in the filename? I mean for example: A HREF=/images/a b.gifOpen/A I tried to create the link using URLEncoder.encode(..) but the created link didn't work either. Zsolt -- Zsolt Koppany -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Lev AssinovskyPeterlink Web ProgrammerSt. Petersburg, Russia Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7Á E-mail: [EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]