Re: JDBCRealm changes from Tomcat 5.0.x to 5.5.x

[Hassan Schroeder]

alexander dosher wrote:
DataSourceRealm (5.5.7): doesn't work or is unconfigurable by me - i've 
got a
<Server>
  <GlobalNamingResources>
    <Resource type="javax.sql.DataSource" name="UserDatabase">

and an
<Engine>
  <Realm className="org.apache.catalina.realm.DataSourceRealm" 
name="UserDatabase">
<snip/>
How about something like:
<GlobalNamingResources>
    <Resource name="jdbc/authorization"
        auth="Container"
        type="javax.sql.DataSource"
        username="ren"
        password="stimpy"
        driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/authority?autoReconnect=true"/> 
</GlobalNamingResources>

:: and ::
<Realm
        className="org.apache.catalina.realm.DataSourceRealm"
        dataSourceName="jdbc/authorization"
        userTable="users"
        userNameCol="user_name"
        userCredCol="user_pass"
        userRoleTable="user_roles"
        roleNameCol="role_name"/>
:: which -- season to taste -- works for me :-)
FWIW!
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
                          dream.  code.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]