PROTECTED]
Sent: Monday, December 08, 2003 1:11 AM
To: 'Tomcat Users List'
Subject: RE: Lock on database file not being released...
In the ODBC connection entry in the registry, or by using the ODBC
Connection editor, change those two parameters. They are probably set
for Yes and should be set
.
-Original Message-
From: Chaikin, Yaakov Y (US SSA)
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 8:43 AM
To: Tomcat Users List
Subject: RE: Lock on database file not being released...
Hi,
I did as you said and adjusted those values for the odbc. Same result.
The database file
Hi,
I am having a problem where the lock on the database is not being
released. I am using database connection pooling and I am just running a
test app and certainly DO close my connections. I double checked that
the code that closes the connection is being called and it is.
What other things
Hi
However, I have used this driver before in a standalone app and when you
close a connection, it certainly does release the lock on the database file.
This makes me think, you didn't use pooling in this standalone app. Therefor
check weather you close all your ResultSets and Statements. In
on the connection.
-Original Message-
From: SH Solutions [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 10:51 AM
To: 'Tomcat Users List'
Subject: AW: Lock on database file not being released...
Hi
However, I have used this driver before in a standalone app and when
you
close a connection
However, I have used this driver before in a standalone app and when
you
close a connection, it certainly does release the lock on the database
file.
This makes me think, you didn't use pooling in this standalone app.
Therefor
check weather you close all your ResultSets and Statements. In
One other question. What is the setting of AutoCommit? Are you setting
it to TRUE?
-Original Message-
From: Chaikin, Yaakov Y (US SSA)
[mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 2:13 PM
To: Tomcat Users List
Subject: RE: Lock on database file not being released
One other question. What is the setting of AutoCommit? Are you setting
it to TRUE?
It's not touched, i.e., it's default, which is true.
All I am doing in my jsp is doing a regular select * from tableName.
Nothing fancy. Returns 2 rows that are in that table. I am just testing
this out first
if what you think is happening is in fact happening.
Sean
- Original Message -
From: George Sexton [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 1:15 PM
Subject: RE: Lock on database file not being released...
One other question. What
PROTECTED]
Sent: Sunday, December 07, 2003 9:11 PM
To: Tomcat Users List
Subject: Re: Lock on database file not being released...
Hi,
Is your jsp/servlet forwarding or redirecting to another
jsp/servlet/html
page before close() is called on the connection?
Dreamweaver will automagically create
, December 07, 2003 9:11 PM
To: Tomcat Users List
Subject: Re: Lock on database file not being released...
Hi,
Is your jsp/servlet forwarding or redirecting to another
jsp/servlet/html
page before close() is called on the connection?
Dreamweaver will automagically create jsp pages that fall prey
)
[EMAIL PROTECTED]
-Original Message-
From: Sean Utt [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 9:11 PM
To: Tomcat Users List
Subject: Re: Lock on database file not being released...
Hi,
Is your jsp/servlet forwarding or redirecting to another
jsp/servlet/html
page
Chaikin, Yaakov Y (US SSA) wrote:
Ok, I don't know why, but it's not letting me attach it.
I think the list discards attachments .
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
PROTECTED]
Sent: Sunday, December 07, 2003 9:53 PM
To: Tomcat Users List
Subject: Re: Lock on database file not being released...
Chaikin, Yaakov Y (US SSA) wrote:
Ok, I don't know why, but it's not letting me attach it.
I think the list discards attachments
PROTECTED]
-Original Message-
From: Kwok Peng Tuck [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 9:53 PM
To: Tomcat Users List
Subject: Re: Lock on database file not being released...
Chaikin, Yaakov Y (US SSA) wrote:
Ok, I don't know why, but it's not letting me attach
these and see what happens.
-Original Message-
From: Chaikin, Yaakov Y (US SSA)
[mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 2:13 PM
To: Tomcat Users List
Subject: RE: Lock on database file not being released...
However, I have used this driver before in a standalone app
]
-Original Message-
From: George Sexton [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 11:28 PM
To: 'Tomcat Users List'
Subject: RE: Lock on database file not being released...
OK, I now think I know the issue. Try changing the entries for the
ODBC
connection. Specifically change
.
-Original Message-
From: Chaikin, Yaakov Y (US SSA)
[mailto:[EMAIL PROTECTED]
Sent: Sunday, December 07, 2003 11:07 PM
To: Tomcat Users List
Subject: RE: Lock on database file not being released...
How do I do that in server.xml file? Is that what you are suggesting?
Specifying other parameters
18 matches
Mail list logo