Ahoj.
Laborujem s postgres + glassfish a persistenciou. Tabulky si zatial nechavam
generovat persistentnou vrstvou.
Moj problem je, ze sa nevytvara sequence, napriek tomu, ze som to anotoval.
Utrzky kodu a konfiguracie:
@Entity
public class ClientRequest implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@SequenceGenerator(name = "MYSEQUENCE", sequenceName = "mysequence")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator
= "MYSEQUENCE")
@Column(name = "id", nullable = false)
private Long id;
<persistence-unit name="appVersionPU" transaction-type="JTA">
<provider>oracle.toplink.essentials.PersistenceProvider</provider>
<jta-data-source>jdbc/test</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="toplink.logging.level" value="FINER"/>
<property name="toplink.target-database" value="PostgreSQL"/>
<property name="toplink.ddl-generation" value="create-tables"/>
</properties>
</persistence-unit>
Log z aplikacneho servera:
... connecting(DatabaseLogin(
... CREATE TABLE CLIENTREQUEST (id SERIAL NOT NULL, CUSTOMERCOMPANY
VARCHAR(255), CUSTOMERSERIAL VARCHAR(255), CUSTOMERNAME VARCHAR(255), APPNAME
VARCHAR(255), CLIENTIP VARCHAR(255), PRIMARY KEY (id))
... INSERT INTO CLIENTREQUEST (CUSTOMERCOMPANY, CUSTOMERSERIAL, CUSTOMERNAME,
APPNAME, CLIENTIP) VALUES (?, ?, ?, ?, ?)
...select currval('mysequence')
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build 36
(02/17/2007))): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR:
relation "mysequence" does not existError Code: 0
Call:select currval('mysequence')
Query:ValueReadQuery()
Moja otazka znie, preco ta sekvencia nebola vytvorena. Tusi niekto?
Diky
--
Dusan
... tykajte mi
