-----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-----
