python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - named-parameters

Parameter marker XXX was not present in the SQL String

I'm trying to use named parameter markers in a SQL query with Java and db2, like this: SELECT ... FROM mytable c ... WHERE c.id_field = :myParam I configure the connection like this: Properties prope...
test-img

madtyn

java

db2

named-parameters

Votes: 0

Answers: 2

Latest Answer

Your question does not show your real code so I cannot guess what mistake or omission that you are making. Named Parameters work well with DB2PreparedStatement, as long as you follow the documented ru...
test-img

mao

Named Parameter Markers in JDBC and DB2

I'm trying to use named parameter markers as in: SELECT field FROM table WHERE field = :value -- I'd like to use this ':value' I've been reading about this and I understood that I need to convert my...
test-img

madtyn

java

db2

dependencies

maven-3

named-parameters

Votes: 0

Answers: 1

Latest Answer

Seems, that this very old Db2 jcc 2.3.63 version driver (from Db2 V8.2) doesn't have support for named parameters. Contemporary Db2 jcc drivers do support such a functionality. It's strongly advised t...
test-img

Mark Barinstein

Posts

Questions

Blogs

Jobs