Two Laptop Bag*
The moose likes JDBC and the fly likes derby dialect Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "derby dialect" Watch "derby dialect" New topic
Author

derby dialect

mike cool
Greenhorn

Joined: Oct 21, 2005
Posts: 24
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

Joined: Dec 15, 2005
Posts: 333
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

Joined: Oct 21, 2005
Posts: 24
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
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.
 
 
subject: derby dialect
 
Similar Threads
SQLGrammarException using Hibernate + Embedded Derby
request for jdbc books
import data from large csv file. Help.
How to use Derby DB in J2EESDK ?
Not-unique unique column