• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

derby dialect

 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic