title: java.sql.SQLException: General error
body: <p>Getting <code>java.sql.SQLException</code></p>
  
  <pre><code>java.sql.SQLException: General error
  at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6986)
  at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
  at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
  at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
  at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
  at com.test.Temp.main(Temp.java:29)
  </code></pre>
  
  <p>I am using following code</p>
  
  <pre><code>Connection con=null;
  ResultSet rs=null;
  Statement stmt=null;
  
  try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con=DriverManager.getConnection("jdbc:odbc:locator","locator","locator");
  
    stmt=con.createStatement();
    System.out.println("Before query");
    String query=null;
    query="select * from user_location_table";
    System.out.println("after query12");
  
    rs=stmt.executeQuery(query);
    //perform certain operation....
    rs.close();
    stmt.close();
    con.close();
  } catch(Exception e) {
    e.printStackTrace();
  }
  </code></pre>
  
  <p>The exception is thrown at <code>stmt.executeQuery(query)</code>.</p>
  
  <p>user_location_table contains following fields</p>
  
  <pre><code>user_id:number  not null,
  latitude:number,
  longitude:number,
  update_time:timestamp(6)
  </code></pre>
  
  <p>Thanks in advance</p>