ORVE WS (Dynamic) (9) Persisting retrieved records and other control information (1). H2 DB proposal

0. Introduction

As ORVE WS will have a daily usage, it is important to have a control, so  it is required to:

  1. Persist all retrieved records.
  2. Have a logging system for failures.
  3. Know the last date the records were requested with success.
  4. Persist the which "ids" where not successfully retrieved.
So we need a simple database management system for this purpose as this is not a critical system. It can be helped by a property file.

A DBMS candidate for this is H2. Hibernate JPA is a good system to access this DBMS using Java.

1.Installing and testing H2


It can be downloaded from the H2 page, and unzipped into a folder.

Open a console and go to the "bin" subfolder and run


java -jar h2*.jar

but if we want that anybody can access our database this command should be executed


java -jar h2*.jar -webAllowOthers -tcpAllowOthers


A new tab is opened in Firefox


If the "Test Connection" button is pressed then the "Test successful" message is displayed.

If we open a new window in another browser and type this URL "127.0.1.1:8082" we can get another console window.

NOTES:

  1. When using the "Test Connection" button for the first time, it is created a new database file. In this case the JDBC URL field (jdbc:h2:~/test) indicates that the database file is in the ~ folder (/home/myuser) and is something similar to "test*" (in my case is "test.mv.db"). But you must supply a user and a password and remember these values or else you will not be able to connect to this recently created database.
  2. When using this button the next times, no database is created, and if you don't provide the user and password, the test will fail.

2. Server mode


If we fillthe JDBC URL field with:

jdbc:h2:tcp://localhost/~/test

Then the access is server mode as a server (localhost) is referenced

3. Where are my Data Files?


I think that "~" represents my home directory (/home/myuser) in Ubuntu, so //localhost/~/test references "/home/myuser/test.mv.db" file

This file name can have some changes depending on the h2 version.

4. Creating SICRES30 Schema

Let's create the schema SICRES30 for organizing purposes. Type


CREATE SCHEMA  SICRES30

And the schema appears in the console





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

AutoFirma ins and outs (4). Errors in tests in afirma-core, jmulticard-jse

Image
 1. The package org.xml.sax is accessible from more than one module: <unnamed>, java.xml and TestMIMEDetection failure This error is produced in the afirma-core project to solve the error in TestMIMEDetection . At fist to solve it, the " Apache xerces " dependecy is added to the build.gradle, In StackOverflow explains that a package is both in the Modulepath and in the Classpath . The ModulePath is the jdk or jre that is being used and the Classpath is formed by the libraries that are imported. Usually, the packages that begin with "java." or "javax." cannot be included in the Classpath as they should be in the jdk. In the menu option " Configure build path " you can see this option. The dependencies in the build.gradle are: api libs . jmimemagic api libs . xerces The library that has conflictive dependencies is "xerces".  To solve this problem in Gradle click on "Project and External Dependencies" to see th...
Read more

Creating a WS Client consumer

Image
Creating the client consumer I was expected to develop a client consumer of a WS. So I began to google out and find Apache CXF project. Here are the main steps: 1. Get the URL of the WDSL in my case was an intranet     http://xxx.xxx.xxx.xxx:8080/gexflow/ws/Registro_v2.0?wsdl     where xxx.xxx.xxx.xxx is the IP address (for instance 110.12.3.1) 2. Download Apache CXF. 3. Extract into a folder 3.1. Verify that you have set the variable JAVA_HOME to the folder where the java is installed, now you can use java >9. For instance, you can type in the terminal:     export JAVA_HOME=/usr/java/jdk-13.0.2 //in java version >13 doesn't work  using apache cxf 3.3.6 version, but java 17 works in csf version 3.5.4 3.2. Verify that the " bin" directory of the apache-cxf-xxxxx directory is available in the path.  For instance, you can type in the terminal:      export PATH=$PATH:/home/ximo/MyPrograms/apache-cxf-3.3.6/bi...
Read more