Question on Object [] args parameter in SimpleJdbcTemplate.query method

[smm]

Greetings,

I have a question on the Object [] args parameter of the SimpleJdbcTemplate's query method -

What impact does setting the arguments have on the query that is executed? The API docs only describe them as "the args for the query".

Thanks,
Steve

[dr_pompeii]

What impact does setting the arguments have on the query that is executed?

?, about performance???

i dont think that 3 objects in the query can make some critical problem in the performance, and 10?

why did you ask this??

[karldmoore]

I'm not entirely sure I understand the question. If you query has parameters then the args are used to fill in the parameter placeholder e.g. SELECT * from my_table WHERE my_id = ?. This is a general JDBC thing.

[smm]

Ok, so what you're saying is that they are for Prepared Statements - that makes sense then. Are you aware of a resource/documentation that confirms this?

Thanks.

[karldmoore]

The reference manual has information on this and a quick look at the code confirms this.
http://static.springframework.org/sp...c-JdbcTemplate

[smm]

Thanks - I appreciate it.

[karldmoore]

Thanks - I appreciate it.

Not a problem, the reference manual is well worth have a look at. There's lots of useful information there!

[al0]

Not a problem, the reference manual is well worth have a look at. There's lots of useful information there!

While thing seems to self-obvious and reference manual is a good thing to look in, I have to note that Javadoc on this matter is definitely subpar. Probably, worth a JIRA.

Regards,
Oleksandr

[karldmoore]

While thing seems to self-obvious and reference manual is a good thing to look in, I have to note that Javadoc on this matter is definitely subpar. Probably, worth a JIRA.

If you feel there's an issue JIRA it away .

[pgathua]

So I ran into this issue. I looked at the API. pass in a single Object parameter, it works. Pass in an Array of a single parameter it works too. Can't be both as both are definitely NOT the same thing. So which is it? API implies and explicitly says variable arguments meaning 1,2,3.... not int[]{1,2,3} or even int[]{1,2,3,4}.

Inquisitive about this, I did a quick experiment. I added another bind parameter to my query and now passed in the API mandated 1,2 Result? No fortune cookie for me! Now I pass in int[]{1,2} and Voilla!

So you see, the array is the right one. The variable argument list is just a side effect of the way they translate your parameters behind the scenes. Whatever it is they are doing, I can check or speculate but doesn't matter only works for the first parameter. Point is the API is wrong and documentation \ javadoc should be updated. In my case, my initial problem was complicated by the fact that I was dealing with Oracle dates and that's a PITA all in itself. After getting completely puzzled why it wont work, I fired up sql plus and wrote and ran equivalent query just for a sanity check. It worked fine. Hey who needs Spring when we have sql plus? So cut it down to a sigle parameter and it worked. I added another one with the array and was even more confused why it worked. Then I realized what was going on. Searched online found this thread.

Hope that helps others who get confused by this.