ORVE WS (Dynamic) (11) Persisting retrieved records and other control information (3). Table creation

0. Introduction

Now that the JPA entities have been defined in the ximodante.sicres.multiclassjpa package it is time to let JPA create tables for us in the database.

This link has been followed

1. Creation of Tables in the schema


Here is a simple class for this purpose



 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
package ximodante.jpamanager;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class JPATest {
  
 /**
   * @param args
   */
 EntityManagerFactory emf = null;
 EntityManager em = null;
   
 /**
  * This is only for creating tables
  * @param args
  */
 public static void main(String[] args) {
 // TODO Auto-generated method stub
  
  EntityManagerFactory emf = Persistence.createEntityManagerFactory("sicresh2");
  EntityManager em = emf.createEntityManager();
    
  persistSomeData(em);
  em.close();
  emf.close();
 }
   
 /**
  * squeleton to persist instances
  * @param em
  */
 private static void persistSomeData (EntityManager em ) {
  em.getTransaction().begin();
     /*
  em.persist (new Party("MyParty"     ,"This is my party name"));
     */
     em.getTransaction().commit();   
  }
  
}

When executing this code, we get this output, conforming table creation


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Hibernate: create table SICRES30.DEANEXO (id bigint generated by default as identity, anexo binary(255), certificado binary(255), firmaDocumento binary(255), hash binary(255), identificadorDocumentoFirmado varchar(255), identificadorFichero varchar(255), nombreFicheroAnexado varchar(255), observaciones varchar(255), timeStamp binary(255), tipoDocumento varchar(255), tipoMIME varchar(255), validacionOCSPCertificado binary(255), validezDocumento varchar(255), primary key (id))
Hibernate: create table SICRES30.DEASUNTO (id bigint generated by default as identity, codigoAsuntoSegunDestino varchar(255), numeroExpediente varchar(255), referenciaExterna varchar(255), resumen varchar(255), primary key (id))
Hibernate: create table SICRES30.DEDESTINO (id bigint generated by default as identity, codigoEntidadRegistralDestino varchar(255), codigoUnidadTramitacionDestino varchar(255), decodificacionEntidadRegistralDestino varchar(255), decodificacionUnidadTramitacionDestino varchar(255), primary key (id))
Hibernate: create table SICRES30.DEFORMULARIOGENERICO (id bigint generated by default as identity, expone varchar(255), solicita varchar(255), primary key (id))
Hibernate: create table SICRES30.DEINTERESADO (id bigint generated by default as identity, canalPreferenteComunicacionInteresado varchar(255), canalPreferenteComunicacionRepresentante varchar(255), codigoPostalInteresado varchar(255), codigoPostalRepresentante varchar(255), correoElectronicoInteresado varchar(255), correoElectronicoRepresentante varchar(255), direccionElectronicaHabilitadaInteresado varchar(255), direccionElectronicaHabilitadaRepresentante varchar(255), direccionInteresado varchar(255), direccionRepresentante varchar(255), documentoIdentificacionInteresado varchar(255), documentoIdentificacionRepresentante varchar(255), municipioInteresado varchar(255), municipioRepresentante varchar(255), nombreInteresado varchar(255), nombreRepresentante varchar(255), observaciones varchar(255), paisInteresado varchar(255), paisRepresentante varchar(255), primerApellidoInteresado varchar(255), primerApellidoRepresentante varchar(255), provinciaInteresado varchar(255), provinciaRepresentante varchar(255), razonSocialInteresado varchar(255), razonSocialRepresentante varchar(255), segundoApellidoInteresado varchar(255), segundoApellidoRepresentante varchar(255), telefonoContactoInteresado varchar(255), telefonoContactoRepresentante varchar(255), tipoDocumentoIdentificacionInteresado varchar(255), tipoDocumentoIdentificacionRepresentante varchar(255), primary key (id))
Hibernate: create table SICRES30.DEINTERNOSCONTROL (id bigint generated by default as identity, aplicacionVersionEmisora varchar(255), codigoEntidadRegistralInicio varchar(255), contactoUsuario varchar(255), decodificacionEntidadRegistralInicio varchar(255), descripcionTipoAnotacion varchar(255), documentacionFisica varchar(255), identificadorIntercambio varchar(255), indicadorPrueba varchar(255), nombreUsuario varchar(255), numeroTransporteEntrada varchar(255), observacionesApunte varchar(255), tipoAnotacion varchar(255), tipoRegistro varchar(255), tipoTransporteEntrada varchar(255), primary key (id))
Hibernate: create table SICRES30.DEORIGENOREMITENTE (id bigint generated by default as identity, codigoEntidadRegistralOrigen varchar(255), codigoUnidadTramitacionOrigen varchar(255), decodificacionEntidadRegistralOrigen varchar(255), decodificacionUnidadTramitacionOrigen varchar(255), fechaHoraEntrada varchar(255), numeroRegistroEntrada varchar(255), timestampEntrada binary(255), primary key (id))
Hibernate: create table SICRES30.FICHEROINTERCAMBIOSICRES30 (id bigint generated by default as identity, deAsunto_id bigint, deDestino_id bigint, deFormularioGenerico_id bigint, deInternosControl_id bigint, deOrigenORemitente_id bigint, primary key (id))
Hibernate: alter table SICRES30.DEORIGENOREMITENTE drop constraint if exists UKo1issakhpgmo7qg9gq4d1utfl
Hibernate: alter table SICRES30.DEORIGENOREMITENTE add constraint UKo1issakhpgmo7qg9gq4d1utfl unique (numeroRegistroEntrada)
Hibernate: create table FICHEROINTERCAMBIOSICRES30_DEANEXO (FicheroIntercambioSICRES3_id bigint not null, deAnexo_id bigint not null)
Hibernate: create table FICHEROINTERCAMBIOSICRES30_DEINTERESADO (FicheroIntercambioSICRES3_id bigint not null, deInteresado_id bigint not null)
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEANEXO drop constraint if exists UK_8d5ledff9w6cbv3vm2tmaa1l7
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEANEXO add constraint UK_8d5ledff9w6cbv3vm2tmaa1l7 unique (deAnexo_id)
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEINTERESADO drop constraint if exists UK_olvtrqlhrktfusdtnsin5rtay
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEINTERESADO add constraint UK_olvtrqlhrktfusdtnsin5rtay unique (deInteresado_id)
Hibernate: alter table SICRES30.FICHEROINTERCAMBIOSICRES30 add constraint FKllhp2cknom68rah9crw1gfuny foreign key (deAsunto_id) references SICRES30.DEASUNTO
Hibernate: alter table SICRES30.FICHEROINTERCAMBIOSICRES30 add constraint FKgta1xwo279c9wjbcorrdhnvsx foreign key (deDestino_id) references SICRES30.DEDESTINO
Hibernate: alter table SICRES30.FICHEROINTERCAMBIOSICRES30 add constraint FK10q955etbue9u4j7omb8grbch foreign key (deFormularioGenerico_id) references SICRES30.DEFORMULARIOGENERICO
Hibernate: alter table SICRES30.FICHEROINTERCAMBIOSICRES30 add constraint FKikfpl8db4aw1qd5ynhpnvj28d foreign key (deInternosControl_id) references SICRES30.DEINTERNOSCONTROL
Hibernate: alter table SICRES30.FICHEROINTERCAMBIOSICRES30 add constraint FKccapa30nepk0m9peery6eetaw foreign key (deOrigenORemitente_id) references SICRES30.DEORIGENOREMITENTE
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEANEXO add constraint FKew61ao2g4lg1w4w4ftnlklhc1 foreign key (deAnexo_id) references SICRES30.DEANEXO
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEANEXO add constraint FKga7iox5wadcccvjc7ehq50mq3 foreign key (FicheroIntercambioSICRES3_id) references SICRES30.FICHEROINTERCAMBIOSICRES30
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEINTERESADO add constraint FKcl1ogdcurpver8n82bky28vu0 foreign key (deInteresado_id) references SICRES30.DEINTERESADO
Hibernate: alter table FICHEROINTERCAMBIOSICRES30_DEINTERESADO add constraint FKiajvtv59apgukyr1k4iac7y6g foreign key (FicheroIntercambioSICRES3_id) references SICRES30.FICHEROINTERCAMBIOSICRES30

