Can you use zombodb with paged JPA?

[James Shoemaker]

   I'm trying to use zombodb with a jpa paged query.  This involves building a query that ends up being PREPARED on postgres.  This ends up giving a error:

HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

you can simulate this without JPA by doing something like:

PREPARE fred (varchar) AS SELECT * from jukebox.songs WHERE songs ==> $1;

EXECUTE fred("searchstring");

where jukebox.songs is the indexed table.

the PREPARE statement errors with the above error.

Any ideas for a solution?

James Shoemaker

[James Shoemaker]

oops. here's the full error:

ERROR:  operator does not exist: songs ==> character varying

LINE 1: ...(varchar) AS SELECT * from jukebox.songs WHERE songs ==> $1;

                                                                ^

HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

[James Shoemaker]

NVM I think I found the issue.

[James Shoemaker]

nope, it works if I put text as the type of the prepare, but I haven't figured out how to make JPA set the parameter to text