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

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

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

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

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

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

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

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. In

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)
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

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 not being released... One other question. What

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

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

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

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

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

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

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)
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

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

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

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 standalone app

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 ODBC connection. Specifically change

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