You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Philip Wilder <05...@acadiau.ca> on 2005/07/19 19:57:17 UTC
Derby Standards
Does anyone know if there is a comprehensive list of standards
implemented by Derby availible online?
thanks,
Philip
Re: Derby Standards
Posted by Mamta Satoor <ms...@gmail.com>.
Hi Lance,
If you follows the thread SQL-99 Core vs. Derby features (dated April 11th
'05), you might find some of the information you are looking for. Bernt
Johnsen had prepared a table comparing the SQL-99 standards against Derby.
Mamta
On 8/11/05, Lance J. Andersen <La...@sun.com> wrote:
>
>
>
> Kathey Marsden wrote:
>
> Philip Wilder wrote:
>
>
>
>
>
> I'll take what I can get. :-)
>
>
> Hmmm.. found this sitting in my drafts folder. Don't know if it is of
> any help at this late date.
>
> I don't think we have a list on the website. It would be nice. In
> addition to those you have mentioned,
> a few specs of interest off the top of my head...
>
> - The Java Transaction API (JTA) Specification from Sun
> - XA+ Specification which lives on the same page as the protocol
> specifications at: http://www.opengroup.org/dbiop/
> - JSR169 from Sun (10.1 only)
> -The Java Virtual Machine Specification from Sun (relevant to byte
> code generation)
>
> FYI: For the SQL Specs, I think you need $$ to get the official copies.
>
>
> yes that is true you have to pay for the SQL standard specs
>
> Kathey
>
>
>
>
>
Re: Derby Standards
Posted by "Lance J. Andersen" <La...@Sun.COM>.
Kathey Marsden wrote:
>Philip Wilder wrote:
>
>
>
>>>
>>>
>>>
>>>
>>I'll take what I can get. :-)
>>
>>
>
>Hmmm.. found this sitting in my drafts folder. Don't know if it is of
>any help at this late date.
>
>I don't think we have a list on the website. It would be nice. In
>addition to those you have mentioned,
>a few specs of interest off the top of my head...
>
> - The Java Transaction API (JTA) Specification from Sun
> - XA+ Specification which lives on the same page as the protocol
>specifications at: http://www.opengroup.org/dbiop/
> - JSR169 from Sun (10.1 only)
> -The Java Virtual Machine Specification from Sun (relevant to byte
>code generation)
>
>FYI: For the SQL Specs, I think you need $$ to get the official copies.
>
>
yes that is true you have to pay for the SQL standard specs
>Kathey
>
>
>
>
Derby XA Standards
Posted by Philip Wilder <05...@acadiau.ca>.
Sorry to bother everyone again with another standard question but I'm
just trying to wrap my head around the Derby's interaction with the XA+
specification. From my research it appears that communication between
Resource Managers (such as Derby) and Transaction Managers is done
through the XA Specification. Interaction between the Application
Program and the Transaction Managers is handled through the Transaction
Demarcation (TX) specification and finally Interaction between the
Transaction Manager and the Communications Resource Manager is done
through the XA+ specification.
My suspicion is that Derby is only concerned with the Interaction
between the Resource Manager and the Transaction Manager and the only
reason Derby uses the XA+ specification is because it is a superset of
the XA specification. Thus the portion of the XA+ specification dealing
with communication between the Transaction Manager and the
Communications Resource Manager is ignored. Can anyone confirm this for me?
Philip
Re: Derby Standards
Posted by Mamta Satoor <ms...@gmail.com>.
Hi Philip,
Derby does not implement JDBC Rowset, so we probably don't need JSR 114
spec.
Mamta
On 8/11/05, Philip Wilder <05...@acadiau.ca> wrote:
>
> Kathey Marsden wrote:
>
> >Philip Wilder wrote:
> >
> >
> >
> >>>
> >>>
> >>>
> >>>
> >>I'll take what I can get. :-)
> >>
> >>
> >
> >Hmmm.. found this sitting in my drafts folder. Don't know if it is of
> >any help at this late date.
> >
> >I don't think we have a list on the website. It would be nice. In
> >addition to those you have mentioned,
> >a few specs of interest off the top of my head...
> >
> > - The Java Transaction API (JTA) Specification from Sun
> > - XA+ Specification which lives on the same page as the protocol
> >specifications at: http://www.opengroup.org/dbiop/
> > - JSR169 from Sun (10.1 only)
> > -The Java Virtual Machine Specification from Sun (relevant to byte
> >code generation)
> >
> >FYI: For the SQL Specs, I think you need $$ to get the official copies.
> >
> >Kathey
> >
> >
> >
> >
> >
> Thanks for the response. The nature of my research is such that I don't
> think I'll need an official copy of the SQL specification, an
> abstraction should suffice.
> Does Derby make use of the JDBC Rowset Implementations (JSR 114) Spec?
>
> My current list of standards looks something like this:
>
> JDBC 2.0
> JDBC 3.0 (JSR-53)
> JDBC Optional Package for CDC/Foundation Profile (JSR -169)
> JavaTM Transaction API (JTA) (JSR-907)
> SQL92
> SQL99
> DRDA Version 3.0
> The XA+ Specification Version 2 (SuperSet of The XA Specification?)
> The Java Virtual Machine Specification
>
> Future:
> JDBC 4.0 API Specification (JSR-221)
>
> Philip
>
Re: Derby Standards
Posted by Philip Wilder <05...@acadiau.ca>.
Kathey Marsden wrote:
>Philip Wilder wrote:
>
>
>
>>>
>>>
>>>
>>>
>>I'll take what I can get. :-)
>>
>>
>
>Hmmm.. found this sitting in my drafts folder. Don't know if it is of
>any help at this late date.
>
>I don't think we have a list on the website. It would be nice. In
>addition to those you have mentioned,
>a few specs of interest off the top of my head...
>
> - The Java Transaction API (JTA) Specification from Sun
> - XA+ Specification which lives on the same page as the protocol
>specifications at: http://www.opengroup.org/dbiop/
> - JSR169 from Sun (10.1 only)
> -The Java Virtual Machine Specification from Sun (relevant to byte
>code generation)
>
>FYI: For the SQL Specs, I think you need $$ to get the official copies.
>
>Kathey
>
>
>
>
>
Thanks for the response. The nature of my research is such that I don't
think I'll need an official copy of the SQL specification, an
abstraction should suffice.
Does Derby make use of the JDBC Rowset Implementations (JSR 114) Spec?
My current list of standards looks something like this:
JDBC 2.0
JDBC 3.0 (JSR-53)
JDBC Optional Package for CDC/Foundation Profile (JSR -169)
JavaTM Transaction API (JTA) (JSR-907)
SQL92
SQL99
DRDA Version 3.0
The XA+ Specification Version 2 (SuperSet of The XA Specification?)
The Java Virtual Machine Specification
Future:
JDBC 4.0 API Specification (JSR-221)
Philip
Re: Derby Standards
Posted by Kathey Marsden <km...@sbcglobal.net>.
Philip Wilder wrote:
>>
>>
> I'll take what I can get. :-)
Hmmm.. found this sitting in my drafts folder. Don't know if it is of
any help at this late date.
I don't think we have a list on the website. It would be nice. In
addition to those you have mentioned,
a few specs of interest off the top of my head...
- The Java Transaction API (JTA) Specification from Sun
- XA+ Specification which lives on the same page as the protocol
specifications at: http://www.opengroup.org/dbiop/
- JSR169 from Sun (10.1 only)
-The Java Virtual Machine Specification from Sun (relevant to byte
code generation)
FYI: For the SQL Specs, I think you need $$ to get the official copies.
Kathey
Re: Derby Standards
Posted by Philip Wilder <05...@acadiau.ca>.
Kathey Marsden wrote:
>Philip Wilder wrote:
>
>
>
>>I was able to find information on Derby exceptions to the SQL standard
>>availible but as you suggest I'm looking for a more comprehensive list.
>>
>>
>
>
> Are you looking for details of each specification and what is
>implemented and what is not or a just list of relevant specifications ?
>
>
>Kathey
>
>
>
>
>
I'll take what I can get. :-) This said I don't want anyone to trouble
themselves too much looking for this information on my account.
Philip
Re: Derby Standards
Posted by Kathey Marsden <km...@sbcglobal.net>.
Philip Wilder wrote:
>
> I was able to find information on Derby exceptions to the SQL standard
> availible but as you suggest I'm looking for a more comprehensive list.
Are you looking for details of each specification and what is
implemented and what is not or a just list of relevant specifications ?
Kathey
Re: Derby Standards
Posted by Philip Wilder <05...@acadiau.ca>.
Satheesh Bandaram wrote:
>Bernt Johnsen compiled a detailed list of SQL standard items implemented
>by Derby. Search the archives to find the doc.
>
>If you are looking for other standards like JDBC and/or others, not sure
>if there is a list for others.
>
>Satheesh
>
>Philip Wilder wrote:
>
>
>
>>Does anyone know if there is a comprehensive list of standards
>>implemented by Derby availible online?
>>
>>thanks,
>>
>>Philip
>>
>>
>>
>>
>>
>
>
>
>
Thanks Satheesh,
I was able to find information on Derby exceptions to the SQL standard
availible but as you suggest I'm looking for a more comprehensive list.
I know Derby also implements JDBC and at least some of the DRDA
specifications but I don't know what I am missing.
Philip
Re: Derby Standards
Posted by Satheesh Bandaram <sa...@Sourcery.Org>.
Bernt Johnsen compiled a detailed list of SQL standard items implemented
by Derby. Search the archives to find the doc.
If you are looking for other standards like JDBC and/or others, not sure
if there is a list for others.
Satheesh
Philip Wilder wrote:
> Does anyone know if there is a comprehensive list of standards
> implemented by Derby availible online?
>
> thanks,
>
> Philip
>
>
>