You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@karaf.apache.org by conejo <lo...@gmail.com> on 2017/07/14 08:31:45 UTC

Karaf 4.0.7 jdbc:query command doesn't work with '

Whe i try:
jdbc:query sacomarDS select msjid from mensajes where "(asto like '%TO:
prueba')"

I get:
Error executing command: Error de Sintaxis en sentencia SQL "SELECT MSJID
FROM MENSAJES WHERE (ASTO LIKE %[*]TO: PRUEBA) "; se esperaba "SELECT, FROM"
Syntax error in SQL statement "SELECT MSJID FROM MENSAJES WHERE (ASTO
LIKE%[*]TO: PRUEBA) "; expected "SELECT, FROM"; SQL statement:
select msjid from mensajes where (asto like%TO: prueba) [42001-172]

I put a breakpoint in QueryCommand.java execute() (line 50) and i see that
query lost the '





--
View this message in context: http://karaf.922171.n3.nabble.com/Karaf-4-0-7-jdbc-query-command-doesn-t-work-with-tp4051007.html
Sent from the Karaf - User mailing list archive at Nabble.com.