java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)

Spring JIRA | Colin McQueen | 3 years ago
  1. 0

    I found an issue with the exists method call, in the code in the CQLTemplate for the count method the parameter says tableName but the value is a CQL statement. Here's the stacktrace that I got: {code} java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44) at org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120) at org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120) at org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy660.exists(Unknown Source) {code}

    Spring JIRA | 3 years ago | Colin McQueen
    java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)
  2. 0

    I found an issue with the exists method call, in the code in the CQLTemplate for the count method the parameter says tableName but the value is a CQL statement. Here's the stacktrace that I got: {code} java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44) at org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120) at org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120) at org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy660.exists(Unknown Source) {code}

    Spring JIRA | 3 years ago | Colin McQueen
    java.lang.IllegalArgumentException: given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)
  3. 0
    Some bots are sending malformed HTTP requests to your site. Try to find their IP addresses in the access logs and ask them to fix the bots or blacklist them.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0
    I was missing a partitioning column because I did not specify the "basePath" option on read
  6. 0
    This error is caused by malformed HTTP request. You are trying to access unsecured page through https.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.IllegalArgumentException

      given string [SELECT count(*) FROM foo_foo WHERE stubValue1=49.277965 AND stubValue2=-123.110181 AND stubDate='2014-03-21' AND stubHour=19 AND stubHourOrdinal=0;] is not a valid quoted or unquoted identifier at org.springframework.cassandra.core.cql.CqlIdentifier.setIdentifier(CqlIdentifier.java:126) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:106) at org.springframework.cassandra.core.cql.CqlIdentifier.<init>(CqlIdentifier.java:89) at org.springframework.cassandra.core.cql.CqlIdentifier.cqlId(CqlIdentifier.java:44)

      at org.springframework.cassandra.core.CqlTemplate.count()
    2. Spring CQL
      CqlTemplate.count
      1. org.springframework.cassandra.core.CqlTemplate.count(CqlTemplate.java:1120)
      1 frame
    3. Spring Data Cassandra - Core
      SimpleCassandraRepository.exists
      1. org.springframework.data.cassandra.core.CassandraTemplate.exists(CassandraTemplate.java:120)
      2. org.springframework.data.cassandra.repository.support.SimpleCassandraRepository.exists(SimpleCassandraRepository.java:74)
      2 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    5. Spring Data Core
      RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke
      1. org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:358)
      2. org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:343)
      2 frames
    6. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    7. com.sun.proxy
      $Proxy660.exists
      1. com.sun.proxy.$Proxy660.exists(Unknown Source)
      1 frame