You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dy...@apache.org on 2008/04/02 19:18:12 UTC
svn commit: r643978 -
/db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita
Author: dyre
Date: Wed Apr 2 10:18:11 2008
New Revision: 643978
URL: http://svn.apache.org/viewvc?rev=643978&view=rev
Log:
10.4 release preparations: Update src/ref/rrefexcept71493.dita with new
SQLStates.
Modified:
db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita
Modified: db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita?rev=643978&r1=643977&r2=643978&view=diff
==============================================================================
--- db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita (original)
+++ db/derby/docs/branches/10.4/src/ref/rrefexcept71493.dita Wed Apr 2 10:18:11 2008
@@ -57,6 +57,14 @@
<entry colname="col2">Privilege not revoked from user <varname><authorizationID></varname>.</entry>
</row>
<row>
+ <entry colname="col1">01007</entry>
+ <entry colname="col2">Role <varname><authorizationID></varname> not revoked from authentication id <varname><authorizationID></varname>.</entry>
+ </row>
+ <row>
+ <entry colname="col1">01008</entry>
+ <entry colname="col2">WITH ADMIN OPTION of role <varname><authorizationID></varname> not revoked from authentication id <varname><authorizationID></varname>.</entry>
+ </row>
+ <row>
<entry colname="col1">0100E</entry>
<entry colname="col2">XX Attempt to return too many result sets. </entry>
</row>
@@ -275,11 +283,55 @@
<entry colname="col2">User '<varname><authorizationID></varname>' cannot hard upgrade database '<varname><databaseName></varname>'. Only the database owner can perform this operation.</entry>
</row>
<row>
+ <entry colname="col1">08004</entry>
+ <entry colname="col2">Connection refused to database '<varname><databaseName></varname>' because it is in replication slave mode.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08004</entry>
+ <entry colname="col2">User '<varname><authorizationID></varname>' cannot issue a replication operation on database '<varname><databaseName></varname>'. Only the database owner can perform this operation.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08004</entry>
+ <entry colname="col2">Missing permission for user '<varname><authorizationID></varname>' to shutdown system [<varname><exceptionMsg></varname>].</entry>
+ </row>
+ <row>
+ <entry colname="col1">08004</entry>
+ <entry colname="col2">Cannot check system permission to create database '<varname><databaseName></varname>' [<varname><exceptionMsg></varname>].</entry>
+ </row>
+ <row>
+ <entry colname="col1">08004</entry>
+ <entry colname="col2">Missing permission for user '<varname><authorizationID></varname>' to create database '<varname><databaseName></varname>' [<varname><exceptionMsg></varname>].</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
+ <entry colname="col2">A network protocol error was encountered and the connection has been terminated: <varname><error></varname></entry>
+ </row>
+ <row>
<entry colname="col1">08006</entry>
<entry colname="col2">An error occurred during connect reset and the connection has been terminated. See chained exceptions for details.</entry>
</row>
<row>
<entry colname="col1">08006</entry>
+ <entry colname="col2"> SocketException: '<varname><error></varname>'</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
+ <entry colname="col2">A communications error has been detected: <varname><error></varname>.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
+ <entry colname="col2">An error occurred during a deferred connect reset and the connection has been terminated. See chained exceptions for details.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
+ <entry colname="col2">Insufficient data while reading from the network - expected a minimum of <varname><number></varname> bytes and received only <varname><number></varname> bytes. The connection has been terminated.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
+ <entry colname="col2">Attempt to fully materialize lob data that is too large for the JVM. The connection has been terminated.</entry>
+ </row>
+ <row>
+ <entry colname="col1">08006</entry>
<entry colname="col2">Database '<varname><databaseName></varname>' shutdown.</entry>
</row>
</tbody>
@@ -333,6 +385,29 @@
</tgroup>
</table>
<table>
+ <title>Class 0P: Invalid role specification</title>
+ <tgroup cols="2">
+ <colspec colname="col1" colwidth="1*"/>
+ <colspec colname="col2" colwidth="7.5*"/>
+ <thead>
+ <row valign="bottom">
+ <entry colname="col1">SQLSTATE</entry>
+ <entry colname="col2">Message Text</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry colname="col1">0P000</entry>
+ <entry colname="col2">Invalid role specification, role does not exist: '<varname><roleName></varname>'.</entry>
+ </row>
+ <row>
+ <entry colname="col1">0P000</entry>
+ <entry colname="col2">Invalid role specification, role not granted to current user or PUBLIC: '<varname><roleName></varname>'.</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+ <table>
<title>Class 21: Cardinality Violation</title>
<tgroup cols="2">
<colspec colname="col1" colwidth="1*"/>
@@ -565,12 +640,12 @@
</thead>
<tbody>
<row>
- <entry colname="col1">25000</entry>
- <entry colname="col2">Invalid transaction state.</entry>
+ <entry colname="col1">25001</entry>
+ <entry colname="col2">Cannot close a connection while a transaction is still active.</entry>
</row>
<row>
<entry colname="col1">25001</entry>
- <entry colname="col2">Cannot close a connection while a transaction is still active.</entry>
+ <entry colname="col2">Invalid transaction state: active SQL transaction.</entry>
</row>
<row>
<entry colname="col1">25501</entry>
@@ -863,6 +938,10 @@
<entry colname="col2">Internal Error: invalid <varname><authorizationID></varname> id in statement permission list.</entry>
</row>
<row>
+ <entry colname="col1">4251A</entry>
+ <entry colname="col2">Statement <varname><value></varname> can only be issued by database owner.</entry>
+ </row>
+ <row>
<entry colname="col1">42601</entry>
<entry colname="col2">In an ALTER TABLE statement, the column '<varname><columnName></varname>' has been specified as NOT NULL and either the DEFAULT clause was not specified or was specified as DEFAULT NULL.</entry>
</row>
@@ -920,7 +999,7 @@
</row>
<row>
<entry colname="col1">42818</entry>
- <entry colname="col2">Comparisons between '<varname><type></varname>' and '<varname><type></varname>' are not supported.</entry>
+ <entry colname="col2">Comparisons between '<varname><type></varname>' and '<varname><type></varname>' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')</entry>
</row>
<row>
<entry colname="col1">42820</entry>
@@ -959,6 +1038,14 @@
<entry colname="col2">The ORDER BY clause of a SELECT UNION statement only supports unqualified column references and column position numbers. Other expressions are not currently supported.</entry>
</row>
<row>
+ <entry colname="col1">42879</entry>
+ <entry colname="col2">The ORDER BY clause may not contain column '<varname><columnName></varname>', since the query specifies DISTINCT and that column does not appear in the query result.</entry>
+ </row>
+ <row>
+ <entry colname="col1">4287A</entry>
+ <entry colname="col2">The ORDER BY clause may not specify an expression, since the query specifies DISTINCT.</entry>
+ </row>
+ <row>
<entry colname="col1">42884</entry>
<entry colname="col2">No authorized routine named '<varname><routineName></varname>' of type '<varname><type></varname>' having compatible arguments was found.</entry>
</row>
@@ -1003,6 +1090,10 @@
<entry colname="col2">An object cannot be created with the schema name '<varname><schemaNamet></varname>'.</entry>
</row>
<row>
+ <entry colname="col1">4293A</entry>
+ <entry colname="col2">A role cannot be created with the name '<varname><authorizationID></varname>', the SYS prefix is reserved.</entry>
+ </row>
+ <row>
<entry colname="col1">42962</entry>
<entry colname="col2">Long column type column or parameter '<varname><columnName></varname>' not permitted in declared global temporary tables or procedure definitions. </entry>
</row>
@@ -1806,6 +1897,26 @@
<entry colname="col1">42ZA3</entry>
<entry colname="col2">The table will have collation type <varname><type></varname> which is different than the collation of the schema <varname><type></varname> hence this operation is not supported .</entry>
</row>
+ <row>
+ <entry colname="col1">42ZB1</entry>
+ <entry colname="col2">Parameter style DERBY_JDBC_RESULT_SET is only allowed for table functions.</entry>
+ </row>
+ <row>
+ <entry colname="col1">42ZB2</entry>
+ <entry colname="col2">Table functions can only have parameter style DERBY_JDBC_RESULT_SET.</entry>
+ </row>
+ <row>
+ <entry colname="col1">42ZB3</entry>
+ <entry colname="col2">XML is not allowed as the datatype of a column returned by a table function.</entry>
+ </row>
+ <row>
+ <entry colname="col1">42ZB4</entry>
+ <entry colname="col2">'<varname><schemaName></varname>'.<varname><functionName></varname>' does not identify a table function.</entry>
+ </row>
+ <row>
+ <entry colname="col1">42ZB5</entry>
+ <entry colname="col2">Class '<varname><className></varname>' implements VTICosting but does not provide a public, no-arg constructor.</entry>
+ </row>
</tbody>
</tgroup>
</table>
@@ -1890,26 +2001,6 @@
</row>
<row>
<entry colname="col1">58009</entry>
- <entry colname="col2">SocketException: '<varname><error></varname>'</entry>
- </row>
- <row>
- <entry colname="col1">58009</entry>
- <entry colname="col2">A communications error has been detected: <varname><error></varname>.</entry>
- </row>
- <row>
- <entry colname="col1">58009</entry>
- <entry colname="col2">An error occurred during a deferred connect reset and the connection has been terminated. See chained exceptions for details.</entry>
- </row>
- <row>
- <entry colname="col1">58009</entry>
- <entry colname="col2">Insufficient data while reading from the network - expected a minimum of <varname><number></varname> bytes and received only <varname><number></varname> bytes. The connection has been terminated.</entry>
- </row>
- <row>
- <entry colname="col1">58009</entry>
- <entry colname="col2">Attempt to fully materialize lob data that is too large for the JVM. The connection has been terminated.</entry>
- </row>
- <row>
- <entry colname="col1">58009</entry>
<entry colname="col2">Network protocol exception: SCLDTA length, <varname><length></varname>, is invalid for RDBCOLID. The connection has been terminated.</entry>
</row>
<row>
@@ -1921,10 +2012,6 @@
<entry colname="col2">Network protocol exception: PKGNAMCSN length, <varname><length></varname>, is invalid at SQLAM <varname><value></varname>. The connection has been terminated.</entry>
</row>
<row>
- <entry colname="col1">58009</entry>
- <entry colname="col2">A network protocol error was encountered and the connection has been terminated: <varname><error></varname></entry>
- </row>
- <row>
<entry colname="col1">58010</entry>
<entry colname="col2">A network protocol error was encountered. A connection could not be established because the manager <varname><value></varname> at level <varname><value></varname> is not supported by the server. </entry>
</row>
@@ -1980,6 +2067,10 @@
<entry colname="col2">Cannot remove jar file '<varname><fileName></varname>' because it is on your derby.database.classpath '<varname><fileName></varname>'.</entry>
</row>
<row>
+ <entry colname="col1">X0X0D</entry>
+ <entry colname="col2">Invalid column array length '<varname><columnArrayLength></varname>'. To return generated keys, column array must be of length 1 and contain only the identity column.</entry>
+ </row>
+ <row>
<entry colname="col1">X0X0E</entry>
<entry colname="col2">Table '<varname><tableName></varname>' does not have an auto-generated column at column position '<varname><columnPosition></varname>'.</entry>
</row>
@@ -2913,6 +3004,14 @@
<entry colname="col1">XIE0R</entry>
<entry colname="col2">Import error on line <varname><lineNumber></varname> of file <varname><fileName></varname>: <varname><details></varname> </entry>
</row>
+ <row>
+ <entry colname="col1">XIE0S</entry>
+ <entry colname="col2">The export operation was not performed, because the specified output file (<varname><fileName></varname>) already exists. Export processing will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the output file name in the export procedure arguments to specify a file which does not exist, or delete the existing file, then retry the export operation.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XIE0T</entry>
+ <entry colname="col2">The export operation was not performed, because the specified large object auxiliary file (<varname><fileName></varname>) already exists. Export processing will not overwrite an existing file, even if the process has permissions to write to that file, due to security concerns, and to avoid accidental file damage. Please either change the large object auxiliary file name in the export procedure arguments to specify a file which does not exist, or delete the existing file, then retry the export operation.</entry>
+ </row>
</tbody>
</tgroup>
</table>
@@ -3441,6 +3540,109 @@
<row>
<entry colname="col1">XN019</entry>
<entry colname="col2">Error executing a <varname><value></varname>, server returned <varname><value></varname>.</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </table>
+ <table>
+ <title>Class XRE: Replication Exceptions</title>
+ <tgroup cols="2">
+ <colspec colname="col1" colwidth="1*"/>
+ <colspec colname="col2" colwidth="7.5*"/>
+ <thead>
+ <row valign="bottom">
+ <entry colname="col1">SQLSTATE</entry>
+ <entry colname="col2">Message Text</entry>
+ </row>
+ </thead>
+ <tbody>
+ <row>
+ <entry colname="col1">XRE00</entry>
+ <entry colname="col2">This LogFactory module does not support replicatiosn.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE01</entry>
+ <entry colname="col2">The log received from the master is corrupted.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE02</entry>
+ <entry colname="col2">Master and Slave at different versions. Unable to proceed with Replication.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE03</entry>
+ <entry colname="col2">Unexpected replication error. See derby.log for details.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE04</entry>
+ <entry colname="col2">Could not establish a connection to the peer of the replicated database '<varname><dbname></varname>' on address '<varname><hostname></varname>:<varname><portname></varname>'.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE04</entry>
+ <entry colname="col2">Connection lost for replicated database '<varname><dbname></varname>'.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE05</entry>
+ <entry colname="col2">The log files on the master and slave are not in synch for replicated database '<varname><dbname></varname>'. The master log instant is <varname><masterfile></varname>:<varname><masteroffset></varname>, whereas the slave log instant is <varname><slavefile></varname>:<varname><slaveoffset></varname>. This is FATAL for replication - replication will be stopped.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE06</entry>
+ <entry colname="col2">The connection attempts to the replication slave for the database <varname><dbname></varname> exceeded the specified timeout period.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE07</entry>
+ <entry colname="col2">Could not perform operation because the database is not in replication master mode.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE08</entry>
+ <entry colname="col2">Replication slave mode started successfully for database '<varname><dbname></varname>'. Connection refused because the database is in replication slave mode. </entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE09</entry>
+ <entry colname="col2">Cannot start replication slave mode for database '<varname><dbname></varname>'. The database has already been booted. </entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE10</entry>
+ <entry colname="col2">Conflicting attributes specified. See reference manual for attributes allowed in combination with replication attribute '<varname><attribute></varname>'.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE11</entry>
+ <entry colname="col2">Could not perform operation '<varname><command></varname>' because the database '<varname><dbname></varname>' has not been booted.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE12</entry>
+ <entry colname="col2">Replication network protocol error for database '<varname><dbname></varname>'. Expected message type '<varname><expectedtype></varname>', but received type '<varname><receivedtype></varname>'.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE20</entry>
+ <entry colname="col2">Failover performed successfully for database '<varname><dbname></varname>', the database has been shutdown.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE21</entry>
+ <entry colname="col2">Error occurred while performing failover for database '<varname><dbname></varname>', Failover attempt was aborted.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE22</entry>
+ <entry colname="col2">Replication master has already been booted for database '<varname><dbname></varname>'</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE23</entry>
+ <entry colname="col2">Replication master cannot be started since unlogged operations are in progress, unfreeze to allow unlogged operations to complete and restart replication</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE40</entry>
+ <entry colname="col2">Could not perform operation because the database is not in replication slave mode.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE41</entry>
+ <entry colname="col2">Replication operation 'failover' or 'stopSlave' refused on the slave database because the connection with the master is working. Issue the 'failover' or 'stopMaster' operation on the master database instead.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE42</entry>
+ <entry colname="col2">Replicated database '<varname><dbname></varname>' shutdown.</entry>
+ </row>
+ <row>
+ <entry colname="col1">XRE43</entry>
+ <entry colname="col2">Unexpected error when trying to stop replication slave mode. To stop repliation slave mode, use operation 'stopSlave' or 'failover'.</entry>
</row>
</tbody>
</tgroup>