You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Jan Hlavatý <hl...@code.cz> on 2004/08/26 22:06:17 UTC

What about documentation?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Cloudscape had a very nice documentation, do we get hold of that too, or
are we back to usual open-source zero-documentation state?

Jan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBQS5CuXFDePgyse5HAQJEYQf9HfCmXvJzLxxHGo3yBq2dicFOpbTavy0m
atVWy1mpz1Pi/z0ZZiqVrK0da2Fo02qVQ0oc0S3rayrSCRUKeOpApJdzE3js90KA
wTLqH89XY3/p59AqJwIfUxZ99DTPyZ1BASOhrAYWHrYZb/xCj5Zlw8kA3eRwnJ2g
sc9ztY4AlAGasdEQABm5ONaX074VvGQs7LVsWaDyqswgiTOPlEY79LN+Xsqa9/4l
6hmCmCdZTEf/1vDjAfFG9pSObxdS9qqr/cb9M566RektNY4QtLRq5puk/58LM4Oi
EDENvbQmwqbXS4f589GuHCYXmL6pkDQLffSUXdeJ+6v5WXU0aSi4BA==
=45x9
-----END PGP SIGNATURE-----

Re: What about documentation?

Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jan Hlavatý wrote:

| Daniel John Debrunner wrote:
|
| | http://incubator.apache.org/derby/manuals/index.html
| |
| | It's a tab off the http://incubator.apache.org/derby page.
|
|
| Yes, but there is no navigation to there from
| http://incubator.apache.org/ (or at least i couldnt see any) so I didn't
| find it ;) Ok ok i suppose it's still work in progress...
|
| Jan


I think there are technical issues with getting the incubator status
page for Derby up to date. I think Ken Coar is driving this.

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBLkueIv0S4qsbfuQRArSfAJ9cc9o6DUPlbMHdoWjPZ2Cye0fPGACbB75j
2G5JO3nmaneiXwKGAVKOZgk=
=TpWI
-----END PGP SIGNATURE-----


Re: What about documentation?

Posted by Jan Hlavatý <hl...@code.cz>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Daniel John Debrunner wrote:

| http://incubator.apache.org/derby/manuals/index.html
|
| It's a tab off the http://incubator.apache.org/derby page.


Yes, but there is no navigation to there from
http://incubator.apache.org/ (or at least i couldnt see any) so I didn't
find it ;) Ok ok i suppose it's still work in progress...

Jan

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBQS5KmXFDePgyse5HAQKv+QgAiu9prIPOTfB36ySgiYGE0BFBItuqkOk4
4BuInhO7QBPWZQ+at1rUeIWemCCt6JZUVhD+meiohF+upblFUhszNjyiio1P8/3Y
ZTYvx/kZ6dQ8U13NdFBGulEsTx9Y7WJudzOFfibC9WfgdkxABtlQfBKkyDUiFX3k
uh3qvp6IEKdJvm94FtG8OQMAUljIgZOVkyyGWJiKBIOiWpXl2n8EwfBG7ZZZsh6u
kJC/SGw2kwzTJOtGghLsz2DZfcgPWmqCe8GD2pkM14EplZ9YFO4cClH0oKsZTC9H
PlKlobFM3yH8Kmr7J2hBCVncTkI8ih7Wzu8LkUHpYGsU6Z0R4ga5/A==
=El6e
-----END PGP SIGNATURE-----

Re: What about documentation?

Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jan Hlavatý wrote:

| Cloudscape had a very nice documentation, do we get hold of that too, or
| are we back to usual open-source zero-documentation state?
|
| Jan
|

Derby documentation is at

http://incubator.apache.org/derby/manuals/index.html

It's a tab off the http://incubator.apache.org/derby page.


Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBLkfHIv0S4qsbfuQRAozfAKCyfNdVT2RptuH4Ib76tXqsTlvQNACePu9B
0s7P9ws5JL3yLiMfxpu7rtA=
=K0qp
-----END PGP SIGNATURE-----


Re: Documentation errors

Posted by Jean Anderson <jt...@bristowhill.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

thanks for the reports!

~ -jean

Christian d'Heureuse wrote:

