sql maven plugin write file in target encoding.

Sql-maven-plugin is used to execute database queries as part of build steps. It can also generate files from database queries. It is an excellent tool when it comes to generating file where certain application parameters are saved in a database and are needed by an application as properties.

Some applications save configuration parameters in the database but do not want to read it from the database at runtime, because of various business or architecture compliances.

These applications rather produce configuration files from the database as part of the build step and use them as application properties as resource bundle.

One good use is for locale messages. applications supporting multiple languages, generate message files of different locale from database tables, which are usually managed by business teams. Locale support needs specific encodings, which is not supported by out of the box by popular sql-maven-plugin from codehaus.

The maven plugin code at GitHub.com has a pull request for this additional feature but not sure why they have not merged the code.

I forked the code from their repository to create a plugin with the required feature so users can specify the encoding of an output file.

The code for the same is located at https://github.com/vbhavsingh/sql-maven-plugin

For more information on plugin visit https://www.mojohaus.org/sql-maven-plugin



<plugin>
    <groupId>net.rationalminds</groupId>
    <artifactId>sql-maven-plugin</artifactId>
    <version>1.0</version>
    <executions>
      <execution>
        <id>generate.messages</id>
        <phase>generate-resources</phase>
        <goals>
          <goal>execute</goal>
        </goals>
        <configuration>
          <autocommit>replace_me</autocommit>
          <printResultSet>true</printResultSet>
          <outputDelimiter>row</outputDelimiter>
          <srcFiles>
            <srcFile>replace_me</srcFile>
          </srcFiles>
          <outputFile>replace_me</outputFile>
          <driver>replace_me</driver>
          <url>replace_me</url>
          <username>replace_me</username>
          <password>replace_me</password> 
          <outputEncoding>UTF-8</outputEncoding>  <!-- Specify encoding out output file-->     
        </configuration>
      </execution>         
    </executions>
    <dependencies>
      <dependency>
        <groupId>replace_me</groupId>
        <artifactId>replace_me</artifactId>
        <version>replace_me</version>
        <scope>compile</scope>
      </dependency>
    </dependencies>
    <configuration>
      <driver>replace_me</driver>
      <url>replace_me</url>
      <username>replace_me</username>
      <password>replace_me</password>
    </configuration>
  </plugin>

Comments

Post a Comment

Popular posts from this blog

Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

Many times we encounter this error and think that there might be some JPA issue or network issue. However, the error is pretty explicit in its nature, but still not clear to ring the bell very first time. As the error says there is a timeout, and since Oracle is saying, we shall accept it. Another clue is "user requested cancel of current operation". This means that the connection was closed by the application server not the database server, hence it can be safely concluded that application has configured timeouts on transactions at its end. However, if you feel that this transaction should have been concluded within the application server limits, your doubt might be true. This problem can arise in case there is a lock on the record being updated by JPA or lock on the table in which JPA is attempting to insert. The lock is most probably being held by some other application, and since application server configuration is on aggressive SLA, the transaction is waiting its
Read more

HashiCorp Vault Integration with Ansible Etower using approle

Image
HashiCorp Vault is  a secrets management tool specifically designed to control access to sensitive credentials in a low-trust environment . It can be used to store sensitive values and at the same time dynamically generate access for specific services/applications on lease.  Integrating the vault with Ansible Etower provides robust and secure automation. Following is the step-by-step guide for the integration. Enable key-value secret engine in Hashi Vault (also known as "kv" engine). Let's call the engine, the "kv" engine. Create a secret inside "kv". A secret can be a collection of key-value pairs or a JSON for nested structure.            Lets assume that secrets are stored as JSON  in the format   { "my_app":{ "service_account_name": "some_service", "service_account_password": "some_password" } } Create a secret policy defining what can be done with the above-defined secret. Create an
Read more

utility to extract date from text with java

Image
A date pattern recognition algorithm to not only identify date pattern but also fetches probable date in Java date format. This algorithm is very fast and lightweight. The processing time is linear and all dates are identified in a single pass. Algorithm resolves date using tree traverse mechanism. Tree data structures are custom created to build supported date, time and month patterns. Following Trees are used (Note: ^ sign denotes complete pattern) DATE PATTERN TREE Month Pattern Tree (Jan and January both are valid, identified using ^ sign) Time pattern (Identified as suffix to Date, $ sign indicates SPACE character) Tree structures are used in the following algorithm.  Date Part Identification algorithm flowchart Time part identification algorithm flowchart These flow charts are self-explanatory in most part. --> sign is used to denote next match in respective tree structures. The algorithm also acknowledges multipl
Read more