Convert a SQL type into something else in Speedment

Question

When Speedment generates entities from a database schema, is there some way to change the default type being generated? For an example, if I have a table like this:

create table comment (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    author_name VARCHAR(40) NOT NULL,
    posted_date TIMESTAMP NOT NULL
);

By default Speedment will generate the TIMESTAMP column as java.sql.Timestamp. Can I make it so that TIMESTAMP columns are converted into Java long values instead?

score -1 · Accepted Answer · answered May 05 '17 at 23:25

In the Tool, select the "posted_date"-column on the left side and change the "Type Mapper" property to "Timestamp to Long". When you regenerate the code, then that column will be represented as a long instead.

If you want to create a custom type mapper, there is a good tutorial for that on the Speedment GitHub page.

Convert a SQL type into something else in Speedment

1 Answers1