Hi,

Where applicable I have configured my <Store> element inside my <Manager> 
element to have the same jdbc config (driverName, connectionURL, 
connectionName,connectionPassword) as my JDBCRealm. The JDBCRealm works fine 
but the JDBCStore seems to be misbehaving. Tomcat (4.0.1) starts fine, no 
exceptions thrown, but in my local_host log fine I see the following and 
nothing is written to the db :

2002-05-11 18:59:43 JDBCStore[/apress]: The database connection is null or 
was found to be closed. Trying to re-open it.
2002-05-11 18:59:43 JDBCStore[/apress]: A SQL exception occured The user 
property is missing. It is mandatory.

Thank you

Grant E


<!-- Tomcat Apress Context -->
        <Context path="/apress" docBase="apress" debug="0" 
reloadable="true">
            <Manager 
className="org.apache.catalina.session.PersistentManager"
                debug="99"
                saveOnRestart="true"
                maxActiveSessions="-1"
                minIdleSwap="-1"
                maxIdleSwap="-1"
                maxIdleBackup="-1">
                <Store className="org.apache.catalina.session.JDBCStore"
                    driverName="org.postgresql.Driver"
connectionURL="jdbc:postgresql://localhost.localdomain:5432/utalk"
                    connectionName="gedwards"
                    connectionPassword="mypassword"
                    sessionTable="session"
                    sessionIdCol="id"
                    sessionDataCol="data"
                    sessionValidCol="valid"
                    sessionMaxInactiveCol="maxinactive"
                    sessionLastAccessCol="lastaccess"
                    checkInterval="60"
                    debug="99"
                />
            </Manager>
        </Context>`



<Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
                driverName="org.postgresql.Driver"
                
connectionURL="jdbc:postgresql://localhost.localdomain:5432/utalk"
                connectionName="gedwards"
                connectionPassword="mypassword"
                userTable="users"
                userNameCol="user_name"
                userCredCol="user_pass"
                userRoleTable="user_roles"
                roleNameCol="role_name" />








_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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

Reply via email to