db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Procedure issue
Date Mon, 21 Jun 2010 22:18:53 GMT
"Clark, Harry" <Harry.Clark@knovalent.com> writes:

> create procedure createTempSchema (in schemaName char(254))
>   language java parameter style java modifies sql data
>   external name 'com.kve.vanguard.model.orm.dao.TempSchemaGenerator.createTempSchema';
> call app.createTempSchema('temp00');
> call app.createTempSchema('temp01');


Did you look in derby.log for any error messages relating to the

Some suggestions:

I see you created the procedure without explicit schema, but call it
with explicit schema 'app'. Does it make a difference to use an
explicit app.createTempSchema when you create it? (should not be
necessary if app is the default schema already)

Have you verified that the classpath contains TempSchemaGenerator?


View raw message