Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

derby dialect

 
mike cool
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

The Apache project has online documentation of the SQL that Derby supports, here:
http://db.apache.org/derby/docs/dev/ref/
Additionally, Derby is derived from IBM's Cloudscape, which IBM donated to Apache. So far as I know, not too much has changed, so IBM's documentation is still pretty useful:
http://publib.boulder.ibm.com/infocenter/cldscp10/index.jsp?topic=/com.ibm.cloudscape.doc/sqlj.htm
You will quickly note that Apache's documentation organization still parallels IBM's...

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
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thx stu derby

but what will you do if your database on a server and many users will access it ?
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic