db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Schema does not exits exception
Date Thu, 30 Sep 2004 13:05:33 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Zahra Zahid wrote:

> I dont think the problem is with the application accessing the
> tables..becuase it works fine with postgres.
> When i used to make a database in postgres...i wud also use the CREATE
> USER omar with password 'omar';
> command to make a user omar.
> How do i do this in Derby...because i think this can help me get the
> schema not found exception out...i have tried to make a schema within
> the database myself but still i get the same exception.
> How do u make a new user in derby system?


Derby doesn't have a CREATE USER command and its built-in user support
is only for authentication, it does not affect schema creation. If you
are using CREATE SCHEMA OMAR in the database just created and you are
still seeing the no such schema exception then it would be a bug.

The best approach is to set this property so that all errors are
reported to the derby.log file.
derby.stream.error.logSeverityLevel=0

The log file should include a stack trace of what is failing.

Adding this property might also help in seeing what SQL statement is
causing the problem.
derby.language.logStatementText=true

These would be set by either adding these two lines to the
derby.properties file (create one if needed)

derby.stream.error.logSeverityLevel=0
derby.language.logStatementText=true

or starting the JVM with these two additional arguments
- -Dderby.language.logStatementText=true
- -Dderby.stream.error.logSeverityLevel=0

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBXASdIv0S4qsbfuQRArQgAKDT/PxeVzLKzSFQwQsqAwIAMl28ngCfcwME
LsdWXEUDPirztZEZrpYLms0=
=sr8V
-----END PGP SIGNATURE-----


Mime
View raw message