Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3

Name and version of the database you are using: Oracle9


i have an image-table and want to search for an Image with a certain keyword. Keywords are Strings collectet in a Set. how can i do this using .createCriteria?




just searching like:

results in

xception in thread "AWT-EventQueue-0"
org.hibernate.exception.GenericJDBCException: could not execute query
at
...
Caused by: java.sql.SQLException: Fehlender IN- oder OUT-Parameter auf Index:: 2
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)[/code]

Hi,

first ahve a look here: http://forum.hibernate.org/viewtopic.php?t=954121

One possible solution is to use sqlRestriction:

List<Image> found = s.createCriteria(Image.class, "i").add(Restrictions.sqlRestriction("id IN (SELECT image_id FROM imagekeywords WHERE element = 'Toll')"))
.list();

Otherwise create a POJO for keywords instead of java.lang.String.

-Thomas