Re: Identity Increment

[Zorro <hz...@gmail.com>]

Ruzal Yumaev schreef op 25-3-2015 om 20:55:
> Hello!
> I'm creating table USERS where primary key ID has autogenerating column:
>   ID INT NOT NULL GENERATED ALWAYS AS IDENTITY(START WITH 1, INCREMENT
> BY 1) PRIMARY KEY
> After inserting second or more row ID column increment to 100 and
> "INCREMENT BY 1" - it's multipling for one hundred.
> Example from table:
>
> ID FIO BIRTHDAY GROUPNUM
> 1 Name 2012-12-21 21312
> 101 Name 2001-12-21 23412
> 201 Name 2001-12-02 21323
> I attach log file  and maven dependency is
> <dependency>
>      <groupId>org.apache.derby</groupId>
>      <artifactId>derby</artifactId>
>      <version>10.11.1.1</version>
> </dependency>

Out of curiosity I tried it, also with derby 10.11.1.1, java 1.8.
My code below is your code extended with 3 inserts .

{
         String dbURL1 = "jdbc:derby:bd;create=true";
         Connection conn1 = null;
         try {
             conn1 = DriverManager.getConnection(dbURL1);
             if (conn1 != null) {
                 System.out.println("Connected to database");
             }
             Statement statement = conn1.createStatement();
             try {
                 System.out.println("Create Table USERS");
                 statement.executeUpdate("CREATE TABLE USERS" +
                         "(ID INT NOT NULL GENERATED ALWAYS AS 
IDENTITY(START WITH 1, INCREMENT BY 1) PRIMARY KEY, FIO VARCHAR(255) NOT 
NULL," +
                         "BIRTHDAY DATE, GROUPNUM VARCHAR(15))");
                 System.out.println("Table USERS created");
             } catch (SQLException e) {
                 System.out.println("Table USERS already exists");
             }
             statement.execute("Insert Into USERS (FIO, BIRTHDAY, 
GROUPNUM) VALUES('Name', '2012-12-21', '21312')");
             statement.execute("Insert Into USERS (FIO, BIRTHDAY, 
GROUPNUM) VALUES('Name', '2012-12-21', '21412')");
             statement.execute("Insert Into USERS (FIO, BIRTHDAY, 
GROUPNUM) VALUES('Name', '2012-12-02', '21323')");
         }
         catch (Exception e) {
             System.out.println("Exception" + e.getMessage());
         }
     }
}

The outcome of a Select * From App.USERS in ij was:
1   |Name      |2012-12-21|21312
2   |Name      |2012-12-21|21412
3   |Name      |2012-12-02|21323

3 rows selected

So seems to work.
Maybe you can try this code also.

Regards,
Harm-Jan Zwinderman

Cebuned.svipr.nl/Cebuned.html