|
|
|
|
|
|
When i create an entity, and generate with the hibernate.hbm2ddl.auto in my persistence.xml, The "OffsetDateTime" is not "timestamp" format.
Even when manually creating the table with "timestamp", and to execute some 'insert', or 'select', an error occurs in the conversion of "OffsetDateTime".
I noticed some odd behavior, with the "TimeOffset" also, the time zone does not seem to work properly, in conversation with the database.
*My settings to exemplify.*
JDK8_u60
+ WildFly-10.0.0.CR4
+ hibernate-core 5.0.1
+ hibernate-entitymanager 5.0.1
+ hibernate-java8 5.0.1
+ postgresql-9.4-1204-jdbc42
+ PostgreSQL 9.4.5 - (timestamp=UTC)
{code:java|title=TestEntity.java}
@Entity
@Table(name="TEST_ENTITY")
public static class TestEntity {
@Id
@SequenceGenerator(name = "TEST_ENTITY_SEQ", sequenceName = "TEST_SEQ", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "TEST_ENTITY_SEQ")
@Column(name = "ID")
private Long id;
@Version
private Long myVersion;
private LocalDateTime myLocalDateTime = LocalDateTime.now();
private LocalDate myLocalDate = LocalDate.now();
private LocalTime myLocalTime = LocalTime.now();
private Instant myInstant = Instant.now();
private ZonedDateTime myZonedDateTime = ZonedDateTime.now();
private OffsetDateTime myOffsetDateTime = OffsetDateTime.now();
private OffsetTime myOffsetTime = OffsetTime.now();
private Duration myDuration = Duration.of(20, ChronoUnit.DAYS);
public TestEntity() {
}
...
...
...
{code}
{code:xml|title=persitence.xml}
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence" version="2.1">
<persistence-unit name="MyServicePU" transaction-type="JTA">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<jta-data-source>java:jboss/datasources/MyServiceDS</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<!--An SQL dialect for Postgres 9.4 and later.-->
<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQL94Dialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>
</properties>
</persistence-unit>
</persistence>
{code}
Definition of JTA connection, with the database.
{code:xml|title=standalone.xml}
<subsystem xmlns="urn:jboss:domain:datasources:4.0">
<datasources>
<datasource jndi-name="java:jboss/datasources/MyServiceDS" pool-name="MyServiceDS" enabled="true" use-java-context="true">
<connection-url>jdbc:postgresql://192.168.1.111:5432/my_database</connection-url>
<driver>postgresql</driver>
<security>
<user-name>test_user</user-name>
<password>test_user</password>
</security>
<validation>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<validate-on-match>true</validate-on-match>
<background-validation>false</background-validation>
</validation>
</datasource>
<drivers>
<driver name="postgresql" module="org.postgresql">
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
{code}
Configuration of the module for wildfly to initialize.
{code:xml|title=module.xml}
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.3" name="org.postgresql">
<resources>
<resource-root path="postgresql-9.4-1204-jdbc42.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>
{code}
after starting the application server.
INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 4) HHH000228: Running hbm2ddl schema update
{code:sql|title=Table}
TABLE TEST_ENTITY
(
id bigint NOT NULL,
myversion bigint,
myduration bigint,
myinstant timestamp without time zone,
mylocaldate date,
mylocaldatetime timestamp without time zone,
mylocaltime time without time zone,
myoffsetdatetime character varying(255),
myoffsettime time without time zone,
myzoneddatetime timestamp without time zone
)
{code}
{color:red}
-----> myoffsetdatetime character varying(255)
{color}
editing...
|
|
|
|
|
|
