Re: Do URL query strings with semi-colons work with TC ?
http://www.faqs.org/rfcs/rfc2396.html section 3.3 seems to be the best reference so far. This RFC only specifies correct URI syntax, it does not mandate how that URI is used under any scheme (like http:) is to be used. Darryl L. Miles wrote: The reference you cite http://www.faqs.org/rfcs/rfc2616.html (el al) maybe you could also cite the section I should look at. A simple search for param or semi yeilds no related results. I have spent an hour looking into the issue over the weekend and found the specification that covers the URI scheme for http: from this angle it seems to leave the part after the ? to denote the start of a query string vague. Which lead me to a presumption that it was HTTP server dependant on its interpretation, since for example the CGI.pm modules changed over from to ; as the standard param delimiter with generated URLs, providing the resulting URL talks back to itself (the CGI.pm module) all will be well in the world but if it links to a TC server then there would appear to be a problem. -- Darryl L. Miles - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Do URL query strings with semi-colons work with TC ?
Aye. It just states for that, amongst others, amphersand and semi-colon are reserved characters within the query string. This got me looking coz I assumed that the structure of the http get query string was defined somewhere in rfc rather than just a convention. I found a few resources saying it was recommended to support ; as a delimiter; http://www.w3.org/TR/1999/REC-html401-19991224/appendix/notes.html#h-B.2.2 But I also found the likely candidate in TC that does the parsing of the query string: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-connectors/util/java/org/apache/tomcat/util/http/Parameters.java?rev=1.15view=markup Just for my peace of mind does anyone know where the standard use of amphersand to delimit name-value pairs in a http get query string is defined? Jon Darryl L. Miles wrote: http://www.faqs.org/rfcs/rfc2396.html section 3.3 seems to be the best reference so far. This RFC only specifies correct URI syntax, it does not mandate how that URI is used under any scheme (like http:) is to be used. Darryl L. Miles wrote: The reference you cite http://www.faqs.org/rfcs/rfc2616.html (el al) maybe you could also cite the section I should look at. A simple search for param or semi yeilds no related results. I have spent an hour looking into the issue over the weekend and found the specification that covers the URI scheme for http: from this angle it seems to leave the part after the ? to denote the start of a query string vague. Which lead me to a presumption that it was HTTP server dependant on its interpretation, since for example the CGI.pm modules changed over from to ; as the standard param delimiter with generated URLs, providing the resulting URL talks back to itself (the CGI.pm module) all will be well in the world but if it links to a TC server then there would appear to be a problem. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Do URL query strings with semi-colons work with TC ?
http://ppewww.ph.gla.ac.uk/~flavell/www/formgetbyurl.html Not sure what authorative basis this has, but it did turn up from NCSA based CGI specifications of yesteryear. Maybe the MIME specification for application/x-www-form-urlencoded wherever that is (cant find it either). It must be noted that a URL like this is valid syntax: http://www.mydomain.com/pathseg1;foo=bar/pathseg2;foo=bar2/pathseg3;foo=bar3;foo=bar33?query=value How the receiving HTTP server interprets the path is unspecified, and I don't think its mandatory for a HTTP server to support path params at any level. Since JSESSIONID is being used I would say that only the last path parameters should be picked up and made available to the target servlet and an error given out to path params no part of the last segment (so no one tries to use them, leaving the door open for their implementation later in a server that would support some usage), that make these path params eligable for pickup: foo=bar3 foo=bar33 As for precedence / override with tranditional query strings, i.e. should the namespaces be collsapse. sigh another issue to head scratch. Darryl Jon Wingfield wrote: Aye. It just states for that, amongst others, amphersand and semi-colon are reserved characters within the query string. This got me looking coz I assumed that the structure of the http get query string was defined somewhere in rfc rather than just a convention. I found a few resources saying it was recommended to support ; as a delimiter; http://www.w3.org/TR/1999/REC-html401-19991224/appendix/notes.html#h-B.2.2 But I also found the likely candidate in TC that does the parsing of the query string: http://cvs.apache.org/viewcvs.cgi/jakarta-tomcat-connectors/util/java/org/apache/tomcat/util/http/Parameters.java?rev=1.15view=markup Just for my peace of mind does anyone know where the standard use of amphersand to delimit name-value pairs in a http get query string is defined? Jon Darryl L. Miles wrote: http://www.faqs.org/rfcs/rfc2396.html section 3.3 seems to be the best reference so far. This RFC only specifies correct URI syntax, it does not mandate how that URI is used under any scheme (like http:) is to be used. Darryl L. Miles wrote: The reference you cite http://www.faqs.org/rfcs/rfc2616.html (el al) maybe you could also cite the section I should look at. A simple search for param or semi yeilds no related results. I have spent an hour looking into the issue over the weekend and found the specification that covers the URI scheme for http: from this angle it seems to leave the part after the ? to denote the start of a query string vague. Which lead me to a presumption that it was HTTP server dependant on its interpretation, since for example the CGI.pm modules changed over from to ; as the standard param delimiter with generated URLs, providing the resulting URL talks back to itself (the CGI.pm module) all will be well in the world but if it links to a TC server then there would appear to be a problem. -- Darryl L. Miles - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Do URL query strings with semi-colons work with TC ?
In a URL the semi-colon indicates the start of path parameters (as opposed to the normal query parameters) as defined in rfc2616 (HTTP1.1 spec) et al. Thus, you can't tell tomcat to use it as a query string delimiter. JSESSIONID is a well known path parameter for Servlet 2.2+ Containers. To use a semi-colon within a url you'll need to url encode it as %3B To use it in the way you want you'll have to encode and parse the query string yourself. HTH, Jon Darryl L. Miles wrote: I swear I had application code working that was using semi-colons to delimit query string parameters. I'm sure I've also seen TC append a ;JSESSIONID= at the end of the URL. But my own application code written like: String val = request.getParameters(name); Yeilds: val=value;name2=foobar; Is there an additional option to allow semi-colon usage, instead of amp; ? Running TC 5.5.9 Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Do URL query strings with semi-colons work with TC ?
I'm not trying to encode semi-colon into QS. I'm trying to use semi-colon as a replacement for or rather amp; when correctly encoded into a HTML document. On the basis that it makes the documents smaller and the code easier to write. I have been left with the impression they are directly substitutable from various references around the internet. But your comments imply otherwise. I'd be happy to lookup path params in the same way I do for query string params with a call: value = request.getPathParameter(name); Can I do this ? Conceptually what is the difference between path params and query string params ? I'd need to better understand when QS params should be used and path params can be used, with relation to cachability properties of the resulting resource, i.e. the external impact of resources using amp; verses ; The reference you cite http://www.faqs.org/rfcs/rfc2616.html (el al) maybe you could also cite the section I should look at. A simple search for param or semi yeilds no related results. I have spent an hour looking into the issue over the weekend and found the specification that covers the URI scheme for http: from this angle it seems to leave the part after the ? to denote the start of a query string vague. Which lead me to a presumption that it was HTTP server dependant on its interpretation, since for example the CGI.pm modules changed over from to ; as the standard param delimiter with generated URLs, providing the resulting URL talks back to itself (the CGI.pm module) all will be well in the world but if it links to a TC server then there would appear to be a problem. Thanks for your response. Jon Wingfield wrote: In a URL the semi-colon indicates the start of path parameters (as opposed to the normal query parameters) as defined in rfc2616 (HTTP1.1 spec) et al. Thus, you can't tell tomcat to use it as a query string delimiter. JSESSIONID is a well known path parameter for Servlet 2.2+ Containers. To use a semi-colon within a url you'll need to url encode it as %3B To use it in the way you want you'll have to encode and parse the query string yourself. HTH, Jon Darryl L. Miles wrote: I swear I had application code working that was using semi-colons to delimit query string parameters. I'm sure I've also seen TC append a ;JSESSIONID= at the end of the URL. But my own application code written like: String val = request.getParameters(name); Yeilds: val=value;name2=foobar; Is there an additional option to allow semi-colon usage, instead of amp; ? Running TC 5.5.9 Thanks. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] . -- Darryl L. Miles - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Do URL query strings with semi-colons work with TC ?
I swear I had application code working that was using semi-colons to delimit query string parameters. I'm sure I've also seen TC append a ;JSESSIONID= at the end of the URL. But my own application code written like: String val = request.getParameters(name); Yeilds: val=value;name2=foobar; Is there an additional option to allow semi-colon usage, instead of amp; ? Running TC 5.5.9 Thanks. -- Darryl L. Miles - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: query problem
i have checked all.. there is no other username
i have put all the codes involved in the coding..
please point out the mistake ..
html
head
title
Staffing
/title
/head
h1Add Staff/h1
body
%@ page language=java import=java.sql.* %
%!
String con_url = jdbc:mysql:///AAAServer?user=tjcpassword=password;
Connection c;
Statement stmt1;
String username,password,AdminName;
%
%
try
{
Class.forName(com.mysql.jdbc.Driver).newInstance();
}
catch (Exception E)
{
System.err.println(CONCEPT: Unable to Load Driver );
E.printStackTrace();
}
%
table border=0 cellpadding=10
tr
%
// System.out.println(Connecting...);
c = DriverManager.getConnection(con_url);
// System.out.println(Connection ok: + c);
stmt1 = c.createStatement();
%
thUserName/th
td
form
input type=text name=username1 size=8
%
username = request.getParameter(username1);
%
/form
/td
/tr
tr
thName/th
td
form
input type=text name=AdminName size=12
/form
/td
/tr
tr
thPassword/th
td
form
input type=password name=password size=8
input type=submit name=Add value=AddStaff
/form
/td
/tr
/table
/body
/html
%
String submit1 = request.getParameter(Add);
if(submit1 == null)
{
}
else
{
password = request.getParameter(password);
AdminName = request.getParameter(AdminName);
String query7 = Insert into
Admin(UserName,PassWord,Admin_type,Admin_Name)
values('+username+','+password+', 'Staff','+AdminName+');
stmt1.executeUpdate(query7);
stmt1.close();
}
%
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
query problem
i am extracting info from html forms .. but one of the field allways return
the value null only
html code
form
input type=text name=username size=8
/form
jsp code
String username = request.getParameter(username);
SQL codes;
String query7 = Insert into Admin(UserName,PassWord,Admin_type,Admin_Name)
values('+username+','+password+', 'Staff','+AdminName+');
it returns the username as null
i cant figure out what is the problem
..
any links or example how to do it properly will help
thanks
stmt1.executeUpdate(query7);
stmt1.close();
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: query problem
Hello,
Are you sure you don't have another filed name=username somewhere else in
your jsp code ?
Lau/
-Message d'origine-
De : ganesan malairaja [mailto:[EMAIL PROTECTED]
Envoyé : lundi 8 août 2005 06:28
À : tomcat-user@jakarta.apache.org
Objet : query problem
i am extracting info from html forms .. but one of the field allways return the
value null only
html code
form
input type=text name=username size=8 /form
jsp code
String username = request.getParameter(username);
SQL codes;
String query7 = Insert into Admin(UserName,PassWord,Admin_type,Admin_Name)
values('+username+','+password+', 'Staff','+AdminName+');
it returns the username as null
i cant figure out what is the problem
..
any links or example how to do it properly will help
thanks
stmt1.executeUpdate(query7);
stmt1.close();
-
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: How to query Tomcat for the number of peers in the cluster without using the JMX
HEy, you can access you local Mbeans Server and write your own HTML interface to show cluster state. Look inside Manager or Admin app for example. Peter Edmon Begoli schrieb: Since I may not be allowed to enable JMX on the production, but we would still like to query host Tomcat for the number of peers in the cluster can someone please share how can this be accomplished using the Tomcat API, and what jars, if any, I would need to have in the lib directory of my web application. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
How to query Tomcat for the number of peers in the cluster without using the JMX
Since I may not be allowed to enable JMX on the production, but we would still like to query host Tomcat for the number of peers in the cluster can someone please share how can this be accomplished using the Tomcat API, and what jars, if any, I would need to have in the lib directory of my web application. -- Thank you, Edmon Begoli http://blogs.ittoolbox.com/eai/software
Server.xml query
Hi again What is this service name in server.xml I have seen two ways of writing it. 1)Tomcat Standalone 2)Tomcat-Apache what is the difference between two? --- Randall Svancara [EMAIL PROTECTED] wrote: This might be something to look at, but I know in Fedora Core 3, the last SE Linux Policy broke mod_jk. You had to either turn of SELinux or modify targeted policy. If you think you may have this problem, look at /var/log/messages to see if the security policy is logging any errors. You can also run: audit2allow -d to see if any policy changes needed to be added. Randall -Original Message- From: Raghupathy,Gurumoorthy [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 7:10 AM To: 'Tomcat Users List' Subject: RE: How to make tomcat work on a remote server? Hey just got it Look at : http://www.junlu.com/msg/170819.html -Original Message- From: Raghupathy,Gurumoorthy [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 14:04 To: 'Tomcat Users List' Cc: '[EMAIL PROTECTED]' Subject: RE: How to make tomcat work on a remote server? From my experience Your DocumentRoot should be different to the appBase of your virtual host ... Set the document root to something else and try Regards Guru -Original Message- From: Raghupathy,Gurumoorthy [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:45 To: 'Tomcat Users List' Cc: '[EMAIL PROTECTED]' Subject: RE: How to make tomcat work on a remote server? Sorry could not get back to you earlier ... I think you are worker2.properties ... Remove LoadModule jk2_module modules/mod_jk2.so Include /usr/local/tomcat/conf/auto/mod_jk2.conf Your workers. Should be somehting like this .. .. http://jakarta.apache.org/tomcat/connectors-doc/howto/workers.html I will look into your problem from home .. Have emailed my home address ... Regards Guru -Original Message- From: sai krishna [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:06 To: Tomcat Users List Subject: RE: How to make tomcat work on a remote server? Can anyone help me out here?? Im unable to access my jsp page on the net. I get internal server error. Im using included both mod_jk and mod_jk2 module, /var/logs/httpd/log shows that mod_jk2 starts but down below this module I loaded mod_jk module so it will support JkMount command in httpd.conf file. Can any one suggest m e the best method to access jsp pages on tomcat 4.1.17 either mod_jk/mod_jk2 connector and 2.0.52 apache on Fedora box 2. Today I added JkMount line in httpd.conf and rest everything is same as my down files server.xml is as following Server port=8005 shutdown=SHUTDOWN debug=0 !-- Define an Apache-Connector Service -- Service name=Tomcat-Apache !-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -- Connector className=org.apache.coyote.tomcat4.CoyoteConnector port=8009 minProcessors=5 maxProcessors=75 enableLookups=true redirectPort=8443 acceptCount=10 debug=0 connectionTimeout=2 useURIValidationHack=false protocolHandlerClassName=org.apache.jk.server.JkCoyoteHandler/ Engine name=Apache defaultHost=www.oursitename.com debug=0 Logger className=org.apache.catalina.logger.FileLogger prefix=apache_log. suffix=.txt timestamp=true/ !-- Access log processes all requests for this virtual host. -- Valve className=org.apache.catalina.valves.AccessLogValve directory=logs prefix=localhost_access_log. suffix=.txt pattern=common resolveHosts=false/ Host name=www.oursitename.com debug=0 appBase=/home/httpd/vhosts/oursitename.com/httpdocs/ unpackWARs=true autoDeploy=true Aliaslocalhost/Alias Aliaswww/Alias/Host AliasOur IP/Alias /Engine /Service /Server -- httpd.conf file LoadModule jk2_module modules/mod_jk2.so LoadModule jk_module modules/mod_jk.so Include /usr/local/tomcat/conf/auto/mod_jk2.conf Include /usr/local/tomcat/conf/auto/mod_jk.conf VirtualHost Our IP:80 ServerName oursite.com:80 ServerAlias www.oursite.com UseCanonicalName On DocumentRoot /home/httpd/vhosts/oursite.com/httpdocs CustomLog /home/httpd/vhosts/oursite.com/statistics/logs/access_log combined ErrorLog /home/httpd/vhosts/oursite.com/statistics/logs/error_log Alias /trainer /home/httpd/vhosts/oursite.com/httpdocs/trainer JkMount /trainer/*.jsp ajp13 JkMount /trainer/adminjsp/*.jsp ajp13 Directory /home/httpd/vhosts/oursite.com/httpdocs/trainer/ Options Indexes FollowSymLinks DirectoryIndex index.html index.htm index.jsp /Directory Location /trainer/WEB-INF/* AllowOverride None deny from all /Location Location /trainer/META-INF/* AllowOverride None deny from all /Location Directory /home/httpd/vhosts/oursite.com/httpdocs/
Re: How to query for number of active participants in the tomcat 5.5 cluster
you would need to write a component that queries the cluster classes (internal tomcat components) yourself. I believe you can reach the cluster object through JMX and through the tomcat classes (host etc) the interface CatalinaCluster.getMembers() returns all members in a cluster. Filip Edmon Begoli wrote: Hi, Is it possible to query host tomcat for the number of active participants in the cluster that host tomcat belongs to. If yes - can you please point me to the API, and possibly examples. Thank you, Edmon - 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: How to query for number of active participants in the tomcat 5.5 cluster
Hey, I have checkin today a JMX Object for McastService (Membership implementation) to access the membership list via mbean. :-) Also every sender is a mbean ( type IDataSender). Look inside the Mbean list via jconsole. Peter Filip Hanik - Dev Lists schrieb: you would need to write a component that queries the cluster classes (internal tomcat components) yourself. I believe you can reach the cluster object through JMX and through the tomcat classes (host etc) the interface CatalinaCluster.getMembers() returns all members in a cluster. Filip Edmon Begoli wrote: Hi, Is it possible to query host tomcat for the number of active participants in the cluster that host tomcat belongs to. If yes - can you please point me to the API, and possibly examples. Thank you, Edmon - 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]
Re: How to query for number of active participants in the tomcat 5.5 cluster
Hi, To answer my own question and for the sake of others. I think I have figured out the way how to query Tomcat for the number of active members in the clusters (that replicate sessions) using available MBeans. To make it easily available I put instructions on my blog - you can access detailed, step by step here: http://blogs.ittoolbox.com/eai/software/archives/004546.asp Please feel free to comment with any additions or better ways if needed. Thank you, Edmon http://blogs.ittoolbox.com/eai/software Edmon Begoli wrote: Hi, Is it possible to query host tomcat for the number of active participants in the cluster that host tomcat belongs to. If yes - can you please point me to the API, and possibly examples. Thank you, Edmon - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
How to query for number of active participants in the tomcat 5.5 cluster
Hi, Is it possible to query host tomcat for the number of active participants in the cluster that host tomcat belongs to. If yes - can you please point me to the API, and possibly examples. Thank you, Edmon - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Query regarding Apache Tomcat and Real Time Application
Hi, Plz Help me regarding this under mentioned query. In my application i am using Apache Tomcat and Real-time Application server.give me any suggestion how to start External Server/Application automatically whenever i start apache tomcat server.So i want to know the procedure for running External server simultaneously whenever the Apache Tomcat is started in the same JVM ? Plz reply soon. Regards, Jayaprada Yahoo! India Matrimony: Find your life partneronline.
Query on catalina.bat of Tomcat 5.0.28
Hi All, In the file catalina.bat, the following lines of code are present: echo Using CATALINA_BASE: %CATALINA_BASE% echo Using CATALINA_HOME: %CATALINA_HOME% echo Using CATALINA_TMPDIR: %CATALINA_TMPDIR% echo Using JAVA_HOME: %JAVA_HOME% set _EXECJAVA=%_RUNJAVA% My question here is, who / wherefrom is the value of _RUNJAVA being set/obtained? I noticed that shutdown.bat file calls catalina.bat file with stop option. I am facing a problem with the execution of the same. When I executed shutdown.bat via the command prompt, the value of _RUNJAVA gets set to the value of the proper java that is present in JAVA_HOME. But when I am executed the same shutdown.bat script from within our product application, the value _RUNJAVA isn't getting set as expected. Because of this, tomcat shutdown is not getting called, hence tomcat never stops when I try to stop it via our application. Any ideas??? - Lakshmi Narayanan K. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Query on catalina.bat of Tomcat 5.0.28
On Apr 1, 2005 2:11 PM, Lakshmi Narayanan K. [EMAIL PROTECTED] wrote: Hi All, In the file catalina.bat, the following lines of code are present: echo Using CATALINA_BASE: %CATALINA_BASE% echo Using CATALINA_HOME: %CATALINA_HOME% echo Using CATALINA_TMPDIR: %CATALINA_TMPDIR% echo Using JAVA_HOME: %JAVA_HOME% set _EXECJAVA=%_RUNJAVA% My question here is, who / wherefrom is the value of _RUNJAVA being set/obtained? I noticed that shutdown.bat file calls catalina.bat file with stop option. I am facing a problem with the execution of the same. When I executed shutdown.bat via the command prompt, the value of _RUNJAVA gets set to the value of the proper java that is present in JAVA_HOME. But when I am executed the same shutdown.bat script from within our product application, the value _RUNJAVA isn't getting set as expected. Because of this, tomcat shutdown is not getting called, hence tomcat never stops when I try to stop it via our application. Any ideas??? - Lakshmi Narayanan K. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] There may be an environment variable set JAVA_HOME that is causing trouble. Look at setclasspath.bat to what _RUNJAVA points to. -- Benchmark Softech www.benchmarksoft.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Query on mod_jk.log
in your mod_jk.conf : JkLogFile /var/log/apache/mod_jk.log On Thu, 10 Mar 2005 11:58:03 +0530 [EMAIL PROTECTED] wrote: Hi All, I need to change the location of mod_jk.log file. Presently it gets logged in /apache/logs. I need to put it in /var/log/apache. How to accomplish this? Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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: Query on mod_jk.log
JkLogFile -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: March 10, 2005 1:28 AM To: tomcat-user@jakarta.apache.org Subject: Query on mod_jk.log Hi All, I need to change the location of mod_jk.log file. Presently it gets logged in /apache/logs. I need to put it in /var/log/apache. How to accomplish this? Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] !DSPAM:422fe96e132135474820448!
Query on changing the path for catalina.out
Hi, I need to change the default location of Catalina.out log file. So I modified the server.xml file in the conf dir in the following way: !-- Global logger unless overridden at lower levels -- Logger className=3Dorg.apache.catalina.logger.FileLogger directory=3D/var/log/tomcat prefix=3Dcatalina_log. suffix=3D.txt timestamp=3Dtrue/ But inspite of doing this my catalina.out is gets logged in CATALINA_BASE/logs/ directory. There are two scripts in tomcat/bin/ directory catalina.sh and Catalina.50.sh which are doing a= touch $CATALINA_BASE/logs/catalina.out So are my changes made in the server.xml are getting overridden by these Scripts? If yes, please let me know a way to handle this. Your inputs will be extremely helpful for me. Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.
RE: Query on changing the path for catalina.out
The location of the catalina.out log file is not controlled from server.xml. This is other log files. Look in catalina.sh for $CATALINA_BASE/logs/catalina.out 21 and change that, to change the location of catalina.out. Ta Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 09 March 2005 12:04 To: tomcat-user@jakarta.apache.org Subject: Query on changing the path for catalina.out Hi, I need to change the default location of Catalina.out log file. So I modified the server.xml file in the conf dir in the following way: !-- Global logger unless overridden at lower levels -- Logger className=3Dorg.apache.catalina.logger.FileLogger directory=3D/var/log/tomcat prefix=3Dcatalina_log. suffix=3D.txt timestamp=3Dtrue/ But inspite of doing this my catalina.out is gets logged in CATALINA_BASE/logs/ directory. There are two scripts in tomcat/bin/ directory catalina.sh and Catalina.50.sh which are doing a= touch $CATALINA_BASE/logs/catalina.out So are my changes made in the server.xml are getting overridden by these Scripts? If yes, please let me know a way to handle this. Your inputs will be extremely helpful for me. Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Query on changing the path for catalina.out
Thanks Dave, Is there any other way of doing this as in my environment, I cannot modify those files as I do not have permission for changing them. Thanks and Regards, Mandar M Kelvekar -Original Message- From: Dale, Matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 5:41 PM To: Tomcat Users List Subject: RE: Query on changing the path for catalina.out The location of the catalina.out log file is not controlled from server.xml. This is other log files. Look in catalina.sh for $CATALINA_BASE/logs/catalina.out 21 and change that, to change the location of catalina.out. Ta Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 09 March 2005 12:04 To: tomcat-user@jakarta.apache.org Subject: Query on changing the path for catalina.out Hi, I need to change the default location of Catalina.out log file. So I modified the server.xml file in the conf dir in the following way: !-- Global logger unless overridden at lower levels -- Logger className=3Dorg.apache.catalina.logger.FileLogger directory=3D/var/log/tomcat prefix=3Dcatalina_log. suffix=3D.txt timestamp=3Dtrue/ But inspite of doing this my catalina.out is gets logged in CATALINA_BASE/logs/ directory. There are two scripts in tomcat/bin/ directory catalina.sh and Catalina.50.sh which are doing a= touch $CATALINA_BASE/logs/catalina.out So are my changes made in the server.xml are getting overridden by these Scripts? If yes, please let me know a way to handle this. Your inputs will be extremely helpful for me. Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Query on mod_jk.log
Hi All, I need to change the location of mod_jk.log file. Presently it gets logged in /apache/logs. I need to put it in /var/log/apache. How to accomplish this? Thanks and Regards, Mandar M Kelvekar Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Multiple mappings to same servlet query
Hi I know that if I have multiple mappings to the same servlet, then I get two seperate objects instantiated. However, where does the engine instantiate the copy from? For example, I want to run two copies of the same servlet with different URLs, one in test mode, one in live mode. I was planning on configuring a different set of parameters for the two cases in my web.xml file but I need to be sure that I will get two instances, each with its own set parameters rather than the engine cloning a copy of the servlet it has already loaded. Regards Roger __ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. __ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged
(B (B -Original Message- (BFrom: Reshma Bhatia [mailto:[EMAIL PROTECTED] (BSent: Thursday, February 17, 2005 7:36 PM (BTo: '[EMAIL PROTECTED]' (BSubject:Please help for a query in Tomcat. - Problem : Tomcat gets (Bhanged (B (BHi, (B (BWe have designed an application which works in Java JSP - Tomcat - Oracle (Benvironment. (B (BOur JSP page has two frames. (B1). First frame : This is the top frame containing links (displayed as Tabs) (B2). Second Frame : This is below the top frame and is updated with the (Bselected link. (B (BFor each click on the link a request is submitted and the response is (Bpopulated in the second frame. (BThe second frame contains a search criteria and fetches data from the (Bdatabase. (B (BConditions when Tomcat hangs (B1). When we try clicking on the links very fast (B2). While the data is being fetched from the database and manipulated and if (Bwe click on other the links the server gets hang. (B (BOur analysis and understanding is : (BThere would be some threads (requests) whose output was not allowed to be (Bdisplayed in the second frame due to click on other links which would spawn (Banother request for the same target. (BThese requests remain in "Service" state as understood from the (BTomcat-Manager status. (BAlso, as per the information given on the link (Bhttp://forum.java.sun.com/thread.jspa?threadID=454684messageID=2072194 (Bthese requests would "always" remain in Service State. (B (BPlease confirm whether our understanding is correct. (BPlease provide a solution to this problem? Let us know in case any further (Binformation is needed. (B (BThanks and regards, (BReshma (B (B (B (Bhttp://www.patni.com (BWorld-Wide Partnerships. World-Class Solutions. (B_ (B (BThis e-mail message may contain proprietary, confidential or legally (Bprivileged information for the sole use of the person or entity to (Bwhom this message was originally addressed. Any review, e-transmission (Bdissemination or other use of or taking of any action in reliance upon (Bthis information by persons or entities other than the intended (Brecipient is prohibited. If you have received this e-mail in error (Bkindly delete this e-mail from your records. If it appears that this (Bmail has been forwarded to you without proper authority, please notify (Bus immediately at [EMAIL PROTECTED] and delete this mail. (B_- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged
You can try modifiying the maxProcessors in the connector element in conf/server.xml to a higher value to test whether increasing no of threads solve the problem. Post Tomcat , Java VM and OS versions. rgds Antony Paul On Fri, 18 Feb 2005 10:14:15 +0530, Reshma Bhatia [EMAIL PROTECTED] wrote: -Original Message- From: Reshma Bhatia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 7:36 PM To: '[EMAIL PROTECTED]' Subject:Please help for a query in Tomcat. - Problem : Tomcat gets hanged Hi, We have designed an application which works in Java JSP - Tomcat - Oracle environment. Our JSP page has two frames. 1). First frame : This is the top frame containing links (displayed as Tabs) 2). Second Frame : This is below the top frame and is updated with the selected link. For each click on the link a request is submitted and the response is populated in the second frame. The second frame contains a search criteria and fetches data from the database. Conditions when Tomcat hangs 1). When we try clicking on the links very fast 2). While the data is being fetched from the database and manipulated and if we click on other the links the server gets hang. Our analysis and understanding is : There would be some threads (requests) whose output was not allowed to be displayed in the second frame due to click on other links which would spawn another request for the same target. These requests remain in Service state as understood from the Tomcat-Manager status. Also, as per the information given on the link http://forum.java.sun.com/thread.jspa?threadID=454684messageID=2072194 these requests would always remain in Service State. Please confirm whether our understanding is correct. Please provide a solution to this problem? Let us know in case any further information is needed. Thanks and regards, Reshma http://www.patni.com World-Wide Partnerships. World-Class Solutions. _ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _ - 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: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged
Is there a way to kill the Tomcat threads which have gone into infinite loop / hang state. -Original Message- From: Antony Paul [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:26 AM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged You can try modifiying the maxProcessors in the connector element in conf/server.xml to a higher value to test whether increasing no of threads solve the problem. Post Tomcat , Java VM and OS versions. rgds Antony Paul On Fri, 18 Feb 2005 10:14:15 +0530, Reshma Bhatia [EMAIL PROTECTED] wrote: -Original Message- From: Reshma Bhatia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 7:36 PM To: '[EMAIL PROTECTED]' Subject:Please help for a query in Tomcat. - Problem : Tomcat gets hanged Hi, We have designed an application which works in Java JSP - Tomcat - Oracle environment. Our JSP page has two frames. 1). First frame : This is the top frame containing links (displayed as Tabs) 2). Second Frame : This is below the top frame and is updated with the selected link. For each click on the link a request is submitted and the response is populated in the second frame. The second frame contains a search criteria and fetches data from the database. Conditions when Tomcat hangs 1). When we try clicking on the links very fast 2). While the data is being fetched from the database and manipulated and if we click on other the links the server gets hang. Our analysis and understanding is : There would be some threads (requests) whose output was not allowed to be displayed in the second frame due to click on other links which would spawn another request for the same target. These requests remain in Service state as understood from the Tomcat-Manager status. Also, as per the information given on the link http://forum.java.sun.com/thread.jspa?threadID=454684messageID=2072194 these requests would always remain in Service State. Please confirm whether our understanding is correct. Please provide a solution to this problem? Let us know in case any further information is needed. Thanks and regards, Reshma http://www.patni.com World-Wide Partnerships. World-Class Solutions. _ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _ - 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] http://www.patni.com World-Wide Partnerships. World-Class Solutions. _ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged
To best of my knowledge you can't. Even if you shutdown Tomcat it will wait till the threads finish their work. rgds Antony Paul On Fri, 18 Feb 2005 11:41:04 +0530, Reshma Bhatia [EMAIL PROTECTED] wrote: Is there a way to kill the Tomcat threads which have gone into infinite loop / hang state. -Original Message- From: Antony Paul [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 10:26 AM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged You can try modifiying the maxProcessors in the connector element in conf/server.xml to a higher value to test whether increasing no of threads solve the problem. Post Tomcat , Java VM and OS versions. rgds Antony Paul On Fri, 18 Feb 2005 10:14:15 +0530, Reshma Bhatia [EMAIL PROTECTED] wrote: -Original Message- From: Reshma Bhatia [mailto:[EMAIL PROTECTED] Sent: Thursday, February 17, 2005 7:36 PM To: '[EMAIL PROTECTED]' Subject:Please help for a query in Tomcat. - Problem : Tomcat gets hanged Hi, We have designed an application which works in Java JSP - Tomcat - Oracle environment. Our JSP page has two frames. 1). First frame : This is the top frame containing links (displayed as Tabs) 2). Second Frame : This is below the top frame and is updated with the selected link. For each click on the link a request is submitted and the response is populated in the second frame. The second frame contains a search criteria and fetches data from the database. Conditions when Tomcat hangs 1). When we try clicking on the links very fast 2). While the data is being fetched from the database and manipulated and if we click on other the links the server gets hang. Our analysis and understanding is : There would be some threads (requests) whose output was not allowed to be displayed in the second frame due to click on other links which would spawn another request for the same target. These requests remain in Service state as understood from the Tomcat-Manager status. Also, as per the information given on the link http://forum.java.sun.com/thread.jspa?threadID=454684messageID=2072194 these requests would always remain in Service State. Please confirm whether our understanding is correct. Please provide a solution to this problem? Let us know in case any further information is needed. Thanks and regards, Reshma http://www.patni.com World-Wide Partnerships. World-Class Solutions. _ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _ - 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] http://www.patni.com World-Wide Partnerships. World-Class Solutions. _ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _ - 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: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged
From: Antony Paul [mailto:[EMAIL PROTECTED] Subject: Re: FW: Please help for a query in Tomcat. - Problem : Tomcat gets hanged To best of my knowledge you can't. Even if you shutdown Tomcat it will wait till the threads finish their work. Not quite true. You can use the kill command on UNIX/Linux to terminate the process, or in Windows, CTRL-c to stop the .bat file, or the Services console to stop the service, or Task Manager to terminate almost anything. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
jk2.properties Query
Hi: I noticed the following on the catalina.out: Feb 15, 2005 9:19:13 AM org.apache.jk.server.JkMain start INFO: Jk running ID=0 time=1/37 config=/local/jakarta-tomcat-5.0.28/conf/jk2.properties Does Tomcat 5.0.28 have mod_jk on by default? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: jk2.properties Query
From: Hari Mailvaganam [mailto:[EMAIL PROTECTED] Subject: jk2.properties Query Does Tomcat 5.0.28 have mod_jk on by default? The default server.xml has an AJP13 connector defined on port 8009; it's been that way for a long time. You should comment it out if you don't need it. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Query about IIS, Tomcat and Virtual Hosts
Hi there,
we are creating a staging / QA environment for our websites.
We are using a Win2K server running IIS which has multiple websites
defined (using host headers for identification against a single IP
address), eg:
localhost
staging.website.com
staging.website2.co.uk
staging.website3.de etc etc
I have installed the latest version of Tomcat (5.5.7) and configured it
using the jk2.0.4 connectors and for the default website this is fine; I
can serve JSP's that I place under the {CATALINA_BASE}\webapps\ROOT
directory structure. I know this isn't the best place to put them but I'm
trying to take this in easy steps!
My main problem is when trying to server JSP's from the virtual, ie non
localhost, sites defined in IIS.
In IIS I have added the isapi_redirector2.dll and created the 'jakarta'
virtual directory so I'm pretty certain that I'm missing a trick somewhere
on the Tomcat configuration side but I'm not sure where.
I have tried editing the workers2.properties file in the conf directory
with the following entry:
[uri:staging.website2.co.uk/*.jsp]
info= Attempt to map requests for all JSP pages on virtual server to
Tomcat.
context=/staging_website2_co_uk
The context directory exist under webapps and was created by cutting,
pasting and renaming the jsp-examples directory. Again, far from ideal but
I'm just trying to get up to speed!
This hasn't worked as expected in that staging.website2.co.uk/test.jsp
returns a 404 whilst localhost/staging_website_co_uk/test.jsp returns the
page properly.
Attentions then turned to the server.xml file where I've really got a bit
lost.
Should I be creating staging.whatever as an engine or a host?
Additionally, should I be adding a new directory under \conf\catalina for
each of the new sites, similar to the localhost directory?
I appreciate that this is a number of questions but I've tried all the
things that seem 'obvious' to me but I'm now flailing about aimlessly and
could do with Some Help :)
Thanks in advance,
Michael Foggin
Technical Specialist, DDA Web Compliance Project
Xansa
t: 0115 959 2089
i: 72 2089
m: 0780 191 7081
e: [EMAIL PROTECTED] / [EMAIL PROTECTED]
w: www.xansa.com
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Help with JDBC query
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue(INSERT INTO Restaurant +
(Name, Cuisine, ChefsName, Address_1, Address_2, +
Neighborhood, City, State, ZIP, Country, +
OfficePhone, ReservationPhone, FaxPhone, Email, Web, +
HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner, +
DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining, +
Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService, +
LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL, +
ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy, +
RestaurantOrder, Subscriber, SubscriptionExpired, UserID) +
VALUES(?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?);
} else {
// Update an existing restaurant
sql.setSqlValue(UPDATE Restaurant SET +
Name = ?, Cuisine = ?, +
ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City = ?, +
State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?, +
FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?, +
CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?, +
NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?, +
Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?, +
ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?, +
DescriptiveCopy = ?, AtAGlance = ?, NearBy = ? +
WHERE RestaurantID = ?);
}
List values = new ArrayList();
values.add(request.getParameter(name));
values.add(request.getParameter(cuisine));
values.add(request.getParameter(chef));
values.add(request.getParameter(address1));
values.add(request.getParameter(address2));
values.add(request.getParameter(neighborhood));
values.add(request.getParameter(city));
values.add(request.getParameter(state));
values.add(request.getParameter(zip));
values.add(request.getParameter(country));
values.add(request.getParameter(officePhone));
values.add(request.getParameter(reservationPhone));
values.add(request.getParameter(fax));
values.add(request.getParameter(email));
values.add(request.getParameter(web));
int access = 0;
String param = request.getParameter(access);
if(param != null param.equals(on)){
access = 1;
}
values.add( + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter(visa);
if(param != null param.equals(on)){
cc |= 1;
}
param = request.getParameter(mastercard);
if(param != null param.equals(on)){
cc |= 2;
}
param = request.getParameter(americanExpress);
if(param != null param.equals(on)){
cc |= 4;
}
param = request.getParameter(discover);
if(param != null param.equals(on)){
cc |= 8;
}
param = request.getParameter(diners);
if(param != null param.equals(on)){
cc |= 16;
}
values.add( + cc);
values.add(request.getParameter(costBreakfast));
values.add(request.getParameter(costLunch));
values.add(request.getParameter(costDinner));
values.add(request.getParameter(dressCode));
values.add(request.getParameter(reservations));
int nonSmoking = 0;
param = request.getParameter(nonSmoking);
if(param != null param.equals(on)){
nonSmoking = 1;
}
values.add( + nonSmoking);
int offStreetParking = 0;
param = request.getParameter(offStreetParking);
if(param != null param.equals(on)){
offStreetParking = 1;
}
values.add( + offStreetParking);
int outsideDining = 0;
param = request.getParameter(outsideDining);
if(param != null param.equals(on)){
outsideDining = 1;
}
values.add( + outsideDining);
int banquet = 0;
param = request.getParameter(banquet);
if(param != null param.equals(on)){
banquet = 1;
}
values.add( + banquet);
values.add(request.getParameter(banquetCapacity));
int catering = 0;
param = request.getParameter(catering);
if(param != null param.equals(on)){
catering = 1;
}
values.add( + catering);
values.add(request.getParameter(serviceTypes));
int deliveryService = 0;
param = request.getParameter(deliveryService);
if(param != null param.equals(on)){
deliveryService = 1;
}
values.add( + deliveryService);
int
Re: Help with JDBC query
I think you put the ) after the end of sql expression. It is not going
to make it into a parsed query.
One more suggestion - put these fields one per line - it is going to be
too hard to debug them this way - they are all on the same line.
Best regards,
Edmon Begoli
Jack Lauman wrote:
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue(INSERT INTO Restaurant +
(Name, Cuisine, ChefsName, Address_1, Address_2, +
Neighborhood, City, State, ZIP, Country, +
OfficePhone, ReservationPhone, FaxPhone, Email, Web, +
HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner, +
DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining, +
Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService, +
LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL, +
ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy, +
RestaurantOrder, Subscriber, SubscriptionExpired, UserID) +
VALUES(?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?);
} else {
// Update an existing restaurant
sql.setSqlValue(UPDATE Restaurant SET +
Name = ?, Cuisine = ?, +
ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City =
?, +
State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone =
?, +
FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards =
?, +
CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?, +
NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?, +
Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?, +
ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?, +
DescriptiveCopy = ?, AtAGlance = ?, NearBy = ? +
WHERE RestaurantID = ?);
}
List values = new ArrayList();
values.add(request.getParameter(name));
values.add(request.getParameter(cuisine));
values.add(request.getParameter(chef));
values.add(request.getParameter(address1));
values.add(request.getParameter(address2));
values.add(request.getParameter(neighborhood));
values.add(request.getParameter(city));
values.add(request.getParameter(state));
values.add(request.getParameter(zip));
values.add(request.getParameter(country));
values.add(request.getParameter(officePhone));
values.add(request.getParameter(reservationPhone));
values.add(request.getParameter(fax));
values.add(request.getParameter(email));
values.add(request.getParameter(web));
int access = 0;
String param = request.getParameter(access);
if(param != null param.equals(on)){
access = 1;
}
values.add( + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter(visa);
if(param != null param.equals(on)){
cc |= 1;
}
param = request.getParameter(mastercard);
if(param != null param.equals(on)){
cc |= 2;
}
param = request.getParameter(americanExpress);
if(param != null param.equals(on)){
cc |= 4;
}
param = request.getParameter(discover);
if(param != null param.equals(on)){
cc |= 8;
}
param = request.getParameter(diners);
if(param != null param.equals(on)){
cc |= 16;
}
values.add( + cc);
values.add(request.getParameter(costBreakfast));
values.add(request.getParameter(costLunch));
values.add(request.getParameter(costDinner));
values.add(request.getParameter(dressCode));
values.add(request.getParameter(reservations));
int nonSmoking = 0;
param = request.getParameter(nonSmoking);
if(param != null param.equals(on)){
nonSmoking = 1;
}
values.add( + nonSmoking);
int offStreetParking = 0;
param = request.getParameter(offStreetParking);
if(param != null param.equals(on)){
offStreetParking = 1;
}
values.add( + offStreetParking);
int outsideDining = 0;
param = request.getParameter(outsideDining);
if(param != null param.equals(on)){
outsideDining = 1;
}
values.add( + outsideDining);
int banquet = 0;
param = request.getParameter(banquet);
if(param != null param.equals(on)){
banquet = 1;
}
values.add( + banquet);
values.add(request.getParameter(banquetCapacity));
int catering = 0;
param = request.getParameter(catering);
if(param != null
Re: Help with JDBC query
Actually you need to add a ) at the end:
?, ?, ?, ?));
Classic case of unmatched bracket. Inner one is for the sql string as per
Edmon and outer for your method call sql.setSqlValue( );
Doug
- Original Message -
From: Edmon Begoli [EMAIL PROTECTED]
To: Tomcat Users List tomcat-user@jakarta.apache.org
Sent: Sunday, January 23, 2005 10:36 PM
Subject: Re: Help with JDBC query
I think you put the ) after the end of sql expression. It is not going to
make it into a parsed query.
One more suggestion - put these fields one per line - it is going to be
too hard to debug them this way - they are all on the same line.
Best regards,
Edmon Begoli
Jack Lauman wrote:
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax
to use near '' at line 1
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue(INSERT INTO Restaurant +
(Name, Cuisine, ChefsName, Address_1, Address_2, +
Neighborhood, City, State, ZIP, Country, +
OfficePhone, ReservationPhone, FaxPhone, Email, Web, +
HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner, +
DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining, +
Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService, +
LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL, +
ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy, +
RestaurantOrder, Subscriber, SubscriptionExpired, UserID) +
VALUES(?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?, ?, +
?, ?, ?, ?);
} else {
// Update an existing restaurant
sql.setSqlValue(UPDATE Restaurant SET +
Name = ?, Cuisine = ?, +
ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City =
?, +
State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?,
+
FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?,
+
CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?, +
NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?, +
Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?, +
ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?, +
DescriptiveCopy = ?, AtAGlance = ?, NearBy = ? +
WHERE RestaurantID = ?);
}
List values = new ArrayList();
values.add(request.getParameter(name));
values.add(request.getParameter(cuisine));
values.add(request.getParameter(chef));
values.add(request.getParameter(address1));
values.add(request.getParameter(address2));
values.add(request.getParameter(neighborhood));
values.add(request.getParameter(city));
values.add(request.getParameter(state));
values.add(request.getParameter(zip));
values.add(request.getParameter(country));
values.add(request.getParameter(officePhone));
values.add(request.getParameter(reservationPhone));
values.add(request.getParameter(fax));
values.add(request.getParameter(email));
values.add(request.getParameter(web));
int access = 0;
String param = request.getParameter(access);
if(param != null param.equals(on)){
access = 1;
}
values.add( + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter(visa);
if(param != null param.equals(on)){
cc |= 1;
}
param = request.getParameter(mastercard);
if(param != null param.equals(on)){
cc |= 2;
}
param = request.getParameter(americanExpress);
if(param != null param.equals(on)){
cc |= 4;
}
param = request.getParameter(discover);
if(param != null param.equals(on)){
cc |= 8;
}
param = request.getParameter(diners);
if(param != null param.equals(on)){
cc |= 16;
}
values.add( + cc);
values.add(request.getParameter(costBreakfast));
values.add(request.getParameter(costLunch));
values.add(request.getParameter(costDinner));
values.add(request.getParameter(dressCode));
values.add(request.getParameter(reservations));
int nonSmoking = 0;
param = request.getParameter(nonSmoking);
if(param != null param.equals(on)){
nonSmoking = 1;
}
values.add( + nonSmoking);
int offStreetParking = 0;
param = request.getParameter(offStreetParking);
if(param != null param.equals(on)){
offStreetParking = 1;
}
values.add( + offStreetParking);
int outsideDining = 0;
param
RE: Alpha, Beeta releases--query
This is not just common to open source development but development in general and I suspect there is no reason than common practice. By the time a product gets out of beta it is generally stable enough for mainstream realease. The reason why this is more prominent in open source development is because there is more visibility of the development process whereas with commercial products it is all done behind closed doors. Ta Matt -Original Message- From: Rajaneesh [mailto:[EMAIL PROTECTED] Sent: 18 January 2005 05:15 To: 'Tomcat Users List' Subject: Alpha, Beeta releases--query Hi, Had a basic question. In the opensource packages why do you have the releases named as alpha and beeta? Why not have gamma releases, theeta releases? Regards Rajaneesh --Curiosity kills-- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Any opinions expressed in this E-mail may be those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that you have received this E-mail in error and that any use or copying is strictly prohibited. If you have received this E-mail in error please notify the beCogent postmaster at [EMAIL PROTECTED] Unless expressly stated, opinions in this email are those of the individual sender and not beCogent Ltd. You must take full responsibility for virus checking this email and any attachments. Please note that the content of this email or any of its attachments may contain data that falls within the scope of the Data Protection Acts and that you must ensure that any handling or processing of such data by you is fully compliant with the terms and provisions of the Data Protection Act 1984 and 1998. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Alpha, Beeta releases--query
Hi, Had a basic question. In the opensource packages why do you have the releases named as alpha and beeta? Why not have gamma releases, theeta releases? Regards Rajaneesh --Curiosity kills-- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Query on Upgrade of tomcat 4.0.6 to 5.0.x
Hi, We would like to upgrade our production Tomcat Server from 4.0.6 to 5.0.x Our application is higly multi-threaded, having 2000 concurrent users. This Application is running on tomcat 4.0.6 from last 2 years without any problem. I will be looking forward for your recommendation/suggestions for more stable tomcat 5.0.x version and is appreciated. Thanks Regards Satish - Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more.
Re: Query on Upgrade of tomcat 4.0.6 to 5.0.x
Murthy Tetali wrote: Hi, We would like to upgrade our production Tomcat Server from 4.0.6 to 5.0.x Our application is higly multi-threaded, having 2000 concurrent users. This Application is running on tomcat 4.0.6 from last 2 years without any problem. I will be looking forward for your recommendation/suggestions for more stable tomcat 5.0.x version and is appreciated. Thanks Regards Satish - Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. Well, If I wasn't having any problems,and I did not have any real reason to upgrade then I would stay confortably where I am at. If, however, you are doing this because you want to move up in the servlet spec or jsp spec, and have been planning on doing so then I would go ahead and move to 5.0.28 or .29. I've been using 5.0.28 for a while now without having any issues. I've been happy with it. Of course I go by the adage: If it isn't broken don't fix it. So, if I didn't have any better reason to upgrade tomcat other than it's a newer version and I have been running happily for 2 years.I would stay right where I'm at. Wade - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Query on Upgrade of tomcat 4.0.6 to 5.0.x
Hi Wade, Thank You. Your opinion will be good input for me. The reason for upgradation is, we would like upgrade the specs and as well want to take the advantage of JMX support. Thank Regards Murthy Tetali Wade Chandler [EMAIL PROTECTED] wrote: Murthy Tetali wrote: Hi, We would like to upgrade our production Tomcat Server from 4.0.6 to 5.0.x Our application is higly multi-threaded, having 2000 concurrent users. This Application is running on tomcat 4.0.6 from last 2 years without any problem. I will be looking forward for your recommendation/suggestions for more stable tomcat 5.0.x version and is appreciated. Thanks Regards Satish - Do you Yahoo!? Dress up your holiday email, Hollywood style. Learn more. Well, If I wasn't having any problems,and I did not have any real reason to upgrade then I would stay confortably where I am at. If, however, you are doing this because you want to move up in the servlet spec or jsp spec, and have been planning on doing so then I would go ahead and move to 5.0.28 or .29. I've been using 5.0.28 for a while now without having any issues. I've been happy with it. Of course I go by the adage: If it isn't broken don't fix it. So, if I didn't have any better reason to upgrade tomcat other than it's a newer version and I have been running happily for 2 years.I would stay right where I'm at. Wade - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses.
RE: Query with 404 error processing -- Tomcat 5.0.19
Enable (comment in) the AccessLogValve in your server.xml. That way you will be able to see exactly what requested URLs result in 404s. The file is enabled and nope -- I'm not seeing any 404 errors. Yoav Shapira http://www.yoavshapira.com What confuses me is why I get a ClassCastException? This must (I assume :) be in the server.xml file. However, that's the standard one that came with Tomcat. I've tried to look at that but I can't find any clues to link the servlet service() error below to anything in that file. If it helps the full Java error stack is: 2004-12-14 21:45:30 StandardContext[/manager]Manager: restart: Reloading web application at '/Server' 2004-12-14 22:03:51 ApplicationDispatcher[/Server] Servlet.service() for servlet default threw exception java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:750) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:512) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:359) at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:440) at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:345) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:194) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:578) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688) at java.lang.Thread.run(Thread.java:534) 2004-12-14 22:03:51 [EMAIL PROTECTED]: Exception Processing ErrorPage[errorCode=404, location=/404.html] java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:750) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:512) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:445) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:359) at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:440) at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:345) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:194) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:578) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972) at
New Babie query - pls pls help me
Hi, I am totally totally new to Servlet/Tomcat. I wrote a very simple HelloWorld servlet. I could compile it and could create the HelloWorld.class file. But how to test it thr Tomat web server ? I put the class inside servlet example dir C:\jakarta-tomcat-5.0.28\webapps\servlets-examples\WEB-INF\classes But whe tried to run it like http://localhost:8080/servlets-examples/servlet/HelloWorld always i get description The requested resource (/servlets-examples/servlet/HelloWorld) is not available. I tried to start-stop/reload the tomcat servlet-example but still the same, i understand i need to change some files - but can any body tell stepwise instructions ? Pls pls help me I am stuck Thanks in advance Manisha - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: New Babie query - pls pls help me
You need to create a mapping in web.xml to invoke the servlet. Look at the elements servlet and servlet-mapping elements in the example/WEB-INF/web.xml. Create a similar one and restart Tomcat. rgds Antony Paul On Mon, 13 Dec 2004 21:09:07 +0800, Manisha Sathe [EMAIL PROTECTED] wrote: Hi, I am totally totally new to Servlet/Tomcat. I wrote a very simple HelloWorld servlet. I could compile it and could create the HelloWorld.class file. But how to test it thr Tomat web server ? I put the class inside servlet example dir C:\jakarta-tomcat-5.0.28\webapps\servlets-examples\WEB-INF\classes But whe tried to run it like http://localhost:8080/servlets-examples/servlet/HelloWorld always i get description The requested resource (/servlets-examples/servlet/HelloWorld) is not available. I tried to start-stop/reload the tomcat servlet-example but still the same, i understand i need to change some files - but can any body tell stepwise instructions ? Pls pls help me I am stuck Thanks in advance Manisha - 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: New Babie query - pls pls help me
Welcome aboard. The first thing you should do is find yourself a good book or tutorial. There is a good one here: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/appdev/index.html If you just want a simple servlet example that you can drop into a running instance of Tomcat and run you can find one here: http://simple.souther.us Good Luck -Ben On Mon, 2004-12-13 at 08:09, Manisha Sathe wrote: Hi, I am totally totally new to Servlet/Tomcat. I wrote a very simple HelloWorld servlet. I could compile it and could create the HelloWorld.class file. But how to test it thr Tomat web server ? I put the class inside servlet example dir C:\jakarta-tomcat-5.0.28\webapps\servlets-examples\WEB-INF\classes But whe tried to run it like http://localhost:8080/servlets-examples/servlet/HelloWorld always i get description The requested resource (/servlets-examples/servlet/HelloWorld) is not available. I tried to start-stop/reload the tomcat servlet-example but still the same, i understand i need to change some files - but can any body tell stepwise instructions ? Pls pls help me I am stuck Thanks in advance Manisha - 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: Query with 404 error processing -- Tomcat 5.0.19
Hi, Because this processing servlet of yours itself had an error. A JSP file by default is processed by Tomcat's JSP servlet, not your Router servlet. Accordingly, it's not subject to your custom error handling mechanism. A more standard way to do this is declare an error-page for 404's in your web.xml, and/or an errorPage for the specific JSP page in the JSP page itself. Yoav Shapira http://www.yoavshapira.com -Original Message- From: Jon Doe [mailto:[EMAIL PROTECTED] Sent: Sunday, December 12, 2004 7:58 PM To: [EMAIL PROTECTED] Subject: Query with 404 error processing -- Tomcat 5.0.19 Can someone please explain why I get the default Tomcat 404 error when a pages does not exist? I have a set of URLs that end with *.ext. These are all routed to a servlet called Router, and these all work fine. This servlet has catch-all at the end that displays an error message when an unknown *.ext is processed. That all works fine. However, when an unknown *.jsp file is processed I get the default Tomcat error: HTTP Status 404 - /unknown.jsp type Status report message /unknown.jsp description The requested resource (/unknown.jsp) is not available. Apache Tomcat/5.0.19 The error in the generates this output in the log file: 2004-12-13 00:40:10 ApplicationDispatcher[/Server] Servlet.service() for servlet default threw exception java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorF ilte r.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic atio nFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terC hain.java:204) ... 2004-12-13 00:40:10 [EMAIL PROTECTED]: Exception Processing ErrorPage[errorCode=404, location=/404.html] java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorF ilte r.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic atio nFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terC hain.java:204) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispat cher .java:750) at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicati onDi spatcher.java:512) ... Here is my web.xml file: ?xml version=1.0 encoding=UTF-8? !DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web Application 2.3//EN http://java.sun.com/dtd/web-app_2_3.dtd; web-app display-nameMy server/display-name servletservlet-nameRouter/servlet-name servlet-classcom.mycompany.Router/servlet-class /servlet servletservlet-nameInitServlet/servlet-name servlet-classcom.mycompany.InitServlet/servlet-class load-on-startup2/load-on-startup /servlet servlet-mappingservlet-nameInitServlet/servlet-name url-pattern/InitServlet/url-pattern /servlet-mapping !-- All URLs end .ext. These are processed by the front controller. -- servlet-mappingservlet-nameRouter/servlet-name url-pattern*.ext/url-pattern /servlet-mapping session-configsession-timeout30/session-timeout/session-config welcome-file-listwelcome-fileindex.html/welcome-file /welcome-file-list error-pageerror-code404/error-code location/404.html/location /error-page /web-app And my 404.html file: html head /head body Error! /body /html Any help will be, as always, greatly appreciated. Joe. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ - 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: New Babie query - pls pls help me
Argh. Triple hijack! This thread started as JSP expressions are displayed as string, became Do not allow browsing the root directory to tomcat, then problem starting tomcat 5.5/jdk1.3.1_11 and now New Babie query - pls pls help me. For the sake of the archives and those of us using thread-aware mail clients, please start a new thread instead of replying to a completely unrelated topic. Ta, Jon Antony Paul wrote: You need to create a mapping in web.xml to invoke the servlet. Look at the elements servlet and servlet-mapping elements in the example/WEB-INF/web.xml. Create a similar one and restart Tomcat. rgds Antony Paul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
ssi including cgi with query args is broken
Using an SSI directive to include a cgi script works under Apache but
fails under Tomcat because the query arguments are not being handled the
same way. Under Tomcat 5.5.4, the query args are being searched for as
if they were part of the filename. [I made a previous post on this
subject but was then reporting the behavior under Tomcat 4.0.24, which
also fails, but somewhat differently.]
More details are below. I would be happy to test a patch class (I'd
need directions for where to put the patch class and how to configure
the class loader to find it). --Brian
In this log/backtrace, you can see that the CGI jar is trying to find
the file:
navTool.pl?REF+GENERAL+WHATIS
This file doesn't exist. On our systems, navTool.pl exists and is in
WEB-INF/cgi/, and is expecting some query args. [Note: by the default
configuration, /cgi-bin/ is rewritten as WEB-INF/cgi/ when the cgi jar
actually searches for the script, so both paths appear in the
log/backtrace below.]
Dec 9, 2004 3:46:04 PM org.apache.catalina.core.ApplicationContext log
INFO: cgi: findCGI: path=/Docs/ref_general1.html,
/Library/Tomcat/webapps/PCW/WEB-INF/cgi
Dec 9, 2004 3:46:04 PM org.apache.catalina.core.ApplicationContext log
INFO: cgi: findCGI: currentLoc=/Library/Tomcat/webapps/PCW/WEB-INF/cgi
Dec 9, 2004 3:46:04 PM org.apache.catalina.core.ApplicationContext log
INFO: cgi: findCGI: currentLoc=/Library/Tomcat/webapps/PCW/WEB-INF/cgi
Dec 9, 2004 3:46:04 PM org.apache.catalina.core.ApplicationContext log
INFO: cgi: findCGI:
currentLoc=/Library/Tomcat/webapps/PCW/WEB-INF/cgi/Docs
Dec 9, 2004 3:46:04 PM org.apache.catalina.core.ApplicationContext log
SEVERE: ssi: #include--Couldn't include file:
/cgi-bin/navTool.pl?REF+GENERAL+WHATIS
java.io.IOException: Couldn't find file:
/cgi-bin/navTool.pl?REF+GENERAL+WHATIS
at
org.apache.catalina.ssi.SSIServletExternalResolver.getFileText(SSIServletExternalResolver.java:391)
at
org.apache.catalina.ssi.SSIMediator.getFileText(SSIMediator.java:154)
at org.apache.catalina.ssi.SSIInclude.process(SSIInclude.java:40)
at
org.apache.catalina.ssi.SSIProcessor.process(SSIProcessor.java:145)
at
org.apache.catalina.ssi.SSIServlet.processSSI(SSIServlet.java:193)
at
org.apache.catalina.ssi.SSIServlet.requestHandler(SSIServlet.java:170)
at org.apache.catalina.ssi.SSIServlet.doGet(SSIServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.valves.RequestDumperValve.invoke(RequestDumperValve.java:150)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:383)
at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:552)
To reproduce this problem, all you need is a web app with a .shtml file
containing the line
!-- #include virtual=/cgi-bin/echoargs.pl?some_args --
and a perl script WEB-INF/cgi/echoargs.pl containing the lines:
#!/usr/bin/perl -w
my $query_args = $ENV{QUERY_STRING};
if (defined($query_args)) {
print query string isbr\n;
print $query_argsbr\n;
} else {
print query string is undefinedbr\n;
}
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Query with 404 error processing -- Tomcat 5.0.19
Hi,
Because this processing servlet of yours itself had an error. A JSP
file by default is processed by Tomcat's JSP servlet, not your Router
servlet. Accordingly, it's not subject to your custom error handling
mechanism. A more standard way to do this is declare an error-page
for 404's in your web.xml, and/or an errorPage for the specific JSP page
in the JSP page itself.
Sorry, not sure I understand this. Is this not what I've done with this?:
error-pageerror-code404/error-code
location/404.html/location
/error-page
My understanding of how this works is that any URL that ends with the string
'.ext' will be picked up by my Servlet. Any other URL ('.jpg', '.jsp' or
whatever) will thus fall through this, and my Router servlet will not see
it. It keeps falling to the error-page code above.
Have you any sample code you would be kiind enough to paste? I'm obviously
being thick here. :(
Joe.
Yoav Shapira http://www.yoavshapira.com
Here is my web.xml file:
?xml version=1.0 encoding=UTF-8?
!DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web
Application
2.3//EN
http://java.sun.com/dtd/web-app_2_3.dtd;
web-app
display-nameMy server/display-name
servletservlet-nameRouter/servlet-name
servlet-classcom.mycompany.Router/servlet-class
/servlet
servletservlet-nameInitServlet/servlet-name
servlet-classcom.mycompany.InitServlet/servlet-class
load-on-startup2/load-on-startup
/servlet
servlet-mappingservlet-nameInitServlet/servlet-name
url-pattern/InitServlet/url-pattern
/servlet-mapping
!-- All URLs end .ext. These are processed by the front
controller.
--
servlet-mappingservlet-nameRouter/servlet-name
url-pattern*.ext/url-pattern
/servlet-mapping
session-configsession-timeout30/session-timeout/session-config
welcome-file-listwelcome-fileindex.html/welcome-file
/welcome-file-list
error-pageerror-code404/error-code
location/404.html/location
/error-page
/web-app
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: Query with 404 error processing -- Tomcat 5.0.19
Hi,
Sorry, not sure I understand this. Is this not what I've done with
this?:
error-pageerror-code404/error-code
location/404.html/location
/error-page
Yeah, that is what you've done. I didn't read your original web.xml
carefully enough it seems ;)
My understanding of how this works is that any URL that ends with the
string
'.ext' will be picked up by my Servlet. Any other URL ('.jpg', '.jsp'
or
whatever) will thus fall through this, and my Router servlet will not
see
it. It keeps falling to the error-page code above.
That understanding is correct.
Enable (comment in) the AccessLogValve in your server.xml. That way you
will be able to see exactly what requested URLs result in 404s.
Yoav Shapira http://www.yoavshapira.com
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]
Query with 404 error processing -- Tomcat 5.0.19
Can someone please explain why I get the default Tomcat 404 error when a pages does not exist? I have a set of URLs that end with *.ext. These are all routed to a servlet called Router, and these all work fine. This servlet has catch-all at the end that displays an error message when an unknown *.ext is processed. That all works fine. However, when an unknown *.jsp file is processed I get the default Tomcat error: HTTP Status 404 - /unknown.jsp type Status report message /unknown.jsp description The requested resource (/unknown.jsp) is not available. Apache Tomcat/5.0.19 The error in the generates this output in the log file: 2004-12-13 00:40:10 ApplicationDispatcher[/Server] Servlet.service() for servlet default threw exception java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) ... 2004-12-13 00:40:10 [EMAIL PROTECTED]: Exception Processing ErrorPage[errorCode=404, location=/404.html] java.lang.ClassCastException at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:750) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:512) ... Here is my web.xml file: ?xml version=1.0 encoding=UTF-8? !DOCTYPE web-app PUBLIC -//Sun Microsystems, Inc.//DTD Web Application 2.3//EN http://java.sun.com/dtd/web-app_2_3.dtd; web-app display-nameMy server/display-name servletservlet-nameRouter/servlet-name servlet-classcom.mycompany.Router/servlet-class /servlet servletservlet-nameInitServlet/servlet-name servlet-classcom.mycompany.InitServlet/servlet-class load-on-startup2/load-on-startup /servlet servlet-mappingservlet-nameInitServlet/servlet-name url-pattern/InitServlet/url-pattern /servlet-mapping !-- All URLs end .ext. These are processed by the front controller. -- servlet-mappingservlet-nameRouter/servlet-name url-pattern*.ext/url-pattern /servlet-mapping session-configsession-timeout30/session-timeout/session-config welcome-file-listwelcome-fileindex.html/welcome-file /welcome-file-list error-pageerror-code404/error-code location/404.html/location /error-page /web-app And my 404.html file: html head /head body Error! /body /html Any help will be, as always, greatly appreciated. Joe. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
lose query args when using cgi and ssi together
We have set up Tomcat to process an SSI directive that is used in many
pages on our site (www.pesticideinfo.org):
!--#include virtual=/cgi-bin/myscript.pl?myqueryargs --
myscript.pl gets executed, but $ENV{QUERY_STRING} is defined but empty
(and other things that I would have thought might be defined such as
REQUEST_URI are not defined at all).
I consider this a bug, although maybe SSI and CGI weren't meant to be
used together this way. The exact same code worked when we had Apache
processing the SSI directive instead of Tomcat.
Can anyone suggest a workaround? Maybe some escaping trick that causes
the queryargs to get passed through? Is this fixed in some more recent
version of Tomcat (we are using Tomcat 4.1.18 (?) on Mac OS X 10.2)?
Thank you for any suggestions!
--Brian
P.S. I have tried the other relevant SSI directive
!--#exec cgi=/cgi-bin/myscript.pl?queryargs --
and get the same result.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: lose query args when using cgi and ssi together
Hi,
Using SSI and CGI together in Tomcat is something I haven't actually
tried. But I would nonetheless recommend trying a later Tomcat version:
5.5.4 or 5.0.28 at least. The reason for this recommendation is that
should you fine a bug in these versions, it's likely to get fixed,
whereas if you find a bug in Tomcat 4.x it's not as likely (and if a fix
is applied, it certainly won't be as timely as for 5.x).
Yoav Shapira http://www.yoavshapira.com
-Original Message-
From: Brian Hill [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 1:16 PM
To: [EMAIL PROTECTED]
Cc: Tony Choi
Subject: lose query args when using cgi and ssi together
We have set up Tomcat to process an SSI directive that is used in many
pages on our site (www.pesticideinfo.org):
!--#include virtual=/cgi-bin/myscript.pl?myqueryargs --
myscript.pl gets executed, but $ENV{QUERY_STRING} is defined but
empty
(and other things that I would have thought might be defined such as
REQUEST_URI are not defined at all).
I consider this a bug, although maybe SSI and CGI weren't meant to be
used together this way. The exact same code worked when we had Apache
processing the SSI directive instead of Tomcat.
Can anyone suggest a workaround? Maybe some escaping trick that causes
the queryargs to get passed through? Is this fixed in some more recent
version of Tomcat (we are using Tomcat 4.1.18 (?) on Mac OS X 10.2)?
Thank you for any suggestions!
--Brian
P.S. I have tried the other relevant SSI directive
!--#exec cgi=/cgi-bin/myscript.pl?queryargs --
and get the same result.
-
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]
problem with simultaneous query submissionS
here is my dopost method
// Code starts here
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws IOException, ServletException
{
System.out.println(Inside doPost);
String strQueryFlag =req.getParameter(new);
if(Integer.parseInt(strQueryFlag.toString())==NEW_QUERY)
{
System.out.println(New Search ...+strQueryString);
Query query = null;
session.removeAttribute(BookObjects);
ArrayList arLstBookDetails = new ArrayList(1);
try {
// Code to get data from Database or file
} catch (Exception e) {
e.printStackTrace();
}
try{
searchlog.println(--Creating objects--+ +session.getId()+
+queryString);
StringBuffer strDesc = null;
StringBuffer strBookID= null;
StringBuffer strItemName = null;
StringBuffer strItemCode = null;
StringBuffer strPrice = null;
StringBuffer strPageID= null;
StringBuffer strBookName = null;
StringBuffer strUrl = null;
StringBuffer strImage = null;
for (// access data one by one from structure )
{
try{
// for each element
strDesc = // get the data and store it
strBookID= // get the data and store it
strItemName = // get the data and store it
strItemCode = // get the data and store it
strPrice = // get the data and store it
strPageID= // get the data and store it
strBookName = // get the data and store it
strUrl = // get the data and store it
strImage = // get the data and store it
strPageID= // get the data and store it
if(hBookFromLucene.containsKey(strBookID.toString()))
{
BookDetails
BKDetails=(BookDetails)hBookFromLucene.get(strBookID.toString());
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
}
else
{
BookDetails BKDetails= new
BookDetails(strBookName,strBookID);
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
hBookFromLucene.put(strBookID.toString(),BKDetails);
// adding objects to arraylist
arLstBookDetails.add(BKDetails);
}
// one more structure to store all objects
m_objallBookDetails.addBook(strBookName,strBookID,strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
}catch(Exception e)
{
System.out.print(SearchDataBean: createBookObjects
1 +e.getMessage());
e.printStackTrace();
}
} // end of for
strBookName = strBookID = strPageID = strPrice =
strItemName = strDesc = strImage = strUrl = null;
}
searchlog.println(Putting data for session +session.getId()+
+arLstBookDetails.size());
// These twostructures together can store 10
data individually in session.
session.setAttribute(BookObjects,arLstBookDetails);
session.setAttribute(AllBookObj,m_objallBookDetails);
searchlog.println( --- Completed--- +arLstBookDetails.size());
}catch(Exception e)
{
System.out.println(SeachDataBean:getResultData: );
e.printStackTrace();
}
}
// Code ends here
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
RE: problem with simultaneous query submissions
Your problem shouldn't occur unless you use instance variables in your
servlet. A quick fix would be put
synchronized (session) {
}
Block outside your code.
-Original Message-
From: Satish Plakote [mailto:[EMAIL PROTECTED]
Sent: November 22, 2004 10:10 PM
To: Tomcat Users List
Subject: RE: problem with simultaneous query submissions
here is my dopost method
// Code starts here
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws IOException, ServletException
{
System.out.println(Inside doPost);
String strQueryFlag =req.getParameter(new);
if(Integer.parseInt(strQueryFlag.toString())==NEW_QUERY)
{
System.out.println(New Search ...+strQueryString);
Query query = null;
session.removeAttribute(BookObjects);
ArrayList arLstBookDetails = new ArrayList(1);
try {
// Code to get data from Database or file
} catch (Exception e) {
e.printStackTrace();
}
try{
searchlog.println(--Creating objects--+
+session.getId()+ +queryString);
StringBuffer strDesc = null;
StringBuffer strBookID= null;
StringBuffer strItemName = null;
StringBuffer strItemCode = null;
StringBuffer strPrice = null;
StringBuffer strPageID= null;
StringBuffer strBookName = null;
StringBuffer strUrl = null;
StringBuffer strImage = null;
for (// access data one by one from structure )
{
try{
// for each element
strDesc = // get the data and store it
strBookID= // get the data and store it
strItemName = // get the data and store it
strItemCode = // get the data and store it
strPrice = // get the data and store it
strPageID= // get the data and store it
strBookName = // get the data and store it
strUrl = // get the data and store it
strImage = // get the data and store it
strPageID= // get the data and store it
if(hBookFromLucene.containsKey(strBookID.toString()))
{
BookDetails
BKDetails=(BookDetails)hBookFromLucene.get(strBookID.toString());
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,
strImage,strUrl);
}
else
{
BookDetails BKDetails= new
BookDetails(strBookName,strBookID);
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,
strImage,strUrl);
hBookFromLucene.put(strBookID.toString(),BKDetails);
// adding objects to arraylist
arLstBookDetails.add(BKDetails);
}
// one more structure to store all objects
m_objallBookDetails.addBook(strBookName,strBookID,strPageID,strPrice,strItem
Name,strDesc,strItemCode,strImage,strUrl);
}catch(Exception e)
{
System.out.print(SearchDataBean:
createBookObjects 1 +e.getMessage());
e.printStackTrace();
}
} // end of for
strBookName = strBookID = strPageID = strPrice =
strItemName = strDesc = strImage = strUrl = null;
}
searchlog.println(Putting data for session
+session.getId()+ +arLstBookDetails.size());
// These twostructures together can store 10
data individually in session.
session.setAttribute(BookObjects,arLstBookDetails);
session.setAttribute(AllBookObj,m_objallBookDetails);
searchlog.println( --- Completed---
+arLstBookDetails.size());
}catch(Exception e)
{
System.out.println(SeachDataBean:getResultData: );
e.printStackTrace();
}
}
// Code ends here
The reason i am storing the data is session is the the user is given a lot
of filtering options and i don't want to go back to my data source retrieve
data and show.. all the filtering has to be done from objects in memory so
thatit takes the minimum possible time.
is the huge amount of data that i am storing that causes the problem ???
rgds
satish
-Original Message-
From: QM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 7:36 AM
To: Tomcat Users List
Subject: Re: problem with simultaneous query submissions
Please post a *new* message when
problem with simultaneous query submissions
hi, i am developing a search engine for my small database. I have written a servlet that takes the input from user , queries the database and creates objects of the information that is recieved. These objects (approximatley 10 ) are stored in the ArrayList which put in the session.using session.putAttribute() While testing i noticed that if i open two browsers,with two different session ID, if submitted simultaneoulsy , one browser stops execution. i.e one instance of the servlet stops.. where as the other one proceeds fine..This happens for n broswers.. There is no problem with database connection as i have tested it. My servlet is only extending the HttpServlet.And my arraylist is not a class instance variable.each instance of the servlet is expected to keep its own copy.. I am not able to figure out what is the problem.. Pls help.. rgds satish - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: problem with simultaneous query submissions
Please post a *new* message when writing to the list. Replying to an old (unrelated) message confuses thread-aware mailers, which makes your question harder to find (and thus answer). On Tue, Nov 23, 2004 at 07:13:21AM +0530, Satish Plakote wrote: : I have written a servlet that takes the input from user , queries the database and creates objects of the information that is : recieved. These objects (approximatley 10 ) are stored in the ArrayList which put in the session.using session.putAttribute() You're storing an ArrayList of 100,000 elements in the user session? That's bound to cause problems... For one, think of the amount of data being pulled back from the database, not to mention the memory used by these objects. You'd do well to limit the scope of the DB result list, even if that's not (directly) related to the problem. : While testing i noticed that if i open two browsers,with two different session ID, if submitted simultaneoulsy , one browser stops : execution. i.e one instance of the servlet stops.. where as the other one proceeds fine..This happens for n broswers.. Do you open two different browsers, or two windows of the same browser? : There is no problem with database connection as i have tested it. Exactly how have you tested this? : My servlet is only extending the HttpServlet.And my arraylist is not a class instance variable.each instance of the servlet is : expected to keep its own copy.. Post the code, and someone here may be able to take a look at it. -QM -- software -- http://www.brandxdev.net tech news -- http://www.RoarNetworX.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: problem with simultaneous query submissions
here is my dopost method
// Code starts here
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws IOException, ServletException
{
System.out.println(Inside doPost);
String strQueryFlag =req.getParameter(new);
if(Integer.parseInt(strQueryFlag.toString())==NEW_QUERY)
{
System.out.println(New Search ...+strQueryString);
Query query = null;
session.removeAttribute(BookObjects);
ArrayList arLstBookDetails = new ArrayList(1);
try {
// Code to get data from Database or file
} catch (Exception e) {
e.printStackTrace();
}
try{
searchlog.println(--Creating objects--+ +session.getId()+
+queryString);
StringBuffer strDesc = null;
StringBuffer strBookID= null;
StringBuffer strItemName = null;
StringBuffer strItemCode = null;
StringBuffer strPrice = null;
StringBuffer strPageID= null;
StringBuffer strBookName = null;
StringBuffer strUrl = null;
StringBuffer strImage = null;
for (// access data one by one from structure )
{
try{
// for each element
strDesc = // get the data and store it
strBookID= // get the data and store it
strItemName = // get the data and store it
strItemCode = // get the data and store it
strPrice = // get the data and store it
strPageID= // get the data and store it
strBookName = // get the data and store it
strUrl = // get the data and store it
strImage = // get the data and store it
strPageID= // get the data and store it
if(hBookFromLucene.containsKey(strBookID.toString()))
{
BookDetails
BKDetails=(BookDetails)hBookFromLucene.get(strBookID.toString());
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
}
else
{
BookDetails BKDetails= new
BookDetails(strBookName,strBookID);
BKDetails.addPageDetails(strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
hBookFromLucene.put(strBookID.toString(),BKDetails);
// adding objects to arraylist
arLstBookDetails.add(BKDetails);
}
// one more structure to store all objects
m_objallBookDetails.addBook(strBookName,strBookID,strPageID,strPrice,strItemName,strDesc,strItemCode,strImage,strUrl);
}catch(Exception e)
{
System.out.print(SearchDataBean: createBookObjects
1 +e.getMessage());
e.printStackTrace();
}
} // end of for
strBookName = strBookID = strPageID = strPrice =
strItemName = strDesc = strImage = strUrl = null;
}
searchlog.println(Putting data for session +session.getId()+
+arLstBookDetails.size());
// These twostructures together can store 10
data individually in session.
session.setAttribute(BookObjects,arLstBookDetails);
session.setAttribute(AllBookObj,m_objallBookDetails);
searchlog.println( --- Completed--- +arLstBookDetails.size());
}catch(Exception e)
{
System.out.println(SeachDataBean:getResultData: );
e.printStackTrace();
}
}
// Code ends here
The reason i am storing the data is session is the the user is given a lot of
filtering options and i don't want to go back to my
data source retrieve data and show.. all the filtering has to be done from
objects in memory so thatit takes the minimum possible
time.
is the huge amount of data that i am storing that causes the problem ???
rgds
satish
-Original Message-
From: QM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 7:36 AM
To: Tomcat Users List
Subject: Re: problem with simultaneous query submissions
Please post a *new* message when writing to the list. Replying to an
old (unrelated) message confuses thread-aware mailers, which makes
your question harder to find (and thus answer).
On Tue, Nov 23, 2004 at 07:13:21AM +0530, Satish Plakote wrote:
: I have written
Query: How to auto-recover from a W2K power bounce ...
I have a 3rd party app running on W2K Server supported by Tomcat 5.0.27 J2SDK 1.4.2_05. I want to set up the box so that Java Tomcat auto-recover if the box is inadvertently bounced. The batch file which I wrote to establish environmental variables start Tomcat (to build the server debug the app) works fine manually but when I define a W2K Started Task bounce the box, it does not fire. I have the task defined under the server's administrative logon ID. Any suggestions on a bullet proof autorecovery that is (hopefully) simple to set up? Thank you, DH Disclaimer: This electronic message, including any attachments, is confidential and intended solely for use of the intended recipient(s). This message may contain information that is privileged or otherwise protected from disclosure by applicable law. Any unauthorized disclosure, dissemination, use or reproduction is strictly prohibited. If you have received this message in error, please delete it and notify the sender immediately. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Query: How to auto-recover from a W2K power bounce ...
register tomcat as a service i do use it that way and is pretty bullet proof... the installer does that for you Hensley, Doug escribió: I have a 3rd party app running on W2K Server supported by Tomcat 5.0.27 J2SDK 1.4.2_05. I want to set up the box so that Java Tomcat auto-recover if the box is inadvertently bounced. The batch file which I wrote to establish environmental variables start Tomcat (to build the server debug the app) works fine manually but when I define a W2K Started Task bounce the box, it does not fire. I have the task defined under the server's administrative logon ID. Any suggestions on a bullet proof autorecovery that is (hopefully) simple to set up? Thank you, DH Disclaimer: This electronic message, including any attachments, is confidential and intended solely for use of the intended recipient(s). This message may contain information that is privileged or otherwise protected from disclosure by applicable law. Any unauthorized disclosure, dissemination, use or reproduction is strictly prohibited. If you have received this message in error, please delete it and notify the sender immediately. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Query: How to auto-recover from a W2K power bounce ...
John, thank you. Is there any issue with JAVA having to stabilize before Tomcat is started during an auto-recover? For instance, should there be a time delay? -Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 3:32 PM To: Tomcat Users List Subject: Re: Query: How to auto-recover from a W2K power bounce ... register tomcat as a service i do use it that way and is pretty bullet proof... the installer does that for you Hensley, Doug escribió: I have a 3rd party app running on W2K Server supported by Tomcat 5.0.27 J2SDK 1.4.2_05. I want to set up the box so that Java Tomcat auto-recover if the box is inadvertently bounced. The batch file which I wrote to establish environmental variables start Tomcat (to build the server debug the app) works fine manually but when I define a W2K Started Task bounce the box, it does not fire. I have the task defined under the server's administrative logon ID. Any suggestions on a bullet proof autorecovery that is (hopefully) simple to set up? Thank you, DH Disclaimer: This electronic message, including any attachments, is confidential and intended solely for use of the intended recipient(s). This message may contain information that is privileged or otherwise protected from disclosure by applicable law. Any unauthorized disclosure, dissemination, use or reproduction is strictly prohibited. If you have received this message in error, please delete it and notify the sender immediately. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com Disclaimer: This electronic message, including any attachments, is confidential and intended solely for use of the intended recipient(s). This message may contain information that is privileged or otherwise protected from disclosure by applicable law. Any unauthorized disclosure, dissemination, use or reproduction is strictly prohibited. If you have received this message in error, please delete it and notify the sender immediately. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Query: How to auto-recover from a W2K power bounce ...
No... just the normal W2K recover procedure... Java is just another app running on your server. Hensley, Doug escribió: John, thank you. Is there any issue with JAVA having to stabilize before Tomcat is started during an auto-recover? For instance, should there be a time delay? -Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 3:32 PM To: Tomcat Users List Subject: Re: Query: How to auto-recover from a W2K power bounce ... register tomcat as a service i do use it that way and is pretty bullet proof... the installer does that for you Hensley, Doug escribió: I have a 3rd party app running on W2K Server supported by Tomcat 5.0.27 J2SDK 1.4.2_05. I want to set up the box so that Java Tomcat auto-recover if the box is inadvertently bounced. The batch file which I wrote to establish environmental variables start Tomcat (to build the server debug the app) works fine manually but when I define a W2K Started Task bounce the box, it does not fire. I have the task defined under the server's administrative logon ID. Any suggestions on a bullet proof autorecovery that is (hopefully) simple to set up? Thank you, DH Disclaimer: This electronic message, including any attachments, is confidential and intended solely for use of the intended recipient(s). This message may contain information that is privileged or otherwise protected from disclosure by applicable law. Any unauthorized disclosure, dissemination, use or reproduction is strictly prohibited. If you have received this message in error, please delete it and notify the sender immediately. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat config - query
Hi, I am using tomcat4.1.30 with oracle 8.0i . I have one query regards to tomcat configuration file. I want to read datasource name and connection url from the config file without parsing config file(parser). Is there any way to read config data using some API using java. Is there any API available with tomcat catalina.Can you please help me out by providing sample code/snippets? regards, shyam Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat config - query
Hi, Once you can the DataSource reference via JNDI, you could cast it explicitly to your DBCP class, and call the DBCP API methods to obtain all the information you want about the pool, including the URL and such. Yoav Shapira Millennium Research Informatics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 8:48 AM To: [EMAIL PROTECTED] Subject: Tomcat config - query Hi, I am using tomcat4.1.30 with oracle 8.0i . I have one query regards to tomcat configuration file. I want to read datasource name and connection url from the config file without parsing config file(parser). Is there any way to read config data using some API using java. Is there any API available with tomcat catalina.Can you please help me out by providing sample code/snippets? regards, shyam Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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 config - query
Hi, I want to get all the datasource names and their corresponding urls. Say if there are 4 datasources with there corresponding urls using java without parsing config file. Datasource1 11.122.333.12.1 Datasource2 11.122.333.12.2 Datasource3 11.122.333.12.3 Datasource4 11.122.333.12.4 Is threre some of doing like this using Some tomcat API ? Please help with some sample code/snippets. Regards, shyam -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 6:23 PM To: Tomcat Users List Subject: RE: Tomcat config - query Hi, Once you can the DataSource reference via JNDI, you could cast it explicitly to your DBCP class, and call the DBCP API methods to obtain all the information you want about the pool, including the URL and such. Yoav Shapira Millennium Research Informatics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 8:48 AM To: [EMAIL PROTECTED] Subject: Tomcat config - query Hi, I am using tomcat4.1.30 with oracle 8.0i . I have one query regards to tomcat configuration file. I want to read datasource name and connection url from the config file without parsing config file(parser). Is there any way to read config data using some API using java. Is there any API available with tomcat catalina.Can you please help me out by providing sample code/snippets? regards, shyam Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat config - query
Hi, I want to get all the datasource names and their corresponding urls. Say if there are 4 datasources with there corresponding urls using java without parsing config file. Datasource1 11.122.333.12.1 Datasource2 11.122.333.12.2 Datasource3 11.122.333.12.3 Datasource4 11.122.333.12.4 Is there any way of doing this using Some tomcat API ? Please help with some sample code/snippets. Regards, shyam -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 6:23 PM To: Tomcat Users List Subject: RE: Tomcat config - query Hi, Once you can the DataSource reference via JNDI, you could cast it explicitly to your DBCP class, and call the DBCP API methods to obtain all the information you want about the pool, including the URL and such. Yoav Shapira Millennium Research Informatics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 8:48 AM To: [EMAIL PROTECTED] Subject: Tomcat config - query Hi, I am using tomcat4.1.30 with oracle 8.0i . I have one query regards to tomcat configuration file. I want to read datasource name and connection url from the config file without parsing config file(parser). Is there any way to read config data using some API using java. Is there any API available with tomcat catalina.Can you please help me out by providing sample code/snippets? regards, shyam Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat config - query
Hi, When you configure these datasources in server.xml, you give them names. You then use these names to do the JNDI lookup. Alternatively, if you don't know the names or don't want to hard-code them, you could use Context#listBindings. Then iterate through all of them and see which ones you can cast to a DataSource or the DBCP implementation class for the DataSource. Then it's simple to use the DBCP API. Nothing here is Tomcat-specific. If you're not familiar with the JNDI API, it's a Sun Specification and you can find information on it in various J2EE tutorials and books. If you're not familiar with the DBCP API, see the site at http://jakarta.apache.org/commons/dbcp. Yoav Shapira Millennium Research Informatics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 9:06 AM To: [EMAIL PROTECTED] Subject: RE: Tomcat config - query Hi, I want to get all the datasource names and their corresponding urls. Say if there are 4 datasources with there corresponding urls using java without parsing config file. Datasource1 11.122.333.12.1 Datasource2 11.122.333.12.2 Datasource3 11.122.333.12.3 Datasource4 11.122.333.12.4 Is threre some of doing like this using Some tomcat API ? Please help with some sample code/snippets. Regards, shyam -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 6:23 PM To: Tomcat Users List Subject: RE: Tomcat config - query Hi, Once you can the DataSource reference via JNDI, you could cast it explicitly to your DBCP class, and call the DBCP API methods to obtain all the information you want about the pool, including the URL and such. Yoav Shapira Millennium Research Informatics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 8:48 AM To: [EMAIL PROTECTED] Subject: Tomcat config - query Hi, I am using tomcat4.1.30 with oracle 8.0i . I have one query regards to tomcat configuration file. I want to read datasource name and connection url from the config file without parsing config file(parser). Is there any way to read config data using some API using java. Is there any API available with tomcat catalina.Can you please help me out by providing sample code/snippets? regards, shyam Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - 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: mod_jk2 ./configure problem/query
Sorry to say but I have gone through the whole process 3 times now (including re-installing Redhat itself) and I still get error 503 Service Temporarily Unavailable. I reckon it must be a permissions problem but where? I have tried the following: chmod 666 jk2.socket I tried changing the path to the file workers2.properties in httpd.conf. Doing this changes the error message to 404, page not found so the file workers2.properties is being read. I have done as instructed on permissions but i wonder if Apache still doesn't have any rights to call the Tomcat engine. I have Tomcat running fine as a standalone. Any further ideas? Cheers Tim - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: mod_jk2 ./configure problem/query
Tim Wills wrote: Sorry to say but I have gone through the whole process 3 times now (including re-installing Redhat itself) and I still get error 503 Service Temporarily Unavailable. I reckon it must be a permissions problem but where? I have tried the following: chmod 666 jk2.socket I tried changing the path to the file workers2.properties in httpd.conf. Doing this changes the error message to 404, page not found so the file workers2.properties is being read. I have done as instructed on permissions but i wonder if Apache still doesn't have any rights to call the Tomcat engine. I have Tomcat running fine as a standalone. Any further ideas? What user did you build Apache as? What group? Also, what user and group is Apache running under? Regards, pascal chong - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: mod_jk2 ./configure problem/query
At 06:41 AM 5/07/2004 +0100, you wrote: I read your article before posting that question but I didn't realise it applied to my situation. Were you getting that error message when you ran ./configure ?? I did for a while. Then I found out the one in my path was the wrong version of apr-config. I had one in /usr/bin for memory and the other in /usr/local/apache/bin (the directory where I had installed Apache). I think at the time I went in and modified the config file and told it don't bother looking for it, which worked, but then later I blew that directory away and restarted everything from scratch. Interestingly the second time around it seemed to work fine... Which probably doesn't help you any. Cheers, Ryan. -- Ryan McConigley - Systems Administrator _.-, Computer Science University of Western Australia.--' '-._ Tel: (+61 8) 6488 7082 - Fax: (+61 8) 6488 1089 _/`- _ '. [EMAIL PROTECTED] - http://www.csse.uwa.edu.au/~ryan ''._`.. \ ` \; You're just jealous because the voices are talking to me;_\ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: mod_jk2 ./configure problem/query
Reading your article more thoroughly, I am a bit confused on a number of matters. 1. Why am I seemingly editing Apache's Makefile (I assume from the directory you have given) and not mod_jk2? Does the apxs command read that file? 2. I checked Apache's make file and it has no reference to JK_LDFLAGS. 3. How do you actually know which apu-config? I have found 2 under /usr path being: /usr/local/apache2/bin /usr/local/httpd-2.0.49/srclib/apr-util/ I assume the top one ?? Cheers Tim -Original Message- From: Ryan McConigley [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 08:22 To: Tomcat Users List Subject: RE: mod_jk2 ./configure problem/query At 06:41 AM 5/07/2004 +0100, you wrote: I read your article before posting that question but I didn't realise it applied to my situation. Were you getting that error message when you ran ./configure ?? I did for a while. Then I found out the one in my path was the wrong version of apr-config. I had one in /usr/bin for memory and the other in /usr/local/apache/bin (the directory where I had installed Apache). I think at the time I went in and modified the config file and told it don't bother looking for it, which worked, but then later I blew that directory away and restarted everything from scratch. Interestingly the second time around it seemed to work fine... Which probably doesn't help you any. Cheers, Ryan. -- Ryan McConigley - Systems Administrator _.-, Computer Science University of Western Australia.--' '-._ Tel: (+61 8) 6488 7082 - Fax: (+61 8) 6488 1089 _/`- _ '. [EMAIL PROTECTED] - http://www.csse.uwa.edu.au/~ryan ''._`.. \ ` \; You're just jealous because the voices are talking to me ;_\ - 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: mod_jk2 ./configure problem/query
Tim Wills wrote: Reading your article more thoroughly, I am a bit confused on a number of matters. 1. Why am I seemingly editing Apache's Makefile (I assume from the directory you have given) and not mod_jk2? Does the apxs command read that file? 2. I checked Apache's make file and it has no reference to JK_LDFLAGS. 3. How do you actually know which apu-config? I have found 2 under /usr path being: /usr/local/apache2/bin /usr/local/httpd-2.0.49/srclib/apr-util/ I assume the top one ?? That's odd. Why would you have two different Apache directories under /usr/local ? Can you check if you have another Apache installed ? Try rpm -qa | grep httpd Regards, pascal chong - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
mod_jk2 ./configure problem/query
I am having problems installing mod_jk2 and although I have not isolated what it is, one thing is worrying me. I have installed Apache 2.0.49 and Tomcat 5.0.25 (on Redhat 9) from source and they both run fine. When I run the command: ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-apr-lib=/usr/lib --with-tomcat-41=/usr/local/tomcat --with-java-home=/usr/local/java --with- jni I get the following error: ./configure: line 1: apr-config: command not found I run the Linux find command and apr-config is indeed in /usr/lib (and two other places aswell) so why is it throwing that error message. I have discussed this problem with a couple of list members who have overcome installation issues themselves but they are using Fedora 2 or rpm installations of Apache. Do I actually need --with-apr-lib=/usr/lib ? (He asks in a novice type of way) Cheers Phil - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: mod_jk2 ./configure problem/query
At 03:35 AM 5/07/2004 +0100, you wrote: I am having problems installing mod_jk2 and although I have not isolated what it is, one thing is worrying me. I have installed Apache 2.0.49 and Tomcat 5.0.25 (on Redhat 9) from source and they both run fine. When I run the command: ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-apr-lib=/usr/lib --with-tomcat-41=/usr/local/tomcat --with-java-home=/usr/local/java --with- jni I get the following error: ./configure: line 1: apr-config: command not found I run the Linux find command and apr-config is indeed in /usr/lib (and two other places aswell) so why is it throwing that error message. I have discussed this problem with a couple of list members who have overcome installation issues themselves but they are using Fedora 2 or rpm installations of Apache. Do I actually need --with-apr-lib=/usr/lib ? (He asks in a novice type of way) Woohoo. A question I can answer. I had this problem about two weeks ago. Here is the weblink (thanks to [EMAIL PROTECTED]) I used to solve my problem -- http://cymulacrum.net/writings/tomcat5/a1375.html (needed to be modified slightly) And my own walk-through notes are here -- http://www.csse.uwa.edu.au/~ryan/tech/mod_jk2.html Essentially you need to add in one/some additional libraries into one of the make files. Just make sure you get the right library paths, but see the web pages for the details as I'm guessing its a system dependant thing. Cheers, Ryan. -- Ryan McConigley - Systems Administrator _.-, Computer Science University of Western Australia.--' '-._ Tel: (+61 8) 6488 7082 - Fax: (+61 8) 6488 1089 _/`- _ '. [EMAIL PROTECTED] - http://www.csse.uwa.edu.au/~ryan ''._`.. \ ` \; You're just jealous because the voices are talking to me;_\ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: mod_jk2 ./configure problem/query
I read your article before posting that question but I didn't realise it applied to my situation. Were you getting that error message when you ran ./configure ?? Cheers Tim At 03:35 AM 5/07/2004 +0100, you wrote: I am having problems installing mod_jk2 and although I have not isolated what it is, one thing is worrying me. I have installed Apache 2.0.49 and Tomcat 5.0.25 (on Redhat 9) from source and they both run fine. When I run the command: ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-apr-lib=/usr/li b --with-tomcat-41=/usr/local/tomcat --with-java-home=/usr/local/java --wit h- jni I get the following error: ./configure: line 1: apr-config: command not found I run the Linux find command and apr-config is indeed in /usr/lib (and two other places aswell) so why is it throwing that error message. I have discussed this problem with a couple of list members who have overcome installation issues themselves but they are using Fedora 2 or rpm installations of Apache. Do I actually need --with-apr-lib=/usr/lib ? (He asks in a novice type of way) Woohoo. A question I can answer. I had this problem about two weeks ago. Here is the weblink (thanks to [EMAIL PROTECTED]) I used to solve my problem -- http://cymulacrum.net/writings/tomcat5/a1375.html (needed to be modified slightly) And my own walk-through notes are here -- http://www.csse.uwa.edu.au/~ryan/tech/mod_jk2.html Essentially you need to add in one/some additional libraries into one of the make files. Just make sure you get the right library paths, but see the web pages for the details as I'm guessing its a system dependant thing. I have read you - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat-- web.xml -- context -- element query
Hi Yoav (et. al.), Thanks for the info. regarding switching off debugging compeltely. I am aware of the swallowOutput and the DefaultContext parameters. Could you please tell me which parameter I could use, to switch-off the debugging completely inside the context( presumably its the same for DefaultContext). I have tried setting debug=0 but it doesnt work as you described, i.e. that the logfile size remains at 0 bytes. Please find an extract from my context below. Context path=/InGeoWebEntryTool docBase=D:\Tomcat\Tomcat 4.1\webapps\InGeoWebEntryTool reloadable=false debug=0 swallowOutput=true I hope you can help. regards, Ben p.s. what paramter can I set to garantee that the servlets in /work/Standalone/* is always re-generated each time Tomcat is re-started. -Ursprungliche Nachricht- Von: Shapira, Yoav [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juni 2004 17:25 An: Tomcat Users List; [EMAIL PROTECTED] Betreff: RE: Override the system.outs so that no Tomcat Logfile is produced. Hi, It's possible to redirect System.out/System.err from each webapp to the context's log instead of catalina.out using the Context's swallowOutput attribute. Further, you can add swallowOutput to the DefaultContext element, thereby establishing that for all webapps using one parameter in in server.xml. However, tomcat will still use System.out (which goes to $CATALINA_HOME/logs/catalina.out by default) for some of its own logging: you can configure that further by configuring commons-logging (see the tomcat FAQ entry on configuring tomcat's internal logging). I think even with these configuration entries, however, the catalina.out file will still be touched, so it will be produced although stay at zero size. You can probably avoid even the latter using OS-specific redirection syntax, such as 21 /dev/null or whatever. Yoav Shapira Millennium Research Informatics -Original Message- From: Ben Bookey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 11:14 AM To: Tomcat User List Subject: Override the system.outs so that no Tomcat Logfile is produced. Is it possible with a single server.xml (or web.xml) paramter, to overide all the System.out's in my webApp so that no logfile is produced. Many thanks in advance. BB - 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-- web.xml -- context -- element query
MatrixOne Tech Support eMail incident submission functionality requires specific subject line. The following subject lines are recognized. Request for CustomerLink Access - This will submit a request for new CustomerLink account Request for CustomerLink Password Reset - This will submit a request for existing CustomerLink account password reset Submit [PUT YOUR SUBJECT LINE HERE] - This will submit a new incident (please only use when CustomerLink is not available to ensure prompt service) Keywords Request or Submit must be the 1st word in the subject line. If you already have a CustomerLink account, please use CustomerLink (https://customerlink.matrixone.com) to submit or update your incidents. Otherwise, please resend your message with the required subject line. Thank you! MatrixOne Tech Support - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat-- web.xml -- context -- element query
Hi, I have tried setting debug=0 but it doesnt work as you described, i.e. I didn't say to set debug=0 (though I should have). Most of tomcat's logging is done via commons-logging. You need to write a commons-logging configuration file (there's a FAQ entry on how to do this) and set the level for org.apache to OFF (or maybe FATAL, your choice). p.s. what paramter can I set to garantee that the servlets in /work/Standalone/* is always re-generated each time Tomcat is re-started. Please start a new thread for new questions. Yoav 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: (Query)Running Program on Tomcat
Are you saying you have /webapps /greetings web.xml whatever.class index.html for your file structure? Wendell Holmes -Original Message- From: mohit agarwal [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 7:12 AM To: [EMAIL PROTECTED] Subject: (Query)Running Program on Tomcat Hello, Please help me come out of this problem. The environment i m having is: Operating System - Windows XP J2sdk1.4.2_04 Tomcat 5.0.19 I am able to compile my servlet program, but when it comes to running it i got the HTTP Status Error 404 which points to file not found. I came to that i need to do some configuration settings. Asper the info i had uncommented both the Servlet and the Servlet -Mapping for the invoker servlet which are commented out in this version. I was hope ful that the program would run biut it still shown the same error. The entire program consisting of index.html , the .class file and the web.xml is contained in the greeting folder which is placed inside the webapps folder.. Try to point the solution to my problem.Moreover tell me if for JSP also i need to do some configuration settings. Regards, mohit Yahoo! India Matrimony: Find your partner online. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
(Query)Running Program on Tomcat
Hello, Please help me come out of this problem. The environment i m having is: Operating System - Windows XP J2sdk1.4.2_04 Tomcat 5.0.19 I am able to compile my servlet program, but when it comes to running it i got the HTTP Status Error 404 which points to file not found. I came to that i need to do some configuration settings. Asper the info i had uncommented both the Servlet and the Servlet -Mapping for the invoker servlet which are commented out in this version. I was hope ful that the program would run biut it still shown the same error. The entire program consisting of index.html , the .class file and the web.xml is contained in the greeting folder which is placed inside the webapps folder.. Try to point the solution to my problem.Moreover tell me if for JSP also i need to do some configuration settings. Regards, mohit Yahoo! India Matrimony: Find your partner online.
RE: (Query)Running Program on Tomcat
Hi, What is your servlet's mapping and what is the URL you're using to access the servlet? Do you have any errors in your logs? You don't need to map JSPs pages, the JSP servlet automagically handles that for you. Yoav Shapira Millennium Research Informatics -Original Message- From: mohit agarwal [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 9:12 AM To: [EMAIL PROTECTED] Subject: (Query)Running Program on Tomcat Hello, Please help me come out of this problem. The environment i m having is: Operating System - Windows XP J2sdk1.4.2_04 Tomcat 5.0.19 I am able to compile my servlet program, but when it comes to running it i got the HTTP Status Error 404 which points to file not found. I came to that i need to do some configuration settings. Asper the info i had uncommented both the Servlet and the Servlet -Mapping for the invoker servlet which are commented out in this version. I was hope ful that the program would run biut it still shown the same error. The entire program consisting of index.html , the .class file and the web.xml is contained in the greeting folder which is placed inside the webapps folder.. Try to point the solution to my problem.Moreover tell me if for JSP also i need to do some configuration settings. Regards, mohit Yahoo! India Matrimony: Find your partner online. 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: auth-method query
I have already authenticated, but I am not authenticating for this particular request. -Original Message- From: Koes, Derrick Sent: Wednesday, March 24, 2004 6:50 PM To: '[EMAIL PROTECTED]' Subject: auth-method query I wish to programmatically check for the auth-method using Tomcat 4.1.18. The HttpServletRequest class provides a getAuthType method, but this is only good for an authentication request. How do I retrieve the auth type used for the web container at runtime for a non-authentication request? I guess I could add it to the session upon authentication, but I was curious if there was another way. Thanks, Derrick This electronic transmission is strictly confidential to Smith Nephew and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. This electronic transmission is strictly confidential to Smith Nephew and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: auth-method query
You can't. If your not authenticated - then getAuthType() can't be filled in -Tim Koes, Derrick wrote: I wish to programmatically check for the auth-method using Tomcat 4.1.18. The HttpServletRequest class provides a getAuthType method, but this is only good for an authentication request. How do I retrieve the auth type used for the web container at runtime for a non-authentication request? I guess I could add it to the session upon authentication, but I was curious if there was another way. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
auth-method query
I wish to programmatically check for the auth-method using Tomcat 4.1.18. The HttpServletRequest class provides a getAuthType method, but this is only good for an authentication request. How do I retrieve the auth type used for the web container at runtime for a non-authentication request? I guess I could add it to the session upon authentication, but I was curious if there was another way. Thanks, Derrick This electronic transmission is strictly confidential to Smith Nephew and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message.
Query about remote_user header Tomcat 5.0.16
I've googled to every relevant doc I can find on this and can't seem to locate a reason for it. Hopefully someone on the list can help. Here's the setup: Apache 1.3.28 web server acts as a front-end to the public. It has a special home-grown authentication module for use here at Cornell used to protect some web pages with Kerberos identities and sets a header, HTTP_REMOTE_USER, with the username of the successfully authenticated user. No big deal. I was just using mod_rewrite to proxy the request back to Tomcat for processing and Cocoon would pick up the header as remote_user. Tomcat wouldn't even see the request unless the user was authenticated. Here's the problem: I had to switch to Struts for an app I'm working on and now I can't get the remote_user header any more unless I use the mod_jk connector. Is there any reason the HTTP_REMOTE_USER header isn't accepted by the Coyote connector? As far as I can tell, this isn't a Struts issue. Struts code appears to simply give the action class an instance of HttpServletRequest with out alteration. I'd prefer to use mod_rewrite and proxy the Tomcat service as much as possible because it allows me more flexibility in mapping requests back to Tomcat. Thanks for any help you can offer. --David - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
These queries all seem like an awful lot of unnecessary processing. Here's what I use: SELECT 1+1 -Original Message- From: Antonio Fiol Bonnín [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:25 AM To: Tomcat Users List Subject: Re: Microsoft SQL Server validation query For any database server I can think of: CREATE TABLE validation ( dummy char(1) ); INSERT INTO validation VALUES ( 'X' ); -- and make sure you do this only once And then use as a validation query: SELECT * FROM validation; Well. Yes. I am ashamed of reimplementing Oracle's DUAL, but if you really want to know of a table that will always be there, provide it yourself. And anyway, I mostly agree with Mike's statement about server-specific params in the config files: Adding one more ... is not too much of a burden. Only if you set the validation query from outside the config files, which is very unlikely, Mike's statement would not strictly apply IMHO. Antonio Fiol Derek Mahar wrote: Thank you to all of you for your quick replies. It seems that the connection pool validation query is not specific to any database server implementation unless the query statement itself is server-specific (that is, it refers to a special server system database, table, or function). I like the idea of querying the server for the date, but I'm not sure that the date function is standard SQL and portable across all server implementations. Does anyone know otherwise? Derek -Original Message- From: Peter Lin [mailto:[EMAIL PROTECTED] Sent: January 8, 2004 10:35 AM To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query in the past I just select the date from sql server. unless you want to test a specific table, but that has potential performance impact. the safe simple query to see if sql server is alive is to just select the date. peter lin Allistair Crossley [EMAIL PROTECTED] wrote: I would not do that because that would return as many 1s as there are rows in the table. Something like count(*) may not be the most efficient but it returns just 1 row always. Also with using 1, you cannot guarantee a row will come back. Allistair Crossley __ Intranet Senior Developer New Media Group, QAS Ltd Telephone: 020 7819 5343 __ -Original Message- From: Michael Duffy [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:25 To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query Or even SELECT 1 FROM TABLE. No COUNT overhead, if any. - MOD --- Allistair Crossley wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Microsoft SQL Server validation query
Hooper, Brian wrote: These queries all seem like an awful lot of unnecessary processing. Here's what I use: SELECT 1+1 Indeed. If your server supports it, there is an even simpler one: select 1 or select 0. But this is not correct SQL for an Oracle server. Equivalent Oracle syntax is select 1 from dual. But on other servers, dual does not exist by default. Well... you see what I mean... Antonio smime.p7s Description: S/MIME Cryptographic Signature
RE: Microsoft SQL Server validation query
Oops, I didn't realize those types of queries don't fly on other databases. Thanks for the tip. -Original Message- From: Antonio Fiol Bonnín [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:03 PM To: Tomcat Users List Subject: Re: Microsoft SQL Server validation query Hooper, Brian wrote: These queries all seem like an awful lot of unnecessary processing. Here's what I use: SELECT 1+1 Indeed. If your server supports it, there is an even simpler one: select 1 or select 0. But this is not correct SQL for an Oracle server. Equivalent Oracle syntax is select 1 from dual. But on other servers, dual does not exist by default. Well... you see what I mean... Antonio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
How about one of these: Select @@VERSION Or Select getdate() as CurrentDate -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 8:15 AM To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - 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: Microsoft SQL Server validation query
How about one of these: Select @@VERSION Or Select getdate() as CurrentDate I would rather use: SELECT CURRENT_DATE since CURRENT_DATE (no parenthesis) is standard SQL, I am not aware if this suffers the same problems as SELECT 1 on Oracle. Another function is COUNT(), and if that is not present on a system... Giuliano -- H U M P H || ||| software Java C++ Server/Client/Human Interface applications on MacOS - MacOS X http://www.humph.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Microsoft SQL Server validation query
Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
Any, such as if you have a user table, Select lastname from user where userid = 1 It's just a query which is going to return results. -Art D'Alessandro CBE Technologies Office: 617-514-1785 Cell: 617-905-5917 -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:15 AM To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - 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: Microsoft SQL Server validation query
i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
Or even SELECT 1 FROM TABLE. No COUNT overhead, if any. - MOD --- Allistair Crossley [EMAIL PROTECTED] wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
I would not do that because that would return as many 1s as there are rows in the table. Something like count(*) may not be the most efficient but it returns just 1 row always. Also with using 1, you cannot guarantee a row will come back. Allistair Crossley __ Intranet Senior Developer New Media Group, QAS Ltd Telephone: 020 7819 5343 __ -Original Message- From: Michael Duffy [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:25 To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query Or even SELECT 1 FROM TABLE. No COUNT overhead, if any. - MOD --- Allistair Crossley [EMAIL PROTECTED] wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - 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: Microsoft SQL Server validation query
in the past I just select the date from sql server. unless you want to test a specific table, but that has potential performance impact. the safe simple query to see if sql server is alive is to just select the date. peter lin Allistair Crossley [EMAIL PROTECTED] wrote: I would not do that because that would return as many 1s as there are rows in the table. Something like count(*) may not be the most efficient but it returns just 1 row always. Also with using 1, you cannot guarantee a row will come back. Allistair Crossley __ Intranet Senior Developer New Media Group, QAS Ltd Telephone: 020 7819 5343 __ -Original Message- From: Michael Duffy [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:25 To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query Or even SELECT 1 FROM TABLE. No COUNT overhead, if any. - MOD --- Allistair Crossley wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- QAS Ltd. Developers of QuickAddress Software www.qas.com Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - 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] - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
RE: Microsoft SQL Server validation query
If that takes to long, you can limit the search, if you have a table with an indexed column where you know that there is certain id SELECT 1 FROM TABLE WHERE ID = known id (We always have such tables) --- Allistair Crossley [EMAIL PROTECTED] wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
Thank you to all of you for your quick replies. It seems that the connection pool validation query is not specific to any database server implementation unless the query statement itself is server-specific (that is, it refers to a special server system database, table, or function). I like the idea of querying the server for the date, but I'm not sure that the date function is standard SQL and portable across all server implementations. Does anyone know otherwise? Derek -Original Message- From: Peter Lin [mailto:[EMAIL PROTECTED] Sent: January 8, 2004 10:35 AM To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query in the past I just select the date from sql server. unless you want to test a specific table, but that has potential performance impact. the safe simple query to see if sql server is alive is to just select the date. peter lin Allistair Crossley [EMAIL PROTECTED] wrote: I would not do that because that would return as many 1s as there are rows in the table. Something like count(*) may not be the most efficient but it returns just 1 row always. Also with using 1, you cannot guarantee a row will come back. Allistair Crossley __ Intranet Senior Developer New Media Group, QAS Ltd Telephone: 020 7819 5343 __ -Original Message- From: Michael Duffy [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:25 To: Tomcat Users List Subject: RE: Microsoft SQL Server validation query Or even SELECT 1 FROM TABLE. No COUNT overhead, if any. - MOD --- Allistair Crossley wrote: i think you could use anything .. maybe SELECT COUNT(*) FROM table The dual table is an oracle dummy table and is quite handy, but I think the validation query can just be any old select statement that should return true a result always. ADC -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:15 To: Tomcat Users List Subject: Microsoft SQL Server validation query Does anyone happen to know which validation query I should use for Microsoft SQL Server? Derek - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- QAS Ltd. Developers of QuickAddress Software www.qas.com Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus - 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] - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Microsoft SQL Server validation query
off hand I know selecting the date from sybase, sql server and oracle are all different. one way around it is to use a stored procedure, that way you can have the same stored proc in each RDBMS and the java call is the same. I'm sure others have done it a different way, but that's how I've tackled the problem in the past. peter Derek Mahar [EMAIL PROTECTED] wrote: Thank you to all of you for your quick replies. It seems that the connection pool validation query is not specific to any database server implementation unless the query statement itself is server-specific (that is, it refers to a special server system database, table, or function). I like the idea of querying the server for the date, but I'm not sure that the date function is standard SQL and portable across all server implementations. Does anyone know otherwise? Derek - Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes
