.
-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
[EMAIL 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
.
-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 for
]
> -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
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 standalo
EMAIL 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 letti
uck [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 it.
&
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]
ot;);
e.printStackTrace();
}
%>
Hello THERE!
---
Yaakov Chaikin
Software Engineer
BAE SYSTEMS
301-838-6899 (phone)
301-838-6802 (fax)
[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 before close() is called on the connection?
> Dreamweaver wi
t [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 before close() is call
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 no
> 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 fir
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
> > 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.
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 connect
16 matches
Mail list logo
