Is it possible to apply field order of a persistent data-class to database table?

I've noticed that if I use the persistence API to create a database table the order of the table columns is not the same as in the persistence data-class. Is it possible to keep the field order in a data-class to a database table?

persistence

asked 24.04.2014 at 10:29

Nikel Weis
(suspended)
accept rate: 57%

2 Answers:

active answers oldest newest most voted

Another solution is to create your database in SQL first and then create your persistence data clases accordingly to the SQL-Database. So it is possible to apply a certain order.

link

answered 06.06.2014 at 08:48

Nikel Weis
(suspended)
accept rate: 57%

You still need to use ORDER BY for certain queries because it is not guaranteed that your query result is in the very order of your database. So you need to manually ensure the order of your results, else you get a bug that is hard to pin down.

(06.06.2014 at 09:59) Daniel Oechslin

I think there was a misunderstanding in my question. It is not the target to have the object in a certain order. The objective was that the columns within the database are in a certain order.

(06.06.2014 at 13:03) Nikel Weis

The only solution I can think of is if you sort your data-class alphabetically and you add the ORDER BY attribute to your database query.

link

answered 02.06.2014 at 12:47

Daniel Oechslin
(suspended)
accept rate: 39%

Thanks for your reply. That would be a possibility if the database should only be created via persistence - so +1 for that. But it is also possible to do it the other way around. :)

(06.06.2014 at 08:49) Nikel Weis

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "Title")
image?![alt text](/path/img.jpg "Title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

persistence ×32

Asked: 24.04.2014 at 10:29

Seen: 2,493 times

Last updated: 06.06.2014 at 13:03

Is it possible to apply field order of a persistent data-class to database table?

Follow this question

Related questions