Peter, indeed, if I use "FROM com_david_app_gen_model.TestLegalPerson" it works.
Thanks a lot! "Peter Cooper" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > 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 > > >
