On 7/17/12 9:15 AM, [email protected] wrote:
Hi Rick,
Thanks a lot for you fast answer.
Right now I am just trying to practice some web-application programming, so it
does not matter much to me using BUILTIN, even though it has no productive
quality. But thanks for the hint with NATIVE.
Using the configuration right now lets use Tomcat the right db-directory, so I
am afraid, that it not quite clear a tomcat issue.
Did I understand the documentation of derby correctly that java-system-property
'derby.system.home' points to the directory derby.properties would be used from?
Hi Malte,
Yes, that is correct.
If I got that right than something must have happened to that property, even
though derby uses the correct directory for ist db-instances. Is there a way to
show up the properties the derby-engine is using or getting?
There is no easy way to get this information right now. I think that it
is reasonable that the DBO would want to view this information and I
have logged https://issues.apache.org/jira/browse/DERBY-5861 to track
this enhancement. In the meantime, I have attached a table function to
that issue along with instructions on how to use it. You should be able
to use that table function to print out the derby properties that are
visible from a database. The table function will not print out the
BUILTIN credentials but it will print out the values of properties like
derby.authentication.provider.
Hope this helps,
-Rick
-----Ursprüngliche Nachricht-----
Von: Rick Hillegas [mailto:[email protected]]
Gesendet: Dienstag, 17. Juli 2012 17:11
An: [email protected]
Betreff: Re: schema-questions
Hi Malta,
One general issue: I see that you are trying to use BUILTIN authentication.
Note that BUILTIN authentication is not production-quality. It is appropriate
only for testing/development purposes. In 10.9.1 we introduced NATIVE
authentication, a production-quality replacement for BUILTIN. You are
encouraged to upgrade to 10.9.1 and to use NATIVE authentication instead.
Hopefully, you will find that NATIVE authentication is easier to administer
than BUILTIN was.
Some more comments inline...
On 7/17/12 7:44 AM, [email protected] wrote:
hi to all,
I am using derby (10.8) with tomcat and used following side helping
me seitting them up:
http://www.zetcode.com/db/apachederbytutorial/tomcat/
Trying to build up a simple web-application where you could register
as user etc. I have following schema *CREATE SCHEMA USER_STUFF;
CREATE TABLE USERS( name VARCHAR(100) PRIMARY KEY
, hatchi VARCHAR(40)
, email VARCHAR(100)
, imagename VARCHAR(100)
, tstmp_in TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP
, tstmp_up TIMESTAMP
);*
now I am wondering that when I connect myself as a user the name of
the schema's name is equal to the user's name.
If I don't use any user my schema's name seems to be the default
schema name "APP".
I thought using the first line of my sql script produces a schema
named USER_STUFF.
What is happening here, what am I doing wrong?
Yes, the first command creates a schema called USER_STUFF owned by the APP
user. However, that command does not change your session to use the new
USER_STUFF schema. To change your default schema, you need to use this command:
set schema USER_STUFF;
Another thing I am wondreing is, that it seems not to matter using a
user or not using following derby.properties, though:
*derby.stream.error.logSeverityLevel=0
derby.database.fullAccessUsers=tech
derby.database.defaultConnectionMode=readOnlyAccess
derby.connection.requireAuthentication=true
derby.user.tech=lala_dongs
derby.user.rou=gaga_bings*
**
*derby.authentication.provider=builtin*
derby seems not to use my derby.proerties. I have put them to the
directory, which is given in the derby.system.home Java-system-property.
It is told to put this system-property into the environment variable
JAVA_OPTS, so tomcat would use it for starting up.
I am using Windows-XP so I defined ths environment-variable in the
dialog as user defined variable.
What am I missing, since derby.properties seem not to work may be not
even been read.
I'm afraid I don't have any theories here. Maybe someone who uses Tomcat on
Windows can give some advice.
Hope this helps,
-Rick
Thanks for hints in advance
Malte
