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
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
or "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 par
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 ?
Conceptual
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
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&quo
i have checked all.. there is no other username
i have put all the codes involved in the coding..
please point out the mistake ..
Staffing
Add Staff
<%@ page language="java" import="java.sql.*" %>
<%!
String con_url = "jdbc:mysql:///AAAServer?user=tjc&password=password";
Connection c;
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 probl
i am extracting info from html forms .. but one of the field allways return
the value null only
html code
jsp code
String username = request.getParameter("username");
SQL codes;
String query7 = "Insert into Admin(UserName,PassWord,Admin_type,Admin_Name)
values('"+username+"','"+passwo
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
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
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 Linu
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
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
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
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
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
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_T
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
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
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
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 attachm
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 2>&1 &"
and c
l 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
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:
But inspite of doing this my catalina.out is gets logged in
CATALINA_BASE/logs/ directory. There are two scripts in tomcat/bin/
dir
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 planni
> 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
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
>
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
TED]> 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
>
(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 d
> 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
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?
-
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 e
D]>
To: "Tomcat Users List"
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
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
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 IN
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 relea
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: [EMAI
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
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 recom
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/suggestion
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 m
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
for 404's in your web.xml, a
Hi,
>Sorry, not sure I understand this. Is this not what I've done with
this?:
>
>404
>/404.html
>
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
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
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 sa
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
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 o
You need to create a mapping in web.xml to invoke the servlet. Look at
the elements
and 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 to
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-IN
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
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):
>
>
>
>myscript.pl gets executed, but $ENV{"QUE
We have set up Tomcat to process an SSI directive that is used in many
pages on our site (www.pesticideinfo.org):
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).
bject: 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");
Strin
if(Integer.parseInt(strQueryFlag.toString())==NEW_QUERY)
{
System.out.println("New Search ..."+strQueryString);
Query query = null;
session.removeAttribute("BookObjects");
ArrayList arLstBookDetails = new ArrayList(1);
if(Integer.parseInt(strQueryFlag.toString())==NEW_QUERY)
{
System.out.println("New Search ..."+strQueryString);
Query query = null;
session.removeAttribute("BookObjects");
ArrayList arLstBookDetails = new ArrayList(1);
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 inpu
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
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"..
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
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
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 & d
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
- 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 Mess
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
t;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 datas
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
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 changi
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
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 refere
4 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 ??
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-con
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
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=
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
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 l
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 subm
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
Def
?
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
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
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 th
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 us
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 d
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 gues
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
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 pre
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
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 valida
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 "
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 &qu
Does it really matter if it's different? You are setting up a
datasource in a configuration file, the contents of that configuration
are pretty much guaranteed to be different for every database anyways.
(JDBC URL and Driver come to mind). Adding one more (the validation
query) is not too
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-
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
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 tha
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
__
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
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, bu
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
1 - 100 of 236 matches
Mail list logo