Error: [SQLServer JDBC Driver]Syntax error at token 0, line 0 offset 0

[Former Member]

Hi:

I´m working with system driver at de JDBC connection in VA. When a record is inserted/updated this error is display:

NWMss SQLServer JDBC Driver Syntax error at token 0, line 0 offset 0

The record is inserted/updated but when the operation ends the exception is throw.

I Google the error but I didn´t find how to solve it.

Any idea?

Thanks a lot for your time on this post.

Rocío.

[Former Member]

Problem solve, it was the queries´ order, the SQL sentence are OK.

[p_2_5_6_9_6_0]

Hi,

NWMss  SQLServer JDBC Driver  Syntax error at token 0, line 0 offset 0

I think that you may be trying to construct an SQL query using some logic. Is that right?

I hav encountered this problem when trying these types of code - If possible please debug the code and see if there is any particular case in which the SQL string in which the command is saved becomes null.

When it is null or blank - the SQL Driver will throw such an error.

Also, if you can elaborate more on the problem - I can give you some more help.

Thanks.

p256960