AW: Torque7 and postgresql autoincrementing primary keys not working
"Kallidis, Georg" <[email protected]> Fri, 19 Jun 2026 17:41:55 +0200
| Newsgroups | gmane.comp.jakarta.turbine.torque.devel |
|---|---|
| Message-ID | <[email protected]> |
SGkgR3JhaGFtLA0KDQpJIHVuZGVyc3RhbmQgVG9ycXVlIGdlbmVyYXRlcywgaWYgYSBjb2x1bW4g aGFzIGF1dG9JbmNyZW1lbnQ9InRydWUiIGZvciB0YXJnZXQgZGF0YWJhc2UgUG9zdGdyZXNxbCB0 aGUgc2VxdWVuY2UsIGJ1dCBub3QgdGhlIHJlcXVpcmVkIGVudHJ5IGluIHRoZSBnZW5lcmF0ZWQg U1FMIGluIHRoZSBjb2x1bW4uDQoNCjEuIFRoZSBtZXRob2QgIGdldEF1dG9JbmNyZW1lbnQgaW4g b3JnLmFwYWNoZS50b3JxdWUudGVtcGxhdGVzLnBsYXRmb3JtLlBsYXRmb3JtUG9zdGdyZXNxbElt cGwgcmV0dXJucyBhbiBlbXB0eSBTdHJpbmcgaW5zdGVhZCBvZiBuZXh0dmFsKCciICsgbmFtZSAr ICInKSAgKFBvc3RncnNxbDgpDQoNCjIuIGluIFBvc3RncmVzQWRhcHRlciB0aGUgbWV0aG9kIGdl dElETWV0aG9kU1FMICBpcyBub3QgY2FsbGVkLCBhcyBmb3IgdGhlIHRhYmxlIGlkTWV0aG9kPSJu YXRpdmUiLCB5b3UgbWlnaHQgdHJ5IHRvIGNoYW5nZSB0byBpZE1ldGhvZD0ic2VxdWVuY2UiLg0K VGhlbiBpdCByZXR1cm5zICgic2VsZWN0IG5leHR2YWwoJyIgKyBuYW1lICsgIicpIik7IHdoaWNo IGlzIG5vdCByaWdodCwgd2hhdCB3ZSB3YW50LCBidXQgcmVhZCBvbiDwn5iKDQoNCjMuIFRoaXMg aXMsIHdoZXJlIHRoZSAiaGFjayIgaXMgZG9jdW1lbnRlZCwgYW5kIHdoaWNoIGV4cGxhaW5zIHdo eSBnZXRBdXRvSW5jcmVtZW50IHJldHVybnMgbm90aGluZzoNCg0KSW4gb3JnLmFwYWNoZS50b3Jx dWUudXRpbC5CYXNlUGVlckltcGwsIGxpbmUgNTk3ZmY6DQoNCmRvSW5zZXJ0KENvbHVtbltdLCBD cml0ZXJpYSwgU3RyaW5nLCBDb25uZWN0aW9uKQ0KaWYgKGtleUdlbiBpbnN0YW5jZW9mIFNlcXVl bmNlSWRHZW5lcmF0b3IpDQogICAgICAgICAgICAgICAgew0KICAgICAgICAgICAgICAgICAgICBT ZXF1ZW5jZUlkR2VuZXJhdG9yIHNlcXVlbmNlSWRHZW5lcmF0b3INCiAgICAgICAgICAgICAgICAg ICAgPSAoU2VxdWVuY2VJZEdlbmVyYXRvcikga2V5R2VuOw0KICAgICAgICAgICAgICAgICAgICBT dHJpbmcgaWRTcWwgPSBzZXF1ZW5jZUlkR2VuZXJhdG9yLmdldElkU3FsKA0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgIGdldElkTWV0aG9kSW5mbygpKTsNCiAgICAgICAgICAgICAgICAgICAg Ly8gVGhpcyBpcyBhIGJpdCBvZiBhIGhhY2suDQogICAgICAgICAgICAgICAgICAgIC8vIFRoZSBp ZFNxbCBpcyB1c3VhbGx5IGEgc3RhbmQtYWxvbmUgc3RhdGVtZW50LCBidXQgd2UNCiAgICAgICAg ICAgICAgICAgICAgLy8gbmVlZCB0aGUgcGFydCB0byBiZSBpbnNlcnRlZCBhcyBhIGNvbHVtbi4N CiAgICAgICAgICAgICAgICAgICAgLy8gVGhlcmVmb3JlIHdlIGV4dHJhY3QgdGhlIGNvbXBsZXRl IHdvcmQgY29udGFpbmluZw0KICAgICAgICAgICAgICAgICAgICAvLyB0aGUgdGVybSBuZXh0dmFs DQoNCkZhc3QgY2hlY2tpbmcgc3ZuIHRoaXMgaXMgYWxyZWFkeSBpbiB0aGUgY29kZSBzaW5jZSAy MDEzIChUT1JRVUUtMzA1IGZpeCApLi4NCg0KSGF2aW5nIHNhaWQgdGhhdCwgaXQgbWlnaHQgYmUg YW4gaWRlYSB0byB1c2UgdGhlIG11Y2ggc2ltcGxlciBrZXl3b3JkIHNlcmlhbCB3aGljaCBpcyBz dXBwb3J0ZWQgc2luY2UgUG9zdGdyZXNxbDkgb3IgZXZlbiBQb3N0Z3JzcWwxMCBzeW50YXggPw0K DQpCZXN0IHJlZ2FyZHMsIEdlb3JnDQoNCg0KLS0tLS1VcnNwcsO8bmdsaWNoZSBOYWNocmljaHQt LS0tLQ0KVm9uOiBHcmFoYW0gTGVnZ2V0dCB2aWEgdG9ycXVlLWRldiA8dG9ycXVlLWRldkBkYi5h cGFjaGUub3JnPiANCkdlc2VuZGV0OiBEaWVuc3RhZywgMTYuIEp1bmkgMjAyNiAwMDoxNw0KQW46 IEFwYWNoZSBUb3JxdWUgRGV2ZWxvcGVycyBMaXN0IDx0b3JxdWUtZGV2QGRiLmFwYWNoZS5vcmc+ DQpDYzogR3JhaGFtIExlZ2dldHQgPG1pbmZyaW5Ac2hhcnAuZm0+DQpCZXRyZWZmOiBSZTogVG9y cXVlNyBhbmQgcG9zdGdyZXNxbCBhdXRvaW5jcmVtZW50aW5nIHByaW1hcnkga2V5cyBub3Qgd29y a2luZw0KDQpPbiAxNSBKdW4gMjAyNiwgYXQgMjI6NTQsIEdyYWhhbSBMZWdnZXR0IDxtaW5mcmlu QHNoYXJwLmZtPiB3cm90ZToNCg0KPiBBZnRlciB1cGdyYWRpbmcgZnJvbSB0b3JxdWUzLjMgdG8g dG9ycXVlNyAoYmlnIGp1bXApLCBJIGhhdmUgZXZlcnl0aGluZyBjb21waWxpbmcsIGJ1dCB3aGF0 IGhhcyBzdWRkZW5seSB2YW5pc2hlZCBhcmUgYXV0b2luY3JlbWVudGluZyBkYXRhYmFzZSBwcmlt YXJ5IGtleXMgZm9yIHBvc3RncmVzLg0KDQpTdGVwcGluZyB0aHJvdWdoIG1vcmUgY29kZSwgSSBn ZXQgaGVyZToNCg0KICAgIHB1YmxpYyBPYmplY3RLZXk8Pz4gZG9JbnNlcnQoDQogICAgICAgICAg ICBmaW5hbCBDb2x1bW5WYWx1ZXMgaW5zZXJ0VmFsdWVzLA0KICAgICAgICAgICAgZmluYWwgQ29u bmVjdGlvbiBjb25uZWN0aW9uKQ0KICAgICAgICAgICAgICAgICAgICB0aHJvd3MgVG9ycXVlRXhj ZXB0aW9uDQogICAgew0KICAgICAgICBpZiAoaW5zZXJ0VmFsdWVzID09IG51bGwpDQogICAgICAg IHsNCiAgICAgICAgICAgIHRocm93IG5ldyBUb3JxdWVFeGNlcHRpb24oImluc2VydFZhbHVlcyBp cyBudWxsIik7DQogICAgICAgIH0NCiAgICAgICAgaWYgKGNvbm5lY3Rpb24gPT0gbnVsbCkNCiAg ICAgICAgew0KICAgICAgICAgICAgdGhyb3cgbmV3IFRvcnF1ZUV4Y2VwdGlvbigiY29ubmVjdGlv biBpcyBudWxsIik7DQogICAgICAgIH0NCiAgICAgICAgU3RyaW5nIGRhdGFiYXNlTmFtZUZyb21J bnNlcnRWYWx1ZXMgPSBpbnNlcnRWYWx1ZXMuZ2V0RGJOYW1lKCk7DQogICAgICAgIGlmIChkYXRh YmFzZU5hbWVGcm9tSW5zZXJ0VmFsdWVzID09IG51bGwpDQogICAgICAgIHsNCiAgICAgICAgICAg IGRhdGFiYXNlTmFtZUZyb21JbnNlcnRWYWx1ZXMgPSBnZXREYXRhYmFzZU5hbWUoKTsNCiAgICAg ICAgfQ0KICAgICAgICBEYXRhYmFzZSBkYXRhYmFzZSA9IFRvcnF1ZS5nZXREYXRhYmFzZShkYXRh YmFzZU5hbWVGcm9tSW5zZXJ0VmFsdWVzKTsNCiAgICAgICAgT2JqZWN0IGtleUluZm8gPSBnZXRJ ZE1ldGhvZEluZm8oKTsNCiAgICAgICAgSWRHZW5lcmF0b3Iga2V5R2VuID0gZGF0YWJhc2UuZ2V0 SWRHZW5lcmF0b3IoDQogICAgICAgICAgICAgICAgZ2V0VGFibGVNYXAoKS5nZXRQcmltYXJ5S2V5 TWV0aG9kKCkpOw0KDQogICAgICAgIFNpbXBsZUtleTw/PiBpZCA9IG51bGw7DQogICAgICAgIC8v IGNhbiBjdXJyZW50bHkgZ2VuZXJhdGUgb25seSBzaW5nbGUgY29sdW1uIHBrcywgdGhlcmVmb3Jl IGEgc2luZ2xlDQogICAgICAgIC8vIGNvbHVtbk1hcCBpcyBvaw0KICAgICAgICBDb2x1bW5NYXAg cHJpbWFyeUtleSA9IG51bGw7DQogICAgICAgIGlmIChrZXlHZW4gIT0gbnVsbCkNCiAgICAgICAg ew0KICAgICAgICAgICAgLy8gZmFpbCBvbiBtdWx0aXBsZSBwa3MNCiAgICAgICAgICAgIHByaW1h cnlLZXkgPSBnZXRUYWJsZU1hcCgpLmdldFByaW1hcnlLZXkoKTsNCg0KICAgICAgICAgICAgLy8g cHJpbWFyeUtleSB3aWxsIGJlIG51bGwgaWYgdGhlcmUgaXMgbm8gcHJpbWFyeSBrZXkNCiAgICAg ICAgICAgIC8vIGRlZmluZWQgZm9yIHRoZSB0YWJsZSB3ZSdyZSBpbnNlcnRpbmcgaW50by4NCiAg ICAgICAgICAgIGlmIChrZXlHZW4uaXNQcmlvclRvSW5zZXJ0KCkgJiYgcHJpbWFyeUtleSAhPSBu dWxsDQogICAgICAgICAgICAgICAgICAgICYmICFpbnNlcnRWYWx1ZXMuY29udGFpbnNLZXkocHJp bWFyeUtleSkpDQogICAgICAgICAgICB7DQogICAgICAgICAgICAgICAgaWQgPSBnZXRJZChwcmlt YXJ5S2V5LCBrZXlHZW4sIGNvbm5lY3Rpb24sIGtleUluZm8pOw0KICAgICAgICAgICAgICAgIGlu c2VydFZhbHVlcy5wdXQoDQogICAgICAgICAgICAgICAgICAgICAgICBwcmltYXJ5S2V5LA0KICAg ICAgICAgICAgICAgICAgICAgICAgbmV3IEpkYmNUeXBlZFZhbHVlKGlkLmdldFZhbHVlKCksIGlk LmdldEpkYmNUeXBlKCkpKTsNCiAgICAgICAgICAgIH0NCiAgICAgICAgfQ0KDQoNClRoZSBhYm92 ZSBjb2RlIGFwcGVhcnMgdG8gaGF2ZSBwaWNrZWQgdXAgdGhlIG9yZy5hcGFjaGUudG9ycXVlLmFk YXB0ZXIuSHNxbGRiQWRhcHRlciBiYXNlZCBvbiB0aGUgSkRCQyBkcml2ZXIgaW4gdGhlIHVuaXQg dGVzdHMsIGluc3RlYWQgb2YgcG9zdGdyZXMgYXMgZGVmaW5lZCBpbiB0aGUgbWF2ZW4gdG9ycXVl IHBsdWdpbjoNCg0KICAgICAgICAgICAgICAgIDx0b3JxdWUudGFyZ2V0RGF0YWJhc2U+cG9zdGdy ZXNxbDwvdG9ycXVlLnRhcmdldERhdGFiYXNlPg0KDQpoc3FsZGIgd2FzIHByZXZpb3VzbHkgaW4g cG9zdGdyZXMtbW9kZSB1c2luZyBzcWwuc3ludGF4X3Bncz10cnVlOyAtIGRvZXMgdGhhdCBubyBs b25nZXIgd29yaz8NCg0KUmVnYXJkcywNCkdyYWhhbQ0KLS0NCg0KDQo= DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0NClRvIHVuc3Vic2NyaWJlLCBlLW1haWw6IHRvcnF1ZS1kZXYt dW5zdWJzY3JpYmVAZGIuYXBhY2hlLm9yZw0KRm9yIGFkZGl0aW9uYWwgY29tbWFuZHMsIGUt bWFpbDogdG9ycXVlLWRldi1oZWxwQGRiLmFwYWNoZS5vcmcNCg0K