Arthur I think you have to use underscores in the name
have a look in Cache SQL manager it will show you the table name required Peter On Wed, 12 May 2004 17:38:39 +0200, "Arthur Rubinstein" <[EMAIL PROTECTED]> wrote: >Hi, > >I've created a class TestLegalPerson in a package com.david.app.gen.model; >I'm trying to create a query with Dynamic SQL: > >CacheQuery query = new CacheQuery(dbconnection, "SELECT %ID FROM >com.david.app.gen.model.TestLegalPerson"); > >but I get an exception: >[Message: <[SQLCODE: <-30>:<Table or View not found>] >[Cache Error: <<SYNTAX>errdone+1^%qaqqt>] >[Details: <FLoop - func = PP>] >[%msg: < SQL ERROR #30: Table `MODEL.TESTLEGALPERSON' not found>]> Error >code: <30> SQL state: <S0002>] > >If I create this class in a package model, it works. Is it really impossible >to use Cache classes in multi-level-packages with Java? > >Thanks > >Arthur >
