generate DB record id in the DB and not in java | Java Community | Help. Code. Learn. | Page 1

lean fox Jul 10, 2024, 12:40 PM

#

hey guys. i have pojo that is being inserted into my DB. i dont want to have id field in my pojo and let my DB generate record id. can i do it somehow? thanks

frozen grottoBOT Jul 10, 2024, 12:40 PM

#

⌛ This post has been reserved for your question.

Hey @lean fox! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

rough kiln Jul 10, 2024, 2:24 PM

#

Is your Pojo an Entity?

#

What is your database vendor? Postgres, Oracle, Mysql?

ornate rampart Jul 10, 2024, 2:28 PM

#

My questions would be what counts as the DB and what counts as Java.
As far as the DB is concerned, objects don't exist. you call INSERT statements to it. That's it.
Admittedly some while allow to create columns where an id is automatically created when inserting a row in their table, but that doesn't sound much like what's asked.

rough kiln Jul 10, 2024, 3:30 PM

#

@ornate rampart Depends, Postgres usually use a sequence to notify the next free number. Oracle 12c can use the new built-in column type identity (https://oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1) what is the most clean solution. The primary-key annotation must differ depending on the database implementation!

ornate rampart Jul 10, 2024, 3:33 PM

#

rough kiln <@996096255237296269> Depends, Postgres usually use a sequence to notify the nex...

......... That doesn't address what I was saying

rough kiln Jul 10, 2024, 5:37 PM

#

ornate rampart ......... That doesn't address what I was saying

Yes, sorry, you are right.

#generate DB record id in the DB and not in java