Sql Syntax error in query string with JDBC?

Question

I'm trying to search a table in sql by timestamp using java and jdbc, but when I insert the timestamp into the query string I get a sytax error at the hour figure:

 String queryString = "select " + tag +  " from WATER_RUNTIME_VALUES
 where Time_Stamp = 2015-06-150 8:58:00.0000000";

 ResultSet rs = statement.executeQuery(queryString);

And here is the error:

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '10'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616) at bandon.scada.core.InitConn.calculateHourlyTotal(InitConn.java:58) at bandon.scada.core.InitConn.dbConnect(InitConn.java:36) at bandon.scada.core.InitConn.main(InitConn.java:24)

Consider using parameterized queries. That will avoid the need to put date literals in quotes and format date literal strings. — Dan Guzman
– Dan Guzman, Commented Jun 15, 2015 at 11:04

Hiren · Accepted Answer · 2015-06-15 11:08:21Z

3

Try this..

String queryString = "select ' " + tag + " ' from WATER_RUNTIME_VALUES where Time_Stamp = '2015-06-150 8:58:00.0000000'";

answered Jun 15, 2015 at 11:08

Hiren

1,4451 gold badge18 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Isuru Gunawardana · Accepted Answer · 2015-06-15 10:59:10Z

0

Use quotes in date parameters,

String queryString = "select " + tag + " from WATER_RUNTIME_VALUES where Time_Stamp = '2015-06-150 8:58:00.0000000'"

answered Jun 15, 2015 at 10:59

Isuru Gunawardana

2,8876 gold badges32 silver badges64 bronze badges

Comments

singhakash · Accepted Answer · 2015-06-15 11:06:42Z

0

Put single quotes in time value to escape the spaces in 2015-06-150 8:58:00.0000000

String queryString = "select " + tag + " from WATER_RUNTIME_VALUES where Time_Stamp = '2015-06-150 8:58:00.0000000'";

Or better use PreparedStatement

edited Jun 15, 2015 at 11:06

answered Jun 15, 2015 at 10:59

singhakash

7,9196 gold badges33 silver badges65 bronze badges

Comments

Nagarz · Accepted Answer · 2015-06-15 10:59:27Z

-1

The date needs to be within quote marks

answered Jun 15, 2015 at 10:59

Nagarz

1662 silver badges13 bronze badges

Collectives™ on Stack Overflow

Sql Syntax error in query string with JDBC?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related