G
Glenn Robinson
Hello,
I'm using jdbc-odbc bridge to try and update a .dbf table.
My code is as follows:
stmt.executeUpdate(
"INSERT INTO sas.dbf VALUES ('1234', '1234567', '1', '1234',
'12:34:56', '2004-06-18', '1','1234',)");
When I run it I get a syntax error in INSERT INTO statement, the following
in my ODBC trace file:
<snip>
java 45c-538 ENTER SQLSetStmtOption
HSTMT 08E421D8
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001
java 45c-538 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
HSTMT 08E421D8
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001 (BADMEM)
java 45c-538 ENTER SQLFreeStmt
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>
java 45c-538 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>
java 45c-538 ENTER SQLExecDirect
HSTMT 08E421D8
UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
SDWORD -3
java 45c-538 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 08E421D8
UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
SDWORD -3
DIAG [37000] [Microsoft][ODBC dBase Driver] Syntax error in INSERT INTO
statement. (-3502)
java 45c-538 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
java 45c-538 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944 (-3502)
WCHAR * 0x0007F500 [ 69] "[Microsoft][ODBC dBase Driver]
Syn"
SWORD 300
SWORD * 0x0007F940 (69)
java 45c-538 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
java 45c-538 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
<snip>
All columns are character apart from the 6th one which is a date type and I
suspect this is what's causing me a problem.
Can anyone shed any light on this?
Thanks
I'm using jdbc-odbc bridge to try and update a .dbf table.
My code is as follows:
stmt.executeUpdate(
"INSERT INTO sas.dbf VALUES ('1234', '1234567', '1', '1234',
'12:34:56', '2004-06-18', '1','1234',)");
When I run it I get a syntax error in INSERT INTO statement, the following
in my ODBC trace file:
<snip>
java 45c-538 ENTER SQLSetStmtOption
HSTMT 08E421D8
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001
java 45c-538 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
HSTMT 08E421D8
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001 (BADMEM)
java 45c-538 ENTER SQLFreeStmt
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>
java 45c-538 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>
java 45c-538 ENTER SQLExecDirect
HSTMT 08E421D8
UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
SDWORD -3
java 45c-538 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 08E421D8
UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
SDWORD -3
DIAG [37000] [Microsoft][ODBC dBase Driver] Syntax error in INSERT INTO
statement. (-3502)
java 45c-538 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
java 45c-538 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944 (-3502)
WCHAR * 0x0007F500 [ 69] "[Microsoft][ODBC dBase Driver]
Syn"
SWORD 300
SWORD * 0x0007F940 (69)
java 45c-538 ENTER SQLErrorW
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
java 45c-538 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 00000000
HDBC 00000000
HSTMT 08E421D8
WCHAR * 0x0007F900 (NYI)
SDWORD * 0x0007F944
WCHAR * 0x0007F500
SWORD 300
SWORD * 0x0007F940
<snip>
All columns are character apart from the 6th one which is a date type and I
suspect this is what's causing me a problem.
Can anyone shed any light on this?
Thanks