[luciddb-users] DO_FOR_ENTIRE_SCHEMA and NullPointerException

[Vassil K. <vas...@gm...>]

Hello,

Has anyone experienced a java.lang.NullPointerException when running
DO_FOR_ENTIRE_SCHEMA?

I am running the following SQL statement against a LucidDB 0.7.4 server
running on Ubuntu 8:

CALL APPLIB.DO_FOR_ENTIRE_SCHEMA( 'select * from %TABLE_NAME%',
'DIM_TRANSFORM_SCHEMA', 'VIEWS' );

...and the result I'm getting is...

Error: java.lang.NullPointerException: null
SQLState:  null
ErrorCode: 0

The schema DIM_TRANSFORM_SCHEMA contains only views and no tables.

I noticed that it makes no difference what is the SQL statement, I still get
the same error even when calling
CALL APPLIB.DO_FOR_ENTIRE_SCHEMA( '', 'DIM_TRANSFORM_SCHEMA', 'VIEWS' );

What's even more interesting - there are only views in this schema and when
executing the following statement:

CALL APPLIB.DO_FOR_ENTIRE_SCHEMA( '', 'DIM_TRANSFORM_SCHEMA', '*TABLES*' );

...it passes with no errors.

It seems that when there are no objects to process,
DO_FOR_ENTIRE_SCHEMAworks, but of course I need it to work when there
is work to be done...

Any help is greatly appreciated,
Vassil