Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use JDBC Positional Binding Style & ExecuteWithParams?

490060Mar 14 2006 — edited Mar 15 2006
Can anyone provide any help here including any documentation on how to configure this (I've checked online help and the developer guide.)

When defining multiple Bind Position variables on a View Object (using sql statement binding style: JDBC Positional), should I defined multiple bind variable names? Otherwise, if I don't, when I use ExecuteWithParams operation to create the data control, only one input variable field is displayed. I can get a single bind position variable to work, but am struggling on how to configure / get multiple bind position variables to work with ExecuteWithParams.

Here's my current configuration:

1. Define View Object with two JDBC Positional Binding Parameters
-- Bind Variables: name=parm1 (???should I define a second bind variable name???)
-- Bind Positions = 0,1
-- SQL Statement add another position var in where clause: "match (zip) against (CONCAT(?,'*') IN BOOLEAN MODE) and "match (name) against (CONCAT(?,'*') IN BOOLEAN MODE)

2. On a JSF page, drag ExecuteWithParams operation from data control onto the JSF page. If I have defined only one bind variable name, only one input field is displayed (and one field label that I defined for that bind variable), but I need two input fields - one for each bind position variable. How do I set this up?

Back-end Database is MySQL 5.0.1 which is why I am using binding stye JDBC positional.
Thanks, Tom

Message was edited by:
javaX
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2006
Added on Mar 14 2006
3 comments
1,465 views