List
Subject: RE: JTDS help
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Subject: RE: JTDS help
Well there aren't any file access errors but it looks like for every
request it is racing through all of the directories and compiling
whatever it finds. Is there a setting that tells
To: Tomcat Users List
Subject: RE: JTDS help
Well there aren't any file access errors but it looks like for every
request it is racing through all of the directories and compiling
whatever it finds. Is there a setting that tells tomcat to recompile on
every request?
Charles
-Original Message
-Original Message-
From: Charles P. Killmer
Sent: Wednesday, February 09, 2005 12:25 PM
To: Tomcat Users List
Subject: RE: JTDS help
I have noticed that if I let FileMon just sit, every ten seconds,
java.exe runs through a bunch of directories. Is this normal? It
doesn't seem to contribute
Charles P. Killmer wrote:
I have also tried these methods since.
%@ page language=java import=java.sql.*%
%@ page language=java import=java.util.Properties%
%
Properties p = new Properties();
p.put(user, *);
p.put(password, **);
Driver d =
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
There must be something wrong with my tomcat/JTDS setup.
Charles,
To be clear: You have run osql.exe, on the same machine as the Tomcat
process, as the same user as your Tomcat process, and it connects
quickly and runs queries quickly? I
.
Cheers, Allistair.
-Original Message-
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Sent: 07 February 2005 22:42
To: Tomcat Users List
Subject: RE: JTDS help
When I strip the code to simply this,
%@ page language=java import=java.sql.*%
%
Connection conn
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Also the thing that I run into with connection pooling the
inability to use the SQL Statement of select @@IDENTITY from table.
With connection pooling, you run the risk of getting the ID
for a record that someone else inserted with the same
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 3:17 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hi Charles,
I've just taken your code and run it through our Tomcat 5.5, jTDS, SQL
Server 2000 web application and it took approx. 0.5s to compile and
subsequent requests were
file won't have anything to do with this. I am certain it is
environmental.
Ali.
-Original Message-
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Sent: 08 February 2005 14:41
To: Tomcat Users List
Subject: RE: JTDS help
Well I must have missed something because it isn't
Message-
From: Allistair Crossley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 8:44 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hi,
No it was a totally raw test of your code which by virtue of using
DriverManager does not use connection pooling even if I do have it
enabled in my
issue. See what your monitoring
brings back. What kind of setup are you running?
Allistair.
-Original Message-
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Sent: 08 February 2005 15:33
To: Tomcat Users List
Subject: RE: JTDS help
I don't mean to be contrary, I am just trying
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
I am
going to run filemon and watch for access denied messages, then regmon
and watch for similar things. The network is very fast, the db server
is not being used by anyone else. It seems to me that if it were
environmental, it would
:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 9:36 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hey Charles,
I'm sure it's quite frustrating, but I've already shown that your
precise code runs way faster than your original statistics, and that was
only on a modest box. It serves no purpose
From: Charles P. Killmer [mailto:[EMAIL PROTECTED]
Subject: RE: JTDS help
Well there aren't any file access errors but it looks like for every
request it is racing through all of the directories and compiling
whatever it finds. Is there a setting that tells tomcat to
recompile on every
Hi,
There's no real reason relating to Tomcat or jTDS that this would run slow. You
are more likely to find answers with your hardware, network latency, database
load or row size and other environmental factors.
Allistair.
-Original Message-
From: Charles P. Killmer [mailto:[EMAIL
[mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 11:37 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hi,
There's no real reason relating to Tomcat or jTDS that this would run
slow. You are more likely to find answers with your hardware, network
latency, database load or row size
I think the main time is spent on opening the database connection!
So you better use connection pooling - then this expensive operation is
just execute once (or at least not so often)
Have a look at the Tomcat documentation (Section on JNDI-DataSources)
Tex
Charles P. Killmer wrote:
I am trying
the code in JSP for Tomcat that it slows down.
Charles
-Original Message-
From: Allistair Crossley [mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 11:37 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hi,
There's no real reason relating to Tomcat or jTDS that this would run
slow. You
. Its only when I
write the code in JSP for Tomcat that it slows down.
Charles
-Original Message-
From: Allistair Crossley [mailto:[EMAIL PROTECTED] Sent:
Monday, February 07, 2005 11:37 AM
To: Tomcat Users List
Subject: RE: JTDS help
Hi,
There's no real reason relating to Tomcat or jTDS
-
From: Mario Winterer [mailto:[EMAIL PROTECTED]
Sent: Monday, February 07, 2005 2:43 PM
To: Tomcat Users List
Subject: Re: JTDS help
I do not think, jsp compilation is the problem - well, the first request
will last long, but after the jsp is compiled, subsequent calls will not
be remarkable
@jakarta.apache.org
Sent: Tuesday, February 08, 2005 5:41 AM
Subject: RE: JTDS help
When I strip the code to simply this,
%@ page language=java import=java.sql.*%
%
Connection conn =
DriverManager.getConnection(jdbc:jtds:sqlserver://*.*.*.*:1433/dbname;u
ser=*;password=**);
conn.close
21 matches
Mail list logo