JBOSS: 3.2.4
PostgresDB: 7.4.2
EJB XDocLet declaration:
* @ejb.finder signature="java.util.Collection findByInfo(java.lang.String info)"
* query=""
* @jboss.declared-sql signature="java.util.Collection findByInfo(java.lang.String
info)"
* where="idA LIKE '%{0}%'"
* strategy="on-find"
jbosscmp-jdbc.xml
...
<query-method>
<method-name>findByInfo</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
Calling code:
BBeanUtil.getLocalHome().findByInfo("123");
Problem:
DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCDeclaredSQLQuery.BBean#findByInfo] Executing
SQL: SELECT id, idA, info FROM b WHERE info LIKE '%?%'
2004-08-03 10:36:11,197 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDeclaredSQLQuery.BBean#findByInfo] Find failed
org.postgresql.util.PSQLException: Parameter index out of range.
at
org.postgresql.jdbc1.AbstractJdbc1Statement.bind(AbstractJdbc1Statement.java:2082)
Why I can't do a LIKE call (Postgres/JDBC-PG
admit this...)?
TIA
Roberto Colmegna
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843960#3843960
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843960
-------------------------------------------------------
This SF.Net email is sponsored by OSTG. Have you noticed the changes on
Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now,
one more big change to announce. We are now OSTG- Open Source Technology
Group. Come see the changes on the new OSTG site. www.ostg.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
