Also, make sure that whatever "jar" file has this
sun.jdbc.odbc.JdbcOdbcDriver class, is located in your tomcat common/lib. As
well as having a binding in your context.xml or web.xml like below. And have
the datasource configured in the server.xml or equivalent(I think 5.5 sets
up the Datasources a little different). but you'll need the follwing
configured..
datasurce:
<Resource name="jdbc/AccessDS" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/AccessDS">
<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>8</value></parameter>
<parameter><name>minIdle</name><value>5</value></parameter>
<parameter><name>maxWait</name><value>1000</value></parameter>
<parameter><name>username</name><value>username</value></parameter>
<parameter><name>password</name><value>password</value></parameter>
<parameter><name>driverClassName</name><value>
sun.jdbc.odbc.JdbcOdbcDriver</value></parameter>
<!-- This URL parameter may be different since it's jdbc.odbc -->
<parameter><name>url</name><value>jdbc:oracle:thin:@host
:<port>:<sid></value></parameter>
<!-- This URL parameter may be different since it's jdbc.odbc -->
<parameter><name>removeAbandoned</name><value>true</value></parameter>
<parameter><name>removeAbandonedTimeout</name><value>10</value></parameter>
<parameter><name>logAbandoned</name><value>true</value></parameter>
</ResourceParams>
resourcelink:
<ResourceLink name="jdbc/AccessDS" global="jdbc/AccessDS" type="
javax.sql.DataSource" />
this is meerly an example, you may have to search the web for the correct
way to bind it.
reference in web or context.xml
<resource-ref>
<res-ref-name>jdbc/AccessDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
On 8/10/07, Propes, Barry L <[EMAIL PROTECTED]> wrote:
>
> you did give it a DSN of some sort?
> Do you have the correct driver or MDAC update?
>
> -----Original Message-----
> From: remmons [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 10, 2007 10:40 AM
> To: users@tomcat.apache.org
> Subject: Using MSAccess database for container authentication
>
>
>
> I am trying to use an MSAccess database for container authentication in
> Tomcat 5.5.23. When I start Tomcat, I get this message in the
> catalina.YYYY-MM-DD.log:
>
> Aug 10, 2007 10:50:30 AM org.apache.catalina.realm.JDBCRealm start
> SEVERE: Exception opening database connection
> java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name
> not
> found and no default driver specified
> at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
> at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
> at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:701)
> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:769)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1006)
> at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(
> StandardService.java:448)
> at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:700)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
> 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.start(Bootstrap.java:295)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
> Aug 10, 2007 10:50:30 AM org.apache.catalina.core.StandardHost start
> INFO: XML validation disabled
>
>
> I setup my realm in server.xml as follows:
>
> <Realm className="org.apache.catalina.realm.JDBCRealm"
> driverName="sun.jdbc.odbc.JdbcOdbcDriver"
> connectionURL="jdbc:odbc:Auth"
> userTable="User" userNameCol="UserName" userCredCol="Password"
> userRoleTable="User_Role" roleNameCol="RoleName" />
>
> where Auth.mdb is the name of my MSAccess database. I configured Auth.mdb
> in my ODBC Data Source Administrator, and I am able to access it and
> display
> its tables from a Java application.
>
> I am using Tomcat 5.5.23.
>
> Has anyone used an MSAccess database via JDBC-ODBC for authentication in
> Tomcat? Can anyone tell me what I am doing wrong?
>
> --
> View this message in context:
> http://www.nabble.com/Using-MSAccess-database-for-container-authentication-tf4249487.html#a12093749
> Sent from the Tomcat - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
