openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From duro <juraj.pe...@gmail.com>
Subject Re: java.lang.IllegalArgumentException: no-named-params
Date Fri, 21 May 2010 08:04:36 GMT

thanks for reply, but your suggested code:


Rick Curtis wrote:
> 
> Query query = em.createNativeQuery("SELECT id FROM :?1 WHERE (next_run -
> now() < interval '2 minutes')", Long.class);
> query.setParameter(1, HARVEST_SCHEDULES_TABLE);
> 

produces systax error: (i don't know why the exception sais :? and not :?1 ,
weird)



>  ERROR: syntax error at or near ":"
>   Position: 16 {prepstmnt 9497985 SELECT id FROM :? WHERE (next_run -
> now() < interval '2 minutes') 
> 

i tried to change it to this:


> Query query = em
> 				.createNativeQuery(
> 						"SELECT id FROM ?1 WHERE (next_run - now() < interval '2 minutes')",
> 						Long.class);
> 

but its also not working:



> ERROR: syntax error at or near "$1"
>   Position: 16 {prepstmnt 8172621 SELECT id FROM ? WHERE (next_run - now()
> < interval '2 minutes')
> 

thanks for some suggestion, Juraj

-- 
View this message in context: http://openjpa.208410.n2.nabble.com/java-lang-IllegalArgumentException-no-named-params-tp5080072p5083226.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message