1-how can i create new user in my database using sql query 2-what sql dialect derby uses, and where can i find some references (like ms sql book online)
thx
stu derby
Ranch Hand
Joined: Dec 15, 2005
Posts: 333
posted
0
Originally posted by mike cool: hi i use derby with java but i have some Q:
1-how can i create new user in my database using sql query 2-what sql dialect derby uses, and where can i find some references (like ms sql book online)
thx
Let's start with your 2nd question first: Derby (like many other databases) more-or-less implements SQL-92, SQL-99 and SQL-2003, focusing on core/mandatory features. However, there's enough missing that no-one could really call it compliant with any of those standards. See: http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
For your first question, I don't really know; I've only used Derby/Cloudscape as an embedded DB, single user. It sort of looks as if each "user" is the database owner, so you specify a new user by creating a new "database".
mike cool
Greenhorn
Joined: Oct 21, 2005
Posts: 24
posted
0
thx stu derby
but what will you do if your database on a server and many users will access it ?
stu derby
Ranch Hand
Joined: Dec 15, 2005
Posts: 333
posted
0
Originally posted by mike cool: thx stu derby
but what will you do if your database on a server and many users will access it ?
For that, I usually use Postgres or MySql or Oracle; I suppose there's away to do it with Derby, but I just don't know what it is.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
