Aug 24, 2010 2:00 PM
Error Codes Returned From Netezza Server
-
Like (0)
Hi,
I am trying to access Netezza from my JDBC code, I am using JDBC driver 5.0.10. My design is based on the error code returned from exception. would any one please tell me where can I get sql error codes returned by netezza.
Thank U
vgss
I think there are no as such error codes. You can manage all operations flow from type of excepetion raised in case of query failure in Java code.
-AmbarishDon
There is no official list, I do have a partial list of JDBC exceptions which was extracted from the JDBC error message localization file.
netezza.unimplemented:The method '{0}' of '{1}' class is not yet implemented
netezza.con.closed.illegal.op:Connection is closed. Illegal Operation performed.
netezza.con.closed:Connection is already closed. Operation can not be completed.
netezza.con.mode.autocommit:The connection object is in auto-commit mode
netezza.trans.isolation.level.invalid:Invalid transaction isolation level :{0}
netezza.res.holdability.invalid:Invalid result set holdability
netezza.feature.not.supported:Current Driver does not support this feature({0})
netezza.unsec.session.needed.to.old.bkend:Need to have unsecured session while connecting to old backends.
netezza.opcode.unknown:Unknown opcode :{0}
netezza.unknown.bknd.resp:Unknown backend response :{0}
netezza.con.kerb4:Kerberos 4 authentication is not supported by this driver.
netezza.con.kerb5:Kerberos 5 authentication is not supported by this driver.
netezza.con.auth:The authentication type {0} is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or Subnet, and that it is using an authentication scheme supported by the driver.
netezza.con.backend:Backend start-up failed: {0}
netezza.stmt.nullquery:SQL query can not be NULL.
netezza.stmt.batch.param.marker:Batch statement cannot have parameter markers.
netezza.con.pass:The password property is missing. It is mandatory.
netezza.con.user:The user property is missing. It is mandatory.
netezza.con.host.or.port:Invalid host/port.
netezza.con.invalid.url:Invalid URL format(jdbc:netezza://<host-name>:<port-number>/<DSN>?<props-list, separated by;>)
netezza.con.state.undefined:Undefined connection state
netezza.con.interrupted:Interrupted while connecting
netezza.con.refused:Connection refused. Check that the host name and port are correct and that the postmaster is accepting TCP/IP connections.
netezza.bknd.ver:Could not get backend version
netezza.driver.ver:Could not log driver version
netezza.bad.query.result:No results were returned by the query.
netezza.query.not.parsed:Query is not parsed.
netezza.bad.update.result:The query returns ResultSet object. Number of rows expected
netezza.data.type.not.supported:Netezza does not support the datatype '{0}'
netezza.ext.table.create.failed:failed to create external table for bulk load
ntezza.ext.table.invalid.block.size:Remote external table transfer error : Invalid block Size :{0}
netezza.res.not.scrollable:ResultSet is TYPE_FORWARD_ONLY
netezza.res.type.unknown:Unknown Resultset Type :{0}
netezza.col.name.not.found:The column name {0} not found.
netezza.res.cursor.not.supported:Netezza does not support cursors
netezza.res.invalid.fetch.direction:Invalid fetch direction constant.
netezza.invalid.fetch.size: Either Fetch Size is negative or Fetch size is greater than maxrows
netezza.res.closed:Result set is closed. Operation is not permitted.
netezza.res.invalid.cur.state:Result set not positioned properly, perhaps you need to call next().
netezza.neg.julian.dayz:Cannot handle negative Julian days
netezza.col.idx.out.of.range:Column Index out of range: {0}
netezza.param.idx.out.of.range:Parameter Index out of range: {0}
netezza.res.bad.num:Bad Number: {0}
netezza.res.bad.date:Bad Date format: {0}
netezza.res.bad.time:Bad Time format: {0}
netezza.res.bad.timestamp:Bad Time format: {0}
netezza.max.field.size.neg:Max Field Size can not be negative
netezza.max.rows.neg:Max Rows can not be negative
netezza.query.timeout.neg:Query Timeout can not be negative
netezza.bad.value: Bad value for: {0}
netezza.idx.out.of.range:Index out of range: {0}
netezza.update.count.exceed.int.range:The update count exceeded Integer.MAX_VALUE.
netezza.stmt.closed:Statement is closed.
netezza.query.timeout.expired:Query timeout expired.
netezza.login.timeout.expired:Login timeout expired.
netezza.max.stmt.handles:Driver can process one query at one time
netezza.dsn.not.found:DataSource name not found '{0}'.
netezza.proto.no.null:Protocol can not be 'NULL'
netezza.prep.param:No value specified for parameter {0}
+netezza.sql.type:SQL type is undefined: {0}
+netezza.date.time.parse:Error occurred while parsing date/time/timestamp: {0}
+netezza.type.mismatch:Java object type is not correctly mapped to SQL type {0}: {1}
Thank U, thats what i am looking for..

