Thread: Re: [HACKERS] PL/Java issues

Re: [HACKERS] PL/Java issues

From
Dave Cramer
Date:
Where is the standard, I for one would be interested in seeing it?

Dave
On Fri, 2004-01-02 at 01:09, Andrew Dunstan wrote:
> Jan Wieck wrote:
>
> > The basic question is the definition of the lifetime of an object and
> > it's identificaition when doing nested calls in this context. In the
> > OO world, ideally a real world object is translated into one instance
> > of a class. And complex structures are trees of instances, possibly of
> > different classes. As an example, a sales order consists of the order
> > header and a variable number of order lines. Therefore, per order we
> > have one OH instance and several OL's. So far so good. Naturally, one
> > Java object instance would correspond to one row in a database.
>
>
> It's not clear to me that this object <--> row mapping is workable. It
> looks like Oracle, by allowing only static methods, has basically
> abandoned any possibility of it.
>
> ISTM that if you want to live in the object world, you have to take care
> of marshalling and unmarshalling the data yourself - either by manual
> methods or using some of the increasingly sophisticated automated tools
> that are available. OTOH, if you want to live in the table world, you
> have to live without the hard ties between data in different tables that
> the object world wants. PL/Java must surely live in the table world.
>
> IOW, the Java interface would probably need to function in a fairly
> similar way to the way the current C interface does.
>
> Or have I missed something?
>
> Also, what does the Standard say about all this? Has anyone actually
> seen it?
>
> cheers
>
> andrew
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Dave Cramer
519 939 0336
ICQ # 1467551


Re: [HACKERS] PL/Java issues

From
Joe Conway
Date:
Andrew Dunstan wrote:
> AFAIK it is not available except for $$$. It looks like the relevant
> standards are parts 1 and 2 of the SQLJ standard (Part 0 covers embedded
> SQL).
>

For working drafts try:

http://www.wiscorp.com/sql/sql_2003_standard.zip
(5WD-13-JRT-2003-09.pdf)

http://www.wiscorp.com/sql/sqljrout.zip
(SQLJ Part 1--SQL Routines)

http://www.wiscorp.com/sql/sqljtype.zip
(SQLJ Part 2--SQL Types)

Joe





Re: [HACKERS] PL/Java issues

From
"Andrew Dunstan"
Date:
Dave Cramer said:
> Where is the standard, I for one would be interested in seeing it?
>

AFAIK it is not available except for $$$. It looks like the relevant
standards are parts 1 and 2 of the SQLJ standard (Part 0 covers embedded
SQL).

cheers

andrew



Re: [HACKERS] PL/Java issues

From
"Andrew Dunstan"
Date:
Joe Conway said:
> Andrew Dunstan wrote:
>> AFAIK it is not available except for $$$. It looks like the relevant
>> standards are parts 1 and 2 of the SQLJ standard (Part 0 covers
>> embedded SQL).
>>
>
> For working drafts try:
>
> http://www.wiscorp.com/sql/sql_2003_standard.zip
> (5WD-13-JRT-2003-09.pdf)
>
[snip]

Cool. Specifically, try this one and have a look at Appendices E and F.

cheers

andrew