sybase:SQL Exception and Warning Messages大全
内容全部来自sybase官方网站:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0707/html/prjdbc0707/CHDGJJIG.htm
网页不好看,但是可以方便大家搜索
这里有个文件的下载地址:https://files.cnblogs.com/files/baby-lijun/sybase%E9%94%99%E8%AF%AF%E7%A0%81%E5%A4%A7%E5%85%A8.rar
The following table lists the SQL exception and warning messages that you may encounter when using jConnect.
SQL state |
Message/description/action |
---|---|
010AF |
Description: An internal assertion in the jConnect driver has failed. Action: Use the devclasses debug classes to determine the reason for this message and report the problem to Sybase Technical Support. |
010CP |
Action: See message text. |
010DF |
Description: jConnect cannot connect to the database specified in the connection URL. Action: Be sure the database name in the URL is correct. Also, if connecting to SQL Anywhere, use the SERVICENAME connection property to specify the database. |
010DP |
Description: A connection property is defined twice. It may be defined twice in the driver connection properties list with different capitalization, for example “password” and “PASSWORD.” Connection property names are not case-sensitive; therefore, jConnect does not distinguish between property names with the same name but different capitalization. The connection property may also be defined both in the connection properties list, and in the URL. In this case, the property value in the connection property list takes precedence. Action: Be sure your application defines the connection property only once. However, you may want your application to take advantage of the precedence of connection properties defined in the property list over those defined in the URL. In this case, you can safely ignore this warning. |
010HA |
Description: The server to which jConnect attempted an HA-enabled connection did not allow the connection. Action: Reconfigure the server to support high availability failover or do not set REQUEST_HA_SESSION to "true." |
010HD |
Description: The database to which jConnect attempted a connection does not support high availability failover. Action: Connect only to database servers that support high availability failover. |
010HN |
Action: Make sure to explicitly specify a service principal name using the connection property. |
010HT |
Description: You provided a string greater than 30 characters for the HOSTNAME connection property, or the host machine on which the jConnect application is running has a name longer than 30 bytes in length. Action: No action is necessary, since this is just a warning to indicate that jConnect is truncating the name to 30 bytes. However, if you wish to avoid this warning, you should set the HOSTNAME to a string less than or equal to 30 bytes in length. |
010KF |
Action: Check your Kerberos environment, and make sure that you authenticated properly to the KDC. See Chapter 3, “Security” for more information. |
010MX |
Description: The server may not have the necessary stored procedures for returning metadata information. Action: Be sure that stored procedures for providing metadata are installed on the server. See “Installing Stored Procedures” in Chapter 3 of the jConnect for JDBC Installation Guide. |
010P4 |
Description: The query you executed returned an output parameter but the application result-processing code did not fetch it so it was ignored. Action: If your application needs the output parameter data, you must rewrite the application so it can get it. This may require using a CallableStatement to execute the query, and adding calls to registerOutputParameter and getXXX. You can also prevent jConnect from returning this warning, and possibly get a performance improvement, by setting the DISABLE_UNPROCESSED_PARAM_WARNINGS connection property to “true.” |
010P6 |
Description: An unexpected object of type 0xD1 was encountered in the result set being processed and was ignored. Action: Check the query that generated the result set and correct as required. |
010PF |
Description: This happens when using the DynamicClassLoader with the PRELOAD_JARS connection property set to a comma-delimited list of .jar file names. When the DynamicClassLoader opens its connection to the server from which the classes are to be loaded, it attempts to “preload” all the .jar files mentioned in this connection property. If one or more of the .jar file names specified does not exist on the server, the above error message results. Action: Verify that every .jar file mentioned in the PRELOAD_JARS connection property for your application exists and is accessible on the server. |
010PO |
Description: If you wish to use precompiled dynamic statements, then you must allow for parameters to be sent to those statements (if the statements take parameters). Setting LITERAL_PARAMS to "true" forces all parameters to be sent as literal values in the SQL that you send to the server. Therefore, you cannot set both properties to "true." Action: To avoid this warning, do not set LITERAL_PARAMS to “true” when you wish to use dynamic SQL. See “Performance tuning for prepared statements in dynamic SQL” for more information. |
010RC |
Description: You requested a type and concurrency combination for the result set that is not supported. The requested values had to be converted. See “Using cursors with result sets” for more information about what result set types and concurrencies are available in jConnect Action: Request a type and concurrency combination for the result set that is supported. |
010SJ |
Description: The metadata information is not configured on the server. Action: If your application requires metadata, install the stored procedures for returning metadata that come with jConnect (see “Installing Stored Procedures” in Chapter 3 of the jConnect for JDBC Installation Guide). If you do not need metadata, set the USE_METADATA property to "false." |
010SK |
Description: Your application attempted an operation that the database you are connected to does not support. Action: You may need to upgrade your database or make sure that the latest version of metadata information is installed on it. |
010SL |
Description: The metadata information on the server is old and needs to be updated. Action: Install the stored procedures for returning metadata that come with jConnect (see “Installing Stored Procedures” in Chapter 3 of the jConnect for JDBC Installation Guide). |
010SM |
Description: Adaptive Server Enterprise versions 11.9.2 and lower had a bug that caused them to reject logins from clients that requested capabilities that the servers did not have. This warning indicates that jConnect has detected this condition and is retrying the connection using the greatest number of capabilities that the server can accept. When jConnect encounters this bug, it attempts to connect to the server twice. Action: Clients can safely ignore this warning, but if they wish to eliminate the warning and ensure that jConnect makes only one connection attempt, they can set the ELIMINATE_010SM connection property to "true." Please note that this property should not be set to "true" when connecting to Adaptive Server versions 12.0 and later. |
010SN |
Description: Permission to write to a file specified in the PROTOCOL_CAPTURE connection property is denied because of a security violation in the VM. This can occur if an applet attempts to write to the specified file. Action: If you are attempting to write to the file from an applet, make sure that the applet has access to the target file system. |
010SP |
Action: Make sure that the file name is correct and that the file is writable. |
010SQ |
Description: The CONNECTION_FAILOVER connection property is set to "true," and jConnect was unable to connect to one of the database servers in the list of servers to which to connect. Therefore, jConnect now tries to connect to the next server in the list. Action: No action is required, as long as jConnect is able to connect to another database server. However, you should determine why jConnect was unable to connect to the particular server that caused the connection warning to be issued. |
010TP |
Description: The server cannot use the character set initially requested by jConnect, and has responded with a different character set. jConnect accepts the change, and performs the necessary character-set conversions. The message is strictly informational and has no further consequences. Action: To avoid this message, set the CHARSET connection property to a character set that the server supports. |
010TQ |
Description: jConnect could not determine the server's default character set. When this occurs, the only characters that are guaranteed to translate properly are the first 127 ASCII characters. Therefore, jConnect reverts to 7-bit ASCII in this case. The message is strictly informational and has no further consequences. Action: Install the stored procedures for returning metadata that comes with jConnect (see “Installing Stored Procedures” in Chapter 3 of the jConnect for JDBC Installation Guide). |
010UF |
Description: jConnect cannot connect to the database specified in the connection URL. Two possibilities are:
Action: Make sure the database name in the URL is correct. Make sure that the stored procedures for returning metadata are installed on the server (see “Installing Stored Procedures” in Chapter 3 of the jConnect for JDBC Installation Guide and jConnect for JDBC Release Bulletin). If you are attempting to access a SQL Anywhere database, either do not specify a database name in the URL, or set USE_METADATA to “false.” |
010UP |
Description: You attempted to set a connection property in the URL that jConnect does not currently recognize. jConnect ignores the unrecognized property. Action: Check the URL definition in your application to make sure it references only valid jConnect driver connection properties. |
0100V |
Description: The server does not support the required version of the TDS protocol. jConnect requires version 5.0 or later. Action: Use a server that supports the required version of TDS. See the system requirements section in the jConnect installation guide for details. |
01S07 |
Description: A time value of precision better than 1/300th of a second was encountered. Because Adaptive server does not support such precision, jConnect rejected the value. Action: Make sure that time values are of precision up to 1/300th of a second. |
01S08 |
Description: jConnect issues rollback to clear out any current local transactions. This occurs when Global transaction has been enlisted, after issuing XAResource.start(). Action: If you have local transactions active prior to issuing the XAResource.start() method, you need to either commit or rollback the local transactions. |
01S09 |
Description: Warns that a local operation is being performed in the global transaction. An example of a local operation is calling the commit() method on the connection. Other operations that can't be used: rollback(), rollback(Savepoint), setSavepoint(), setSavepoint(String), releaseSavepoint(Savepoint), and setAutoCommit(). Action: Local transactions need to be kept separated from global transactions. Make sure to complete all local transactions and their operations prior to starting the Global transaction. |
01S10 |
Description: You have used a local transaction method that does not work with versions earlier than Sybase SQL Anywhere version 12. Action: Do not use the method. |
01S11 |
Description: The user-specified length of a stream or LOB is greater than the limit (Integer.MAX_VALUE) in a ResultSet.updateXXX method. Action: Make sure that the length is within the limit. |
01S12 |
Description: When DYNAMIC_PREPARE is set to false, ASE does not send parameter metadata. When HOMOGENEOUS_BATCH is set to true, jConnect requires this information for optimization. Thus, jConnect reverts to normal batching. Action: Use optimized batching (HOMOGENEOUS_BATCH set to true) with precompiled dynamic SQL prepared statements only (DYNAMIC_PREPARE set to true). |
01S13 |
Description: The connected ASE is of a version (version earlier than 15.7 ESD #1) that does not support logged bulk load. Hence, jConnect has reverted to normal batching. Action: Use ENABLE_BULK_LOAD=LOG_BCP setting with the correct version of ASE (15.7 ESD #1 or later.) |
01ZZZ |
Description: Password for connecting to ASE has expired. Action: Set the password again. |
JZ001 |
Action: Do not exceed the 30-byte maximum. |
JZ002 |
Action: Do not exceed the 30-byte maximum. |
JZ003 |
Action: Verify the URL format. See “URL connection property parameters”. If you are using the PROXY connection property, you may get a JZ003 exception while trying to connect if the format for the PROXY property is incorrect. The PROXY format for the Cascade proxy is: ip_address:port_number The PROXY format for the TDS tunnelling servlet is: http[s]://host:port/tunneling_servlet_alias |
JZ004 |
Action: Provide the required user property. |
JZ006 |
Description: An unexpected I/O error was detected from a lower layer. When such I/O exceptions are caught, they are rethrown as SQL exceptions using the ERR_IO_EXCEPTION JZ006 sqlstate. These errors are often the result of network communication problems. If the I/O exception causes the database connection to be closed, jConnect chains a JZ0C1 exception to the JZ006. Client applications can look for the JZ0C1 exception in the chain to see if the connection is still usable. Action: Examine the text of the original I/O exception message, and proceed from there. |
JZ008 |
Description: You have requested a column index value of less than 1 or greater than the highest available value. Action: Check call to the getXXX method and the text of the original query, or be sure to call rs.next. |
JZ009 |
Description: Some of the possibilities are:
Action: Make sure that the JDBC specification supports the attempted type conversion. Make sure that strings are correctly formatted. If a string contains non-numeric characters, do not attempt to convert it to a numeric type. |
JZ00A |
Description: When using the setBigDecimal method, the BigDecimal value is set to either a precision value of less than 1, a negative scale value, a precision less than the scale value, or precision value greater than 127. Action: Examine the query and correct to specify a legal precision/scale value. |
JZ00B |
Description: You tried to send a BigInteger as a TDS numeric, and the value was too large, or you tried to send a Java long as an int and the value was too large. Action: These values cannot be stored in Sybase. For long, consider using a Sybase numeric. There is no solution for Bignum. |
JZ00C |
Description: When using the setBigDecimal method, the BigDecimal value has a precision or scale that exceeds the specified precision or scale. Action: Make sure that the specified precision and scale can accommodate the BigDecimal value. |
JZ00E |
Action: Do not try to call execute or executeUpdate on a statement that has a cursor name set. Use a separate statement to delete or update a cursor. See “Using cursors with result sets” for more information |
JZ00F |
Action: Do not set the cursor name twice for a statement. Close the result set of the current cursor statement. |
JZ00G |
Description: You attempted to update a row in which no column values were changed. Action: To change column values in a row, call updateXX methods before calling updateRow. |
JZ00H |
Action: To change a result set from read-only to updatable, use the Statement.setResultSetConcurrencyType method or add a for update clause to your SQL select statement. |
JZ00I |
Description: The scale value must be greater than zero. Action: Be sure the scale value is not negative. |
JZ00L |
Action: See message text; proceed according to the reason(s) given for the login failure. |
JZ00M |
Action: Follow the recommended actions in the error message. |
JZ010 |
Action: Make sure that the Java object from the database implements the Serializable interface and is in your local CLASSPATH variable. |
JZ011 |
Description: A noninteger value was specified for a numeric connection property. Action: Specify an integer value for the connection property. |
JZ012 |
Action: Contact Sybase Technical Support. |
JZ013 |
Action: Correct the JNDI URL, or make a new entry in the directory service. |
JZ014 |
Action: Check your application code, where it calls Connection.setTransactionIsolation, and verify the value you are passing to the method. |
JZ015 |
Action: Check the value to which you set the GSSMANAGER_CLASS property. |
JZ017 |
Description: You have specified a nonexistent savepoint for rollback or release. Action: Examine the query and correct to specify an existing savepoint. |
JZ018 |
Description: The getSavepointId() method does not work on named savepoints (which have no ID) and the getSavepointName() method does not work on unnamed savepoints (which have no name). Action: Examine the query and correct. |
JZ019 |
Description: The URL set using jdbc:sybase:jndi:file does not specify either the sql.ini file (Windows) or the interfaces file (UNIX) or a server name. Action: Examine the URL command and correct. |
JZ021 |
Description: The sql.ini file (Windows) or the interfaces file (UNIX) specified in the connection URL is not found. Action: Check the connection URL and correct. |
JZ022 |
Description: The connection URL string in the sql.ini file (Windows) or the interfaces file (UNIX) is not in the correct format. Action: Check the connection URL string and correct. |
JZ024 |
Description: The server name specified in connection URL has no corresponding entry in the sql.ini file (Windows) or the interfaces file (UNIX). Action: Check the connection URL string and correct. |
JZ025 |
Description: The server details in the TLI format interfaces file (UNIX) is incorrect. Action: Check the settings and correct. |
JZ026 |
Description: An unsupported protocol (other than tli, tcp, and nlwnsck) is specified in the sql.ini file (Windows) or the interfaces file (UNIX). Action: Specify a supported protocol only. |
JZ027 |
Description: An invalid value is specified in the Kerberos connection URL. Action: Examine the URL and correct. |
JZ028 |
Action: Specify a legal value. |
JZ029 |
Description: jConnect is unable to locate the server specified with the ALTERNATE_SERVER_NAME property using the SQL Anywhere UDP discovery protocol. Action: Check the server name specified with the ALTERNATE_SERVER_NAME connection property and correct. |
JZ030 |
Description: You are using a public API that is currently not supported. |
JZ031 |
Description: jConnect cannot unwarp the object of a custom class because the custom class is not in the classpath. Action: Add the class to classpath. |
JZ032 |
Action: See message text. |
JZ033 |
Description: jConnect is unable to map the ASE datatype of the column to a BLOB datatype. Action: Make sure that the ASE column is convertible to a BLOB datatype. |
JZ034 |
Description: The version of the connected ASE does not support LOB methods. Action: Use the regular stream methods to access LOB. |
JZ035 |
Action: See message text. |
JZ036 |
Action: See message text. |
JZ037 |
Action: See message text. |
JZ038 |
Description: The size specified in an operation (getBytes, truncate, getSubString) on a LOB object is negative Action: Specified a nonnegative value only. |
JZ040 |
Description: The read (write) operation has failed as input stream or LOB reader (output stream or LOB writer) has already closed. Action: Check the application to locate the reason of the conflict and correct. |
JZ041 |
Description: The read(write)(available()) operation has failed as input stream or reader (output stream or writer)(input stream) has already closed. Action: Check the application to locate the reason of the conflict and correct. |
JZ042 |
Action: See message text. |
JZ043 |
Action: See message text. |
JZ044 |
Action: See message text. |
JZ0BD |
Action: Verify that the parameter value in the method is correct. |
JZ0BI |
Message: Description: The client application has tried to call setFetchSize with an invalid number of rows. Action: Verify that you are calling setFetchSize with the parameter falling within the above range of values. |
JZ0BJ |
Message: Action: See message text. |
JZ0BP |
Action: Examine your application code and check that you did not try to declare an output parameter in your batch. |
JZ0BR |
Description: You attempted to call a ResultSet method that is invalid for the current row position (for example, calling insertRow when the cursor is not on the insert row). Action: Do not attempt to call a ResultSet method that is invalid for the current row position. |
JZ0BS |
Action: Install or update the jConnect metadata stored procedures on your database with the latest versions. |
JZ0BT |
Description: You attempted to call a ResultSet method that is invalid for the type of ResultSet. Action: Do not attempt to call a ResultSet method that is invalid for the type of ResultSet. |
JZ0C0 |
Description: The application has already called Connection.close on this connection object; it cannot be used any more. Action: Fix the code so that connection object references are nulled out when a connection is closed. |
JZ0C1 |
Description: An unrecoverable IOException occurred that caused the connection to be closed. The connection cannot be used for any further database activity. If this exception occurs, it can always be found in an exception chain with the JZ006 Exception (explained earlier). Action: Determine the cause of the IOException that disrupted the connection. |
JZ0CL |
Action: Be sure to specify a CLASS_LOADER when setting PRELOAD_JARS to a non-null value. |
JZ0D4 |
Description: You specified a connection URL using a protocol other than TDS, which is the only protocol currently supported by jConnect. Action: Check the URL definition. If the URL specifies TDS as a subprotocol, make sure that the entry uses the following format and capitalization: jdbc:sybase:Tds:host:port If the URL specifies JNDI as a subprotocol, make sure that it starts with: jdbc:sybase:jndi: |
JZ0D5 |
Action: Check the settings for the CLASSPATH system variable. |
JZ0D6 |
Action: See message text. |
JZ0D7 |
Action: Check the JNDI URL to make sure it is correct. |
JZ0D8 |
Action: Check the JNDI URL to make sure it is correct. |
JZ0EM |
Action: Please report this error to Sybase Technical Support. |
JZ0F1 |
Description: When you set the REQUEST_HA_SESSION connection property to "true," you must also specify a failover server. Action: You can specify the secondary server using the SECONDARY_SERVER_HOSTPORT connection property, or you can set the secondary server using JNDI (see “Implementing high availability failover support”). |
JZ0F2 |
Description: The back-end database server to which you were connected has gone down, but you have failed over to a secondary server. The database connection is still usable. Action: Client code should catch this exception, then restart the transaction from the last committed point. Assuming you properly handle the exception, you can continue executing JDBC calls on the same connection object. |
JZ0FP |
Description: The value of the parameter specified for the state of the current resultset is invalid. Action: Make sure that the value is a legal valid (CLOSE_CURRENT_RESULT, KEEP_CURRENT_RESULT, CLOSE_ALL_RESULTS.) |
JZ0GC |
Action: See message text. |
JZ0GK |
Description: The auto-generated key column name/index array is either NULL or contains more than one key. Only one key is allowed in the array since it relates to the IDENTITY column. Action: Check the query and correct. |
JZ0GN |
Action: Make sure your CLASSPATH environment variable includes any .jar files required by your third-party GSSManager implementation. |
JZ0GS |
Action: Examine the major and minor error codes and messages. Check your Kerberos configuration. See Chapter 3, “Security” for more information. |
JZ0H0 |
Action: Please report this error to Sybase Technical Support. |
JZ0H1 |
Action: Please report this error to Sybase Technical Support. |
JZ0HC |
Description: A string that is supposed to represent a binary value contains a character that is not in the range (0–9, a–f) that is required for a hexadecimal number. Action: Check the character values in the string to make sure they are in the required range. |
JZ0I3 |
Action: Indicates an internal product problem. Please report this error to Sybase Technical Support. |
JZ0I5 |
Description: You specified an unsupported character set code for the CHARSET connection property. Action: Enter a valid character-set code for the connection property. See “jConnect character-set converters”. |
JZ0I6 |
Action: Choose a different character set code for the CHARSET connection property on the jConnect client that can support all the characters you need to send to the server. You may need to install a different character set on the server, too. Also, if you are using jConnect version 6.05 or later, and Adaptive Server Enterprise 12.5 or later, you can send your data to the server as unichar/univarchar datatypes. Please see “Using jConnect to pass Unicode data”. |
JZ0I7 |
Description: The connection cannot be established as there is no response from proxy gateway specified with the PROXY connection property. Action: Check the PROXY setting and correct. |
JZ0I8 |
Description: The proxy gateway connection was refused due to the specified reason. Action: Check the proxy gateway settings. |
JZ0I9 |
Description: You tried to read an InputStream obtained from getAsciiStream, getUnicodeStream, or getBinaryStream, but the InputStream was already closed. The stream may have been closed because you moved to another column or cancelled the result set and there were not enough resources to cache the data. Action: Increase the cache size or read columns in order. |
JZ0IA |
Description: There was a truncation error on character set conversion prior to sending a string. The converted string is longer than the size allocated for it. Action: Choose a different character-set code for the CHARSET connection property on the jConnect client that can support all the characters you need to send to the server. You may need to install a different character set on the server, too. |
JZ0IB |
Action: See message text. |
JZ0IR |
Action: Remove the getXXX call on the ResultSet column which you updated using a Reader. |
JZ0IS |
Description: After updating a column in a result set, you attempted to read the updated column value using one of the following SybResultSet methods: getAsciiStream, getUnicodeStream, getBinaryStream. jConnect does not support this usage. Action: Do not attempt to fetch input streams from columns you are updating. |
JZ0J0 |
Action: Verify that the offset and/or length values you used are correct. |
JZ0LA |
Description: The implementation of the JCE provider specified with the JCE_PROVIDER_CLASS connection property is not in the classpath. Action: Make sure that the implementation is in the classpath. |
JZ0LC |
Description: The application tried to call one of the ResultSet cursor scrolling methods on a ResultSet which was created with a language cursor. Action: See the error message. |
JZ0MD |
Description: The J2EE_TCK_COMPLIANT property is set and the resultset metadata is not available. Action: Install the metadata stored procedures. |
JZ0NC |
Description: You can only call wasNull after a call to get a column, such as getInt or getBinaryStream. Action: Change the code to move the call to wasNull. |
JZ0NE |
Action: Check the format of the URL. Make sure that the port number consists only of numeric characters. |
JZ0NF |
Action: See message text. |
JZ0NK |
Description: The getGeneratedKeys() method is unable to return the auto-generated keys because the statement was executed with .NO_GENERATED_KEYS or the statement produced no auto-generated keys. Action: Use getGeneratedKeys() only on statements executed with .RETURN_GENERATED_KEYS or those that are expected to auto-generate keys. |
JZ0NS |
Action: See message text. |
JZ0P1 |
Description: The database has returned a result that the statement cannot return to the application, or that the application is not expecting at this point. This generally indicates that the application is using JDBC incorrectly to execute the query or stored procedure. If the JDBC application is connected to an Open Server application, it may indicate an error in the Open Server application that causes the Open Server to send unexpected sequences of results. Action: Use the com.sybase.utils.Debug(true, “ALL”) debugging tools to try to determine what unexpected result is seen, and to understand its causes. |
JZ0P4 |
Action: See message text. |
JZ0P7 |
Description: With the REPEAT_READ connection property set to "false," an attempt was made to reread a column or read a column in the wrong order. When REPEAT_READ is "false," you can only read the column value for a row once, and you can only read columns in ascending column-index order. For example, after reading column 3 for a row, you cannot read its value a second time and you cannot read column 2 for the row. Action: Either set REPEAT_READ to "true," or do not attempt to reread a column value and be sure that you read columns in ascending column-index order. |
JZ0P8 |
Description: jConnect cannot determine the name of a column type in the ResultSetMetaData.getColumnTypeName method. Action: Be sure that your database has the most recent stored procedures for metadata. |
JZ0P9 |
Description: The query you executed returned COMPUTE results, which are not supported by jConnect. Action: Change your query or stored procedure so it does not use COMPUTE BY. |
JZ0PA |
Description: A cancel was probably issued by another statement on the connection. Action: Check the chain of SQL exceptions and warnings on this and other statements to determine the cause. |
JZ0PB |
Description: When jConnect creates a connection with a server, it informs the server of capabilities it wants supported, and the server informs jConnect of the capabilities that it supports. This error message is sent when an application requests an operation that was denied in the original capabilities negotiation. For example, if the database does not support precompilation of dynamic SQL statements, and your code invokes SybConnection.prepareStatement(sql_stmt, dynamic), and dynamic is set to "true," jConnect generates this message. Action: Modify your code so that it does not request an unsupported capability. |
JZ0PC |
Description: You are trying to execute a statement with a large number of parameters, and the server is not configured to handle that many parameters. The number of parameters that can produce this exception varies, depending on the datatypes of the data you are sending. You never get this exception if you are sending 481 or fewer parameters. Action: You must run this query against an Adaptive Server 12.5 or later server. When you connect to the database, set the JCONNECT_VERSION property to “6”. |
JZ0PD |
Description: You are trying to execute a dynamic prepared statement with a large number of parameters, and the server is not configured to handle that many parameters. Action: You must run this query against an Adaptive Server 12.5 or later server. When you connect to the database, set the JCONNECT_VERSION property to “6”. |
JZ0PE |
Description: This error can occur when your SELECT statement tries to return data from more than 255 columns, or when the actual length of the SELECTstatement is very large (greater than approximately 65500 characters). Action: You must run this query against a version 12.5 or later Adaptive Server. When you connect to the database, set the JCONNECT_VERSION property to “6”. |
JZ0PN |
Action: Check the port number that is specified in the database URL. |
JZ0R0 |
Description: The ResultSet.close method has already been called on the result set object; you cannot use the result set for anything else. Action: Fix the code so that ResultSet object references are set to null whenever a result set is closed. |
JZ0R1 |
Description: The application has called one of the ResultSet.getXXX column-data retrieval methods, but there is no current row; the application has not called ResultSet.next, or ResultSet.next returned "false" to indicate that there is no data. Action: Verify that rs.next is set to "true" before calling rs.getXXX. |
JZ0R2 |
Description: You used Statement.executeQuery, but the statement returned no rows. Action: Use executeUpdate for statements returning no rows. |
JZ0R3 |
Action: See message text. |
JZ0R4 |
Description: You cannot update a text/image column if it is null. A null text/image column does not contain a text pointer. Action: Be sure that you are not trying to update or get a text pointer to a column that does not support text/image data. Be sure that you are not trying to update a text/image column that is null. Insert data first, then make the update. |
JZ0R5 |
Description: The application has moved the ResultSet row pointer beyond the last row. In this position, there is no data to read, so any get* operations are illegal. Action: Alter the code so that it does not attempt to read column data when the ResultSet is positioned beyond the last row. |
JZ0RD |
Description: An application is trying to retrieve data from a row that has been deleted. There is no valid data to be retrieved. Action: Alter the code so that the application does not attempt to retrieve data from a deleted row. |
JZ0RM |
Description: After updating a row in the database with SybCursorResult.updateRow, or deleting it with SybCursorResult.deleteRow, you used SybCursorResult.refreshRow to refresh the row from the database. Action: Do not attempt to refresh a row after updating it or deleting it from the database. |
JZ0S0 |
Description: The only time this error is raised is from the Statement.setCursorname method, if the application is trying to set the cursor name when the statement is already in use and has noncursor results that need to be read. Action: Set the cursor name on a statement before you execute any queries on it, or call Statement.cancel before setting the cursor name, to make sure that the statement is not busy. |
JZ0S1 |
Description: An internal error occurred on the statement. Action: Close the statement and open another one. |
JZ0S2 |
Description: The Statement.close method has already been called on the statement object; you cannot use the statement for anything else. Action: Fix the application so that statement object references are set to null whenever a statement is closed. |
JZ0S3 |
Description: PreparedStatement does not support executeQuery(String), executeUpdate(String), or execute(String). Action: To pass a query string, use Statement, not PreparedStatement. |
JZ0S4 |
Action: Do not execute an empty query (““). |
JZ0S5 |
Description: This exception can occur when using distributed transactions. Action: See Chapter 7, “Distributed Transactions,” in the JDBC 2.0 Optional Package (formerly the JDBC 2.0 Standard Extension API) for more information on diagnosing the problem. |
JZ0S6 |
Description: This exception can occur when using distributed transactions. Action: See Chapter 7, “Distributed Transactions,” in the JDBC 2.0 Optional Package(formerly the JDBC 2.0 Standard Extension API) for more information on diagnosing the problem. |
JZ0S8 |
Description: This error results from bad escape syntax. Action: Check JDBC documentation for correct syntax. |
JZ0S9 |
Action: Do not execute an empty query (““). |
JZ0SA |
Action: Be sure that each input parameter has a value. |
JZ0SB |
Description: You have attempted to get, set, or register a parameter that goes beyond the maximum number of parameters. Action: Check the number of parameters in your query. |
JZ0SC |
Description: You have prepared a call to a stored procedure that returns a status, but you are trying to set parameter 1, which is the return status. Action: Parameters that you can set start at 2 with this type of call. |
JZ0SD |
Description: This indicates an application logic error. You attempted to call getXXX or wasNull on a parameter, but you have not read any parameters yet, or there are no output parameters. Action: Check to make sure that the application has registered output parameters on the CallableStatement, that the statement has been executed, and that the output parameters were read. |
JZ0SE |
Description: Illegal type argument passed to PreparedStatement.setObject. Action: Check the JDBC documentation. The argument must be a constant from java.sql.Types. |
JZ0SF |
Description: You tried to set a parameter on a statement with no parameters. Action: Make sure the query has been sent before you set the parameters. |
JZ0SG |
Description: This error occurs if you call CallableStatement.registerOutParam for more parameters than you declared as “OUTPUT” parameters in the stored procedure. See “RPC returns fewer output parameters than registered” for more information. Action: Check your stored procedures and registerOutParameter calls. Make sure that you have declared all of the appropriate parameters as “OUTPUT.” Look at the line of code that reads:
If you receive this error while using SQL Anywhere, upgrade to SQL Anywhere version 5.5.04. |
JZ0SH |
Action: Install metadata accessor information before using static function escapes. |
JZ0SI |
Action: Do not use this escape. |
JZ0SJ |
Action: Install metadata information before making metadata calls. |
JZ0SK |
Action: Read the error message. Also, install the latest version of the jConnect metadata. |
JZ0SL |
Description: The application has declared a parameter to be of a type that jConnect does not support. Action: If possible, try declaring the parameter to be of a different type. Do not use Types.NULL or PreparedStatement.setObject (null). |
JZ0SM |
|
JZ0SN |
Action: Use a positive value or zero (unlimited) when calling setMaxFieldSize. |
JZ0SO |
Action: Check that your declared concurrency is either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE. |
JZ0SP |
Action: Check that your declared ResultSet type is ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_INSENSITIVE. jConnect does not support the ResultSet.TYPE_SCROLL_SENSITIVE ResultSet type. |
JZ0SQ |
Description: When calling the DatabaseMetaData.getUDTs method, jConnect throws this exception if the user-defined type is not either Types.JAVA_OBJECT, Types.STRUCT or Types.DISTINCT. Action: Use one of the three UDTs mentioned above. |
JZ0SR |
Action: Use a positive value or zero (unlimited) when calling setMaxRows. |
JZ0SS |
|
JZ0ST |
|
JZ0SU |
Description: Adaptive Server Enterprise and SQL Anywhere have different allowable ranges for datetime and date values. datetime values must have years greater or equal to 1753. The date datatype, however, can hold years greater or equal to 1. Action: Make sure that the date/timestamp value you are sending falls in the acceptable range. |
JZ0SV |
Description: The CallableStatement has parameters specified by name and by index (ordinal position). Mixed use is invalid. Action: Specify parameters by name only or by index (ordinal position) only. |
JZ0SW |
Description: You have specified an invalid value with the setHoldability() method. Action: Use the legal values only - HOLD_CURSORS_OVER_COMMIT or CLOSE_CURSORS_AT_COMMIT. |
JZ0T2 |
Action: Check your network communications. |
JZ0T3 |
Description: The time allotted to read the response to a query was exceeded. Action: Increase the timeout period by calling Statement.setQueryTimeout. |
JZ0T4 |
Description: The time allotted to send a request was exceeded. Action: Increase the timeout period by calling Statement.setQueryTimeout. |
JZ0T5 |
Action: Use default or larger value for the STREAM_CACHE_SIZE connection property. |
JZ0T6 |
Description: The tunneled protocol failed while reading the URL header. Action: Check the URL you defined for the connection. |
JZ0T7 |
Action: Check the network connections and try to run the application again. If the threads continue to be aborted, please contact Sybase Technical Support. |
JZ0T8 |
|
JZ0T9 |
Action: See message text. |
JZ0TC |
Description: Conversion between a Java type and a SQL type failed. Action: Check the requested type conversion to make sure it is supported in the JDBC specification. |
JZ0TD |
Description: The calling application thread was killed while jConnect was performing a timed IO operation. Action: Check the application code to locate the conflict and correct. |
JZ0TE |
Description: The database column datatype and the datatype requested in theResultSet.getXXX call are not implicitly convertible. Action: Use one of the valid datatypes listed in the error message. |
JZ0TI |
Description: This kind of exception can occur, for example, if an application tries to call ResultSet.getObject(int, Types.DATE) on a time value that is returned from the database. Action: Make sure that the database datatype is implicitly convertible to the Object type you wish to retrieve. |
JZ0TO |
Description: This exception occurs when there is a socket read timeout. Action: Increase the timeout period by calling Statement.setQueryTimeout. Also, check the query or stored procedure you are executing to determine why it is taking longer than expected. |
JZ0TS |
Description: The application specified a string that was longer than the length that the application wanted to send. Therefore, the string is truncated to the declared length. Action: Set the length properly to avoid truncation. |
JZ0US |
Action: See message text. |
JZ0XC |
Description: The metadata information indicates that the server supports distributed transactions, but jConnect does not support the protocol being used. Action: Verify that you have installed the latest metadata scripts. If the error persists, please contact Sybase Technical Support. |
JZ0XS |
Description: The server to which jConnect attempted a connection does not support distributed transactions. Action: Do not use XADataSource with this server, or upgrade or configure the server for distributed transactions. |
JZ0XU |
Description: The user connected to the database is not authorized to conduct distributed transactions, most likely because the user does not have the proper role (shown in the blank). Action: Grant the user the role shown in the error message, or have another user with that role conduct the transaction. |
JZBK1 |
Action: Install MDA stored procedures. |
JZBK3 |
Description: The table specified with BCP does not exist in the database. Action: Correct the table name. |
JZBK4 |
Description: During a batch operation, you are attempting to execute a nonbatch operation. Action: Wait for the batch operation to complete before attempting a nonbatch operation. |
JZBK5 |
Action: See message text. |
JZBK6 |
Action: See message text. |
JZBK7 |
Action: See message text. |
JZBKI |
Action: Set ENABLE_BULK_LOAD to one of the valid values only –ARRAYINSERT_WITH_MIXED_STATEMENTS, ARRAYINSERT, BCP, or LOG_BCP. |
JZNNA |
Description: You attempted to set a Bit-type column to a NULL value using setNull() in a prepared statement. Action: Examine the query and correct to set a value of 0 or 1 for Bit-type columns. |
S0022 |
Description: You attempted to reference a column by name and there is no column with that name. Action: Check the spelling of the column name. |
ZZ00A |
Description: You attempted to use a method that is not implemented. Action: Check the release bulletin that came with your version of jConnect for further information. You can also check the jConnect Web page to see whether a more recent version of jConnect implements the method. If not, do not use the method.
|