RE: Database pool problem (new problem)
I understand that you do not have a choice, but please not that the JDBC-ODBC bridge is *not for production* [according to Sun], it is *solely* for development and evaluation. The bridge contains identified bugs that will not be addressed [i e support is EOLed]. So, you are using this at your own risk. Check out the bug parade of the bridge; you might have encountered a well-known, documented bug. It that case, there might be a published work-around. Yes, true. But this worked 100% for the Realm with that same driver. Someone already solved that problem. I need to a parameter username, not user. Now, I am having a different problem. My database connection is not being released even though I am closing it. Could someone help me out with this? (I am inlcluding my server.xml file just in case). When I start up the server, however, I get the following exceptions in the log file: 2003-12-07 04:24:21 StandardContext[/webdav]: Resources start failed: java.lang.IllegalArgumentException: Document base C:\jakarta-tomcat-4.1.24-LE-jdk14\webapps\webdav does not exist or is not a readable directory at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.jav a:193) at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext. java:3344) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3474 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) 2003-12-07 04:24:21 StandardContext[/webdav]: Context startup failed due to previous errors 2003-12-07 04:24:21 StandardContext[/webdav]: Exception during cleanup after start failed LifecycleException: Container StandardContext[/webdav] has not been started at org.apache.catalina.core.StandardContext.stop(StandardContext.java:3658) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3636 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at org.apache.catalina.core.StandardServer.start(StandardServer.java:2190) at org.apache.catalina.startup.Catalina.start(Catalina.java:512) at org.apache.catalina.startup.Catalina.execute(Catalina.java:400) at org.apache.catalina.startup.Catalina.process(Catalina.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203) 2003-12-07 04:24:21 StandardContext[/tomcat-docs]: Resources start failed: java.lang.IllegalArgumentException: Document base C:\jakarta-tomcat-4.1.24-LE-jdk14\webapps\tomcat-docs does not exist or is not a readable directory at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.jav a:193) at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext. java:3344) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3474 ) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardHost.start(StandardHost.java:754) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363) at org.apache.catalina.core.StandardService.start(StandardService.java:497) at
WebDAV Problems with Tomcat 4.1.29
Hello I´m using a tomcat 4.1.29 server application on my webserver. I want to access to this server with a webDAV client. I allready used a couple of webDAV- Client applications like DAVexplorer, SkunkDAV or Photoshop 6.0 but the system won´t work without problems. It is no problem to connect to the server with the client- tool, but some typical webDAV functions will be without effect. There is no way to lock a file or to move it to another directory. The Client and also the server don´t generate an error-message or something like this, it will only be without an effect. I also made tests with an apache 1.3.20 webserver, an there all functions will be availible. So I believe the client is not the problem. Does anybody have an idea what the problem is? I think i have to change the configuration of the tomcat- server. Note this: I allready switched on the WebDAV function in the web.xml file. Thank You - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat doesn't start inprocess
I have Apache 2.0.48 and Tomcat 4.1.29 and mod_jk2.dll running on Windows 2000. I am sure that I have the Apache2 workers2.properties and httpd.conf configured properly. I am also sure that I have the tomcat jk2.properties and server.xml file configured properly. I started Apache2 and I got the following code in the Apache2 error log: [Sat Dec 06 16:41:32 2003] [notice] Parent: Created child process 2720 [Sat Dec 06 16:41:32 2003] [notice] Child 2720: Child process is running [Sat Dec 06 16:41:32 2003] [notice] jk2_init() Found child 2720 in scoreboard slot 0 [Sat Dec 06 16:41:32 2003] [notice] vm.init(): Jni lib: c:/j2sdk1.4.2_02/jre/bin/client/jvm.dll [Sat Dec 06 16:41:33 2003] [notice] vm.open2() done [Sat Dec 06 16:41:33 2003] [notice] jni.validate() class= org/apache/jk/apr/TomcatStarter [Sat Dec 06 16:41:33 2003] [notice] Loaded org/apache/jk/apr/TomcatStarter [Sat Dec 06 16:41:33 2003] [notice] jni.init() setting stdout=c:/web/Apache2/logs/stdout.log... [Sat Dec 06 16:41:33 2003] [notice] jni.init() setting stderr=c:/web/Apache2/logs/stderr.log... [Sat Dec 06 16:41:33 2003] [notice] jni.init() ARG start [Sat Dec 06 16:41:33 2003] [notice] jni.init() calling main()... [Sat Dec 06 16:41:33 2003] [notice] jni.validate() class= org/apache/jk/apr/TomcatStarter [Sat Dec 06 16:41:33 2003] [notice] Loaded org/apache/jk/apr/TomcatStarter [Sat Dec 06 16:41:33 2003] [notice] jni.init() disabling the non init hook worker [Sat Dec 06 16:41:33 2003] [notice] workerEnv.init() ok C:/web/Apache2/conf/workers2.properties [Sat Dec 06 16:41:33 2003] [error] mod_jk child init 1 0 [Sat Dec 06 16:41:33 2003] [notice] Child 2720: Acquired the start mutex. [Sat Dec 06 16:41:33 2003] [notice] Child 2720: Starting 250 worker threads. It all looks good, but it doesn't start Tomcat at all. It looks like there is an error in the stderr.log ... as follows ... TomcatStarter: main() Try org.apache.tomcat.startup.Main Try org.apache.catalina.startup.BootstrapService Try org.apache.catalina.startup.Bootstrap No class found So, the first question is how do I generate more of a detailed error log, and the second question is how do I fix this problem? Any help would be much appreciated.Thanks. Tom - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat-4.1.24 Hangs
Hi, after two days my tomcat-4.1.24 hangs. I cannot connect to the server not even with telnet localhost 8080. The Process (JVM) is not big, it is approx 100Mb. Any ideas why? TC is running under RedHat-9.0 with Sun Jre-1.4.2_02. Zsolt - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Lock on database file not being released...
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 I check or might be doing wrong? I am using the M$ Access as the database and the odbc bridge driver to get to it. When I shut down the server I would expect that the database pooling releases all its connections. It does look like it though, since I still still the databaseName.ldb file in that directory (MS Access way of lock the database file). I know that Sun says that it is not production level driver. 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 leads me to believe that it's NOT the driver problem, but my configuration problem. I am attaching the server.xml file just in case that would help in solving the problem. I would really appreciate any help. Thank you. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [EMAIL PROTECTED] ?xml version='1.0' encoding='utf-8'? Server className=org.apache.catalina.core.StandardServer debug=99 port=8005 shutdown=SHUTDOWN Logger className=org.apache.catalina.logger.FileLogger debug=0 directory=logs prefix=localhost_afecWEB_log. suffix=.txt timestamp=true verbosity=99/ Listener className=org.apache.catalina.mbeans.ServerLifecycleListener debug=0 jsr77Names=false/ Listener className=org.apache.catalina.mbeans.GlobalResourcesLifecycleListener debug=0/ GlobalNamingResources Logger className=org.apache.catalina.logger.FileLogger debug=0 directory=logs prefix=resource_afecWEB_log. suffix=.txt timestamp=true verbosity=99/ Environment name=simpleValue override=true type=java.lang.Integer value=30/ Resource auth=Container description=User database that can be updated and saved name=UserDatabase scope=Shareable type=org.apache.catalina.UserDatabase/ ResourceParams name=UserDatabase parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter parameter namepathname/name valueconf/tomcat-users.xml/value /parameter /ResourceParams Resource name=UserDatabase auth=Container type=org.apache.catalina.UserDatabase description=User database that can be updated and saved /Resource ResourceParams name=UserDatabase parameter namefactory/name valueorg.apache.catalina.users.MemoryUserDatabaseFactory/value /parameter parameter namepathname/name valueconf/tomcat-users.xml/value /parameter /ResourceParams !--*** BEGIN Physical AFEC database configuration **-- Resource name=afec/web/database auth=Container description=AFEC database; stores info about documents, login type=javax.sql.DataSource scope=Shareable/ ResourceParams name=afec/web/database parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value10/value /parameter parameter namemaxIdle/name value5/value /parameter parameter namemaxWait/name value1/value /parameter parameter namedriverClassName/name valuesun.jdbc.odbc.JdbcOdbcDriver/value /parameter parameter nameurl/name valuejdbc:odbc:afec/value /parameter parameter nameusername/name valuedefault/value /parameter parameter namepassword/name valueafecrelease2003/value /parameter parameter nameremoveAbandoned/name valuetrue/value /parameter parameter nameremoveAbandonedTimeout/name value60/value /parameter parameter namelogAbandoned/name valuetrue/value /parameter /ResourceParams /GlobalNamingResources Service className=org.apache.catalina.core.StandardService debug=0 name=Tomcat-Standalone Connector className=org.apache.coyote.tomcat4.CoyoteConnector acceptCount=100 bufferSize=2048 compression=off connectionLinger=-1 connectionTimeout=2 debug=0 disableUploadTimeout=true enableLookups=true maxKeepAliveRequests=100 maxProcessors=75 minProcessors=5 port=80 protocolHandlerClassName=org.apache.coyote.http11.Http11Protocol proxyPort=0 redirectPort=8443 scheme=http secure=false tcpNoDelay=true useURIValidationHack=false Factory className=org.apache.catalina.net.DefaultServerSocketFactory/ /Connector Connector className=org.apache.coyote.tomcat4.CoyoteConnector acceptCount=10 bufferSize=2048 compression=off connectionLinger=-1 connectionTimeout=0 debug=0 disableUploadTimeout=false enableLookups=true maxKeepAliveRequests=100 maxProcessors=75 minProcessors=5
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, 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 standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. cu Steffen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: SSL - FileNotFoundException (Access is denied)
Thank you! I wil add it to the Connector tag!! Bill Barker [EMAIL PROTECTED] wrote:You need to put the full path to the file (including the file name :) for the keystore. Also, for future reference, the tag is deprecated in Tomcat 5. You should set the attributes on the tag instead. Ron Andersen wrote in message news:[EMAIL PROTECTED] Installed SSL by the following(ADV Server 2000 and tomcat build 5.0.16): 1) Creating the keystore file 2) Added attribute keystoreFile to the tag 3)Added path C:\Program Files\Apache Software Foundation\Tomcat 5.0\conf to keystoreFile 4) Restarted Tomcat (logged in as Administrator) and received the following error: Dec 6, 2003 2:23:57 PM org.apache.coyote.http11.Http11Protocol init INFO: Initializing Coyote HTTP/1.1 on port 8080 Dec 6, 2003 2:23:57 PM org.apache.coyote.http11.Http11Protocol init SEVERE: Error initializing endpoint java.io.FileNotFoundException: C:\Program Files\Apache Software Foundation\Tomcat 5.0\conf (Access is denied) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(Unknown Source) at java.io.FileInputStream.(Unknown Source) at org.apache.tomcat.util.net.jsse.JSSESocketFactory.getStore(JSSESocketFactory .java:294) at org.apache.tomcat.util.net.jsse.JSSESocketFactory.getKeystore(JSSESocketFact ory.java:259) at org.apache.tomcat.util.net.jsse.JSSE14SocketFactory.getKeyManagers(JSSE14Soc ketFactory.java:172) at org.apache.tomcat.util.net.jsse.JSSE14SocketFactory.init(JSSE14SocketFactory .java:138) at org.apache.tomcat.util.net.jsse.JSSESocketFactory.createSocket(JSSESocketFac tory.java:127) at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java :297) at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:184) at org.apache.coyote.tomcat5.CoyoteConnector.initialize(CoyoteConnector.java:13 66) at org.apache.catalina.core.StandardService.initialize(StandardService.java:633 ) at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:2413) at org.apache.catalina.startup.Catalina.load(Catalina.java:532) at org.apache.catalina.startup.Catalina.load(Catalina.java:553) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:397) Dec 6, 2003 2:23:57 PM org.apache.catalina.startup.Catalina load - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
RE: [ANN] Apache Tomcat 5.0.16 Stable released
Congratulations to all those involved. This is a huge release, in my book. Lukas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat-4.1.24 Hangs
Zsolt Koppany wrote: after two days my tomcat-4.1.24 hangs. I cannot connect to the server not even with telnet localhost 8080. The Process (JVM) is not big, it is approx 100Mb. Any ideas why? TC is running under RedHat-9.0 with Sun Jre-1.4.2_02. Send the process a QUIT signal to see where it is hung. Also try upgrading to 4.1.29, it fixes an issue where Tomcat can hang under high load patterns. -Dave - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
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 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, 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 standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. cu Steffen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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. In standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
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. In standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 and that's why it's so simple for now. So, no updates are being done. Nothing. Just one select. Yet, it still locked the database file after the server is shut down. I am shutting down the server with the shutdown script that came with the download. Ideas? Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Out of topic: smake n cdrecord for linux
Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Not even close to on topic: smake n cdrecord for linux
You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Not even close to on topic: smake n cdrecord for linux
So his 'Out of topic' is in fact out of topic ? :) Achana, maybe you can have a look at many of the linux mailling list out there ? Might be better help than the tomcat list. Oscar Carrillo wrote: You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Not even close to on topic: smake n cdrecord for linux
Thank-you for your suggestion. ** Oscar Carrillo wrote: You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Not even close to on topic: smake n cdrecord for linux
Thank-you for your suggestion. Kwok Peng Tuck wrote: So his 'Out of topic' is in fact out of topic ? :) Achana, maybe you can have a look at many of the linux mailling list out there ? Might be better help than the tomcat list. Oscar Carrillo wrote: You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 to this gotcha. If you have access to the log files, log the opening and closing of the connection, and see 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 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. In standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Not even close to on topic: smake n cdrecord for linux
is there any way to get the mails which someone is only interested in? :) no offence just joking... --- Kwok Peng Tuck [EMAIL PROTECTED] wrote: So his 'Out of topic' is in fact out of topic ? :) Achana, maybe you can have a look at many of the linux mailling list out there ? Might be better help than the tomcat list. Oscar Carrillo wrote: You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Pls ignore emails which do not interest you!
Thank-you for your suggestion. Please do not contribute to SPAM, do ignore emails which do not interest you. *** r h wrote: is there any way to get the mails which someone is only interested in? :) no offence just joking... --- Kwok Peng Tuck [EMAIL PROTECTED] wrote: So his 'Out of topic' is in fact out of topic ? :) Achana, maybe you can have a look at many of the linux mailling list out there ? Might be better help than the tomcat list. Oscar Carrillo wrote: You are waay off topic here. A google search is the way to go here. Regards, Oscar On Mon, 8 Dec 2003 [EMAIL PROTECTED] wrote: Hi, apologies for being out of topic. I've installed a new scsi cd-rw, a cursory cdrecord -scanbus shows that it is recognised as a scsi device (which is fine) but displayed as CD-ROM. Does anyone have a more concise and readable howto for Joerg Schilling's smake and cdrecord tools? Apologies again for being out of topic... TIA :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
No, it's not doing any of that at all. I am attaching my welcome.jsp for reference. It's extremely simple code there. Thanks. 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 will automagically create jsp pages that fall prey to this gotcha. If you have access to the log files, log the opening and closing of the connection, and see 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 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. In standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
Sorry, but for some reason the welcome.jsp didn't get attached to the previous email. Trying again. 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 will automagically create jsp pages that fall prey to this gotcha. If you have access to the log files, log the opening and closing of the connection, and see 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 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. In standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
Ok, I don't know why, but it's not letting me attach it.
I am pasting it here in this email:
-
%@ page import=javax.naming.* %
%@ page import=javax.sql.* %
%@ page import=java.sql.* %
html
body
%
try
{
Context ctx = new InitialContext();
if(ctx == null ) throw new Exception(Boom - No Context);
DataSource ds =
(DataSource)ctx.lookup(java:comp/env/jdbc/afecWEBDB);
out.println(DataSource is: + ds);
if (ds != null)
{
out.println(ds is NOT null);
Connection conn = ds.getConnection();
out.println();
out.println(Connection is: + conn);
if(conn != null)
{
out.println(Connection is not NULL);
out.println();
Statement stmt = conn.createStatement();
out.println(Statement is: + stmt);
ResultSet rst = stmt.executeQuery(select * from
Users);
while(rst.next())
{
out.println(Record Found!);
out.println(br/);
out.println(rst.getString(1));
out.println(rst.getString(2));
out.println(br/);
}
log(THIS IS TEST! CONNECTION IS ABOUT TO BE
CLOSED!***);
rst.close();
stmt.close();
conn.close();
}
}
}
catch(Exception e)
{
System.out.println(NO LUCK!);
e.printStackTrace();
}
%
h1Hello THERE!/h1
/body
/html
---
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 will automagically create jsp pages that fall prey to this
gotcha. If you have access to the log files, log the opening and
closing of
the connection, and see 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 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. In
standalone
apps where no pooling is involved, they are caught by the garbage
collector,
but not in connection pooling.
Trapped into this myself.
Steffen,
I tried what you said and closed the ResultSet and Statement before
I
close the Connection. Still same affect.
Any other ideas anyone?
I highly doubt it's the driver. I would bet that I am doing
something
wrong. I just can't figure out what it is.
Thanks,
Yaakov.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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 . - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Lock on database file not being released...
Well, I've sent server.xml files over before and it went through. I am a bit confused about the attachment policy now. Thanks. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [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 letting me attach it. I think the list discards attachments . - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Lock on database file not being released...
Hmm, I could be wrong as well.. Chaikin, Yaakov Y (US SSA) wrote: Well, I've sent server.xml files over before and it went through. I am a bit confused about the attachment policy now. Thanks. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [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 letting me attach it. I think the list discards attachments . - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat5 close to production?
Is there any word, or any place where I could check the status of Tomcat5 to move to production? My host would rather not go through with a Tomcat5 install until it comes out of beta, but I like all of the new things in JSP2. Will Tomcat5 be going production within a month or two or four or eight? Thanks, Philihp - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
mod jk failover without load balancing
Hello All, I have what seems to be a unique problem. I have trawled through all the mailing lists but could not find a response. My question is: Is it possible to setup mod_jk to do only failover clustering without load balancing? We have an application that does much internal caching and thus we do not want to do load balancing. I have read through the documents and have 2 possible solutions: 1) We setup 2 worker like this: worker.list=router # Define a 'local_worker' worker using ajp13 worker.worker1.port=8009 worker.worker1.host=node1.domain.org worker.worker1.type=ajp13 worker.worker1.lbfactor=10 # Define another 'local_worker' worker using ajp13 worker.worker2.port=8009 worker.worker2.host=node2.domain.org worker.worker2.type=ajp13 worker.worker2.lbfactor=1 # Define the LB worker worker.router.type=lb worker.router.balanced_workers=worker1,worker2 Notice the high lbfactor for worker 1 and low lbfactor for worker 2. Will this do the job? 2) We setup the same configuration like this: worker.list=router # Define a 'local_worker' worker using ajp13 worker.worker1.port=8009 worker.worker1.host=node1.domain.org worker.worker1.type=ajp13 worker.worker1.lbfactor=1 worker.worker1.local_worker=1 # Define another 'local_worker' worker using ajp13 worker.worker2.port=8009 worker.worker2.host=node2.domain.org worker.worker2.type=ajp13 worker.worker2.lbfactor=1 worker.worker2.local_worker=0 # Define the LB worker worker.router.type=lb worker.router.balanced_workers=worker1,worker2 worker.router.local_worker_only=0 From what I gather this will mean all new requests will go to worker1 as it is set as local and worker2 isnt. If worker1 is down, as we have set local_worker_only=0, all new requests will get forwarded to worker2. Is this correct? Any help would be greatly appreciated. Daniel Moscufo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Jikes with -encoding option supported
There was a recent message on the list about this. See... http://www.javaroom.de/index.html Jake At 11:56 AM 12/7/2003 +0700, you wrote: Hi, Refer to Tomcat documentation. If you wish to use Jikes to compile JSP pages: - Download and install jikes. jikes must support the -encoding option. Execute jikes -help to verify that it was built with support for -encoding. - Set the init parameter compiler to jikes. - Define the property -Dbuild.compiler.emacs=true when starting Tomcat by adding it to your CATALINA_OPTS environment variable. This changes how jikes outputs error messages so that it is compatible with Jasper. - If you get an error reporting that jikes can't use UTF8 encoding, try setting the init parameter javaEncoding to ISO-8859-1. Unfortunately, lastest Jikes binary release seem not support -encoding option. So, I need helps. Does anyone know where to download Jikes binary release both for Linux and Win32 which support -encoding option? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat5 close to production?
Well, sure, on Jakarta's web site. Did you read that before posting here? http://jakarta.apache.org/site/news.html#20031203.1 Jake At 10:14 PM 12/7/2003 -0500, you wrote: Is there any word, or any place where I could check the status of Tomcat5 to move to production? My host would rather not go through with a Tomcat5 install until it comes out of beta, but I like all of the new things in JSP2. Will Tomcat5 be going production within a month or two or four or eight? Thanks, Philihp - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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: ImplicitCommitSync And UserCommitSync The docs are inconsistent on their usage, and I think the drivers vary depending upon the version of the Jet engine you are using. Anyhow, adjust 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 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 standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Enforce no cache
Hello, How do I enforce no caching for a particular context under TC? Sites/doco welcome G. - BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be.
[OT] Writing methods in servlets
Hi all, Is there any issues associated with writing methods in servlets other than the morality of it( I dont use methods in JSP pages). My application uses controller servlets for redirecting requests to different pages based on the parameter(action) passed to it. Application is designed in a way that it will have one controller servlet for a group of actions on same entity. Earlier I used to check the action in if else blocks. Now the servlet is becoming cluttered with lots of if else blocks. So I want to move this to methods and I must do it in Servlets itself (The application design dont allow to move this to another class). I know that container creates multiple threads of servlce method of (I dont know how) same servlet to service multiple requests. Then what about other custom methods in servlets. I dont use any instance variables. rgds Antony Paul. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 the connection pooling? Please elaborate on what you think I should do. Thanks. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [EMAIL PROTECTED] -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: ImplicitCommitSync And UserCommitSync The docs are inconsistent on their usage, and I think the drivers vary depending upon the version of the Jet engine you are using. Anyhow, adjust 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 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 standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 to No. If you are not using an ODBC Connection entry, then you need to pass these as arguments in the connection string. -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 the connection pooling? Please elaborate on what you think I should do. Thanks. Yaakov Chaikin Software Engineer BAE SYSTEMS 301-838-6899 (phone) 301-838-6802 (fax) [EMAIL PROTECTED] -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: ImplicitCommitSync And UserCommitSync The docs are inconsistent on their usage, and I think the drivers vary depending upon the version of the Jet engine you are using. Anyhow, adjust 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 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 standalone apps where no pooling is involved, they are caught by the garbage collector, but not in connection pooling. Trapped into this myself. Steffen, I tried what you said and closed the ResultSet and Statement before I close the Connection. Still same affect. Any other ideas anyone? I highly doubt it's the driver. I would bet that I am doing something wrong. I just can't figure out what it is. Thanks, Yaakov. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
