Re: Broken links on the Tomcat 5.5 Docs pages
Brian Cook wrote: The following links relating to realm logging on page http://jakarta.apache.org/tomcat/tomcat-5.5-doc/realm-howto.html are broken http://jakarta.apache.org/tomcat/tomcat-5.5-doc/context.html http://jakarta.apache.org/tomcat/tomcat-5.5-doc/host.html http://jakarta.apache.org/tomcat/tomcat-5.5-doc/engine.html Fixed in CVS. Thanks for the report. Mark - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Broken links on the Tomcat 5.5 Docs pages
The following links relating to realm logging on page http://jakarta.apache.org/tomcat/tomcat-5.5-doc/realm-howto.html are broken http://jakarta.apache.org/tomcat/tomcat-5.5-doc/context.html http://jakarta.apache.org/tomcat/tomcat-5.5-doc/host.html http://jakarta.apache.org/tomcat/tomcat-5.5-doc/engine.html -- Brian Cook Digital Services Analyst Print Time Inc. [EMAIL PROTECTED] 913.345.8900 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
tomcat 5.0 docs(no url configured for link)
At this page on the jakarta site http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/server.html on the left the General Intro link has no url configured. This is the url the link points to http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/connector.html could somebody pass it on to the site admins. regards kamal Send instant messages to your online friends http://uk.messenger.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Please correct docs - Compile JSPs w/ JDK 1.5
Please correct the documentation to reflect that this does not work. It would save a lot of time and lots of emails here about the same issue. Thanks, Milo -- ___ Get your free email from http://www.dellmail.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
Mladen, Built new jk from CVS. How to I access the lovely status page? /jkstatus as in jk2? Do have to enable it? Docs do not seem to be updated yet. Looking forward to playing with it! thanks, -Michael Greer On Feb 19, 2005, at 2:44 PM, Mladen Turk wrote: Michael Greer wrote: Mladen , That sounds like the right solution! I think I remember the status page from jk2, and it is a good idea. Yes, we are trying to backport all goodies from jk2 now that is deprecated and no longer maintained. Not only that. It will have options to fully edit properties, as well to add or disable uri mappings, to reflect the dynamic deployment in tomcat. You can try new features either from cvs, or wait for a public beta release, before releasing stable version. Regards, Mladen. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
Ah, I extrapolated from the jk2 docs: workers.properties: worker.status.type=status httpd.conf: JkMount /jkstatus/* status Nice! -Michael Greer On Feb 22, 2005, at 1:01 AM, Michael Greer wrote: Mladen, Built new jk from CVS. How to I access the lovely status page? /jkstatus as in jk2? Do have to enable it? Docs do not seem to be updated yet. Looking forward to playing with it! thanks, -Michael Greer On Feb 19, 2005, at 2:44 PM, Mladen Turk wrote: Michael Greer wrote: Mladen , That sounds like the right solution! I think I remember the status page from jk2, and it is a good idea. Yes, we are trying to backport all goodies from jk2 now that is deprecated and no longer maintained. Not only that. It will have options to fully edit properties, as well to add or disable uri mappings, to reflect the dynamic deployment in tomcat. You can try new features either from cvs, or wait for a public beta release, before releasing stable version. Regards, Mladen. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
I have been looking around the web to figure out how to implement server quiescence (starving sessions from server in balanced set to take it down for maintenance). The documentation on the jakarta site confused me, and it looks like I am not alone. More people have questions than answers. I think the trouble it that the docs start with the properties, and then describe their complex interactions and possible outcomes. It might be helpful to write a HOWTO starting from the use case instead: HOWTO Quiesce Load-balanced Tomcat Server. Should I take the trouble? Does this belong instead on the Apache wiki? I will need some help to get it right, so I wrote here to see if I could post drafts and get corrections from the community. thanks, -Michael Greer - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
Michael Greer wrote: Should I take the trouble? local_worker and local_worker_only flags will be deprecated. (already are with the current 1.2.9-dev) There has been more powerful mechanism implemented, that is IMO more clearer and acts like it should. 1.2.9 has shared memory and status page that can be used to dynamically change worker properties at runtime, without the need for graceful restarts, or something like. New directives like 'redirect' (for preferred failover), 'disabled' and 'sticky_session_force' has been added. The documentation will be updated accordingly. Release plan is for the first half of march. Like you said the entire concept of local_worker and local_worker_only was too fuzzy and understandable to a wider audience. Regards, Mladen. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
Mladen , That sounds like the right solution! I think I remember the status page from jk2, and it is a good idea. -Michael Greer On Feb 19, 2005, at 2:29 PM, Mladen Turk wrote: Michael Greer wrote: Should I take the trouble? local_worker and local_worker_only flags will be deprecated. (already are with the current 1.2.9-dev) There has been more powerful mechanism implemented, that is IMO more clearer and acts like it should. 1.2.9 has shared memory and status page that can be used to dynamically change worker properties at runtime, without the need for graceful restarts, or something like. New directives like 'redirect' (for preferred failover), 'disabled' and 'sticky_session_force' has been added. The documentation will be updated accordingly. Release plan is for the first half of march. Like you said the entire concept of local_worker and local_worker_only was too fuzzy and understandable to a wider audience. Regards, Mladen. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: volunteering to enhance docs for mod_jk local_worker_only (server quiescence)
Michael Greer wrote: Mladen , That sounds like the right solution! I think I remember the status page from jk2, and it is a good idea. Yes, we are trying to backport all goodies from jk2 now that is deprecated and no longer maintained. Not only that. It will have options to fully edit properties, as well to add or disable uri mappings, to reflect the dynamic deployment in tomcat. You can try new features either from cvs, or wait for a public beta release, before releasing stable version. Regards, Mladen. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Online docs, was jsp version of session variable access.
-Original Message- From: Tim Funk The JSP examples from a default tomcat install might have some. Some, and leads into Sun documentation, which often dates from 2000. From an hours googling: regards DaveP DATE: 2005-02-08T12:39:27Z KEYWORDS:jsp, EL, Tomcat 5.0 uses the Jasper 2 JSP Engine to implement the JavaServer Pages 2.0 specification. * Documentation -http://java.sun.com/products/jsp/docs.html Includes quick reference cards. -http://java.sun.com/products/jsp/syntax/1.0/tags.html 1.0 Syntax reference -http://www.apl.jhu.edu/%7Ehall/java/Servlet-Tutorial/ Tutorial -http://java.sun.com/products/jsp/syntax/1.2/syntaxref12.html 1.2 syntax reference -http://java.sun.com/products/jsp/syntax/2.0/syntaxref20.html 2.0 syntax reference. ** Intro/training course documentation. Objectives By the end of this module you will be able to: Manage session-related information from JSP Communicate between JSP pages Process forms with JSP -http://java.sun.com/developer/onlineTraining/JSPIntro/contents.html -- DISCLAIMER: NOTICE: The information contained in this email and any attachments is confidential and may be privileged. If you are not the intended recipient you should not use, disclose, distribute or copy any of the content of it or of any attachment; you are requested to notify the sender immediately of your receipt of the email and then to delete it and any attachments from your system. RNIB endeavours to ensure that emails and any attachments generated by its staff are free from viruses or other contaminants. However, it cannot accept any responsibility for any such which are transmitted. We therefore recommend you scan all attachments. Please note that the statements and views expressed in this email and any attachments are those of the author and do not necessarily represent those of RNIB. RNIB Registered Charity Number: 226227 Website: http://www.rnib.org.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Suggestion for how-to docs
I have a suggestion for an improvement to the how-to docs (a slightly misleading instruction which I think needs correcting). Where should I send that? Bugzilla? Also I have a suggestion for a new how-to document that I would be prepared to write, or contribute to, if these are written by an established team. I've never done one before. Where do I suggest that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Suggestion for how-to docs
Hi, Submit your suggestions as .diff patches to Bugzilla. Please mark your issues as enhancements. Thanks, Yoav Shapira http://www.yoavshapira.com -Original Message- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 9:00 AM To: 'Tomcat Users List' Subject: Suggestion for how-to docs I have a suggestion for an improvement to the how-to docs (a slightly misleading instruction which I think needs correcting). Where should I send that? Bugzilla? Also I have a suggestion for a new how-to document that I would be prepared to write, or contribute to, if these are written by an established team. I've never done one before. Where do I suggest that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Suggestion for how-to docs
Do I just view page source from the HTML in my browser then base a diff on that, or is there a separate source repository I need to get it from? I just browsed through the how to contribute and CVS pages but couldn't see quickly how to get the page source. The how-to page in question is http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how to.html -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Tuesday 26 October 2004 14:06 To: Tomcat Users List Subject: RE: Suggestion for how-to docs Hi, Submit your suggestions as .diff patches to Bugzilla. Please mark your issues as enhancements. Thanks, Yoav Shapira http://www.yoavshapira.com -Original Message- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 9:00 AM To: 'Tomcat Users List' Subject: Suggestion for how-to docs I have a suggestion for an improvement to the how-to docs (a slightly misleading instruction which I think needs correcting). Where should I send that? Bugzilla? Also I have a suggestion for a new how-to document that I would be prepared to write, or contribute to, if these are written by an established team. I've never done one before. Where do I suggest that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Suggestion for how-to docs
Hi, The diff patches are against the XML source of the docs, so yes you do need to go to the source repository (or download a Tomcat source distro). For online access to the source of the how-to's, see http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-catalina/webapps/docs/. Yoav Shapira http://www.yoavshapira.com -Original Message- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 10:08 AM To: 'Tomcat Users List' Subject: RE: Suggestion for how-to docs Do I just view page source from the HTML in my browser then base a diff on that, or is there a separate source repository I need to get it from? I just browsed through the how to contribute and CVS pages but couldn't see quickly how to get the page source. The how-to page in question is http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-example s- how to.html -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Tuesday 26 October 2004 14:06 To: Tomcat Users List Subject: RE: Suggestion for how-to docs Hi, Submit your suggestions as .diff patches to Bugzilla. Please mark your issues as enhancements. Thanks, Yoav Shapira http://www.yoavshapira.com -Original Message- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 9:00 AM To: 'Tomcat Users List' Subject: Suggestion for how-to docs I have a suggestion for an improvement to the how-to docs (a slightly misleading instruction which I think needs correcting). Where should I send that? Bugzilla? Also I have a suggestion for a new how-to document that I would be prepared to write, or contribute to, if these are written by an established team. I've never done one before. Where do I suggest that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: API docs for Mysql JDBC Driver?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Curwen wrote: Ok, those docs are way out of date. If you're using connectorj 3, those docs would only confuse the matter. The current docos on the jconnector portion of the mysql.com website contain all the latest info on how much of the spec the jconnector drivers implement. The JavaDoc for the drivers themselves (and it's hard to see when you'd want those, unless you intend to bypass java.sql) you can create from the java source files that you get when you download the binaries + source downloads from mysql.com (or don't bother generating them, and just read them from the *.java files). If you're asking yourself: how do I do SQL with jconnector drivers, then I think what you actually want to look into is how do I use the java.sql classes to do SQL, for which there is a healthy amount of JavaDoc included with the JDK, and a JDBC tutorial on java.sun.com. You should not be directly using the jconnector classes for doing SQL. -Original Message- From: John Najarian [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:10 AM To: 'Tomcat Users List' Subject: RE: API docs for Mysql JDBC Driver? I tired looking this up also. The best I could come up with is to compare the java.sql APIs and the mysql limitations. Here is a URL for that: http://www.cs.nott.ac.uk/TSG/manuals/databases/mysql/jdbc/mm.doc/ -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. The documentation for the JDBC driver at MySQL.com shows you any MySQL _specific_ information. It is assumed that you either know JDBC or know where to look for the information (I believe it even has some pointers in the docs). There are plenty of documentation artifacts for JDBC (books, tutorials, apidocs, etc), there's no reason for us to re-invent the wheel there. We implement the _standard_, there are very few 'extensions' to the JDBC standard in the Connector/J docs...Where there are, they're documented. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com MySQL Guide to Lower TCO http://www.mysql.com/it-resources/white-papers/tco.php -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBVy5FtvXNTca6JD8RAqfLAJ9UfemYcooEvsYwHcErMXJ5VXYQaQCgsPEZ kVnbBFcukA92jOUXD0hoi7c= =zss7 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
API docs for Mysql JDBC Driver?
Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[OFF-TOPIC] RE: API docs for Mysql JDBC Driver?
Hi, Please mark your questions as [OFF-TOPIC] in the subject line if they have nothing to do with Tomcat. Thanks, Yoav Shapira Millennium Research Informatics -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver?
This has everything to do with tomcat. I am using the driver to connect to Mysql from Tomcat. --- Shapira, Yoav [EMAIL PROTECTED] wrote: Hi, Please mark your questions as [OFF-TOPIC] in the subject line if they have nothing to do with Tomcat. Thanks, Yoav Shapira Millennium Research Informatics -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] = Chuck Carson - Sr. Systems Engineer Syrrx, Inc. - www.syrrx.com 10410 Science Center Drive San Diego, CA 92121 Work: 858.731.3540 Fax: 858.550.0526 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver?
The API docs for a mysql driver has **nothing** to do with tomcat. Does tomcat distribute the API for mysql drivers?? Perhaps the double star and question marks will convince you. ;) -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 12:02 PM To: Tomcat Users List Subject: Re: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver? This has everything to do with tomcat. I am using the driver to connect to Mysql from Tomcat. --- Shapira, Yoav [EMAIL PROTECTED] wrote: Hi, Please mark your questions as [OFF-TOPIC] in the subject line if they have nothing to do with Tomcat. Thanks, Yoav Shapira Millennium Research Informatics -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] = Chuck Carson - Sr. Systems Engineer Syrrx, Inc. - www.syrrx.com 10410 Science Center Drive San Diego, CA 92121 Work: 858.731.3540 Fax: 858.550.0526 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver?
One answer, btw, is the download contains all the source files. This one time, when I was curious, I built the javadoc. -Original Message- From: Mike Curwen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 12:07 PM To: 'Tomcat Users List' Subject: RE: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver? The API docs for a mysql driver has **nothing** to do with tomcat. Does tomcat distribute the API for mysql drivers?? Perhaps the double star and question marks will convince you. ;) -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 12:02 PM To: Tomcat Users List Subject: Re: [OFF-TOPIC] RE: API docs for Mysql JDBC Driver? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: API docs for Mysql JDBC Driver?
Hi Chuck, Here is another link you might find useful. http://www.cs.nott.ac.uk/TSG/manuals/databases/mysql/jdbc/apidoc/ -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: API docs for Mysql JDBC Driver?
I tired looking this up also. The best I could come up with is to compare the java.sql APIs and the mysql limitations. Here is a URL for that: http://www.cs.nott.ac.uk/TSG/manuals/databases/mysql/jdbc/mm.doc/ -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: API docs for Mysql JDBC Driver?
Ok, those docs are way out of date. If you're using connectorj 3, those docs would only confuse the matter. The current docos on the jconnector portion of the mysql.com website contain all the latest info on how much of the spec the jconnector drivers implement. The JavaDoc for the drivers themselves (and it's hard to see when you'd want those, unless you intend to bypass java.sql) you can create from the java source files that you get when you download the binaries + source downloads from mysql.com (or don't bother generating them, and just read them from the *.java files). If you're asking yourself: how do I do SQL with jconnector drivers, then I think what you actually want to look into is how do I use the java.sql classes to do SQL, for which there is a healthy amount of JavaDoc included with the JDK, and a JDBC tutorial on java.sun.com. You should not be directly using the jconnector classes for doing SQL. -Original Message- From: John Najarian [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:10 AM To: 'Tomcat Users List' Subject: RE: API docs for Mysql JDBC Driver? I tired looking this up also. The best I could come up with is to compare the java.sql APIs and the mysql limitations. Here is a URL for that: http://www.cs.nott.ac.uk/TSG/manuals/databases/mysql/jdbc/mm.doc/ -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 7:49 AM To: LIST: Tomcat User Subject: API docs for Mysql JDBC Driver? Does anyone know where I can find a complete set of API docs for the JConnect Driver 3.x? The docs on the site are lacking and only have simple examples on how to do SELECT's. I am looking for a complete method list or something more detailed. Thanks for any info, rhugga - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
4.1 JNDI Realm configuration docs error
Hi, I have just managed to setup Tomcat 4.1.30 with LDAP authentication, including the retrieval of roles. Following the docs here: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm-howto.html#JNDIRealm I put brackets in the roleSearch attribute like this: roleSearch=(uniqueMember={0}) This won't work, no roles are found. I eventually found out that it will only work if the brackets are removed, like this: roleSearch=uniqueMember={0} Could the website be changed? It may save someone some hair pulling... Regards, Simeon - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Docs?
I'm sorry to aks, but could anyone plese point me to the documents which describe how to configure mod_proxy to be used as a connector between tomcat and apache?? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
5.0.19 docs about new clustering config?
Hello, Are there (up-to-date) docs about the new clustering config in 5.0.19? Some attributes are not in the example config (like 'name') and the documents arn't very clear if it's still needed or not. Greetings, Ronald.
Tomcat 5 Bug or Docs - logging - SOLUTION
The following should either be added to the documentation (as something admins should do) or fixed as a bug. ISSUE: Tomcat 5 does not come with log4j, but appears to be aware of it and attempts to use it for the server if log4j is included in a webapp. As a consequence some of the commons components (like org.apache.catalina.session.ManagerBase) throw a log4j warning about appenders not being found for their logger. SOLUTION: Include commons-logging.jar and log4j-x.x.x.jar in common/lib and put a log4j.properties in common/classes. The following is a minimal sample log4j.properties file that fixes the problem: log4j.logger.org.apache.catalina.session.ManagerBase=INFO, RollFile log4j.rootLogger=INFO, RollFile log4j.appender.RollFile=org.apache.log4j.RollingFileAppender log4j.appender.RollFile.File=logs/tomcat.log log4j.appender.RollFile.MaxFileSize=1000KB log4j.appender.RollFile.MaxBackupIndex=4 log4j.appender.RollFile.layout=org.apache.log4j.PatternLayout log4j.appender.RollFile.layout.ConversionPattern=%d %-5p (%F:%L) - %m%n COMMENT: It would probably be best to include this default setup (or a similar one) with Tomcat, provided the log4j guys aren't antisocial and prohibit it. As an alternative, the sensitive commons classes could be made a bit more resilient against missing loggers. Or, in the worst case, the above info should be somehow included in the documentation, to make people's life easier... it took me over a month to discover the missing files and locations where they should go, and probably wouldn't have succeeded at all if it wasn't for a comment I saw in an unrelated thread. ISSUE 2: It appears that there is some forgotten debug code in org.apache.commons.dbcp.AbandonedObjectPool that displays to the console. Sample output is below. I think that for consistency this code should use log4j like the other parts of commons, or not output at all. In any case, this is just a suggestion to the developers. BTW developers, dealing with Abandoned objects in the pool is a great feature, thanks!!! AbandonedObjectPool is used ([EMAIL PROTECTED]) LogAbandoned: true RemoveAbandoned: true RemoveAbandonedTimeout: 300 b - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
tomcat 5.0 docs
Hello, I am reading the documentation for tomcat 5.0.14. I am at the 'first web app' section and I have followed all of the documentation very closely in setting up my first web app. I am using the example build.xml, build.properties, and web.xml files with appropriate changes to reflect my setup. However when I execute 'ant install' I get: [...] install: [deploy] FAIL - Encountered exception java.util.zip.ZipException: error in opening zip file BUILD FAILED file:/home/toll/java/swit/build.xml:360: FAIL - Encountered exception java.util.zip.ZipException: error in opening zip file line number 360 from build.xml is: deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=file://${build.home}/ My environment: jdk 1.4.; debian sarge on a sparc station. I can overcome this by just copying my build directory over to my context base directory in the web-apps directory, however, it's a pain in the ass. Does anybody have a solution to this for me? Thanks, Dustins - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: tomcat 5.0 docs
I'm pretty sure war=file://${build.home} doesn't pont to a .war file. You need to create a .war file using the jar or war task before the deploy and point to that file in the war attribute of the deploy task. Jake At 05:15 PM 11/8/2003 -0700, you wrote: Hello, I am reading the documentation for tomcat 5.0.14. I am at the 'first web app' section and I have followed all of the documentation very closely in setting up my first web app. I am using the example build.xml, build.properties, and web.xml files with appropriate changes to reflect my setup. However when I execute 'ant install' I get: [...] install: [deploy] FAIL - Encountered exception java.util.zip.ZipException: error in opening zip file BUILD FAILED file:/home/toll/java/swit/build.xml:360: FAIL - Encountered exception java.util.zip.ZipException: error in opening zip file line number 360 from build.xml is: deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=file://${build.home}/ My environment: jdk 1.4.; debian sarge on a sparc station. I can overcome this by just copying my build directory over to my context base directory in the web-apps directory, however, it's a pain in the ass. Does anybody have a solution to this for me? Thanks, Dustins - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
Howdy, Even though i think you're mistaking here, it might be even more reason to update the Application Developer's Guide on the tomcat 5 docs ;) Feel free to contribute... Why would a target be deprecated? I could call it jake-the-snake if i For the normal reason things are deprecated: methods, classes, build targets, documentation. They're out of date and no longer supported, so complaints about them are ignored. Then again: a fairly new tutorial wouldn't trigger me to see if anything I'm using is deprecated. Would it be your first guess? ;) I can understand a bit of your confusion, since you're new to this as you say. The app developer's guide and its tutorial are not new, they're probably almost 2 years old by now. They're modified here and there, and haven't really been updated for tomcat 5 yet, just mostly copied over from the tomcat 4 docs. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
Hi :) Shapira, Yoav wrote: Howdy, Feel free to contribute... A discussion like this turns out to be more of a learning course for me than a contribution to the docs i suppose :D Should i post the tomcat-dev mailinglist for contributions to the docs as well? Maybe i'll try to work out some updated tutorial... in the not-so-near future that is... For the normal reason things are deprecated: methods, classes, build targets, documentation. They're out of date and no longer supported, so complaints about them are ignored. I'm not complaining, and i understand the meaning of the word deprecated ;) I just wondered why one would deprecate a target by it's name, and not by it's function. As you could have seen, the target i posted contains a deploy ... /, and it's still not clear to me what of both things now is deprecated? I mean... i could also write a target with name my-funky-target and put the deploy statement in there... Or DO targets have special meaning based on their names? By the way: any idea why Ant doesn't warn me about this deprecated stuff? Anyhow, i should go RTFM, so if none bothers to answer this i could relate ;) I can understand a bit of your confusion, since you're new to this as you say. The app developer's guide and its tutorial are not new, they're probably almost 2 years old by now. They're modified here and there, and haven't really been updated for tomcat 5 yet, just mostly copied over from the tomcat 4 docs. Yeah, I figured so... drama Well thanks anyway for letting me see the light :) /drama drm - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
Howdy, Should i post the tomcat-dev mailinglist for contributions to the docs as well? Maybe i'll try to work out some updated tutorial... in the not-so-near future that is... You would put an enhancement issue into Bugzilla and attach your documents/patches/whatever to that issue. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
cheers Shapira, Yoav wrote: Howdy, Should i post the tomcat-dev mailinglist for contributions to the docs as well? Maybe i'll try to work out some updated tutorial... in the not-so-near future that is... You would put an enhancement issue into Bugzilla and attach your documents/patches/whatever to that issue. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[tomcat 5.0 docs] Application Developer's Guide: build.xml file
Hi all :) First post here, so don't bomb me if i do anything wrong :P After downloading and installing Tomcat 5.0 beta i discovered an error in the build.xml file provided in that section. The target install misses the action to create a war file, and deploying that war file in/on/to (?) the server. I solved it this way: ---snip--- target name=install depends=compile description=Install application to servlet container !-- added -- jar jarfile=${build.home}/${app.version}.war basedir=${build.home}/ !-- /added -- !-- [EMAIL PROTECTED] now points to the just created war file (ofcourse ;)) -- deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=${build.home}/${app.version}.war/ /target ---snip--- Maybe it's all wrong, (if so, please let me know how to do better ;)) but that's not my point. Maybe the guys over there creating and managing these docs can provide a better build.xml file :) I searched my ass of (being new to Ant and all :)) how to solve that weird ZipException... Cheers in advance :) drm - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
*feeling n00bish :o I just realized it is would be more handy if you put the jar in a dir where it would not try to include itself when compressing :P so replace ${build.home}/${app.version}.war with plain ${app.version}.war And yes, thank you, i love talking to myself :P drm wrote: Hi all :) First post here, so don't bomb me if i do anything wrong :P After downloading and installing Tomcat 5.0 beta i discovered an error in the build.xml file provided in that section. The target install misses the action to create a war file, and deploying that war file in/on/to (?) the server. I solved it this way: ---snip--- target name=install depends=compile description=Install application to servlet container !-- added -- jar jarfile=${build.home}/${app.version}.war basedir=${build.home}/ !-- /added -- !-- [EMAIL PROTECTED] now points to the just created war file (ofcourse ;)) -- deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=${build.home}/${app.version}.war/ /target ---snip--- Maybe it's all wrong, (if so, please let me know how to do better ;)) but that's not my point. Maybe the guys over there creating and managing these docs can provide a better build.xml file :) I searched my ass of (being new to Ant and all :)) how to solve that weird ZipException... Cheers in advance :) drm - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
Howdy, Even though you like talking to yourself, maybe I'll interrupt for two quick questions: did you notice the install target is deprecated? Did you perhaps search the archives to see why? http://marc.theaimsgroup.com/?l=tomcat-devm=106400337928462w=2 Yoav Shapira Millennium ChemInformatics -Original Message- From: drm [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:59 PM To: Tomcat Users List Subject: Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file *feeling n00bish :o I just realized it is would be more handy if you put the jar in a dir where it would not try to include itself when compressing :P so replace ${build.home}/${app.version}.war with plain ${app.version}.war And yes, thank you, i love talking to myself :P drm wrote: Hi all :) First post here, so don't bomb me if i do anything wrong :P After downloading and installing Tomcat 5.0 beta i discovered an error in the build.xml file provided in that section. The target install misses the action to create a war file, and deploying that war file in/on/to (?) the server. I solved it this way: ---snip--- target name=install depends=compile description=Install application to servlet container !-- added -- jar jarfile=${build.home}/${app.version}.war basedir=${build.home}/ !-- /added -- !-- [EMAIL PROTECTED] now points to the just created war file (ofcourse ;)) -- deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=${build.home}/${app.version}.war/ /target ---snip--- Maybe it's all wrong, (if so, please let me know how to do better ;)) but that's not my point. Maybe the guys over there creating and managing these docs can provide a better build.xml file :) I searched my ass of (being new to Ant and all :)) how to solve that weird ZipException... Cheers in advance :) drm - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file
Hi, Even though i think you're mistaking here, it might be even more reason to update the Application Developer's Guide on the tomcat 5 docs ;) Why would a target be deprecated? I could call it jake-the-snake if i wanted to... Don't you mean an 'install' element? Since the deploy you're pointing out here is what is used in the target itself... I'm new to this, so i'm not sure if i'm right ;) Then again: a fairly new tutorial wouldn't trigger me to see if anything I'm using is deprecated. Would it be your first guess? ;) Thanks for the tip though, i'll figure it out Shapira, Yoav wrote: Howdy, Even though you like talking to yourself, maybe I'll interrupt for two quick questions: did you notice the install target is deprecated? Did you perhaps search the archives to see why? http://marc.theaimsgroup.com/?l=tomcat-devm=106400337928462w=2 Yoav Shapira Millennium ChemInformatics -Original Message- From: drm [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 3:59 PM To: Tomcat Users List Subject: Re: [tomcat 5.0 docs] Application Developer's Guide: build.xml file *feeling n00bish :o I just realized it is would be more handy if you put the jar in a dir where it would not try to include itself when compressing :P so replace ${build.home}/${app.version}.war with plain ${app.version}.war And yes, thank you, i love talking to myself :P drm wrote: Hi all :) First post here, so don't bomb me if i do anything wrong :P After downloading and installing Tomcat 5.0 beta i discovered an error in the build.xml file provided in that section. The target install misses the action to create a war file, and deploying that war file in/on/to (?) the server. I solved it this way: ---snip--- target name=install depends=compile description=Install application to servlet container !-- added -- jar jarfile=${build.home}/${app.version}.war basedir=${build.home}/ !-- /added -- !-- [EMAIL PROTECTED] now points to the just created war file (ofcourse ;)) -- deploy url=${manager.url} username=${manager.username} password=${manager.password} path=${app.path} war=${build.home}/${app.version}.war/ /target ---snip--- Maybe it's all wrong, (if so, please let me know how to do better ;)) but that's not my point. Maybe the guys over there creating and managing these docs can provide a better build.xml file :) I searched my ass of (being new to Ant and all :)) how to solve that weird ZipException... Cheers in advance :) drm - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Docs
Good day, We are moving over from IIS to Jakarta, but my knowledge of the product is null. I googled around for help, but can not seem to find anything starting from scratch. Does anybody know of a good place to start teaching yourself the product? Need to define three separate sites from the main site. E.g. www.ourdomain.com/site1-site3 Many thanks Regards Werner vd Merwe SAICOM Cpt Linux user #322423 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Docs
Howdy, I googled around for help, but can not seem to find anything starting from scratch. Does anybody know of a good place to start teaching yourself the product? Need to define three separate sites from the main site. E.g. www.ourdomain.com/site1-site3 Each site would likely be a web application, or a context in tomcat-speak. A good document for you would be the App Developer's guide at http://jakarta.apache.org/tomcat/tomcat-4.1-doc/appdev/index.html Especially the deployment organization section. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Docs
I recommend a server admin book. There was a recent flame war about this. Check the user archives. http://jakarta.apache.org/tomcat/faq/ -Tim Werner vd Merwe wrote: Good day, We are moving over from IIS to Jakarta, but my knowledge of the product is null. I googled around for help, but can not seem to find anything starting from scratch. Does anybody know of a good place to start teaching yourself the product? Need to define three separate sites from the main site. E.g. www.ourdomain.com/site1-site3 Many thanks Regards Werner vd Merwe SAICOM Cpt Linux user #322423 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Docs
The Apache Tomcat Bible from Wiley. -Original Message- From: Werner vd Merwe [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 5:27 AM To: Tomcat Users List Subject: Docs Good day, We are moving over from IIS to Jakarta, but my knowledge of the product is null. I googled around for help, but can not seem to find anything starting from scratch. Does anybody know of a good place to start teaching yourself the product? Need to define three separate sites from the main site. E.g. www.ourdomain.com/site1-site3 Many thanks Regards Werner vd Merwe SAICOM Cpt Linux user #322423 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
looking for docs on building mod_jk 1.2.x for AIX 4.3.x
No luck with the encap package for mod_jk as i don't have the required encap for Apache. Now I am trying to build from src files and am having trouble. If you know of any docs or even different locations for pre-built so files, I would appreciate hearing about them. Thanks!! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Connection Pooling/Jakarta prob/fix - Update or add to docs.
Referring to http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html The example given for the JNDI MySQL connection pool had me stumped for a time. I did everything the example said, it wouldnt get past if (ds != null) { SEE BELOW for code but would just finish the servlet (no execption thrown that I saw) when it got to Connection conn = ds.getConnection(); I had to lookup a different example, and realized from the exceptions thrown, [EMAIL PROTECTED] was being denied. I changed (in http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html) mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'javadude' WITH GRANT OPTION; to mysql GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] - IDENTIFIED BY 'javadude' WITH GRANT OPTION; and all worked fine. I am guessing thats just because locahost.localdomain is in the /etc/hosts file?? RedHat 8.0 Keepers of the JNDI examples page my want to offer the note about localhost stuff. I would like an explanation for why I didn't see an error, I even tried to try { Connection conn = ds.getConnection(); }catch(SQLException se){ //println stuff } the servlet would appear to just end, nothing in the context's logs. ### To reiterate code: package foo; import javax.naming.*; import javax.sql.*; import java.sql.*; public class DBTest { String foo = Not Connected; int bar = -1; public void init() { try{ Context ctx = new InitialContext(); if(ctx == null ) throw new Exception(Boom - No Context); DataSource ds = (DataSource)ctx.lookup( java:comp/env/jdbc/TestDB); //Look here if (ds != null) { Connection conn = ds.getConnection(); //end if(conn != null) { foo = Got Connection +conn.toString(); Statement stmt = conn.createStatement(); ResultSet rst = stmt.executeQuery( select id, foo, bar from testdata); if(rst.next()) { foo=rst.getString(2); bar=rst.getInt(3); } conn.close(); } } }catch(Exception e) { e.printStackTrace(); } } public String getFoo() { return foo; } public int getBar() { return bar;} }
Where are mod_webapp docs??
It seems that every few months I have to pull up the reference on mod_webapp (Apache side), and every time, I lose all my hair trying find where the docs are, on apache.org or on jakarta.apache.org! Can someone please tell me where the docs are? Today, all I'm trying to find out, is the formal syntax of the WebAppDeploy command, and whether or not the URL parameter supports regular expressions (or wildcards). Thanks! Bryan
tomcat ant tasks (docs?)
On advice given here, I've got tomcat configured to _not_ unpack my .war file. Then my ant 'deploy' target [not task] simply copies the .war file over to /path/to/tomcat/webapps. Now I'm trying to use the tomcat ant tasks to automate things, and I'm running into problems. First, I can't reload this app with the ant task. It says: w:\java\bendevant reload Buildfile: build.xml reload: BUILD FAILED file:w:/java/bendev/build.xml:159: java.io.IOException: Server returned HTTP res ponse code: 401 for URL: http://localhost/manager/reload?path=%2Fbendev Total time: 1 second w:\java\bendev I can reload it manually using the manager app, and I get: OK - Reloaded application at context path /bendev Then, the install task doesn't seem to work with a .war file. It installed my .war file under the /webapps/bendev directory instead of under /webapps where it belongs. I guess it's supposed to work with a set of loose files? What I really need ar the start and stop tasks, not install and remove which are shown in Craig's App Developer Guide: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/appdev/sample/build.xml. I see that they are present in catalina-ant.jar. Is there a set of documentation for the Tomcat ant tasks, similar to ant's user guide? For example, if I put 'ant jar task' into Google, I get this: http://ant.apache.org/manual/CoreTasks/jar.html. 'tomcat stop ant task' doesn't turn up anything useful. Does anyone have an example of how to use the start and stop tasks? I'm going to guess at the syntax based on reload, hopefully it will work. -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University PA Information Resources Management
RE: tomcat ant tasks (docs?)
I wrote: Then, the install task doesn't seem to work with a .war file. It installed my .war file under the /webapps/bendev directory instead of under /webapps where it belongs. I guess it's supposed to work with a set of loose files? Oops... I'm sure you know this, but it didn't move the .war file at all... it just pointed the context at the directory I gave it, which was the dist directory where I put my .war files. Not what I expected at all... -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University PA Information Resources Management
Re: tomcat ant tasks (docs?)
Wendy Smoak wrote: Now I'm trying to use the tomcat ant tasks to automate things, and I'm running into problems. First, I can't reload this app with the ant task. It says: w:\java\bendevant reload Buildfile: build.xml reload: BUILD FAILED file:w:/java/bendev/build.xml:159: java.io.IOException: Server returned HTTP res ponse code: 401 for URL: http://localhost/manager/reload?path=%2Fbendev Total time: 1 second w:\java\bendev I can reload it manually using the manager app, and I get: OK - Reloaded application at context path /bendev I have not used the ant custom task (catalina-ant.jar) that does reloading, I have written my own with wget. But one of the issues is that the /manager webapp requires HTTP authentication to work. In my wget command I supply the --http-user and --http-pass arguments. You may have a session cookie in your browser that is letting you reload without specifying these, which may explain why it works in your browser but not in your ant script. Does your ant task provide the HTTP authentication credentials? According to the example build.xml comments, you need to set a manager.username and manager.password property for the ant script to access the /manager app with. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: tomcat ant tasks (docs?)
On Thursday 20 February 2003 12:51 pm, Wendy Smoak wrote: On advice given here, I've got tomcat configured to _not_ unpack my .war file. Then my ant 'deploy' target [not task] simply copies the .war file over to /path/to/tomcat/webapps. Wendy, why are you dealing with war files during development at all? Ant does a great job installing and reloading from docBases at arbitrariry locations on the filesystem. I may not have read into your problem carefully enough but the very mentioning of war files with Ant Catalina tasks being used for something other that final distribution causes misgivings about your setup. Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: tomcat ant tasks (docs?)
Wendy, why are you dealing with war files during development at all? Ant does a great job installing and reloading from docBases at arbitrariry locations on the filesystem. At the moment, I don't have my development files arranged in a webapp structure (with WEB-INF, etc.). I was developing directly underneath /path/to/tomcat/webapps with everything expanded, and I recently moved it all to a different location. I thought I was doing it right actually, but now I see the error of my ways. ;) I also didn't realize that docBase could *be* anywhere outside of the Tomcat directory structure! Rearranging everything now... thanks for the advice. -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University PA Information Resources Management
RE: tomcat ant tasks (docs?)
Erik wrote: Does your ant task provide the HTTP authentication credentials? According to the example build.xml comments, you need to set a manager.username and manager.password property for the ant script to access the /manager app with. It's taken almost straight from the example: target name=reload description=Reload Web application depends= reload url=${manager.url} username=${manager.username} password=${manager.password} path=/${context}/ /target (With the appropriate properties set, of course.) And I get: w:\java\bendevant reload Buildfile: build.xml reload: BUILD FAILED file:w:/java/bendev/build.xml:159: java.io.IOException: Server returned HTTP res ponse code: 401 for URL: http://localhost/manager/reload?path=%2Fbendev Total time: 2 seconds w:\java\bendev It does work manually from the manager app: OK - Reloaded application at context path /bendev with this URL: http://localhost/manager/html/reload?path=/bendev Looks the same to me... -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University PA Information Resources Management
Re: tomcat ant tasks (docs?)
Wendy Smoak wrote: It's taken almost straight from the example: target name=reload description=Reload Web application depends= reload url=${manager.url} username=${manager.username} password=${manager.password} path=/${context}/ /target (With the appropriate properties set, of course.) And I get: w:\java\bendevant reload Buildfile: build.xml reload: BUILD FAILED file:w:/java/bendev/build.xml:159: java.io.IOException: Server returned HTTP res ponse code: 401 for URL: http://localhost/manager/reload?path=%2Fbendev Total time: 2 seconds w:\java\bendev It does work manually from the manager app: OK - Reloaded application at context path /bendev with this URL: http://localhost/manager/html/reload?path=/bendev Looks the same to me... Hmm... not to be contradictory but those two URLs are not the same, if you look closely. (One is manager/html/reload, the other is manager/reload.) But I do not know much about the /manager app, so this might not be the source of your problems. Erik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: tomcat ant tasks (docs?)
* Paul Yunusov [EMAIL PROTECTED] [0245 19:45]: On Thursday 20 February 2003 12:51 pm, Wendy Smoak wrote: On advice given here, I've got tomcat configured to _not_ unpack my .war file. Then my ant 'deploy' target [not task] simply copies the .war file over to /path/to/tomcat/webapps. Wendy, why are you dealing with war files during development at all? Ant does a great job installing and reloading from docBases at arbitrariry locations on the filesystem. I may not have read into your problem carefully enough but the very mentioning of war files with Ant Catalina tasks being used for something other that final distribution causes misgivings about your setup. Only problem with this is when you run 'ant clean' the webapp breaks! I don't understand your phobia about using a warfile - it's no more work to deploy a warfile than to run a jar task, so why not do it? -- Real computer scientists don't program in assembler. They don't write in anything less portable than a number two pencil. Rasputin :: Jack of All Trades - Master of Nuns - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: tomcat ant tasks (docs?)
Erik wrote: Hmm... not to be contradictory but those two URLs are not the same, if you look closely. (One is manager/html/reload, the other is manager/reload.) But I do not know much about the /manager app, so this might not be the source of your problems. One is what you use when sending it commands programmatically, the other is what you use to actually view the html pages and click on the links to do various things. It was me all along... I copied in the reload task from the sample build.xml file and didn't check the property names. Mine were 'username' and 'password' and the example has 'manager.username' and 'manager.password'. Oops! When I looked up what a response code 401 actually was, it all became clear, plus Erik hit it immediately and I made the mistake of not double checking right then. ;) -- Wendy Smoak
Re: Tomcat's examples and tomcat-docs Directories
Bio Jazz [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am setting up Tomcat on my Linux machine, and am curious about ../webapps/examples and ../webapps/tomcat-docs directories. I have removed the context for the examples directory from the server.xml file, and restarted Tomcat (and the machine). However, I am still able to access files within the examples directory via a web browser. Is there a way to prevent the examples and tomcat-docs directories from being accessible via the web browser (other than deleting the directories). Urm, no. Tomcat will auto-config all directories under $CATALINA_HOME/webapps (same as all 3.x versions that I know). Nuke the directories, and re-start Tomcat and you are working. Thanks... Brian _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat's examples and tomcat-docs Directories
I am setting up Tomcat on my Linux machine, and am curious about ../webapps/examples and ../webapps/tomcat-docs directories. I have removed the context for the examples directory from the server.xml file, and restarted Tomcat (and the machine). However, I am still able to access files within the examples directory via a web browser. Is there a way to prevent the examples and tomcat-docs directories from being accessible via the web browser (other than deleting the directories). Thanks... Brian _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Wanted: docs on Applet-Servlet RMI on Port 80
I've been studying chapt 10 of 2nd Edition of Jason Hunters' Java Servlet Programming. Much to my dismay, I cannot find where the second edition says Applet-Servlet RMI works on Port 80. I'm sure the first edition talked about using port 80 with RMI callbacks. Can someone point me to the Tomcat documentation that says how to implement RMI on port 80 with Applet/Servlet communication? I cannot find it! - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
tomcat 4.1 api docs not online?
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/catalina/docs/api/ is empty. Am I looking in the wrong place? This is the link available at the bottom of this page: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/index.html -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
JAASRealm docs
Is there a documentation or a sample configuration somewhere that demonstrates JAASRealm? (Tomcat 4.1.12) Thanks, Alex. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: JAASRealm docs
The answer is no. But if you search the list, I'm sure you will find a lot of interesting discussions. You can also look at the class API documentation org.apache.catalina.realm.JAASRealm. Since this class is a Valve, setting JAAS should not differ that setting JNDIRealmLet me know if you still have difficulties -- Jeanfrancois Aleksandr Shneyderman wrote: Is there a documentation or a sample configuration somewhere that demonstrates JAASRealm? (Tomcat 4.1.12) Thanks, Alex. -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Problem accessing data source (I've read docs ;) )
Hi In the first place I'd like to admit that I've read docs and it seems I've done everything correctly. I've defined data source as follows (inside GlobalNamingResources): Resource name=jdbc/DistributedComputingDatabase auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/DistributedComputingDatabase parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namedriverClassName/name valueorg.postgresql.Driver/value /parameter parameter nameurl/name valuejdbc:postgresql://some.address:5432/baza/value /parameter parameter nameusername/name valuesomeusername/value /parameter parameter namepassword/name valuesomepassword/value /parameter parameter namemaxActive/name value20/value /parameter parameter namemaxIdle/name value10/value /parameter parameter namemaxWait/name value-1/value /parameter /ResourceParams web.xml contains: resource-ref descriptionpostgreSQL Datasource/description res-ref-namejdbc/DistributedComputingDatabase/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref And I'm getting: java.sql.SQLException: Cannot load JDBC driver class 'null' exception when calling getConnection() on datasource object. What is most surprising, if I cast data source object to BasicDataSource and call setDriverClassName(), setUrl(), setUsername() and setPassword() on it, getConnection() works, so I do have all required libraries. It appears, that for some reason Tomcat doesn't set up this data source instance. I'm bit desperate about this, so I decompiled BasicDataSource and added generation of stack traces to constructor and setDriverClassName() methods. Conclusion is that Tomcat creates and initializes one instance of data source when it starts, but when I'm taking data source from JNDI it creates another instance and does NOT initialize it. Do you have any suggestions or ideas what could I correct or try? TIA for any help. Regards PS. If you would like to take a look at complete source code (it's very small yet) it's available via Web CVS at http://cvs.michal.waw.pl/index.cgi/projekt_zespolowy/distributed/ -- --= Michal Kochanowicz =--==--==BOFH==--==--= [EMAIL PROTECTED] =-- --= PGP key: www.ee(...)/~mkochano/PGP/ or finger me @tmp.iem.pw... =-- --==--==--==--==--==--=Vodka. Connecting people.=--==--==--==--==--==-- A chodzenie po górach SSIE!!! -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
How to contribute to the docs in 7 easy steps.
As Craig McClanahan once said to me General whines about how the documentation sucks will go to /dev/null. Specific patches to add to (or fix) the existing documentation pages are MUCH more likely to be effective :-). Ok, so let's get to it. I'm going to try to make it easy for everyone to help out with the documentation of Tomcat, more specifically the documentation for the connectors. I was a little bewildered at how to get started. Hopefully, you will be clued in after reading of this. It's really quite simple: Here's what you'll need: A recent version of Ant The source code for the connectors from cvs Any ascii text editor. STEP 1. Install Ant, http://jakarta.apache.org/builds/jakarta-ant/release/ and setup your environment variables for ANT_HOME and the path to Ant/bin so you can run ant from the command line. STEP 2. Get the sources for jakarta-tomcat-connectors from CVS. If you'll be editing from a windows platform you will need a cvs client. Install CYG-WIN http://www.cygwin.com/ and during the install elect to install the cvs client. You can also use jEdit, http://www.jedit.org/, which also includes a CVS plug-in. Unix people should install the CVS client of their choice. Run the following from a command prompt window. Change directory to the location where you want to store your CVS repository. cd c:\ Run the following command to download the source for the first time. cvs -d :pserver:[EMAIL PROTECTED]:/home/cvspublic login Type in the password for anonymous access at the next prompt. anoncvs When the prompt comes back, run the following to download the sources. cvs -d :pserver:[EMAIL PROTECTED]:/home/cvspublic checkout jakarta-tomcat-connectors You should now be watching all the downloads come in. STEP 3. Set up your build environment. Change to the directory you downloaded the source into. Now cd to the jk directory. Copy the build.properties.sample file to build.properties and edit it for the locations of your installed Tomcat. My only edits were: tomcat41.home=c:/Tomcat Optional: cd into the xdocs directory and copy the supplied build.properties.sample file to build.properties. I would not edit this file. STEP 4. Test the build for the docs. On a windows machine, open a command prompt window in the jk directory of the CVS repository you made. On a Unix machine just cd into the directory that contains your CVS repository then cd into the jk directory. Now type in the following command: ant docs You should see build lines start flowing. Notice that all the files are sent to a new directory under jk called build/doc. Open the doc directory and you should see all the files translated into html. STEP 5. Find a typo in the documentation to edit, pay attention to what file your actually looking at. Cd back into the xdocs directory and after you have found your intended target, open up the xml file in a text editor. Correct the typo then from a command prompt window in the jk directory run: ant clean ant docs Now check how your edit looks in the build/docs directory by opening it in your web browser. STEP 6. Create a unified diff of the corrections you just made. Cd into the directory containing the xml file you edited and run the following command. cvs diff -u name_of_the_file_you_edited patch.txt STEP 7. Now to get it, (or yourself :-), committed. Patches to the documentation are handled just like a bug report. Send it to http://nagoya.apache.org/bugzilla/ and include a good one line subject. At the web site paste your patch into the web form and don't forget to describe what it is your patch is for. Sooner or later a someone with commit privileges will commit your change. They are pretty good about doing this. That's all there is to it. It's easy once you know how. Now you know how. General notes about using CVS. It is much easier to use CVS if you setup a CVSROOT environment variable. After setting up the CVSROOT variable you don't have to type in those long command lines to use CVS. A Unix bash user could do the following: CVSROOT=:pserver:[EMAIL PROTECTED]:/home/cvspublic export CVSROOT A windows user would set a system environment variable for CVSROOT to the same value as above Now all you would have to do is open a command prompt window or bash window and cd to the directory where you have or want your repository and then: cvs login then at the password prompt anoncvs To check out the sources for the first time: cvs checkout jakarta-tomcat-connectors After you have checked out the connectors source the first time you will periodically need to update your repository. Do this especially before you edit your files to prevent conflicts. Make sure you are above the directory of your repository, then you can run the following cvs command. cvs update
RE: How to contribute to the docs in 7 easy steps.
Rockin' !! Thanks, Robert! John -Original Message- From: Robert L Sowders [mailto:rsowders;usgs.gov] Sent: Wednesday, October 23, 2002 5:35 AM To: Tomcat Users List Subject: How to contribute to the docs in 7 easy steps. As Craig McClanahan once said to me General whines about how the documentation sucks will go to /dev/null. Specific patches to add to (or fix) the existing documentation pages are MUCH more likely to be effective :-). Ok, so let's get to it. -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
RE: there are type: HTTP Status 404 -/tomcat-docs...
Yufeng, I'm pretty new to this so others may have better info. Check your path to make sure that tomcat-docs is in the webapps folder [%CATALINA_HOME\webapps\tomcat-docs] and that you have a WEB-INF in your tomcat-docs folder. Hope that helps..experienced ones please correct me if needed. Bob -Original Message- From: [mailto:czyf2001;hotmail.com] Sent: Sunday, October 20, 2002 3:37 AM To: [EMAIL PROTECTED] Subject: there are type: HTTP Status 404 -/tomcat-docs... hi tomcat, when I saw tomcat's index.jsp and there is If you're seeing this page via a web browser, it means you've setup Tomcat successfully. Congratulations! till I click Tomcat Documentation .there are type: HTTP Status 404 - /tomcat-docs type Status report message /tomcat-docs description The requested resource (/tomcat-docs) is not available. Apache Tomcat/4.1.12-LE-jdk14 what shall i do?Could you will give me some advice and help me to configue it right!! thanks! I will glad to hear form you. yours yufeng _ ÓëÁª»úµÄÅóÓѽøÐн»Á÷£¬ÇëʹÓà MSN Messenger: http://messenger.msn.com/lccn/ -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
there are type: HTTP Status 404 -/tomcat-docs...
hi tomcat, when I saw tomcat's index.jsp and there is If you're seeing this page via a web browser, it means you've setup Tomcat successfully. Congratulations! till I click Tomcat Documentation .there are type: HTTP Status 404 - /tomcat-docs type Status report message /tomcat-docs description The requested resource (/tomcat-docs) is not available. Apache Tomcat/4.1.12-LE-jdk14 what shall i do?Could you will give me some advice and help me to configue it right!! thanks! I will glad to hear form you. yours yufeng _ ÓëÁª»úµÄÅóÓѽøÐн»Á÷£¬ÇëʹÓà MSN Messenger: http://messenger.msn.com/lccn/ -- To unsubscribe, e-mail: mailto:tomcat-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:tomcat-user-help;jakarta.apache.org
Problem with JK 1.2.0 docs?
I am confused by the build process for mod_jk 1.2.0 on a Redhat 7.3 server. From the 'BUILDING' text file, it says: use configure and indicate Apache 1.3 apxs location (--with-apxs) use make copy the mod_jk binary to the apache modules location Now, after doing a 'make' there is no binary in the top-level directory with the configure script (i.e., jakarta-tomcat-connectors-jk-1.2.0-src/jk/native). So I went into jakarta-tomcat-connectors-jk-1.2.0-src/jk/native/apache-1.3 and I see the following files: [root@javatest2 apache-1.3]# ls -l total 1556 -rw-r--r--1 root root 120 Sep 26 04:34 libjk.module -rw-r--r--1 root root 2350 Oct 9 11:27 Makefile -rw-r--r--1 root root 659 Oct 9 11:27 Makefile.apxs -rwxr-xr-x1 root root 582 Sep 26 04:34 Makefile.apxs.in -rwxr-xr-x1 root root 2234 Sep 26 04:34 Makefile.in -rw-r--r--1 root root 252 Sep 26 04:34 Makefile.libdir -rw-r--r--1 root root 827 Sep 26 04:34 Makefile.tmpl -rw-r--r--1 root root 920456 Oct 9 11:28 mod_jk.a -rw-r--r--1 root root66958 Sep 26 04:34 mod_jk.c -rw-r--r--1 root root 7326 Sep 26 04:34 mod_jk.dsp -rw-r--r--1 root root 11 Sep 26 04:34 mod_jk.exp -rw-r--r--1 root root 713 Oct 9 11:28 mod_jk.la -rw-r--r--1 root root 103752 Oct 9 11:28 mod_jk.lo -rw-r--r--1 root root 101844 Oct 9 11:28 mod_jk.o lrwxrwxrwx1 root root 15 Oct 9 11:28 mod_jk.so - mod_jk.so.0.0.0 lrwxrwxrwx1 root root 15 Oct 9 11:28 mod_jk.so.0 - mod_jk.so.0.0.0 -rwxr-xr-x1 root root 326225 Oct 9 11:28 mod_jk.so.0.0.0 So which is the binary? Mod_jk.so is a symlink. Should I just move mod_jk.so.0.0.0 to the apache directory as mod_jk.so? The documentation is very vague on this point. I get around it by doing a 'make install' in the native directory and it installs a symlink to the the libexec directory of Apache. -- Ben Ricker [EMAIL PROTECTED] Wellinx.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs? (SOLVED)
First, thanks to everyone who replied with help and suggestions. Quick summary of the problem: stored procedure with 5 input parameters, 5 output parameters, and a return status. Normally, you would think that the correct CallableStatement would be: cstmt = sConn.prepareCall({? = call sp_validate_pwd(?, ?, ?, ?, ?, ?, ?, ?, ? ,?)}); However, this did not work, no matter what arrangement was used for declaring and registering the inputs and outputs. What did finally work is ignoring the return status. I don't know why, but the return status was never explicity declared in the stored procedure, though it did show up in the MS Query Analyzer as a parameter for that stored procedure. Apparently, since it was never explicitly declared, it's not required, and including a spot for it in the call threw all of the other parameter positions off by one. So, the code snippet that is currently working is: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({call sp_validate_pwd(?, ?, ?, ?, ?, ?, ?, ?, ? ,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(1, strUserID); cstmt.setString(2, strPassword); cstmt.setString(3, strRemoteAddress); cstmt.setString(4, strReferURL); cstmt.setString(5, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(6, Types.BIT); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.CHAR); cstmt.registerOutParameter(10, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } The moral of the story being that unless a parameter is explicitly declared within the procedure itself, it's not available and shouldn't be accounted for when preparing the statement, regardless of what sort of tool is used to manage the stored procedures, like MS Query Analyzer. Maybe this is a bug/feature of MS Query Analyzer, where a return status is included in the list just for housekeeping purposes, or maybe it's true regardless of database platform. Either way: unless a parameter is explicitly declared, don't count on it in your CallableStatement. Thanks again to everyone who helped, even though it was off-topic. John Turner [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:05 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt = null; I've tried different calls, putting the output parameters first (2-6) and the inputs last (7-11), I've tried no return value, putting that return value at the end (#11), etc. with no luck. All of the variables in the setString() methods are set before calling
RE: OFF-TOPIC: Pointers to CallableStatement docs?
John, I've dug out some old code and i think you may have to set initial values for the OUT parameters as well. We used functions with oracle 8i with no problems in this way: One of the CallableStatements we prepared with {?=call pk_housekeeping.f_purge_inactive_consumers(?)} and used as below: snippet private void initializeParameters(CallableStatement cs) throws SQLException { int total = 0; if (cs!=null) { cs.setInt(1, total); cs.registerOutParameter(1, Types.INTEGER); if (purgeDate!=null) { cs.setDate(2, purgeDate); } else { cs.setNull(2, Types.DATE); } } else { throw new IllegalStateException (CallableStatement has not been initialized.); } } /snippet The statement was executed and the out parameters accessed via the getXXX methods. I do seem to recall (two years ago on a different project, i'm afraid) that without the cs.setInt(1, total); line it did throw a SQLException. This may be a driver dependent 'feature' coz the java.sql.CallableStatement javadocs don't mention this as a requirement. Hope this helps/works, Jon -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: 19 August 2002 19:27 To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt = null; I've tried different calls, putting the output parameters first (2-6) and the inputs last (7-11), I've tried no return value, putting that return value at the end (#11), etc. with no luck. All of the variables in the setString() methods are set before calling setString(). Am I at least on the right track with the code shown above? Or have I completely missed it? Thanks again for replying! John Turner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:14 PM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? It's been sometime since I used JDBC and SQL Server. But here are a few points to note: 1) Your first ? is the return status. It should be registered as an OUT parameter. 2) Remember to use the right JDBC type when registering the OUT parameters. This is of utmost importance. 3) All ouput parameters should be registered before the call to the stored proc is made. 4) cstmt.setXXX(questionmark_placeholder_position, value) 5) cstmt.getXXX(questionmark_placeholder_position) 6) If your stored procedure is returning any result set, retrieve all the results before retrieving the OUT parameters. To make sure all the results have been retrieved, use the getMoreResults method. An example
RE: OFF-TOPIC: Pointers to CallableStatement docs?
correct me if I'm wrong, but I count only 10 parameters. in one line you have cstmt.registerOutParameter(11, Types.VARCHAR); where is the 11th parameter? peter lin --- Turner, John [EMAIL PROTECTED] wrote: Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:05 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11
RE: OFF-TOPIC: Pointers to CallableStatement docs?
The 11th is the return_status. Actually, #1 is the return status. According to the CallableStatement docs, you have to account for every ? in your statement. There is 1 return status, 5 input parameters, and 5 output parameters: 1 + 5 + 5 = 11. cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); John Turner -Original Message- From: Peter Lin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 8:07 AM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? correct me if I'm wrong, but I count only 10 parameters. in one line you have cstmt.registerOutParameter(11, Types.VARCHAR); where is the 11th parameter? peter lin --- Turner, John [EMAIL PROTECTED] wrote: Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
BTW: What JDBC driver are you using? We had tried the MS driver and had problems using it with stored procs. We ended up using a 3rd party driver which we had to pay for. Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 6:49 AM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:05 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8
RE: OFF-TOPIC: Pointers to CallableStatement docs?
We're using a thrid-party driver, trial version. It's our third one (the first two, from two other vendors, had even more problems). The cost is over $1000, and there's no support during the trial version. I can't get approval for the money unless I demonstrate that the driver will work. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 8:47 AM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? BTW: What JDBC driver are you using? We had tried the MS driver and had problems using it with stored procs. We ended up using a 3rd party driver which we had to pay for. Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 6:49 AM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:05 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2
Re: OFF-TOPIC: Pointers to CallableStatement docs?
Try this: private static final String SQL_CALL_GETTERMIDS = exec P.dbo.TO_GetTermIDs @term=?,@symbol=?,@side=?,@where=?,@rowcount=?,@num_term_ids=?,@time_in_ms=?; private static final int INIT_IDS_LIST_SIZE = 50; 1,2,3,4 and 5 are input parameters 6 and 7 are output. This is using microsoft sql driver. conn = connPoolMgr.getConnection(); CallableStatement cs = (CallableStatement)connPoolMgr.getUserData(conn); cs.setString(1, request.termId); cs.setString(2, request.symbol); cs.setString(3, request.side); cs.setString(4, request.whereClause); cs.setString(5, request.maxTermIdsReturned); cs.registerOutParameter(6, Types.NUMERIC); cs.registerOutParameter(7, Types.NUMERIC); ResultSet rs = cs.executeQuery(); ArrayList ids = new ArrayList(INIT_IDS_LIST_SIZE); while (rs.next()) { String id = rs.getString(1); ids.add(id); } HTH d. Turner, John wrote: The 11th is the return_status. Actually, #1 is the return status. According to the CallableStatement docs, you have to account for every ? in your statement. There is 1 return status, 5 input parameters, and 5 output parameters: 1 + 5 + 5 = 11. cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); John Turner -Original Message- From: Peter Lin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 8:07 AM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? correct me if I'm wrong, but I count only 10 parameters. in one line you have cstmt.registerOutParameter(11, Types.VARCHAR); where is the 11th parameter? peter lin --- Turner, John [EMAIL PROTECTED] wrote: Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- David Mossakowski [EMAIL PROTECTED] Instinet Corporation 212.310.7275 ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
I don't know if it'll help, but here's one that I use: if ( db.connect() ) { CallableStatement cstmt = db.getConnection().prepareCall( begin delete_record( ?, ?, ?, ? ); end; ); cstmt.setInt( 1, ( ( Integer ) ht.get( teq.ARCHIVE_NBR ) ).intValue() ); cstmt.setString( 2, session.getValue( USERNAME ).toString() ); cstmt.setString( 3, + request.getRemoteAddr() ); cstmt.registerOutParameter( 4, java.sql.Types.VARCHAR ); cstmt.executeUpdate(); result = cstmt.getString( 4 ); deleted = true; cstmt.close(); db.commit(); } The db object is a wrapper that I have around the database connection. Otherwise it should be self-explainitory. Hope this helps some... --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 4:49 AM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks, but I'm not getting any Java-related error messages. The Java code just blows right on through, as everything keys off of the return status, which is always false or negative. This is because the stored procedure never executes, and according to the debug log printed by the driver, it's parameter related...that is, whatever I am doing with set*() and registerOutParameter() doesn't match up with what the procedure is expecting. That's my question...can anyone point me to a resource that shows how to call real-world stored procedures correctly with CallableStatement? By real-world I don't mean rudimentary take two numbers and add them together or get a row from a table procedures, I can already do that. I'm looking for a more advanced tutorial, something that shows how to have inputs, outputs, in/outputs, and a return status, all at once. It must be possible, I just can't figure it out, and can't find any resources that explain how to do it. We have VB DLLs calling these procedures in production, so I know the procedures work, at least in conjunction with VB. John Turner -Original Message- From: Jim Urban [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 5:05 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT
OFF-TOPIC: Pointers to CallableStatement docs?
Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
When you say it returns a status, do you mean it is a function (I work primarily with Oracle, so if this does not apply to MS I apologize)? If so, you need to make the call something like: CallableStatement stmt = conn.prepareCall({call ? = proc(?,?, ... )}); -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:18 PM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
Right. My setup looks like this: cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); Basically, there are 5 inputs (username, password, IP address, browser type, and referer) and I'm supposed to get a return status back (bad or good) and 5 outputs: 3 booleans and 2 strings (isValid, isExceeded, isEnabled, name, and title). I've tried everything I can think of...only having 6 question marks, having all 11, only using 5, etc. to no avail. I enabled debug logging on the driver, and I get messages that say parameter my_parameter not registers as output or not registered as input, even when they are, and regardless of how I use the set*() and registerOutParameter() methods. Very confusing. I'd love to find a complete stored procedures How-To somewhere that addresses complex stored procedures instead of the basic tutorials that do simple math or just insert a row. Thanks for the reply. John -Original Message- From: Wagoner, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:31 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? When you say it returns a status, do you mean it is a function (I work primarily with Oracle, so if this does not apply to MS I apologize)? If so, you need to make the call something like: CallableStatement stmt = conn.prepareCall({call ? = proc(?,?, ... )}); -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:18 PM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
I don't think there is one, it'd be really nice if there was however. There is some good documentation available from Sun, but it doesn't get into real examples (like what you're doing). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 9:18 AM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
There are some docs/sample code at the oracle website (otn) that came in quite handy when I needed it. hope it helps - [EMAIL PROTECTED] -Original Message- From: Mike Jackson [mailto:[EMAIL PROTECTED]] Sent: 19. ágúst 2002 16:59 To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? I don't think there is one, it'd be really nice if there was however. There is some good documentation available from Sun, but it doesn't get into real examples (like what you're doing). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 9:18 AM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
I don't know if it is possible in your case, but have you tried changing the parameter types within the stored procedure to something simple, like all strings? I always just try to get SOMETHING to work, then go from there. ;o) I think I recall Oracle having problems with booleans a while back so I reverted to integers (1 and 0). Maybe this is actually a JDBC thing, in which case you may be experiencing the same issue. From the little bit of DB/2 work I have done I know IBM's error messages will lead you to believe the number of parameters do not match, when in fact the problem is the parameter types. Again, just something to test. -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:53 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Right. My setup looks like this: cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); Basically, there are 5 inputs (username, password, IP address, browser type, and referer) and I'm supposed to get a return status back (bad or good) and 5 outputs: 3 booleans and 2 strings (isValid, isExceeded, isEnabled, name, and title). I've tried everything I can think of...only having 6 question marks, having all 11, only using 5, etc. to no avail. I enabled debug logging on the driver, and I get messages that say parameter my_parameter not registers as output or not registered as input, even when they are, and regardless of how I use the set*() and registerOutParameter() methods. Very confusing. I'd love to find a complete stored procedures How-To somewhere that addresses complex stored procedures instead of the basic tutorials that do simple math or just insert a row. Thanks for the reply. John -Original Message- From: Wagoner, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:31 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? When you say it returns a status, do you mean it is a function (I work primarily with Oracle, so if this does not apply to MS I apologize)? If so, you need to make the call something like: CallableStatement stmt = conn.prepareCall({call ? = proc(?,?, ... )}); -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:18 PM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
It's been sometime since I used JDBC and SQL Server. But here are a few points to note: 1) Your first ? is the return status. It should be registered as an OUT parameter. 2) Remember to use the right JDBC type when registering the OUT parameters. This is of utmost importance. 3) All ouput parameters should be registered before the call to the stored proc is made. 4) cstmt.setXXX(questionmark_placeholder_position, value) 5) cstmt.getXXX(questionmark_placeholder_position) 6) If your stored procedure is returning any result set, retrieve all the results before retrieving the OUT parameters. To make sure all the results have been retrieved, use the getMoreResults method. An example: -- TestAdd proc adds two numbers. It returns a status of 1 is the any one of the input parameters is less than 0. It returns a status of 0 if the add worked and it also returns a result of the addition. Stored proc: - create procedure TestAdd @param1 int, @param2 int, @param3 int output as begin if @param1 0 and @param2 0 begin return 1 end else begin select @param3 = @param1 + @param2 return 0 end end Java code: CallableStatement cstmttmt = con.prepareCall({? = call TestAdd(?, ?, ?)} ); cstmt.registerOutParameter(1, Types.INTEGER); cstmt.setInt(2, 10); cstmt.setInt(3, 20); cstmt.registerOutParameter(4, Types.INTEGER); cstmt.execute(); System.out.println(status : + cstmt.getInt(1)); System.out.println(value after adding 10 and 20 : + cstmt.getInt(4)); Hope this helps. RS Turner, John [EMAIL PROTECTED]To: 'Tomcat Users List' [EMAIL PROTECTED] 08/19/02 11:53 AMcc: Please respond toSubject: RE: OFF-TOPIC: Pointers to CallableStatement Tomcat Users docs? List Right. My setup looks like this: cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); Basically, there are 5 inputs (username, password, IP address, browser type, and referer) and I'm supposed to get a return status back (bad or good) and 5 outputs: 3 booleans and 2 strings (isValid, isExceeded, isEnabled, name, and title). I've tried everything I can think of...only having 6 question marks, having all 11, only using 5, etc. to no avail. I enabled debug logging on the driver, and I get messages that say parameter my_parameter not registers as output or not registered as input, even when they are, and regardless of how I use the set*() and registerOutParameter() methods. Very confusing. I'd love to find a complete stored procedures How-To somewhere that addresses complex stored procedures instead of the basic tutorials that do simple math or just insert a row. Thanks for the reply. John -Original Message- From: Wagoner, Mark [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:31 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? When you say it returns a status, do you mean it is a function (I work primarily with Oracle, so if this does not apply to MS I apologize)? If so, you need to make the call something like: CallableStatement stmt = conn.prepareCall({call ? = proc(?,?, ... )}); -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:18 PM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand
RE: OFF-TOPIC: Pointers to CallableStatement docs?
Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt = null; I've tried different calls, putting the output parameters first (2-6) and the inputs last (7-11), I've tried no return value, putting that return value at the end (#11), etc. with no luck. All of the variables in the setString() methods are set before calling setString(). Am I at least on the right track with the code shown above? Or have I completely missed it? Thanks again for replying! John Turner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:14 PM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? It's been sometime since I used JDBC and SQL Server. But here are a few points to note: 1) Your first ? is the return status. It should be registered as an OUT parameter. 2) Remember to use the right JDBC type when registering the OUT parameters. This is of utmost importance. 3) All ouput parameters should be registered before the call to the stored proc is made. 4) cstmt.setXXX(questionmark_placeholder_position, value) 5) cstmt.getXXX(questionmark_placeholder_position) 6) If your stored procedure is returning any result set, retrieve all the results before retrieving the OUT parameters. To make sure all the results have been retrieved, use the getMoreResults method. An example: -- TestAdd proc adds two numbers. It returns a status of 1 is the any one of the input parameters is less than 0. It returns a status of 0 if the add worked and it also returns a result of the addition. Stored proc: - create procedure TestAdd @param1 int, @param2 int, @param3 int output as begin if @param1 0 and @param2 0 begin return 1 end else begin select @param3 = @param1 + @param2 return 0 end end Java code: CallableStatement cstmttmt = con.prepareCall({? = call TestAdd(?, ?, ?)} ); cstmt.registerOutParameter(1, Types.INTEGER); cstmt.setInt(2, 10); cstmt.setInt(3, 20); cstmt.registerOutParameter(4, Types.INTEGER); cstmt.execute(); System.out.println(status : + cstmt.getInt(1)); System.out.println(value after adding 10 and 20 : + cstmt.getInt(4)); Hope this helps. RS Turner, John [EMAIL PROTECTED]To: 'Tomcat Users List' [EMAIL PROTECTED] 08/19/02 11:53 AMcc: Please respond toSubject: RE: OFF-TOPIC: Pointers to CallableStatement Tomcat Users docs? List Right. My setup looks like this: cstmt
RE: OFF-TOPIC: Pointers to CallableStatement docs?
What error are you receiving? Can you post a stack trace and a code clip with line numbers so we can see what is failing? Jim Urban - [EMAIL PROTECTED] Park City Solutions Inc. Clinical Connectivity Suite Product Manager Suite 295 500 Park Blvd. Itasca, IL 60143 Voice: (630) 250-3045 x106 Fax: (630) 250-3046 CONFIDENTIALITY NOTICE This message and any included attachments are from Park City Solutions Inc. and are intended only for the entity to which it is addressed. The contained information is confidential and privileged material. If you are not the intended recipient, you are hereby notified that any use, dissemination, or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error please notify the sender of the delivery error by e-mail or call Park City Solutions Inc. corporate offices at (435) 654-0621 -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 1:27 PM To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt = null; I've tried different calls, putting the output parameters first (2-6) and the inputs last (7-11), I've tried no return value, putting that return value at the end (#11), etc. with no luck. All of the variables in the setString() methods are set before calling setString(). Am I at least on the right track with the code shown above? Or have I completely missed it? Thanks again for replying! John Turner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:14 PM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? It's been sometime since I used JDBC and SQL Server. But here are a few points to note: 1) Your first ? is the return status. It should be registered as an OUT parameter. 2) Remember to use the right JDBC type when registering the OUT parameters. This is of utmost importance. 3) All ouput parameters should be registered before the call to the stored proc is made. 4) cstmt.setXXX(questionmark_placeholder_position, value) 5) cstmt.getXXX(questionmark_placeholder_position) 6) If your stored procedure is returning any result set, retrieve all the results before retrieving the OUT parameters. To make sure all the results have been retrieved, use the getMoreResults method. An example: -- TestAdd proc adds two numbers. It returns a status of 1 is the any one of the input parameters is less than 0. It returns a status of 0 if the add worked and it also returns a result of the addition. Stored proc: - create
RE: OFF-TOPIC: Pointers to CallableStatement docs?
I don't have it here at the moment, but I think the WROK book Java DATA does a good job on this. I will check tonight. It's on my boat. At 09:59 AM 8/19/2002 -0700, you wrote: I don't think there is one, it'd be really nice if there was however. There is some good documentation available from Sun, but it doesn't get into real examples (like what you're doing). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 9:18 AM To: '[EMAIL PROTECTED]' Subject: OFF-TOPIC: Pointers to CallableStatement docs? Hello - I think there is a java-user list, or even a jdbc-interest list, but I'd rather not subscribe when all I need is one quick pointer, so I am hoping someone on this list can get me started. I'm having quite a bit of difficulty working with stored procedures in my classes and servlets. The database is MS SQL Server 2000. I've read every single doc I can find, both at Sun, through Google, and even through the driver vendor's documentation. I even scammed some code from a JDBC 3.0 book (the only one I could find) at Border's, with still no luck. Can anyone point me to a resource that explains how to setup stored procedures in a CallableStatement correctly? I understand about registering the output parameters and setting the input types, and I understand that the parameters in a CallableStatement are numbered from left to right starting at 1. I've seen the examples at Sun, etc. but they're not much help. The problem is that all of the examples I can find deal with very simple, very rudimentary stored procedures, like finding the average of two numbers, or whatever. Our stored procedures are more involved than that. Example: a stored procedure used to validate logins. It has 5 input parameters, and 5 output parameters. It returns a status. According to the docs I have read so far, that means I should have a CallableStatement with 11 question marks (?) in it (5 + 5 + 1 = 11). but that doesn't work, and I have tried every combination of inputs, outputs, input/outputs, etc. that I can think of, to no avail. Any help or pointers to resources that explain stored procedures and CallableStatements in more in-depth fashion would be greatly appreciated. - John John Turner [EMAIL PROTECTED] | 248-488-3466 Advertising Audit Service http://www.aas.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: OFF-TOPIC: Pointers to CallableStatement docs?
Hi, I would first like to say, your code looks ok. I dont think it matters in what order you set the parameters. Are you calling a procedure or a function, I've had some problems with functions, in my experince a function must have a OutParameter in the no. 1 param. which errors do you get ? The stored-procedure-call should return an exception with errorcode / messages from the database-server or the jdbc-driver. So, if you want us to be able to help, I think an error message could be very helpfull. below is a sample of a working code, that calls stored procedure in oracle, I guess it's a bit different, as the oracle driver has it's own datatypes. regards, [EMAIL PROTECTED] String outParamTypeName = PACKAGENAME.NAMESLIST; String inParamTypeName = PACKAGENAME.NAMES; try { String call = {call package.name.Procedure(?,?,?,?)}; ArrayDescriptor arrayDesc = new ArrayDescriptor (inParamTypeName, m_connection); oracle.sql.ARRAY array = new oracle.sql.ARRAY(arrayDesc, m_connection, arrayValues); oracle.jdbc.driver.OracleCallableStatement cs = (oracle.jdbc.driver.OracleCallableStatement) m_connection.prepareCall(call); Calendar c = Calendar.getInstance(); java.util.Date d = c.getTime(); java.sql.Date dags= new java.sql.Date( d.getTime() ); oracle.sql.NUMBER update = new oracle.sql.NUMBER (parm_update); cs.setARRAY(1,array); cs.setDate(2,dags); cs.registerOutParameter(3,OracleTypes.ARRAY,outParamTypeName); cs.setNUMBER(4,update); cs.execute(); resultArray = cs.getARRAY(3); Object[] names_list = (Object []) resultArray.getArray(); for (int y=0;y!=names_list.length;y++) { BigDecimal LastValue=null; BigDecimal firstValue=null; Struct l_objstruct = (Struct)names_list[y]; // get the attributes in the STRUCT l_objstruct Object l_objval[] = l_objstruct.getAttributes(); // Retrieve individual attributes if (l_objval[2]!=null) {LastValue = ((BigDecimal) l_objval[2]);} if (l_objval[3]!=null) {firstValue= ((BigDecimal) l_objval[3]);} // output the outcome out.write( number.format(LastValue.setScale(2, BigDecimal.ROUND_HALF_UP))); out.write( number.format(firstValue.setScale(2, BigDecimal.ROUND_HALF_UP))); } // close database connection m_connection.close(); } catch(Exception e) { out.write(font color=redpre+ e.toString() + /pre/font); } -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: 19. ágúst 2002 18:27 To: 'Tomcat Users List' Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt
RE: OFF-TOPIC: Pointers to CallableStatement docs?
Is my_parameter a variable or is that like a placeholder in the email for pwdvalid, etc? quote I enabled debug logging on the driver, and I get messages that say parameter my_parameter not registers as output or not registered as input, even when they are, and regardless of ... /quote Your code looks allright. Could you write a simple proc, something like the example I detailed below. And then call it from java. RS Turner, John [EMAIL PROTECTED]To: 'Tomcat Users List' [EMAIL PROTECTED] 08/19/02 01:26 PMcc: Please respond toSubject: RE: OFF-TOPIC: Pointers to CallableStatement Tomcat Users docs? List Thanks! I've set up my code as you've described, but no luck. For example, here is the relevant portion of the stored procedure declaring the parameters (forgive me, I don't work with stored procedures that often, so this may not be the right portion of the procedure to focus on): @userid_in varchar(8), @password_in varchar(8), @ip_addr varchar(15), @http_referer varchar(80), @http_user_agent varchar(80), @pwdvalid bit OUTPUT, @userenabled bit OUTPUT, @graceexceeded bit OUTPUT, @adminuser char(1) OUTPUT, @title varchar(4) OUTPUT My code looks like this: // prepare the stored procedure statement try { cstmt = sConn.prepareCall({? = call sp_validate_pwd(?,?,?,?,?,?,?,?,?,?)}); } catch (SQLException sqle) { sqle.printStackTrace(); } // set the input parameters try { cstmt.setString(2, strUserID); cstmt.setString(3, strPassword); cstmt.setString(4, strRemoteAddress); cstmt.setString(5, strReferURL); cstmt.setString(6, strHTTPUserAgent); } catch (Exception e) { e.printStackTrace(); } // register the output parameters for the stored procedure try { cstmt.registerOutParameter(1, Types.INTEGER); cstmt.registerOutParameter(7, Types.BIT); cstmt.registerOutParameter(8, Types.BIT); cstmt.registerOutParameter(9, Types.BIT); cstmt.registerOutParameter(10, Types.CHAR); cstmt.registerOutParameter(11, Types.VARCHAR); } catch (Exception e) { e.printStackTrace(); } // execute the stored procedure try { cstmt.execute(); } catch (SQLException sqle) { sqle.printStackTrace(); } // grab the results from the stored procedure call try { spReturnStatus = cstmt.getInt(1); isValid = cstmt.getBoolean(7); isEnabled = cstmt.getBoolean(8); isExceeded = cstmt.getBoolean(9); strAdmin = cstmt.getString(10); strTitle = cstmt.getString(11); } catch (SQLException sqle) { sqle.printStackTrace(); } cstmt = null; I've tried different calls, putting the output parameters first (2-6) and the inputs last (7-11), I've tried no return value, putting that return value at the end (#11), etc. with no luck. All of the variables in the setString() methods are set before calling setString(). Am I at least on the right track with the code shown above? Or have I completely missed it? Thanks again for replying! John Turner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:14 PM To: Tomcat Users List Subject: RE: OFF-TOPIC: Pointers to CallableStatement docs? It's been sometime since I used JDBC and SQL Server. But here are a few points to note: 1) Your first ? is the return status. It should be registered as an OUT parameter. 2) Remember to use the right JDBC type when registering the OUT parameters. This is of utmost importance. 3) All ouput parameters should be registered before the call to the stored proc is made. 4) cstmt.setXXX(questionmark_placeholder_position, value) 5) cstmt.getXXX(questionmark_placeholder_position) 6) If your
Docs for Apache 2 / Tomcat 4 integration
Through the advice on this list, I have installed on my WinNT server Apache 2.0.39, Tomcat 4.1.8, and J2SDK 1.3. I have successfully tested each of the 3 independently. My question is where is simple instructions on how to configure the Apache-Tomcat communication (is that what the mod_jk2.dll is for?). All I want at this point is something that says edit this, restart that and be done (if it exists). Thanks, Kenny -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Docs for Apache 2 / Tomcat 4 integration
As if it were that simple... :) Here's a starter: http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg59593.html - Andrew -Original Message- From: Kenny G. Dubuisson, Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:29 PM To: [EMAIL PROTECTED] Subject: Docs for Apache 2 / Tomcat 4 integration Through the advice on this list, I have installed on my WinNT server Apache 2.0.39, Tomcat 4.1.8, and J2SDK 1.3. I have successfully tested each of the 3 independently. My question is where is simple instructions on how to configure the Apache-Tomcat communication (is that what the mod_jk2.dll is for?). All I want at this point is something that says edit this, restart that and be done (if it exists). Thanks, Kenny -- To unsubscribe, e-mail: mailto:tomcat-user- [EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Need help deciphering the docs for Host/
Hello, The docs say that the Host tag can take a deployXML attribute, and has the following explanation: Set to false if you want to disable deploying applications using a Context XML config file. Applications are deployed with the security permissions of catalina, for security this may need to be set to false if untrusted users can manage web applications. The flag's value defaults to true. (From http://jakarta.apache.org/tomcat/tomcat-4.1-doc/config/host.html#Standard%20Implementation) What is meant by 'a Context XML config file'? Is this a deployment descriptor? (A web.xml) Something different? Also, I noticed that the server.xml file doesn't have the standard XML preamble (No ?xml? tag, and no DTD reference.) Is there a DTD for this file, or is it more of an ad hoc kind of thing? Should I be asking this on the developer list instead? Let me know. (I always try to ask stuff on the user list first, as a courtesy, but this seems like it might be more a developer list question.) Thanks in advance! -Ian -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Need help deciphering the docs for Host/
On Thu, 18 Jul 2002, Ian McFarland wrote: Date: Thu, 18 Jul 2002 19:56:19 -0700 From: Ian McFarland [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Cc: Ian McFarland [EMAIL PROTECTED] Subject: Need help deciphering the docs for Host/ Hello, The docs say that the Host tag can take a deployXML attribute, and has the following explanation: Set to false if you want to disable deploying applications using a Context XML config file. Applications are deployed with the security permissions of catalina, for security this may need to be set to false if untrusted users can manage web applications. The flag's value defaults to true. (From http://jakarta.apache.org/tomcat/tomcat-4.1-doc/config/host.html#Standard%20Implementation) What is meant by 'a Context XML config file'? Is this a deployment descriptor? (A web.xml) Something different? In Tomcat 4.1.x, you can take the Context element (and it's nested elements) out of server.xml and manage them in a separate file called a context config file. If one of these files is found in the webapps directory, that application will get deployed with a configuration based on the contents of this file, just as if it had been embedded inside the Host element in server.xml. In the 4.1.7 beta release, for example, the admin and manager webapps are deployed in this way. Also, I noticed that the server.xml file doesn't have the standard XML preamble (No ?xml? tag, and no DTD reference.) Is there a DTD for this file, or is it more of an ad hoc kind of thing? Should I be asking this on the developer list instead? Let me know. (I always try to ask stuff on the user list first, as a courtesy, but this seems like it might be more a developer list question.) There should probably be an ?xml? tag at the top. For DTDs, however, there is not and cannot be one. The challenge is that you can define your own implementation classes for many elements (including Valve, just to take one example), and your implementation class might have a set of JavaBeans properties to configure it. If you built a DTD for server.xml, the information about the Valve element would not list the attributes for the properties supported by your Valve class. Thanks in advance! -Ian Craig -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
can't build jakarta-tomcat-4.0/webapps/tomcat-docs/
I guess i need to specify to use trax or xalan, and not the xslp stuff. where? I did not see an entry in the j-t-4.0/build.properties (.sample) file? build-main: [style] DEPRECATED - xslp processor is deprecated. Use trax or xalan instead . [style] java.lang.NoClassDefFoundError: com/kvisco/xsl/XSLProcessor [style] at org.apache.tools.ant.taskdefs.optional.XslpLiaison.init(Xsl pLiaison.java:80) [style] at java.lang.Class.newInstance0(Native Method) [style] at java.lang.Class.newInstance(Class.java:237) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.resolveProcessor(XS LTProcess.java:367) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.getLiaison(XSLTProc ess.java:546) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.execute(XSLTProcess .java:192) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:357) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:357) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.Project.executeTargets(Project.java:1160 ) [style] at org.apache.tools.ant.Main.runBuild(Main.java:605) [style] at org.apache.tools.ant.Main.start(Main.java:195) [style] at org.apache.tools.ant.Main.main(Main.java:234) [style] java.lang.NoClassDefFoundError: org/apache/xalan/xslt/XSLTProcessorF actory [style] at org.apache.tools.ant.taskdefs.optional.XalanLiaison.init(Xa lanLiaison.java:84) [style] at java.lang.Class.newInstance0(Native Method) [style] at java.lang.Class.newInstance(Class.java:237) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.resolveProcessor(XS LTProcess.java:370) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.getLiaison(XSLTProc ess.java:543) [style] at org.apache.tools.ant.taskdefs.XSLTProcess.execute(XSLTProcess .java:192) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:357) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:357) [style] at org.apache.tools.ant.Task.perform(Task.java:313) [style] at org.apache.tools.ant.Target.execute(Target.java:309) [style] at org.apache.tools.ant.Target.performTasks(Target.java:334) [style] at org.apache.tools.ant.Project.executeTarget(Project.java:1216) [style] at org.apache.tools.ant.Project.executeTargets(Project.java:1160 ) [style] at org.apache.tools.ant.Main.runBuild(Main.java:605) [style] at org.apache.tools.ant.Main.start(Main.java:195) [style] at org.apache.tools.ant.Main.main(Main.java:234) BUILD FAILED D:\Test\jakarta\cvs\jakarta-tomcat-4.0\webapps\tomcat-docs\build.xml:80: java.la ng.NoClassDefFoundError: javax/xml/transform/ErrorListener -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Download of MS Office docs from protected areas fail with IE
Hi, when I try to download files with MS Word (for example: https://test.iwka.de/protectedarea/test.doc) from a protected area with a MS IE 5.5 I get the error the internet page could not be opened. File not found or not reachable. When I try to download it from a non protected area it works. I have a special hardware constellation: I have an application server with tomcat 4.0.2 with the standard HTTP 1.1 connector. And there is another box wich does hardware SSL encryption. Because of the SSL encryption I have defined the HTTP Connector like that: Connector className=org.apache.catalina.connector.http.HttpConnector port=80 minProcessors=1 maxProcessors=200 redirectPort=443 scheme=https acceptCount=20 debug=0 secure=true proxyPort=443 / So, now to the courius things: - With tomcat 4.0.1 it WORKS! - When I try it without the SSL encryption it works - With an other browser (mozilla...) it works I have looked in the lock files, watched the network traffic with a network monitor and so on. I see no differences but something happend with tomcat 4.0.2 so that it didn't work any more. Any ideas? Martin -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
3.2 serving 3.3's DOCs
I have the TOMCAT_HOME variable set to the v 3.2 installation directory now, and Tomcat is showing me the v 3.3 documents. Since the document tree is entirely separate, and I am not even running Apache, I can't imagine how this is happening. Any clues anyone? Joel Rees -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: 3.2 serving 3.3's DOCs
Browser cache. You'd think I _enjoyed_ making a fool of myself in MLs. Sorry for the more static. Joel - Original Message - I have the TOMCAT_HOME variable set to the v 3.2 installation directory now, and Tomcat is showing me the v 3.3 documents. Since the document tree is entirely separate, and I am not even running Apache, I can't imagine how this is happening. Any clues anyone? Joel Rees -- 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]
RE: tomcat 4.0.1 shortname(non-8.3) CATALINA_HOME (subj docs)
I think I'm experiencing some of the problems you are talking about, I let the defaults decide where and how my apache and Tomcat were installed, so I've got things like C:/Program Files/Apache Group/Apache/* C:/Program Files/Apache Tomcat 4.0/* I wanted to use the short names in my conf files but I'm not aware of the naming convention and how it works (8.3???) where can I read up on this?? TIA Mike -Original Message- From: David C. Hochrein [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 08, 2001 2:39 PM To: Tomcat Users List Subject: tomcat 4.0.1 shortname(non-8.3) CATALINA_HOME Hello All, I'm seeing some odd behavior with Tomcat 4.0.1 on NT/2k and installation directories containing anything greater than 8.3 naming. I'd like to know if anyone else has seen this or if perhaps this is a known issue. I originally noticed this problem because the examples manager webapps would always result in 404 errors whenever Tomcat 4.0.1 was installed into a non-8.3 directory (ie any directory that has a corresponding short name with ~. with or without spaces -- doesn't matter). Everything else worked great -- my application was working just fine. In tracking this down, I found the following entry in the log files: 2001-12-05 18:22:44 ContextConfig[/manager]: Missing application web.xml, using defaults only ... 2001-12-05 18:23:17 ContextConfig[/examples]: Missing application web.xml, using defaults only And, after some testing, I found that the non-8.3 installation directory was causing the problem. So, I assumed that a longname was being used somewhere that it shouldn't be and went about tracking it down. I intended to then convert it to the short name and all would be well. Unfortunately, I found that short names were being used correctly everywhere and the problem still existed. At this point, I've boiled this down to the following test case(s). 1. Take a 4.0.1 binary release (zip file). Copy the contents to C:\123456789. Setup CATALINA_HOME to it's shortname version: (probably C:\123456~1). Run bin\startup.bat. Notice the 404 errors for the examples manager webapps. Run bin\shutdown.bat to stop Tomcat. 2. Now, copy the 4.0.1 binary release to C:\12345678. Setup CATALINA HOME again (it can now be just C:\12345678). Run the bin\startup.bat again. Now, notice that the examples manager webapps work just fine. Very strange. It seems as though shortname versions (including ~) of longnames for the installation directory *cannot* be used for CATALINA_HOME because Tomcat 4.0.1 doesn't like it. (In fact, if you set CATALINA_HOME to the full C:\123456789 path for the first case, this also resolves the issue.) Finally, I grabbed a nightly build from 12/7 and this problem no longer appears to exist on the development codebase. So, it looks like this was a known issue that has been resolved or perhaps it's resolution is a side effect of some other changes. The problem I still have is that my configuration code converts everything to shortnames (which is usually the proper thing to do). But, in this case, it is causing Tomcat to fail. I guess I can use the longname for CATALINA_HOME -- it just seems a strange thing to have to do. Anyone else see this or have any thoughts? Dave -- 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]
RE: tomcat 4.0.1 shortname(non-8.3) CATALINA_HOME (subj docs)
Hi, Right click the C:/Program Files/Apache Group/Apache/ folder in Windows Explorer and choose to view the properties. Among many listed is one called MSDOS Name. This is the one that you need. Now use this where ever you need to mention folder names etc. Sriram 09/12/2001 12:03:20 PM, Mike Kelley [EMAIL PROTECTED] wrote: I think I'm experiencing some of the problems you are talking about, I let the defaults decide where and how my apache and Tomcat were installed, so I've got things like C:/Program Files/Apache Group/Apache/* C:/Program Files/Apache Tomcat 4.0/* I wanted to use the short names in my conf files but I'm not aware of the naming convention and how it works (8.3???) where can I read up on this?? TIA Mike -Original Message- _ 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]
Solaris VM crash? Full docs included
Hi there, So last night the JVM crashed on one of our big servers. It had been running without a problem for a while, but we've been experimenting with tuning garbage collection, as this particular JVM is typically around ~400MB in memory during the day. Here are the details (sorry for this long message, but I know it's a pointless question without all the details I can provide). Tomcat: 4.0.1 ($JAVA_HOME = /dvl/info/prj/infra/jdk1.3.1) JVM: Sun JVM v1.3.1-b24 for Solaris Server uname -a output: SunOS serverName 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-Enterprise (The server is a 12-CPU, 2GB RAM, big machine, and it had plenty of available memory, CPU usage was low all night without any spikes, nothing suspicious) (Java runtime parameters below) Relevant catalina.out section: --- Unexpected Signal : 11 occurred at PC=0xfe0c7d18 Function name=JVM_ArrayCopy Library=/dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so Current Java thread: Dynamic libraries: 0x1 /dvl/info/prj/infra/jdk1.3.1/bin/../bin/sparc/native_threads/jav a 0xff35 /usr/lib/libthread.so.1 0xff39 /usr/lib/libdl.so.1 0xff20 /usr/lib/libc.so.1 0xff33 /usr/platform/SUNW,Ultra-Enterprise/lib/libc_psr.so.1 0xfe00 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so 0xff2d /usr/lib/libCrun.so.1 0xff1e /usr/lib/libsocket.so.1 0xff10 /usr/lib/libnsl.so.1 0xff0d /usr/lib/libm.so.1 0xff30 /usr/lib/libw.so.1 0xff0b /usr/lib/libmp.so.2 0xff08 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/native_threads/libhpi .so 0xff05 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libverify.so 0xfe7c /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libjava.so 0xff02 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libzip.so 0xfccd /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libnet.so 0xfccb /usr/lib/nss_files.so.1 0xda3e /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libawt.so 0xd668 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/motif21/libmawt.so 0xda39 /dvl/info/prj/infra/jdk1.3.1/bin/../jre/lib/sparc/libmlib_image. so 0xd640 /usr/dt/lib/libXm.so.4 0xd9c9 /usr/openwin/lib/libXt.so.4 0xda15 /usr/openwin/lib/libXext.so.0 0xda13 /usr/openwin/lib/libXtst.so.1 0xd740 /usr/openwin/lib/libX11.so.4 0xd9ee /usr/openwin/lib/libSM.so.6 0xd97d /usr/openwin/lib/libICE.so.6 0xd97a /usr/openwin/lib/libdga.so.1 0xd630 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libfontmanager.so 0xd942 /usr/openwin/lib/libdps.so.5 Local Time = Thu Dec 6 06:50:32 2001 Elapsed Time = 24574 # # HotSpot Virtual Machine Error : 11 # Error ID : 4F530E43505002CC 01 # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Server VM (1.3.1-b24 mixed mode) # # An error report file has been saved as hs_err_pid15459.log. # Please refer to the file for further information. # - End catalina.out excerpt - The error report file hs_err_pid15459.log contains a verbatim copy of the above, no additional information. Needless to say, the server died immediately, which I suppose is OK to expect from Tomcat given such an internal JVM crash. So no complaints, I'm just wondering if anyone has seen this crash before? My theory is that it had to do with us slightly tweaking the Java runtime parameters we'd been using, in an effort to improve garbage collection on the machine. Previous CATALINA_OPTS= CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -XX:NewRatio=1 -verbose:gc' New ones, started last night, that probably caused the error: CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -Xincgc -verbose:gc -XX:MaxNewSize=100m -XX:NewSize=10m' I realize this is as much a question to Sun as to tomcat-users, so I'm reporting this bug there as well. Thanks in advance for any ideas, Yoav -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
AW: Solaris VM crash? Full docs included
Is completely a question to sun. I suspect that it is a bug in the incremental gc. May be you should upgrade to JVM 1.3.1_01 There two bugs fixed that might help you: (Don't know if this changes where between v1.3.1-b24 and 1.3.1_01) http://developer.java.sun.com/developer/bugParade/bugs/4469343.html (Might solve the problem) http://developer.java.sun.com/developer/bugParade/bugs/4450681.html (Might give better information what caused the signal) -Ursprüngliche Nachricht- Von: Yoav Shapira [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Dezember 2001 15:30 An: Tomcat Users List Betreff: Solaris VM crash? Full docs included Hi there, So last night the JVM crashed on one of our big servers. It had been running without a problem for a while, but we've been experimenting with tuning garbage collection, as this particular JVM is typically around ~400MB in memory during the day. Here are the details (sorry for this long message, but I know it's a pointless question without all the details I can provide). Tomcat: 4.0.1 ($JAVA_HOME = /dvl/info/prj/infra/jdk1.3.1) JVM: Sun JVM v1.3.1-b24 for Solaris Server uname -a output: SunOS serverName 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-Enterprise (The server is a 12-CPU, 2GB RAM, big machine, and it had plenty of available memory, CPU usage was low all night without any spikes, nothing suspicious) (Java runtime parameters below) Relevant catalina.out section: --- Unexpected Signal : 11 occurred at PC=0xfe0c7d18 Function name=JVM_ArrayCopy Library=/dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so Current Java thread: Dynamic libraries: 0x1 /dvl/info/prj/infra/jdk1.3.1/bin/../bin/sparc/native_threads/jav a 0xff35 /usr/lib/libthread.so.1 0xff39 /usr/lib/libdl.so.1 0xff20 /usr/lib/libc.so.1 0xff33 /usr/platform/SUNW,Ultra-Enterprise/lib/libc_psr.so.1 0xfe00 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so 0xff2d /usr/lib/libCrun.so.1 0xff1e /usr/lib/libsocket.so.1 0xff10 /usr/lib/libnsl.so.1 0xff0d /usr/lib/libm.so.1 0xff30 /usr/lib/libw.so.1 0xff0b /usr/lib/libmp.so.2 0xff08 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/native_threads/libhpi .so 0xff05 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libverify.so 0xfe7c /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libjava.so 0xff02 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libzip.so 0xfccd /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libnet.so 0xfccb /usr/lib/nss_files.so.1 0xda3e /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libawt.so 0xd668 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/motif21/libmawt.so 0xda39 /dvl/info/prj/infra/jdk1.3.1/bin/../jre/lib/sparc/libmlib_image. so 0xd640 /usr/dt/lib/libXm.so.4 0xd9c9 /usr/openwin/lib/libXt.so.4 0xda15 /usr/openwin/lib/libXext.so.0 0xda13 /usr/openwin/lib/libXtst.so.1 0xd740 /usr/openwin/lib/libX11.so.4 0xd9ee /usr/openwin/lib/libSM.so.6 0xd97d /usr/openwin/lib/libICE.so.6 0xd97a /usr/openwin/lib/libdga.so.1 0xd630 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libfontmanager.so 0xd942 /usr/openwin/lib/libdps.so.5 Local Time = Thu Dec 6 06:50:32 2001 Elapsed Time = 24574 # # HotSpot Virtual Machine Error : 11 # Error ID : 4F530E43505002CC 01 # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Server VM (1.3.1-b24 mixed mode) # # An error report file has been saved as hs_err_pid15459.log. # Please refer to the file for further information. # - End catalina.out excerpt - The error report file hs_err_pid15459.log contains a verbatim copy of the above, no additional information. Needless to say, the server died immediately, which I suppose is OK to expect from Tomcat given such an internal JVM crash. So no complaints, I'm just wondering if anyone has seen this crash before? My theory is that it had to do with us slightly tweaking the Java runtime parameters we'd been using, in an effort to improve garbage collection on the machine. Previous CATALINA_OPTS= CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -XX:NewRatio=1 -verbose:gc' New ones, started last night, that probably caused the error: CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -Xincgc -verbose:gc -XX:MaxNewSize=100m -XX:NewSize=10m' I realize this is as much a question to Sun as to tomcat-users, so I'm reporting this bug there as well. Thanks in advance for any ideas, Yoav -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL
Re: AW: Solaris VM crash? Full docs included
Hi, Thanks a bunch for the quick reply. It seems relevant and I'll try updating the system. Yoav Ralph Einfeldt wrote: Is completely a question to sun. I suspect that it is a bug in the incremental gc. May be you should upgrade to JVM 1.3.1_01 There two bugs fixed that might help you: (Don't know if this changes where between v1.3.1-b24 and 1.3.1_01) http://developer.java.sun.com/developer/bugParade/bugs/4469343.html (Might solve the problem) http://developer.java.sun.com/developer/bugParade/bugs/4450681.html (Might give better information what caused the signal) -Ursprüngliche Nachricht- Von: Yoav Shapira [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Dezember 2001 15:30 An: Tomcat Users List Betreff: Solaris VM crash? Full docs included Hi there, So last night the JVM crashed on one of our big servers. It had been running without a problem for a while, but we've been experimenting with tuning garbage collection, as this particular JVM is typically around ~400MB in memory during the day. Here are the details (sorry for this long message, but I know it's a pointless question without all the details I can provide). Tomcat: 4.0.1 ($JAVA_HOME = /dvl/info/prj/infra/jdk1.3.1) JVM: Sun JVM v1.3.1-b24 for Solaris Server uname -a output: SunOS serverName 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-Enterprise (The server is a 12-CPU, 2GB RAM, big machine, and it had plenty of available memory, CPU usage was low all night without any spikes, nothing suspicious) (Java runtime parameters below) Relevant catalina.out section: --- Unexpected Signal : 11 occurred at PC=0xfe0c7d18 Function name=JVM_ArrayCopy Library=/dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so Current Java thread: Dynamic libraries: 0x1 /dvl/info/prj/infra/jdk1.3.1/bin/../bin/sparc/native_threads/jav a 0xff35 /usr/lib/libthread.so.1 0xff39 /usr/lib/libdl.so.1 0xff20 /usr/lib/libc.so.1 0xff33 /usr/platform/SUNW,Ultra-Enterprise/lib/libc_psr.so.1 0xfe00 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/server/libjvm.so 0xff2d /usr/lib/libCrun.so.1 0xff1e /usr/lib/libsocket.so.1 0xff10 /usr/lib/libnsl.so.1 0xff0d /usr/lib/libm.so.1 0xff30 /usr/lib/libw.so.1 0xff0b /usr/lib/libmp.so.2 0xff08 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/native_threads/libhpi .so 0xff05 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libverify.so 0xfe7c /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libjava.so 0xff02 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libzip.so 0xfccd /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libnet.so 0xfccb /usr/lib/nss_files.so.1 0xda3e /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libawt.so 0xd668 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/motif21/libmawt.so 0xda39 /dvl/info/prj/infra/jdk1.3.1/bin/../jre/lib/sparc/libmlib_image. so 0xd640 /usr/dt/lib/libXm.so.4 0xd9c9 /usr/openwin/lib/libXt.so.4 0xda15 /usr/openwin/lib/libXext.so.0 0xda13 /usr/openwin/lib/libXtst.so.1 0xd740 /usr/openwin/lib/libX11.so.4 0xd9ee /usr/openwin/lib/libSM.so.6 0xd97d /usr/openwin/lib/libICE.so.6 0xd97a /usr/openwin/lib/libdga.so.1 0xd630 /dvl/info/prj/infra/jdk1.3.1/jre/lib/sparc/libfontmanager.so 0xd942 /usr/openwin/lib/libdps.so.5 Local Time = Thu Dec 6 06:50:32 2001 Elapsed Time = 24574 # # HotSpot Virtual Machine Error : 11 # Error ID : 4F530E43505002CC 01 # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Server VM (1.3.1-b24 mixed mode) # # An error report file has been saved as hs_err_pid15459.log. # Please refer to the file for further information. # - End catalina.out excerpt - The error report file hs_err_pid15459.log contains a verbatim copy of the above, no additional information. Needless to say, the server died immediately, which I suppose is OK to expect from Tomcat given such an internal JVM crash. So no complaints, I'm just wondering if anyone has seen this crash before? My theory is that it had to do with us slightly tweaking the Java runtime parameters we'd been using, in an effort to improve garbage collection on the machine. Previous CATALINA_OPTS= CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -XX:NewRatio=1 -verbose:gc' New ones, started last night, that probably caused the error: CATALINA_OPTS='-server -Xms300m -Xmx500m -Xmaxf0.30 -Xminf0.10 -Xincgc -verbose:gc -XX:MaxNewSize=100m -XX:NewSize=10m' I realize this is as much a question to Sun as to tomcat-users, so I'm reporting this bug