Using Progress DB for Tomcat JDBCRealm autohorization

[jkuhns]

I am using Tomcat 6, Progress 10.1C.

Here is the realm setup from my server.xml file, edited for readability, the connection is made, the query fails:

    <Realm className="org.apache.catalina.realm.JDBCRealm"
         debug="99" driverName="com.ddtek.jdbc.openedge.OpenEdgeDriver" 
         connectionURL="jdbc:datadirect:openedge://SERVER:2222;databaseName=
                 dbname;defaultschema=pub;statementCacheSize=10;"
         connectionName="user"
         connectionPassword="secret"
         userTable="Employee"
         userNameCol="Number"
         userCredCol="Password"
         userRoleTable="Role"
          roleNameCol="RoleName" />

No luck on doing this, it looks like Tomcat is sending a parameterized query that chokes Progress:

java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "Number = ?" (10713)

I have looked around for help, so far no luck. Any ideas? I've already started writing my own Realm, but a quick answer may save me a few hours.

Thanks in advance.