SimpleJdbcInsert and auto-generated key problem?

[burki]

I'm using SimpleJdbcInsert object for inserting new record into Oracle 10g database. Table consists of two columns. id for pkey, and name for description. I wanna use usingGeneratedKeyColumns("id") method to generate pkey for insert statement. For this purpose, I'm creating a new instance with this statement:

SimpleJdbcInsert simpleJdbcInsert = new SimpleJdbcInsert(dataSource)
		.withTableName("TPaymentOrgSector")
		.usingGeneratedKeyColumns("id");

And create method of my dao impl like this:

Number newKey = this.simpleJdbcInsert.executeAndReturnKey(createParameterSource(po));
int newId = newKey.intValue();

Also createParameterSource method:

private MapSqlParameterSource createParameterSource(PaymentOrganizationSector po) {
		return new MapSqlParameterSource()
		.addValue("NAME", po.getName());
}

in this method, i'm not mapping "id" column. because i want it to be created by Spring. But when i run the code,

org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL []; ORA-01400: cannot insert NULL into ("TKRY"."TPAYMENTORGSECTOR"."ID")
; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("TKRY"."TPAYMENTORGSECTOR"."ID")

exception occurs. What spring does here if i explicitly set the id column? I'm leaving it null, becase i expect it to be generated somehow by Spring. Am i missing some important point? What is the generation rule here? Do i need a sequence or trigger. I couldn't find any clue in the 2.5 Spring documentation...

Thanks in advance.

[Marten Deinum]

exception occurs. What spring does here if i explicitly set the id column? I'm leaving it null, becase i expect it to be generated somehow by Spring. Am i missing some important point? What is the generation rule here? Do i need a sequence or trigger. I couldn't find any clue in the 2.5 Spring documentation...

Your understanding of the feature is off... Spring doesn't generate anything it lets the database generate a key and returns it for you. However the database must support the feature and a key must be generated by the database. For oracle this means specifing a trigger on the column which generates the key for you, in MySQL you can use an autoincrement column. As stated Spring isn't generating anything for you and that is where your logic is off...

[burki]

Hi, Marten

I misunderstood the concept of auto-generated key then. It only returns the value that has been created at db layer...

Thanks,