Re: JDBCRealm SQLException

[Joe Clem <cl...@strategiesmail.saic.com>]

Well,

This is pretty much what I am doing.  I followed the configuration
example in the 3.2.3 documentation.  I am using the exact table
structure that you have laid out here.  As far as the realm attributes I
am just plugging in my own account info and database connection info.

JOe

Peter Rossbach wrote:

> Hello!
>
> Please test the following configuration:
>
>            <Realm
>               className="org.apache.catalina.realm.JDBCRealm"
>               debug="99"
>               driverName="oracle.jdbc.driver.OracleDriver"
>               connectionName="scott"
>               connectionPassword="tiger"
>               connectionURL="jdbc:oracle:thin:@puuh:1521:puuh"
>               userTable="users"
>               userNameCol="user_name"
>               userCredCol="user_pass"
>               userRoleTable="user_roles"
>               roleNameCol="role_name"
>            />
>
> with the tomcat doc schema:
> drop table users ;
> drop table user_roles ;
>
> create table users (
>   user_name         varchar(50) not null primary key,
>   user_pass         varchar(50) not null
> );
>
> create table user_roles (
>   user_name         varchar(50) not null,
>   role_name         varchar(32) not null,
>   primary key (user_name, role_name)
> );
>
> --
> Regards
> --
> Peter Roßbach
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>   The WebApp Framework     http://www.webapp.de/
>   SMI                      connect your Web-Business with success
>   Persistence              objectrelational mapping
>   Java Server & Servlets   The German servlet book
> ---
> Address:    Am Josephsschacht 72, 44879 Bochum, Germany
> Phone:      (49) 234 / 9413228
> Mobil:      (49) 175 / 1660884
> E-Mail:     pr@webapp.de


--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>