Re: Portable stored procedures

From: Dennis (df_at_tdc-broadband.dk)
Date: 02/08/04 

Date: Sun, 8 Feb 2004 09:40:15 +0100

JDatastore also uses java as the language for its stored procedures.

http://info.borland.com/techpubs/jdatastore/

from the above link, you can download the documentation for the database.

JDBC compliance is good, and the database itself is written in java.

It also have a nice features that lets you write binary streams to it, so in
addition to the database, you get yourself a virtual file system.

The main thing it has going against itself is that it is not a generational
database like Interbase and i think oracle.

Borland is about to release a new version, it is possible to download a
trial to check it out.

By the way - using java as the language for stored procedures is of course
extremely smart. They probably perform way better than other languages, and
you only have to develop the code once.

Performance is comparable to other (even non-java) databases. Java keeps on
getting faster and faster.

Dennis

"Kenneth P. Turvey" <kt@squeakydolphin.com> wrote in message
news:slrnc2bjpl.45h.kt@premium.geo.yahoo.akadns.net...
> I was reading some Oracle documentation the other day on Java stored
> procedures and found that I could write stored procedures that would
> be database and platform independent. Is this really true? Does it
> work out in practice?
>
> I would like to use a Java based database on my Linux box to test some
> of this out at home with the hope of using it at work at a later
> date if it is a "good idea". I've just installed hypersonicDB on my
> laptop and I'm suitably impressed. Is this a reasonable platform on
> which to try this out? Are there any better 100% Java databases with
> which to work? I'm not looking for production systems, just a
> test bed.
>
> TIA,
>
> --
> Kenneth P. Turvey <kt@squeakydolphin.com>
>
> Artificial Intelligence Algorithms Wiki
> http://ai.squeakydolphin.com

Relevant Pages

  • Re: Portable stored procedures
    ... > JDatastore also uses java as the language for its stored procedures. ... and the database itself is written in java. ...
    (comp.lang.java.databases)
  • RE: Standards for developing secure software
    ... The database was Oracle, and we used some C programs to ... the Java components ... programming language. ... We have now corrected the problems, but speed/performance in this case had ...
    (SecProg)
  • Re: Ruby vs Java vs c++
    ... data modeling--including graphics and data handling via database queries, ... Then they use an OO language for their high-level command-and-control ... That's because Java was invented to take market share from C++, ... Ruby, by contrast, is the ultimate in programmer-friendliness. ...
    (comp.lang.ruby)
  • Re: Ruby vs Java vs c++
    ... data modeling--including graphics and data handling via database queries, ... Then they use an OO language for their high-level command-and-control ... That's because Java was invented to take market share from C++, ... Ruby, by contrast, is the ultimate in programmer-friendliness. ...
    (comp.lang.ruby)
  • Re: Why use Java Stored Procedures....
    ... Would you rather have a Java programmer migrating Java stored procedures ... a different database or have a PL/SQL programmer migrating PL/SQL stored ...
    (comp.databases.oracle.server)