| Documentation errors:
|
| ---
|
| 1. NULLIF Function
|
| http://incubator.apache.org/derby/manuals/reference/sqlj66.html
| ("NULLIF and CASE expressions")
|
| The Description of the NULLIF function is incomplete.
|
| The definition in ISO 9075-2 could be used: NULLIF(V1,V2) is
| equivalent to the following: CASE WHEN V1=V2 THEN NULL ELSE V1 END
|
| ---
|
| 2. Commits in Stored Procedures
|
| There are contradicting rules on whether Commits are allowed in
| stored procedures that use nested connections:
|
| http://incubator.apache.org/derby/manuals/develop/develop50.html
| ("Database-Side JDBC Procedures and Nested Connections"): "Commits
| are permitted when the procedure is called within a CALL or VALUES
| statement."
|
| http://incubator.apache.org/derby/manuals/develop/develop63.html
| ("Transactions"): "Procedures that use nested connections are not
| permitted " ... " to commit or roll back."
|
| "Table 2. Summary of Application Behavior with Auto-Commit On or
| Off": ... "no explicit commits or rollbacks are allowed"
|
| ---
|
| 3. Documentation Request: SQLStates and ErrorCodes
|
| There should be a list and description of the SQLState and
| ErrorCodes that are generated by Derby.
|
| ---
|
| Christian
|

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBLz2uF0L6u5lYbCYRAkx/AJ9nLJKPza4vqPbbp+JDwsdDpEdv+wCfebao
5l6/fcVXsJwz5rnQlfOs6CA=
=0seu
-----END PGP SIGNATURE-----


Documentation errors

Posted by Christian d'Heureuse <ch...@inventec.ch>.
Documentation errors:

---

1. NULLIF Function

http://incubator.apache.org/derby/manuals/reference/sqlj66.html
("NULLIF and CASE expressions")

The Description of the NULLIF function is incomplete.

The definition in ISO 9075-2 could be used:
 NULLIF(V1,V2) is equivalent to the following:
  CASE WHEN V1=V2 THEN NULL ELSE V1 END

---

2. Commits in Stored Procedures

There are contradicting rules on whether Commits are allowed in stored
procedures that use nested connections:

http://incubator.apache.org/derby/manuals/develop/develop50.html
("Database-Side JDBC Procedures and Nested Connections"):
"Commits are permitted when the procedure is called within a CALL or VALUES
statement."

http://incubator.apache.org/derby/manuals/develop/develop63.html
("Transactions"):
"Procedures that use nested connections are not permitted " ... " to commit
or roll back."

"Table 2. Summary of Application Behavior with Auto-Commit On or Off":
... "no explicit commits or rollbacks are allowed"

---

3. Documentation Request: SQLStates and ErrorCodes

There should be a list and description of the SQLState and ErrorCodes that
are generated by Derby.

---

Christian


Re: What about documentation?

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Derby documentation can be found here:

http://incubator.apache.org/derby/manuals/index.html

It was converted from the cloudscape docs, so please post any errors you
find.

regards,

 -jean




Re: What about documentation?

Posted by Jan Hlavatý <hl...@code.cz>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Original Cloudscape 10 documentation can be found here:

http://www-306.ibm.com/software/data/cloudscape/pubs/collateral.html

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iQEVAwUBQS5FmXFDePgyse5HAQLBbQf+OeOf2CJa+1ym/DFU298jNuk/LiU2y8jO
6dHz1keAH/VLg8DjxVmE2RvfDxJzaR8SvfZe6cUINuNWX7rDxpGKTeIdSrU5q2X/
7smopq4Cf1FUEL2pqVl3p+FhykXT3fmqJyZm6/YgTK4iNuJ23mM51AHPktOAf+rR
rE6I74OkuQ2VThX8NAoYOgJRycq1V/CAkPfK7KIXibT2bw1j17YWTinAp/P70Qhe
5LvO6NoY2Md6aDLxCOJ8ImRbmK3VL7NUhSJ9hhOSyrfbd5j/bjoPWn7MsVRNFiJ9
vTrJ+Lwne26jnMH8sM5AQIyyHrH27xfqQLUtMarIwe2avKjfjngFsg==
=lSmI
-----END PGP SIGNATURE-----