Skip navigation
14032 Views 3 Replies Latest reply: Aug 25, 2010 12:13 PM by vgss RSS
vgss New Enzee 5 posts since
Aug 10, 2010
Currently Being Moderated

Aug 24, 2010 2:00 PM

Error Codes Returned From Netezza Server

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

  • AmbarishDon New Enzee 67 posts since
    May 11, 2010
    Currently Being Moderated
    1. Aug 25, 2010 6:24 AM (in response to vgss)
    Re: Error Codes Returned From Netezza Server

    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

  • Shawn Fox Enzee Exraordinaire 1,333 posts since
    Aug 15, 2006
    Currently Being Moderated
    2. Aug 25, 2010 8:17 AM (in response to vgss)
    Re: Error Codes Returned From Netezza Server

    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}

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points