Thanks
Specifically, I have a web.xml having:
**
?xml version=1.0 encoding=ISO-8859-1?
!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
resource-ref
descriptionDB Connection/description
Thanks for the quick reply...
Yes the .jar file is in common/lib. I fear the problem lies in the
server.xml since jndi is binding datasource jdbc/TestDB to
org.hsql.jdbcDriver
On Mon, 19 Sep 2005, andy gordon wrote:
is the MySQL Connector Jar file in the $CATALINA_HOME/common/lib directory?
is the MySQL Connector Jar file in the $CATALINA_HOME/common/lib directory?
Kito Holliday [EMAIL PROTECTED] wrote:Attempting to use connector-java-3.3.10
with tomcat 4.0 and mysql and
servlets. The Java code:
InitialContext ctx = new InitialContext();
DataSource ds =
I can get a session to persist but there is a delay. Is there a way of
forcing Tomcat to flush the session to the DB on every change? The goal
is use the DB for session replication rather than multicasting.
Thanks,
Peter Johnson
Peter Johnson wrote:
Hi All,
Does anyone have a working
It is my understanding that the JDBC realm will execute prior to any
filters or other servlets, so I wouldn't think this would be possible
unless you perform your own authentication - possibly in a filter - to
do just what you're looking for.
-Original Message-
From: Fredrik Liden
Write tomcat-users element in the tomcat-users.xml file.
deepak suldhal wrote:
Hi,
I followed the JDBC document posted on Tomcat site.
and it works fine. I am able to access the database
and see the results.
My question is.
I have different users who will be using my
application
and I need to
Hi,
This does not solved the problem, with this I can
restrict access to user group or allow access.
Once the user has access I need to know who he or she
is so that I can query the database with respect to
his or her user_id.
And So how would I do this.
Thanks
D
--- Hiroshi Iwatani
Sounds like you need application logic to do this - probably in
conjunction with using Tomcat's Container Managed Authentication (CMA).
Tomcat can validate the username against a database (see JDBCRealm at
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/realm-howto.html#JDBCRea
lm ).
However
Hi,
Looks like you are using the Tomcat Connection pool.
Refer to the attached Readme.txt file and verify that you have done these
steps.
I think it should solve your problem.
Have also attached the server.xml web.xml files which worked fine for us.
let me know whether ur problem gets solved by
Hi,
Looks like you are using the Tomcat Connection pool.
Refer to the attached file and verify that you have done these steps.
I think it should solve your problem.
-Original Message-
From: deepak suldhal [mailto:[EMAIL PROTECTED]
Sent: Monday, February 21, 2005 11:43 AM
To: tomcat
You are not giving the correct parameters for the connection, see '' and
null, correct them ...
Best Regards,
S H A K E E L A H M A D
http://members.fortunecity.com/javaclub/shakeel.htm
Voice: 00923002723316
Senior Software Engineer.
NorthStar Technologies. www.globalnorthstar.com
EE(Computer
Hi,
The next logical step is to read the Tomcat JNDI Datasource manual at
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
Allistair.
-Original Message-
From: deepak suldhal [mailto:[EMAIL PROTECTED]
Sent: 18 February 2005 14:29
To: tomcat users
Hi Jeff,
If everything is setup the exact way it was ni 5.0.28 that will be your
problem. There is a slightly new format for how to define your datasources that
looks like this.
Resource name=jdbc/EmployeeDB auth=Container
type=javax.sql.DataSource username=dbusername
Hi,
If your resource is setup just like 5.0.28, it'll fail. There are no
more nested parameter elements, instead they are attributes of the
Resource element. Please consult the Tomcat 5.5 documentation for
details and examples.
Yoav Shapira http://www.yoavshapira.com
-Original
Someone just last week recommended this one:
http://jtds.sourceforge.net/
But you can use the one from Microsoft as well:
http://www.microsoft.com/downloads/details.aspx?FamilyID=ee91ad1a-1ee4-49e1-95ea-e3f0e39114a9DisplayLang=en
That's a crappy URL, but it links to the JDBC driver.
Charlie
Charles,
Do a search of the archives. There were several threads in the last few
months on SQL server. Some of them discussed this very issue.
If price is an issue, is there any compelling reason that make it worth
staying with SQL server?
Doug
- Original Message -
From: Charles P.
Charles P. Killmer wrote:
Looking for concensus on how people, with much more experience than I
have, use to connect to SQL Server 7. I have been planning on using
Datadirect's JDBC Connect until I saw the price tag for a server.
So with that does any body have a preferred JDBC connector to
Mostly people use DAO, instead of JDBC driver directly.
One DAO is iBatis.
and jTDS is much better driver.
.V
Charles P. Killmer wrote:
Looking for concensus on how people, with much more experience than I
have, use to connect to SQL Server 7. I have been planning on using
Datadirect's JDBC
We use jTds drivers. They are available on sourceforge I think.
We tried the 'free' Microsoft JDBC driver as well.
There is information to support that jTds is the faster of the two.
On SQLServer 2000 we float about 1000 total connections between three DBCP pools
using jTds and the DB just rips
, November 23, 2004 4:34 PM
To: Tomcat Users List
Subject: Re: JDBC
We use jTds drivers. They are available on sourceforge I think.
We tried the 'free' Microsoft JDBC driver as well.
There is information to support that jTds is the faster of the two.
On SQLServer 2000 we float about 1000 total
On Wednesday 24 November 2004 00:13, Charles P. Killmer wrote:
Looking for concensus on how people, with much more experience than I
have, use to connect to SQL Server 7. I have been planning on using
Datadirect's JDBC Connect until I saw the price tag for a server.
Hi,
I used the standard
hi
Can u use JNET' JDBC Driver it has quite good advenatges over JTD's and
DataDirect JBDC Driver.
Regards
Deepak
On Wed, 24 Nov 2004 Al Gidden wrote :
We use jTds drivers. They are available on sourceforge I think.
We tried the 'free' Microsoft JDBC driver as well.
There is information
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Trond G. Ziarkowski wrote:
Hi all!
In my webapp I do two db inserts into two different tables. If the
second one fails I want to rollback the first one. My code is something
like the following:
Connection con = gotten from jndi DataSource
Prior to your first insert, do you need to execute an SQL Start
transaction? Otherwise, it sounds like autocommit will revert to the
default start of true.
http://dev.mysql.com/doc/mysql/en/COMMIT.html
[EMAIL PROTECTED] 11/16/2004 12:14:13 PM
Hi all!
In my webapp I do two db inserts into
Shouldn't jdbc 3.0 do the trick?
-Original Message-
From: David Boyer [mailto:[EMAIL PROTECTED]
Sent: November 16, 2004 3:35 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: JDBC transactions using MySQL / DBCP in Tomcat 5.0.28
Prior to your first insert, do you need to execute
Follow
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
closely.
Viorel Dragomir
.
..
---
vioss was here
- Original Message -
You need a JDBC driver for your selected DBMS
Nelson, Jerry W, Contractor 146CF, SCB escribió:
What do I need to download to establish/create a JDBC connection?
//SIGNED//
Jerry Nelson
--
John Villar
Gerente de Proyectos
Computadores Flor Hard Soft 2058 C.A.
www.florhard.com
That would Microsoft Access and Microsoft SQL.
//SIGNED//
Jerry Nelson
PS,
I can't receive attachments unless you rename them.
-Original Message-
From: John Villar [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 1:39 PM
To: Tomcat Users List
Subject: Re: JDBC connections
You
Users List'
Subject: RE: JDBC connections
That would Microsoft Access and Microsoft SQL.
//SIGNED//
Jerry Nelson
PS,
I can't receive attachments unless you rename them.
-Original Message-
From: John Villar [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 1:39 PM
:
That would Microsoft Access and Microsoft SQL.
//SIGNED//
Jerry Nelson
PS,
I can't receive attachments unless you rename them.
-Original Message-
From: John Villar [mailto:[EMAIL PROTECTED]
Sent: Friday, August 27, 2004 1:39 PM
To: Tomcat Users List
Subject: Re: JDBC connections
You need
Hello,
the SQL error message does not look like if the driver itself could not
be found, it appears more obvious to me, that the connection URL for the
database is incorrect. Please check your database connection string,
maybe the bug hides in there:-)
To your xml problem: Did you also
U can set session time out atttribute in server.xml file
so that u can solve ur problem
Deepak
On Tue, 22 Jun 2004 Frank von Daak wrote :
Hi...
...is there really noone, who can tell me, how to set up the
connection-timeout for a mssql-based ConnectionPool with tomcat ?
The methode
There are some good examples for JDBC connection pooling for a variety of databases
located at the following URL:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Good luck,
Randall
-Original Message-
From: Ram Mahajan [mailto:[EMAIL PROTECTED]
Sent:
Can you give one little example, because I try do it but my tomcat return to
me one error say that not have one drive defined for this conection or dis
drive not exist...
I want use pool connection of tomcat-catalina.
I'm sending the attached file to help you understand my problem, I'm using
Richard,
I believe the first two elements appearing in your web.xml (Resource and
ResourceParams) need to be present in the server configuration:
1. either as a global resource in your server.xml (inside the Server
element)
2. or as a context specific resource in a context descriptor - a Context
PROTECTED]
Sent: Monday, May 10, 2004 2:30 PM
To: Tomcat Users List
Subject: Re: JDBC Source getting null url
Richard,
I believe the first two elements appearing in your web.xml (Resource and
ResourceParams) need to be present in the server configuration:
1. either as a global resource in your
.
-Original Message-
From: Richard Calosso [mailto:[EMAIL PROTECTED]
Sent: Monday, May 10, 2004 3:32 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Source getting null url
I also tried it using a global resource (option 1) with the same error
result. Built it by hand and used the admin pages, same result
For the global to work you must place a link in the context. As for the
web.xml this is the wrong tags for that file.
Doug
- Original Message -
From: Richard Calosso [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Monday, May 10, 2004 7:01 PM
Subject: RE: JDBC Source
-
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 2:58 AM
Subject: Re: JDBC/mySQL problem.
Doug,
I created a test stand-alone application: TestConnection.java
Inside theis class, it has
public static void main(Strig[] args
Subject: Re: JDBC/mySQL problem.
Doug,
I created a test stand-alone application: TestConnection.java
Inside theis class, it has
public static void main(Strig[] args)
{
DatabaseOperation op = DatabaseOperation.newInstance();
op.selectOperation()
...
}
When DatabaseOperation
within Tomcat to use the context.
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 2:58 AM
Subject: Re: JDBC/mySQL problem.
Doug,
I created a test stand-alone application: TestConnection.java
Inside theis class
clarify what you mean by inside the main().
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:37 PM
Subject: RE: JDBC/mySQL problem.
Hi folks,
Sorry to bring back this issue I still cannot make my
to use the context.
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 2:58 AM
Subject: Re: JDBC/mySQL problem.
Doug,
I created a test stand-alone application: TestConnection.java
Inside theis class, it has
.
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 4:37 AM
Subject: Re: JDBC/mySQL problem.
Wait.. it's working now... I played around with my server.xml file
and change the path to empty () and it's working!
--Kawthar
M Sulaiman [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 6:52 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC/mySQL problem.
Yes, I have the latest connector inside my /common/lib.
mysql-connector-java-3.0.11-stable-bin.jar
I even tried naming this without the word stable in it, and still
Kawthar,
Please clarify what you mean by inside the main().
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:37 PM
Subject: RE: JDBC/mySQL problem.
Hi folks,
Sorry to bring back this issue I still
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:37 PM
Subject: RE: JDBC/mySQL problem.
Hi folks,
Sorry to bring back this issue I still cannot make my connection
pooling to work... arrrgghh...
I got
: Thursday, March 18, 2004 6:52 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC/mySQL problem.
Yes, I have the latest connector inside my /common/lib.
mysql-connector-java-3.0.11-stable-bin.jar
I even tried naming this without the word stable in it, and still
not
working.
In my log file, I can see
still want me to help let me know.
Steve
-Original Message-
From: Kawthar Bt M Sulaiman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:52 PM
To: [EMAIL PROTECTED]
Subject: RE: JDBC problems with MySQL
I've changed the driver to com.mysql.jdbc.Driver. Which jdbc jar file
, 2004 12:29 AM
Subject: Re: JDBC/mySQL problem.
Kawthar,
As for Steve's concerns:
It is the same one. The short story: Mark Mathews wrote it MySQL liked it
and adopted it and him. So it went from org.gjt.mm to com.mysql. Both
names
will work fine but to be up to date use the com.mysql
:29 AM
Subject: Re: JDBC/mySQL problem.
Kawthar,
As for Steve's concerns:
It is the same one. The short story: Mark Mathews wrote it MySQL
liked it
and adopted it and him. So it went from org.gjt.mm to com.mysql.
Both
names
will work fine but to be up to date use the com.mysql
9.1
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 8:51 PM
Subject: Re: JDBC/mySQL problem.
Yes, I have the latest connector inside my /common/lib.
mysql-connector-java-3.0.11-stable-bin.jar
I even tried naming
these files as requested in just a sec.
Thanks for your help.
Steve
-Original Message-
From: Adam Hardy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:07 PM
To: Tomcat Users List
Subject: Re: JDBC problems with MySQL
Steve,
post the Resource ResourceParams tags from your context
Sulaiman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 9:09 PM
To: [EMAIL PROTECTED]
Subject: RE: JDBC problems with MySQL
I got the same error message as yours. Still trying to figure out
myself.
--Kawthar
[EMAIL PROTECTED] 17/03/2004 05:46:43 AM
It appears the attachment
PROTECTED]
Sent: Wednesday, March 17, 2004 1:34 AM
To: Tomcat Users List
Subject: Re: JDBC problems with MySQL
Steve, like Wendell said, you've got to put the context.xml file under
that directory. And rename it to the context name.
It will only work from the META-INF directory when you
Hi,
Does the META-INF directory in a war file sit next to the WEB-INF
directory?
Yes (a WAR is just a special JAR, and the JAR spec controls the location
of the META-INF directory).
One other thing. In the context file that is currently working can you
tell me why the logger doesn't?
Logger
, and it
works fine.
Steve
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 7:59 AM
To: Tomcat Users List
Subject: RE: JDBC problems with MySQL
Hi,
Does the META-INF directory in a war file sit next to the WEB-INF
directory?
Yes (a WAR is just
Gums [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:21 AM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
I tried removing the directory tag and it doesn't appear in the default logs
directory. I tried it with the absolute path and still nothing. I will investigate
Dear Steve,
I posted this problem around 3 months back and I am daily reading the forum, hoping
that one day somebody will give a solution.
I will deeply appreciate you if u share the solution with me if u r able to find.
Good Luck
Best Regards
Abhay Kumar
-Original Message-
From:
, but it is working now.
Steve
Check the archives...
Adrian Lanning
- Original Message -
From: Kumar Abhay-CAK203C [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 1:01 PM
Subject: RE: JDBC problems with MySQL
Dear Steve,
I posted this problem around 3
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 12:01 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
Importance: High
Dear Steve,
I posted this problem around 3 months back and I am daily reading the
forum, hoping that one day somebody will give a solution.
I will deeply
Kawthar,
Try this context in place of yours.
Context path=/db docBase =ROOT debug=9 reloadable=true
Resource auth=Container description=JDBC Connection to
MySQL v4.0.18 name=mySQLDatabase scope=Shareable
type=javax.sql.DataSource/
Resource name=jdbc/mySQLDatabase auth=Container
Users List [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:02 PM
Subject: Re: JDBC/mySQL problem.
Kawthar,
Try this context in place of yours.
Context path=/db docBase =ROOT debug=9 reloadable=true
Resource auth=Container description=JDBC Connection to
MySQL v4.0.18 name
.
Steve
-Original Message-
From: Kumar Abhay-CAK203C [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 11:01 AM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
Importance: High
Dear Steve,
I posted this problem around 3 months back and I am daily reading the forum,
hoping
: RE: JDBC problems with MySQL
I am new to this list as of today, so I don't know if anyone has already
answered your question. Tomcat will not connect to mysql unless you have
a password and of course rights to the database. Here is an example.
Use these mySQL commands
mysql -u root (This command
jdbc/ .
Doug
- Original Message -
From: Parsons Technical Services [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:02 PM
Subject: Re: JDBC/mySQL problem.
Kawthar,
Try this context in place of yours.
Context path=/db docBase =ROOT
]
Sent: Tuesday, March 16, 2004 11:01 AM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
Importance: High
Dear Steve,
I posted this problem around 3 months back and I am daily reading the
forum,
hoping that one day somebody will give a solution.
I will deeply appreciate you if u
PROTECTED]
Sent: Wednesday, March 17, 2004 11:46 PM
Subject: Re: JDBC/mySQL problem.
Followed your suggestion, but still not working.
Thnx,
--Kawthar
[EMAIL PROTECTED] 18/03/2004 12:18:00 PM
Kawthar,
Change:
Resource auth=Container description=JDBC Connection to
MySQL v4.0.18 name
are the rights for the user in the database, can the user gain
access
from localhost?
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:46 PM
Subject: Re: JDBC/mySQL problem.
Followed your suggestion
]
Sent: Wednesday, March 17, 2004 11:46 PM
Subject: Re: JDBC/mySQL problem.
Followed your suggestion, but still not working.
Thnx,
--Kawthar
[EMAIL PROTECTED] 18/03/2004 12:18:00 PM
Kawthar,
Change:
Resource auth=Container description=JDBC Connection to
MySQL v4.0.18
for the user in the database, can the user gain
access
from localhost?
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 11:46 PM
Subject: Re: JDBC/mySQL problem.
Followed your suggestion, but still
, 2004 1:26 AM
Subject: Re: JDBC/mySQL problem.
Hi Doug,
I know basic table creation and simple sql statement.. so I was able to
create the database
and create few tables to get tomcat running with mySQL. I read few
docs (including the
link you gave to get me started).. but other advance stuff
spelling and capitalization.
If you want to keep working on the pool, repost the applicable parts of
your
current web.xml, server.xml and code.
Doug
- Original Message -
From: Kawthar Bt M Sulaiman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:26 AM
Subject: Re: JDBC
Just an update.
I included a file, that works great on my webapp that is already running on
an old system, and you can see the change I made, which allows the app to
run. Not sure if this helps anyone.
package com.voast.vkey.utils;
import java.io.*;
import java.sql.*;
import javax.sql.*;
import
Steve,
post the Resource ResourceParams tags from your context for the
webapp. State whether it's in a context.xml file, server.xml or whatever.
Perhaps we can spot something.
Adam
ps this email has got some weird font - my mail reader is up the creek
at the mo'. sorry
On 03/16/2004 09:47
/AppName/META-INF/context.xml
?
I will post these files as requested in just a sec.
Thanks for your help.
Steve
-Original Message-
From: Adam Hardy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:07 PM
To: Tomcat Users List
Subject: Re: JDBC problems with MySQL
Steve,
post
]
Sent: Tuesday, March 16, 2004 2:07 PM
To: Tomcat Users List
Subject: Re: JDBC problems with MySQL
Steve,
post the Resource ResourceParams tags from your context for the
webapp. State whether it's in a context.xml file, server.xml or whatever.
Perhaps we can spot something.
Adam
ps this email
?autoReconnect=true/value
/parameter
/ResourceParams
/Context
[wolfgang]#
-Original Message-
From: Steve Gums [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:38 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
The .cap file can be open with notepad or whatever.
I
I think with Tomcat 5.0.x, you need to put the context.xml file under
/conf/Catalina/localhost as web-app.xml
-Original Message-
From: Steve Gums [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:38 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
The .cap file
: JDBC problems with MySQL
I think with Tomcat 5.0.x, you need to put the context.xml file under
/conf/Catalina/localhost as web-app.xml
-Original Message-
From: Steve Gums [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 2:38 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems
16, 2004 2:38 PM
To: 'Tomcat Users List'
Subject: RE: JDBC problems with MySQL
The .cap file can be open with notepad or whatever.
I have it in the META-INF directory. If I copy the contents of this
into
the server.xml file it starts to work.
Gotta be something simple that I am doing wrong here
Hi Jay,
I don't know if it's of any help at all, but I went through
something similar.
What I found to be my problem was that my URLs for invoking
JSPs/servlets did not always specify my Tomcat Context and
all the DataSource stuff was set up in my context (in server.xml
and the associated
comments in mind, see if I can
uncover anything further, and see if anyone else replies.
Thanks.
Jay
-Original Message-
From: Chris Ward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 10:00 AM
To: Tomcat Users List
Subject: RE: JDBC/DBCP problems
Hi Jay,
I don't know
Hi!
Burgess, Jay S wrote:
Thanks for the feedback. Maybe my problem does have something to do
with context visibility, but since I'm defining the resource within
SERVER.XML's GlobalNamingResources, I was under the impression that
these resources were available to all contexts.
I had a similar
I think it's a better idea to make those app resources
local instead of global. If your app is the only one
that needs that data source, by all means it should
not be global. That's the way I prefer to do it.
Keep those apps uncoupled and isolated from each
other. - MOD
--- Philipp Taprogge
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 11:36 AM
To: Tomcat Users List
Subject: Re: JDBC/DBCP problems
Hi!
Burgess, Jay S wrote:
Thanks for the feedback. Maybe my problem does have something to do
with context visibility, but since I'm defining the resource within
Tomcat version is 4.1.29 on Windows XP. I'm attempting to connect to
SQL Server. The JDBC driver JARs are in CATALINA_HOME\common\lib, and
since everything works fine if I manually load the driver via
Class.forName(), I don't think my problem is related to my driver files
location. When
the various configurations and decide
what the option(s) are and whether there's truly a bug in 4.1.29.
Thanks for the info.
Jay
-Original Message-
From: Julio César Aguilar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 1:23 PM
To: Tomcat Users List
Subject: Re: JDBC/DBCP problems
Don´t use it in init( ) method, only doPost( ) or doGet( ).
--
De: Burgess, Jay S[SMTP:[EMAIL PROTECTED]
Responder:Tomcat Users List
Enviada: quarta-feira, 28 de janeiro de 2004 12:35
Para: [EMAIL PROTECTED]
Assunto: JDBC/DBCP problems
I'm
Hi!
Michael Duffy wrote:
I think it's a better idea to make those app resources
local instead of global. If your app is the only one
that needs that data source, by all means it should
not be global. That's the way I prefer to do it.
Keep those apps uncoupled and isolated from each
other. -
Hi!
Hart, Justin wrote:
Quick question. I see that one can configure a JDBC datasource in their server.xml file and their web.xml file.
What does this get you? Every example that I have read tells me
that I need to open a JDBC connection just about
the same as I would from any other java
Ok, so, how does one access this datasource from tagsupport?
Justin
-Original Message-
From: Philipp Taprogge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:24 PM
To: Tomcat Users List
Subject: Re: JDBC from TagSupport
Hi!
Hart, Justin wrote:
Quick question. I see
[EMAIL PROTECTED]
cc:
Subject:RE: JDBC from TagSupport
Ok, so, how does one access this datasource from tagsupport?
Justin
-Original Message-
From: Philipp Taprogge [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:24 PM
To: Tomcat Users List
Subject: Re
Czajkowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:37 PM
To: Tomcat Users List
Subject: RE: JDBC from TagSupport
i have it setup for sybase and mine looks like this in the server.xml:
-
Context path
]
cc:
Subject:RE: JDBC from TagSupport
Gotcha, so the datasource gets stuck into a naming directory, and then you
can grab it via JNDI and use it that way.
The benefit being that a sysadmin can change the datasource via server.xml
rather than having you rewrite the code
Cool, thanks.
-Original Message-
From: Alan Czajkowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:44 PM
To: Tomcat Users List
Subject: RE: JDBC from TagSupport
affirmative,
but instead of looking at my proprietary example below .. goto the Tomcat
Documentation under
Subject
Re: JDBC Realm
Get rid of the single quotes.
userNameCol=USERNAME
-Tim
Justin Wesbrooks wrote:
I have a JDBCRealm set up in Tomcat 4.1.29. The realm config is as
follows..
Realm className=org.apache.catalina.realm.JDBCRealm
debug=99 driverName=org.gjt.mm.mysql.Driver
cc
Subject
Please respond to Re: JDBC Realm
Tomcat
Subject
Please respond to Re: JDBC Realm
Tomcat Users
List
On Thursday 20 November 2003 8:51 am, Justin Wesbrooks wrote:
Thanks for the response. When I describe the user table, I get the
following output...
mysql describe users;
Isn't users the default table in mysql where it stores MySQL logins? Or was
that your intention. If not, you might
1 - 100 of 724 matches
Mail list logo