You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@karaf.apache.org by "Jirka (JIRA)" <ji...@apache.org> on 2016/09/26 08:21:20 UTC

[jira] [Created] (KARAF-4732) jdbc:query cannot parse wildcard % in SQL like expression

Jirka created KARAF-4732:
----------------------------

             Summary: jdbc:query cannot parse wildcard % in SQL like expression
                 Key: KARAF-4732
                 URL: https://issues.apache.org/jira/browse/KARAF-4732
             Project: Karaf
          Issue Type: Bug
    Affects Versions: 4.0.5
            Reporter: Jirka


from Karaf shell
jdbc:query myDB select * from parameters where name like '%somename'

causes an error
{code}
Error executing command: bad expression: select * from parameters where name like '%somename'
{code}

log
{code}
2016-09-26 10:15:39,815 | ERROR | nsole user karaf | ShellUtil                        | 44 - org.apache.karaf.shell.core - 4.0.5 | Exception caught while executing command
org.apache.felix.gogo.runtime.SyntaxError: bad expression: select * from parameters where name like '%somename'
        at org.apache.felix.gogo.runtime.Tokenizer.expandExp(Tokenizer.java:615)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Tokenizer.expand(Tokenizer.java:516)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Tokenizer.expand(Tokenizer.java:492)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Tokenizer.expand(Tokenizer.java:561)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Tokenizer.expand(Tokenizer.java:492)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Tokenizer.expand(Tokenizer.java:476)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Closure.eval(Closure.java:271)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:342)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Pipe.run(Pipe.java:108)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:182)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:119)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.felix.gogo.runtime.CommandSessionImpl.execute(CommandSessionImpl.java:94)[44:org.apache.karaf.shell.core:4.0.5]
        at org.apache.karaf.shell.impl.console.ConsoleSessionImpl.run(ConsoleSessionImpl.java:270)[44:org.apache.karaf.shell.core:4.0.5]
        at java.lang.Thread.run(Thread.java:745)[:1.8.0_92]
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)