SQL State error while JDBC'ing to a db2 database

Question

I am using JDBC to connect to a db2 database and have the following sql to insert some values into the database.

sql="insert into HC_PROPF.PATIENT (given_name) values ('"+strArray[0]+"');";

However, I get a SQL STATE error as follows:

DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=@;ME) values ('Lorna');END-OF-STATEMENT, DRIVER=3.66.46

Thanks guys.

In the future, you need to describe to us what the error is; often, this will tell you what the problem is, and where to look to resolve it. In case you don't know that particular one, IBM has a list of all the codes. Also, you should be using prepared statements, as depending on where strArray[0] is coming from, you may be open to SQL Injection (which is often the cause of data breaches); this is especially worrying as you look to be subject to HIPAA regulations... — Clockwork-Muse
– Clockwork-Muse, Commented Jun 19, 2013 at 20:52

MaVRoSCy · Accepted Answer · 2013-06-19 20:48:27Z

3

try it without the last ; in your query

sql="insert into HC_PROPF.PATIENT (given_name) values ('"+strArray[0]+"')";

According to documentation this is a syntax error

answered Jun 19, 2013 at 20:48

MaVRoSCy

17.9k15 gold badges87 silver badges129 bronze badges

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

1 Answer 1