Hi Guys,

I am having problems with creating a JDBC realm in my server.xml. This is how I have configured the server.xml so far:

    <Realm className="org.apache.catalina.realm.JDBCRealm"
        debug="99"
                 driverName="com.mysql.jdbc.Driver"
              connectionURL="jdbc:mysql://localhost/singlesignon"
             connectionName="root"
        connectionPassword="password"
                  userTable="users"
        userNameCol="Username"
        userCredCol="Password"
              userRoleTable="userroles"
        roleNameCol="Role" />
</Context>

Under the context is the following:

<!--
<Valve className="org.apache.catalina.valves.RequestDumpe rValve"/>
-->



<!-- This Realm uses the UserDatabase configured in the global JNDI
     resources under the key "UserDatabase". Any edits
     that are performed against this UserDatabase are immediately
     available for use by the Realm. -->


<Realm className="org.apache.catalina.realm.UserDatabaseR ealm"
resourceName="UserDatabase"/>



<!-- Comment out the old realm but leave here for now in case we
     need to go back quickly -->

****COULD SOME ONE PLEASE EXPLAIN WHAT THE COMMENT ABOVE MEANS??****

<!--
<Realm className="org.apache.catalina.realm.MemoryRealm" />
-->

<!-- Replace the above Realm with one of the following to get a Realm
     stored in a database and accessed via JDBC -->

Thanks Guys

Adz - Learning The J2EE Ways.

__________________
Adz - Learning The J2EE Ways.

What that means is the Realm line that contains the MemoryRealm entry has been commented so it doesn't interfere with the Realm line above that is using the UserDatabase. Surrounding the line with "<!-- " and " -->" comments it so it is not read as part of the configuration. But leaving the line there in case you want to revert to the earlier behavior/configuration quickly. (Delete the "<!-- " line and the " -->" line from around the "<Realm className="org.apache.catalina.realm.MemoryRealm" />" line and put the same lines around the "<Realm className="org.apache.catalina.realm.UserDatabaseR ealm" ResourceName="UserDatabase"/>" line and restart the Tomcat server.)

Now, a couple things that I notice as differences between what you have posted above and what I have in our servers that is working are:

1.) In our configuration, we have the port and database names in the connectionURL (e.g. "jdbc:mysql://127.0.0.1:3306/test" where 'test' = the name of the database. So, your database is called 'singlesignon'?)

2.) I notice that you are using:
Are the columns in your database for username and password using capitals at the beginning of their names? Case sensitivity can be an issue with these.

HTH.