SELECT * WHERE in H2 database
<p>I'm trying to do in my program a JDBC connection with my Embedded H2 database. The problem is that I couldn't execute a simple query with "WHERE ID =". In my databse, the ID are string not integer ('D58BE' in my example).</p>

<p>There is my code :</p>

<pre><code>   public Milestone findbyId(String id) throws ClassNotFoundException, SQLException {

    Class.forName("org.h2.Driver");
    Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
    PreparedStatement prepareStatement = connection.prepareStatement("SELECT * FROM MILESTONE WHERE ID= 'D58BE'");
</code></pre>

<p>The problem is that the SAME query ("SELECT * FROM MILESTONE WHERE ID= 'D58BE'") works perfectly in my embeded database (I verify the result with the h2.jar provided to manage the database). While  in eclipse, I had this exception :</p>

<pre><code>Exception in thread "main" org.h2.jdbc.JdbcSQLException: Column "D58BE" not found [42122-191]
</code></pre>

<p>I tried A LOT of things but it still never works...</p>