JDBC MSSQL Insert fails with error "near where"

Question

I have a strange problem. I'm executing insert using prepared statement like this: try (Connection connection = connectionPool.getConnection(); PreparedStatement ps = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) { //TODO: caching of PS int i = 1; ParameterMetaData pmd = ps.getParameterMetaData(); ... } catch (SQLException e) { throw new TGFIOException("Error executing SQL command " + sql, e); } Insert statement is like this: insert into dbo.CurrencyRates(RateDate, CurrencyID, Rate) values ( ?, ?, ? ) Unfortunately it fails with following exception: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) at com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData.(SQLServerParameterMetaData.java:426) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getParameterMetaData(SQLServerPreparedStatement.java:1532) at com.jolbox.bonecp.PreparedStatementHandle.getParameterMetaData(PreparedStatementHandle.java:246) There is no WHERE in the statement, so I am puzzled why it fails on metadata extraction... EDIT: SQL Server = 10.50.2500.0 Express Edition, Driver = sqljdbc4.jar from 4.0 package Also, I am using getParameterMetaData because I need to set some params to null and the preferred method is to use setNull() where you need SQLType. EDIT2: I've tested with Driver sqljdbc41 from newest 6.0 package - results are the same EDIT3: I've removed call to getParameterMetaData() and it worked, unfortunately it is a generic part that should max portable, yet it does not work with this single table (inserts to other tables on the same database works fine !!!) EDIT4: I've tried with different insert statements for this table and all of them works fine if I skip ps.getParameterMetaData() and fail when I call it. If I try with 2 or more params I get usual near WHERE error. If I try one column insert I get an error stating that the column name is incorrect, even if it is correct and without the meta data call it works perfectly fine. I will try to trace what driver tries to do underneath... JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

After some tracing on what actually the driver does (many thanks a_horse_with_no_name), I've come to some funny conclusion. The solution for my question is to: Replace following insert statement INSERT INTO CurrencyRates(RateDate, CurrencyID, Rate) VALUES ( ?, ?, ? ) With this statement INSERT INTO CurrencyRates (RateDate, CurrencyID, Rate) VALUES ( ?, ?, ? ) Logic behind that is that SQL driver does some metadata extraction in the background, and it creates a query with following fragment: ... FROM CurrencyRates(RateDate WHERE ... if you do not put space after table name, yet for the ordinary call this is perfectly possible! EDIT: This is obviously an inconsistency as (putting aside what actually is a valid insert) it should consistently accept or reject this query no matter if I call for meta data or not.