why this program always show syntax error

[bhallarahul]

import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.ResultSet;
class db
	{
		public static void main(String arg[])
			{
				Statement statementObj=null;
				Connection connectionObj=null;
				try
					{
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        			connectionObj=DriverManager.getConnection("jdbc:odbc:sensorData","","");
			                        statementObj=connectionObj.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
						System.out.println("do not worry ho ga yr ho ga");
						statementObj.executeUpdate("INSERT INTO hardwareData (Time, Date, humidity, Temp, DiesalLevel) VALUES('1','12','3','s','a')");
						connectionObj.close();
					}
				catch(ClassNotFoundException e)
					{
						System.out.println("class not found exception");
					}
				
				catch(SQLException e)
					{
						e.printStackTrace();
					}
			}   
       }

[mKorbel]

which database Engine you want to connect

[dononelson]

Please put your code snippets within

blocks in the future - it makes it easier for us all to read.

Can you post your exception stack so we can see what might be going wrong?

[ivatanako]

Maybe in the database your using. The TIME and DATE are reserved keywords that you should escape first. for sql, [TIME],[DATE]. For mysql, `TIME`,`DATE`

[bhallarahul]

I m using MS access

[bhallarahul]

it shows
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
INSERT INTO statement.
And it all the field of data base is Text.

[bhallarahul]

Maybe in the database your using. The TIME and DATE are reserved keywords that you should escape first. for sql, [TIME],[DATE]. For mysql, `TIME`,`DATE`

if i use this Statement:
statementObj.executeUpdate("INSERT INTO hardwareData VALUES('1','12','3','s','a')");
where in database fields are
Time:Text
Date:Text
humidity:Text
Temp:Text
DiesalLevel:Text

[masijade]

If you use that statement, what? The machine blows up?

[ivatanako]

INSERT INTO hardwareData ([Time], [Date], humidity, Temp, DiesalLevel) VALUES('1','12','3','s','a')

[bhallarahul]

INSERT INTO hardwareData ([Time], [Date], humidity, Temp, DiesalLevel) VALUES('1','12','3','s','a')

First of all THANK YOU. My code is working.
Can you tell me please why we required square bracket in Time and Date field

[Ezzaral]

He already did above in this post: http://www.daniweb.com/software-development/java/threads/355285/1513029#post1513029