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