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
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
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
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
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
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
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 =
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
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
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
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 Linux
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
,
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
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
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
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%
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%
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?
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
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
:[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
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
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
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
(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
:
-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
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
.
-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
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
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?
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
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
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
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
@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
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:
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
(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
: 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
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
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
(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
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
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
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
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
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
: [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
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
- 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
- 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
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:
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
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
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
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
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
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
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
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
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
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
?
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
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
: 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
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
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
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
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
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
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
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
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
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
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]
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
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
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
__
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
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
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
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
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
1 - 100 of 223 matches
Mail list logo