table has no indexes, need better error message #74

deanhiller opened this Issue Feb 1, 2013 · 5 comments


None yet
2 participants

deanhiller commented Feb 1, 2013

This table has no index and never will but should give a message saying this table has no indexes....access it from a sibling table that has indexes and do a join(for when we have that feature of course).

If I run a generic "select * from

;" from any of the tables, I get results EXCEPT for the EntityGroupXref. When I do the select on that table I get:

playorm >> select * from EntityGroupXref;
09:41:00.459 [main] WARN com.alvazan.ssql.cmdline.PlayOrm - Exception occurred
java.lang.reflect.InvocationTargetException: null
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_37]
at sun.reflect.NativeMethodAccessorImpl.invoke( ~[na:1.6.0_37]
at sun.reflect.DelegatingMethodAccessorImpl.invoke( ~[na:1.6.0_37]
at java.lang.reflect.Method.invoke( ~[na:1.6.0_37]
at ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.orm.api.z8spi.meta.DboTableMeta_$$javassist_8.getAnyIndex(DboTableMeta$$ ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.orm.layer5.query.SpiIndexQueryImpl.getResultListImpl( ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.orm.layer5.query.SpiIndexQueryImpl.getResultList( ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.orm.layer3.typed.NoSqlTypedSessionImpl.createQueryCursor( ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.CmdSelect.processSelect( ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.PlayOrm.processCommand( [playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.PlayOrm.process( [playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.PlayOrm.processAnotherLine( [playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.PlayOrm.start( [playorm.jar:1.4.3 January 30 2013]
at com.alvazan.ssql.cmdline.PlayOrm.main( [playorm.jar:1.4.3 January 30 2013]
Caused by: java.lang.IllegalArgumentException: The table=EntityGroupXref has no columnes with indexes. ie. no entity attributes had the @nosqlindexed annotation
at com.alvazan.orm.api.z8spi.meta.DboTableMeta.getAnyIndex( ~[playorm.jar:1.4.3 January 30 2013]
at com.alvazan.orm.api.z8spi.meta.DboTableMeta
$$_javassist_8.d9getAnyIndex(DboTableMeta$$ ~[playorm.jar:1.4.3 January 30 2013]
... 15 common frames omitted
Sorry, we ran into a bug, recovering now so you can continue using command line


easility commented Mar 4, 2013

This is related to Issue #38. Will look into it once that is done.


easility commented Jul 17, 2013

Now as issue #113 is resolved we still need this? I mean it was all about getting results for "select * from Entity"??


deanhiller commented Jul 18, 2013

well, this only works for non-virtual tables, so we still have to make message better for virtual tables. select * from Car whould only return the rows that are Car if Car is a virtual table inside the data CF along with other virtual entities in that same CF. Does the command line work with non-virtual entities now? It should even if it has no indexes, it should display them all. Do you know if that works or can you test it out?


easility commented Sep 3, 2013

Surprisingly, the command line is working for in-memory for non-virtual table but not for cassandra. I will look more into it.

easility added a commit that referenced this issue Sep 4, 2013


easility commented Sep 4, 2013

ok, so now command line works for non-virtual column family for inmemory, cassandra and mongodb too..

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment