Wish JRDC2 to have @p1, @p2 instead of ? (Re-use parameters)

[John Naylor]

I've recently been using JRDC2 quite a bit and it is excellent but I often find I need to reuse parameters in queries.

An entry in the JRDC2 config.properties query may read something like

Select
    mainstock.id,
    mainstock.name,
    mainstock.description
From
    mainstock
Where
    (mainstock.id = ?) Or
    (mainstock.name Like Concat('%', ?, '%')) Or
    (mainstock.description Like Concat('%', ?, '%'))

So I would have to pass three parameters when only two are actually required to pull off the following alternative

Select
    mainstock.id,
    mainstock.name,
    mainstock.description
From
    mainstock
Where
    (mainstock.id = @p1) Or
    (mainstock.name Like Concat('%', @p2, '%')) Or
    (mainstock.description Like Concat('%', @p2, '%'))

I know I could pass multiple parameters (reusing the same one multiple times) like this

Dim cmd As DBCommand = CreateCommand("Select_Stock", Array(ID, SearchString, SearchString))

but that gets to be a nightmare very quickly with a more complex query.

I also know I could just write a stored procedure and use that instead buy hey, this is a wish list eh?

 

[Alexander Stolte]

+1

but that gets to be a nightmare very quickly with a more complex query.

I know the struggle with it...
I then used StoredProcedures.

 

[John Naylor]

+1

I know the struggle with it...
I then used StoredProcedures.

I'm happy I'm not on my own ;-)

 

[Erel]

The JDBC API doesn't support it. We can parse the query ourselves but it is not a simple change.