title: Jetty JDBCLoginService using null in mysql request
body: <p>i'm trying to use a JDBCLoginService in Jetty but when it's used by my app i get this error in the logs:</p>
  <pre><code>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null where null = 'admin'' at line 1
  </code></pre>
  <p>like if jetty wasn't using the columns in the properties file</p>
  <p>the jetty.xml part:</p>
  <pre><code>&lt;Call name=&quot;addBean&quot;&gt;
    &lt;Arg&gt; 
      &lt;New class=&quot;org.eclipse.jetty.security.JDBCLoginService&quot;&gt;
        &lt;Set name=&quot;name&quot;&gt;gateway_jndi&lt;/Set&gt;
        &lt;Set name=&quot;config&quot;&gt;/usr/local/jetty/etc/jdbcRealm.properties&lt;/Set&gt;
      &lt;/New&gt;
   &lt;/Arg&gt;
  &lt;/Call&gt;
  </code></pre>
  <p>/usr/local/jetty/etc/jdbcRealm.properties has been chmoded to 777 and seems to be used since with a wrong path i get an error.</p>
  <p>jdbcRealm.properties content:</p>
  <pre><code>jdbcdriver = org.gjt.mm.mysql.Driver
  url = jdbc:mysql://mydatabasefqdb:3306/mydatabasename
  username = mydatabaseuser
  password = mydatabasepassword
  userTable = gateway_users
  userTableKey = ID
  userTableUserField = USERNAME
  userTablePasswordField = PASSWORD
  roleTable = gateway_roles
  roleTableKey = ID
  roleTableRoleField = NAME
  userRoleTableName = gateway_users_roles
  userRoleTableUserKey = user_id
  userRoleTableRoleKey = role_id
  cachetime = 300
  </code></pre>
  <p>versions:</p>
  <blockquote>
  <p>jetty: 9.3.2</p>
  <p>jre: 8</p>
  <p>mysql: 5.5</p>
  </blockquote>