So far so good

Comments

Post a Comment

Popular posts from this blog

ORVE WS (Dynamic) (4) Jackson XML mapper

0. Introduction I love Jackson parser as it is easy to use and can be used to with some data formats such as CSV ,  JSON , YAML and XML . Just define a wrapper and a class for marshalling/unmarshalling. Although JAXB is a standard, in the Java ecosystem exists many solutions. And my decision is to use Jackson. 1. Defining MAVEN dependencies To use Jackson XML it is required this dependency in Maven. Note that  ${jackson.version} represents a variable that contains preferably the latest Jackson version. 1 2 3 4 5 <dependency> <groupId> com.fasterxml.jackson.dataformat </groupId> <artifactId> jackson-dataformat-xml </artifactId> <version> ${jackson.version} </version> </dependency> But if you want to use CSV, JSON or YAML in the project, it is as easy as including these dependencies 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 <!-- Jackson for CSV --> <de...
Read more

ENI (1) ENI Document OR the Spanish Electronic Administration Mafia

Image
0.Introduction. Getting the "xsd" schemas 1. Obtaining the afirma.xsd 2. Managing the "xsd" schemas. Changing  schemalocation  property from the  xsd  tag 3. Generating classes from xsd schema 4. Modifying the classes to solve operational problems 0. Old version 1. Generating the classes 0.Introduction. Getting the "xsd" schemas To obtain the correct URLs of the schemas: 1.For the document: https://administracionelectronica.gob.es/ENI/XSD/v1.0/documento-e in this URL it is shown these schemas (click on the link and download the schemas): http://administracionelectronica.gob.es/ENI/XSD/v1.0/documento-e/documentoEni.xsd http://administracionelectronica.gob.es/ENI/XSD/v1.0/documento-e/metadatos/metadatosDocumentoEni.xsd http://administracionelectronica.gob.es/ENI/XSD/v1.0/documento-e/contenido/contenidoDocumentoEni.xsd http://administracionelectronica.gob.es/ENI/XSD/v1.0/firma/firmasEni.xsd 2. For the file (expediente) https://administracionelectronica.gob.es...
Read more

ORVE WS (Dynamic) (12) Defiining the control tables

0. Introduction Our goals are: Retrieving the INPUT records (Received from other administrations) Retrieving the OUTPUT records (Sent to other administrations) To retrieve any record the WS requires at least these parameters   1. State (Estado). For INPUT these are the available states: RPC : Received but confirmation pending RR : Received and rejected RC : Received and confirmed RREEN : Received and resent      For OUTPUT : PE : Pending delivery EPC : Sent but confirmation is pending ER : Sent but rejected EC : Sent and confirmed 2. Date from in " YYYY-MM-DD HH:MM:SS " format 3. Date to in the same format. The system knows who is our administration (Oficina or Office) 1. Additional tables or entities We need to have control of: "Ids" that can identify the records and if the records have been saved and passed to the Gexflow application (an application that controls our records). To get the "Ids", the WS operation...
Read more