db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Segel <mse...@segel.com>
Subject Re: how to use schema names , it allways return error for me.
Date Sun, 06 Nov 2005 02:34:10 GMT
On Saturday 05 November 2005 17:04, Legolas Woodland wrote:
> hi
> Thank you for reading my post.
> i tried to execute following statement but it return the exception that the
> table does not exists ,
> i tried several cobination of " and ' around the schema and table name with
> no luck.
>   "INSERT INTO APP.table2 ( data, data2 ) VALUES ( ?, ? )"
>   This statement return
>   Table 'APP.TABLE2' does not exist.
>  can some one help me ?
>  is there any way to pass schema name in connection url ? or set the schema
> to a default one?

Well, you have SET SCHEMA (see page 38 of Ref Manual)

Of course you may want to query your sysscheamas table to see the schema names 
and also check to see that the table does exist in the schema that you think 
it exists in...

HTH.

-- 
Michael Segel
Principal 
MSCC

Mime
View raw message