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
A common problem in beginner JDBC is not performing a ROLLBACK when an
update fails. Even when autocommit is set to TRUE, a failed update will
leave the records locked in the database. Update statements should
always be coded so that if an exception is thrown, a rollback is
performed on the
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
16 matches
Mail list logo