IDS Forum

Re: Serial Column Informix 10.x

Posted By: FRANK
Date: Friday, 16 February 2007, at 5:45 p.m.

In Response To: Serial Column Informix 10.x (VIJAYAKUMAR GANESH KUMAR)

This may help.

Frank

IBM Informix JDBC Driver provides support for the Informix SERIAL and
SERIAL8 data types through the methods *getSerial()* and *getSerial8()*,
which are part of the implementation of the *java.sql.Statement* interface.

Because the SERIAL and SERIAL8 data types do not have an obvious mapping to
any JDBC API data types from the *java.sql.Types* class, you must import
Informix-specific classes into your Java program to handle SERIAL and
SERIAL8 columns. To do this, add the following import line to your Java
program:

import com.informix.jdbc.*;

Use the *getSerial()* and *getSerial8()* methods after an INSERT statement
to return the serial value that was automatically inserted into the SERIAL
or SERIAL8 column of a table, respectively. The methods return 0 if any of
the following conditions are true:

· The last statement was not an INSERT statement.

· The table being inserted into does not contain a SERIAL or SERIAL8
column.

· The INSERT statement has not executed yet.

If you execute the *getSerial()* or *getSerial8()* method after a CREATE
TABLE statement, the method returns 1 by default (assuming the new table
includes a SERIAL or SERIAL8 column). If the table does not contain a SERIAL
or SERIAL8 column, the method returns 0. If you assign a new serial starting
number, the method returns that number.

If you want to use the *getSerial()* and *getSerial8()* methods, you must
cast the *Statement* or *PreparedStatement* object to *IfmxStatement*, the
Informix-specific implementation of the *Statement* interface. The following
example shows how to perform the cast:

cmd = "insert into serialTable(i) values (100)";

stmt.executeUpdate(cmd);

System.out.println(cmd+"...okay");

int serialValue = ((IfmxStatement)stmt).getSerial();

System.out.println("serial value: " + serialValue);

If you want to insert consecutive serial values into a column of data type
SERIAL or SERIAL8, specify a value of 0 for the SERIAL or SERIAL8 column in
the INSERT statement. When the column is set to 0, the database server
assigns the next-highest value.

On 2/16/07, VIJAYAKUMAR GANESH KUMAR <ganesh17jan@gmail.com> wrote:
>
> Hi All,
>
> I have a table with a primary key column defined as serial.
> and I also have a child table which refers this.
>
> In my application, While making an entry in to the primary table , i also
> need
> to make an entry in to the child table.
>
> How do i get the generated ID so that i can insert into the child table
> with
> this id as a foreign key.
>
> I am using IFXJDBC 3.0.JC3.
>
> Thanks,
> Ganesh
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

Messages In This Thread

• Serial Column Informix 10.x
  VIJAYAKUMAR GANESH KUMAR -- Friday, 16 February 2007, at 12:26 p.m.
  • Re: Serial Column Informix 10.x
    FRANK -- Friday, 16 February 2007, at 5:45 p.m.
    • Re: Serial Column Informix 10.x
      VIJAYAKUMAR GANESH KUMAR -- Friday, 16 February 2007, at 6:59 p.m.
      • Re: Serial Column Informix 10.x
        ART KAGEL, BLOOMBERG/ 731 LEXIN -- Tuesday, 20 February 2007, at 10:29 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.