> 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 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]: Context startup failed due to previous errors 2003-12-07 04:24:21 StandardContext[/tomcat-docs]: Exception during cleanup after start failed LifecycleException: Container StandardContext[/tomcat-docs] 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 WebappLoader[/manager]: Deploying class repositories to work directory C:\jakarta-tomcat-4.1.29-full\work\Standalone\localhost\manager 2003-12-07 04:24:21 WebappLoader[/manager]: Reloading checks are enabled for this Context 2003-12-07 04:24:21 ContextConfig[/manager]: Configured an authenticator for method BASIC 2003-12-07 04:24:21 StandardManager[/manager]: Seeding random number generator class java.security.SecureRandom 2003-12-07 04:24:21 StandardManager[/manager]: Seeding of random number generator has been completed 2003-12-07 04:24:21 StandardWrapper[/manager:default]: Loading container servlet default 2003-12-07 04:24:21 StandardWrapper[/manager:invoker]: Loading container servlet invoker 2003-12-07 04:24:21 WebappLoader[]: Deploying class repositories to work directory C:\jakarta-tomcat-4.1.29-full\work\Standalone\localhost\_ 2003-12-07 04:24:21 WebappLoader[]: Reloading checks are enabled for this Context 2003-12-07 04:24:21 StandardManager[]: Seeding random number generator class java.security.SecureRandom 2003-12-07 04:24:21 StandardManager[]: Seeding of random number generator has been completed 2003-12-07 04:24:21 StandardWrapper[:default]: Loading container servlet default 2003-12-07 04:24:21 StandardWrapper[:invoker]: Loading container servlet invoker 2003-12-07 04:24:21 HostConfig[localhost]: Deploying web application directory examples 2003-12-07 04:24:21 StandardHost[localhost]: Installing web application at context path /examples from URL file:C:\jakarta-tomcat-4.1.29-full\webapps\examples 2003-12-07 04:24:21 WebappLoader[/examples]: Deploying class repositories to work directory C:\jakarta-tomcat-4.1.29-full\work\Standalone\localhost\examples 2003-12-07 04:24:21 WebappLoader[/examples]: Deploy class files /WEB-INF/classes to C:\jakarta-tomcat-4.1.29-full\webapps\examples\WEB-INF\classes 2003-12-07 04:24:21 ContextConfig[/examples]: Configured an authenticator for method FORM 2003-12-07 04:24:21 StandardManager[/examples]: Seeding random number generator class java.security.SecureRandom 2003-12-07 04:24:21 StandardManager[/examples]: Seeding of random number generator has been completed 2003-12-07 04:24:21 ContextListener: contextInitialized() 2003-12-07 04:24:21 SessionListener: contextInitialized() 2003-12-07 04:24:21 StandardWrapper[/examples:default]: Loading container servlet default 2003-12-07 04:24:21 StandardWrapper[/examples:invoker]: Loading container servlet invoker I would really appreciate if someone would help me out with this. Thanks, Yaakov.
<?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> <name>factory</name> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> </parameter> <parameter> <name>pathname</name> <value>conf/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> <name>factory</name> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> </parameter> <parameter> <name>pathname</name> <value>conf/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> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>driverClassName</name> <value>sun.jdbc.odbc.JdbcOdbcDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:odbc:afec</value> </parameter> <parameter> <name>username</name> <value>default</value> </parameter> <parameter> <name>password</name> <value>afecrelease2003</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</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="20000" 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" port="8009" protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler" proxyPort="0" redirectPort="8443" scheme="http" secure="false" tcpNoDelay="true" useURIValidationHack="false"> <Factory className="org.apache.catalina.net.DefaultServerSocketFactory"/> </Connector> <Engine className="org.apache.catalina.core.StandardEngine" debug="0" defaultHost="localhost" mapperClass="org.apache.catalina.core.StandardEngineMapper" name="Standalone"> <Host className="org.apache.catalina.core.StandardHost" appBase="webapps" autoDeploy="true" configClass="org.apache.catalina.startup.ContextConfig" contextClass="org.apache.catalina.core.StandardContext" debug="0" deployXML="true" errorReportValveClass="org.apache.catalina.valves.ErrorReportValve" liveDeploy="true" mapperClass="org.apache.catalina.core.StandardHostMapper" name="localhost" unpackWARs="false"> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Administration Application" docBase="../server/webapps/admin" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/admin" privileged="true" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_admin_log." suffix=".txt" timestamp="true" verbosity="1"/> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Webdav Content Management" docBase="C:\jakarta-tomcat-4.1.24-LE-jdk14\webapps\webdav" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/webdav" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> </Context> <!--*** BEGIN AFECWEB Context ***--> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="AFECWEB" docBase="c:/corej2ee/stage/wls/afecWebApp/afecWEB.war" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/afecWEB" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_afecWEB_log." suffix=".txt" timestamp="true" verbosity="99"/> <!-- <Resource name="jdbc/afecWEBDB" auth="Container" description="AFEC database; stores info about documents, login" type="javax.sql.DataSource" scope="Shareable" /> <ResourceParams name="jdbc/afecWEBDB"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>10</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>driverClassName</name> <value>sun.jdbc.odbc.JdbcOdbcDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:odbc:afec</value> </parameter> <parameter> <name>username</name> <value>default</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> </ResourceParams> --> <ResourceLink global="afec/web/database" name="jdbc/afecWEBDB" type="javax.sql.DataSource"/> </Context> <!--*** END AFECWEB Context ***--> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Documentation" docBase="C:\jakarta-tomcat-4.1.24-LE-jdk14\webapps\tomcat-docs" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/tomcat-docs" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Welcome to Tomcat" docBase="ROOT" mapperClass="org.apache.catalina.core.StandardContextMapper" path="" privileged="false" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> </Context> <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="true" debug="0" displayName="Tomcat Manager Application" docBase="../server/webapps/manager" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/manager" privileged="true" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <ResourceLink global="UserDatabase" name="users" type="org.apache.catalina.UserDatabase"/> </Context> <DefaultContext className="org.apache.catalina.core.StandardDefaultContext" cookies="true" crossContext="true" name="defaultContext" reloadable="true" swallowOutput="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> </DefaultContext> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true" verbosity="1"/> </Host> <Logger className="org.apache.catalina.logger.FileLogger" debug="0" directory="logs" prefix="catalina_log." suffix=".txt" timestamp="true" verbosity="1"/> <Realm className="org.apache.catalina.realm.UserDatabaseRealm" debug="0" resourceName="UserDatabase"/> <!-- <Realm className="org.apache.catalina.realm.JDBCRealm" connectionName="default" connectionPassword="afecrelease2003" connectionURL="jdbc:odbc:afec" debug="0" driverName="sun.jdbc.odbc.JdbcOdbcDriver" roleNameCol="UserRole" userCredCol="UserPassword" userNameCol="UserName" userRoleTable="TestUsers" userTable="TestUsers" validate="true" /> --> </Engine> </Service> </Server>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]