Hi,
It is pity that you got an error for too long, I have been used the
OrientDB for a year and a half, I only have that problem with some special
queries only.
Could you try with
*select * from Place where name.toLowerCase() like :name *
and
*params.put("name", name + "%"); *
I think that should be working. Hope it help!
Cheers,
Hung Tran
On Saturday, September 27, 2014 12:18:02 AM UTC+7, Emmanuel Fauré wrote:
>
> Hi everyone,
>
> Going back on my project with OrientDB... and i'm asking myself again the
> same question with prepared statements on Object database.
>
> Does anyone have any clue ? any other exemple of a prepared statement with
> Object database ? or a zoom in my code for errors i cannot see :)
>
> I'd like to fix this before trying others tests with distributed instances
>
> Thanks,
>
>
>
> Le lundi 5 mai 2014 17:34:05 UTC+2, Emmanuel Fauré a écrit :
>>
>> Hi,
>>
>> Hmm one month and no answers.. it seems that I am the only one with this
>> problem :)
>>
>> Does anybody uses prepared statements with Object database ?
>>
>> Le mardi 1 avril 2014 17:08:49 UTC+2, Emmanuel Fauré a écrit :
>>>
>>> Hi everyone,
>>>
>>> I try to use prepared queries with object database, but it doesn't work
>>> : is this supported, or is this only for document databases ?
>>>
>>> My code (without prepared query) that returns a result.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> * public List<Place> searchByName(String name) {
>>> OObjectDatabaseTx db = Db.instance().get(); String query="select *
>>> from Place where name.toLowerCase() like '%"+name+"%'"; logger.info
>>> <http://logger.info>("PlaceService.searchByName query="+query);
>>> List<Place> result = db.query(new OSQLSynchQuery<Place>(query));
>>> db.close(); return result; }*
>>>
>>> My code (with prepared query) that returns no result.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *public List<Place> searchByNamePrepared(String name) {
>>> OObjectDatabaseTx db = Db.instance().get(); String s="select * from
>>> Place where name.toLowerCase() like '%:name%'";
>>> OSQLSynchQuery<Place> query= new OSQLSynchQuery<Place>(s);
>>> Map<String,Object> params = new HashMap<String,Object>();
>>> params.put("name", name); List<Place> result =
>>> db.command(query).execute(params); db.close(); return
>>> result; }*
>>>
>>> My Pojo Place is basic, no annotations, juste private membres and
>>> getters/setters.
>>> My Db class is just an abstraction of
>>> OObjectDatabasePool.global().acquire(DB_URL, DB_LOGIN, DB_PASSWORD);
>>>
>>> Thanks :)
>>>
>>> @OrientDB team : good job with this product !
>>>
>>>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
