Hello,
I can't seem to get parameter binding to work! Does it need to be enabled?
I am using Glassfish, Toplink, NetBeans, and Derby -- the standard NetBeans
package.
MY JAVA:
StringBuffer sql = new StringBuffer("SELECT * FROM container WHERE contid =
?1 AND ...... ");
em.createNativeQuery(sql.toString(), Container.class).setParameter(1,
"'"+contid+"'").getResultList();
MY PERSISTANCE.XML:
<property name="toplink.bind-all-parameters" value="true"/>
<property name="toplink.jbdc.bind-parameters" value="true"/>
SQL THAT GETS EXECUTED:
SELECT * FROM container WHERE contid = ? AND siteid = 'YoniCntr' AND
subcontid > 0 ORDER BY subcontid ASC
bind => ['Tank00000001']
And I get no results!
I have written the exact same query without parameter binding, which gets
executed like
SELECT * FROM container WHERE contid = 'Tank00000000' AND siteid =
'YoniCntr' AND subcontid > 0 ORDER BY subcontid ASC
And results do return!
Please advise, many thanks!
--
View this message in context: http://www.nabble.com/SQL-Parameter-Binding---how-to-enable--tp23539223p23539223.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.