RE: Lock on database file not being released...

2003-12-08 Thread George Sexton
. -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

RE: Lock on database file not being released...

2003-12-08 Thread Chaikin, Yaakov Y (US SSA)
[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

RE: Lock on database file not being released...

2003-12-07 Thread George Sexton
. -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

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
] > -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

RE: Lock on database file not being released...

2003-12-07 Thread George Sexton
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

Re: Lock on database file not being released...

2003-12-07 Thread Kwok Peng Tuck
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

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
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. &

Re: Lock on database file not being released...

2003-12-07 Thread Kwok Peng Tuck
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]

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
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]

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
; 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

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
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

Re: Lock on database file not being released...

2003-12-07 Thread Sean Utt
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

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
> 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

RE: Lock on database file not being released...

2003-12-07 Thread George Sexton
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

RE: Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
> > 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.

RE: Lock on database file not being released...

2003-12-07 Thread George Sexton
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 whe

AW: Lock on database file not being released...

2003-12-07 Thread SH Solutions
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 st

Lock on database file not being released...

2003-12-07 Thread Chaikin, Yaakov Y (US SSA)
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 can