Maven Auto PLSQL/SP Generator Plugin

Maven plugin to generate Java classes from StoredProcedure and Functions in Database

Лицензия	Лицензия GPL-3.0
Категории	Категории Auto Библиотеки уровня приложения Code Generators
Группа	Группа com.github.yadickson
Идентификатор	Идентификатор autoplsp
Последняя версия	Последняя версия 1.7.28
Дата	Дата 3 февр. 2020 г.
Тип	Тип maven-plugin
Описание	Описание Maven Auto PLSQL/SP Generator Plugin Maven plugin to generate Java classes from StoredProcedure and Functions in Database
Ссылка на сайт	Ссылка на сайт https://github.com/yadickson/autoplsp
Организация-разработчик	Организация-разработчик Yadickson Soto
Система контроля версий	Система контроля версий https://github.com/yadickson/autoplsp

Скачать autoplsp

Имя Файла	Размер
autoplsp-1.7.28.pom
autoplsp-1.7.28.jar	146 KB
autoplsp-1.7.28-sources.jar	136 KB
autoplsp-1.7.28-javadoc.jar	895 KB
Обзор

Как подключить последнюю версию

Apache Maven

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>1.7.28</version>
</plugin>

Зависимости

compile (7)

Идентификатор библиотеки	Тип	Версия
org.apache.maven : maven-plugin-api	jar	3.5.2
org.apache.maven.plugin-tools : maven-plugin-tools-api	jar	3.5
org.apache.maven.plugin-tools : maven-plugin-annotations	jar	3.5
org.freemarker : freemarker	jar	2.3.23
commons-lang : commons-lang	jar	2.6
commons-io : commons-io	jar	2.5
commons-dbutils : commons-dbutils	jar	1.7

test (3)

Идентификатор библиотеки	Тип	Версия
junit : junit	jar	4.12
org.jmockit : jmockit	jar	1.37
org.mockito : mockito-core	jar	1.10.19

Модули Проекта

Данный проект не имеет модулей.

Maven Auto PLSQL/SP Generator Plugin

Maven plugin to generate Java classes from StoredProcedure and Functions in Database

Support

Oracle DataBase 11g and 12c
Basic PostgresSQL
Basic SQL Server (Tested 2017, Driver jTDS)
Java >= 7
Spring Framework >= 4
Auto package name detection
Configuration file generation for Spring
Use output parameters to evaluate process
Transaction annotation
Command line for driver, user, pass and connectionString parameters
JsonNonNull support

Examples

Oracle

Procedures
Functions
Numerics (NUMBER, DECIMAL, INTEGER, FLOAT, REAL, DEC, INT, SMALLINT, BINARY_DOUBLE, BINARY_FLOAT)
Texts (CHAR, NCHAR, VARCHAR, VARCHAR2, NVARCHAR2)
Lobs (CLOB, NCLOB, BLOB)
Time (DATE, TIMESTAMP)
ROWID and UROWID
REF CURSOR (only output)
TYPE OBJECT (only input)
TYPE TABLE [NATIVE] (only input)
TYPE TABLE [TYPE OBJECT] (only input)

PostgresSQL

Procedures
Functions
Numerics (INTEGER, REAL)
Texts (TEXT, CHARACTER)
Working in progress

SQL Server

Procedures
Functions
Numerics (INT, BIGINT, SMALLINT, TINYINT, DECIMAL, NUMERIC, FLOAT, REAL, BIT, MONEY, SMALLMONEY)
Texts (CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, NTEXT)
Binaries (BINARY, VARBINARY, IMAGE)
Time (DATE, TIME, DATETIME, DATETIME2, DATETIMEOFFSET, SMALLDATETIME)
REF CURSOR (Not supported)
Working in progress

POM properties

<properties>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>

POM dependencies

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.x.x.RELEASE</version>
    <scope>provided</scope>
</dependency> 

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>4.x.x.RELEASE</version>
    <scope>provided</scope>
</dependency> 
        
<dependency>
    <groupId>commons-io</groupId>
    <artifactId>commons-io</artifactId>
    <version>2.5</version>
    <scope>provided</scope>
</dependency>

<dependency>
    <groupId>javax.annotation</groupId>
    <artifactId>javax.annotation-api</artifactId>
    <version>1.3.2</version>
    <scope>provided</scope>
</dependency>

<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.5.0</version>
    <scope>provided</scope>
</dependency>

Oracle

<dependency>
    <groupId>com.jslsolucoes</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.1.0</version>
    <scope>provided</scope>
</dependency>

PostgreSQL

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>42.1.4</version>
    <scope>provided</scope>
</dependency>

SQL Server

<dependency>
    <groupId>net.sourceforge.jtds</groupId>
    <artifactId>jtds</artifactId>
    <version>1.3.1</version>
    <scope>provided</scope>
</dependency>

POM plugin config

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>...</version>
    <executions>
        <execution>
            <goals>
                <goal>generator</goal>
            </goals>
        </execution>
    </executions>
    <configuration>
        <driver>...</driver>
        <connectionString>...</connectionString>
        <user>...</user>
        <pass>...</pass>
        <javaDataSourceName>...DataSource</javaDataSourceName>
        <javaJdbcTemplateName>...JdbcTemplate</javaJdbcTemplateName>
        <jndiDataSourceName>JDBC/...</jndiDataSourceName>
        <objectSuffix>Object</objectSuffix>
        <arraySuffix>Array</arraySuffix>
        <outputDirectory>...</outputDirectory>
        <outputDirectoryResource>...</outputDirectoryResource>
        <folderNameGenerator>...</folderNameGenerator>
        <folderNameResourceGenerator>...</folderNameResourceGenerator>
        <outputConfigFileName>...</outputConfigFileName>
        <outParameterCode>...</outParameterCode>
        <outParameterMessage>...</outParameterMessage>
        <javaPackageName>...</javaPackageName>
        <jsonNonNull>...</jsonNonNull>
        <includes>
            <param>...</param>
            <param>...</param>
        </includes>
        <excludes>
            <param>...</param>
            <param>...</param>
        </excludes>
        <mappers>
            <param>...</param>
            <param>...</param>
        </mappers>
        <resultset>
            <param>...</param>
            <param>...</param>
        </resultset>
        <tables>
            <param>...</param>
            <param>...</param>
        </tables>
    </configuration>
    <dependencies>
        <dependency>
            <groupId>...driver..</groupId>
            <artifactId>..driver..</artifactId>
            <version>..version..</version>
        </dependency>
    </dependencies>
</plugin>

driver (required)

JDBC Driver class name, examples:

oracle.jdbc.driver.OracleDriver

org.postgresql.Driver

net.sourceforge.jtds.jdbc.Driver

connectionString (required)

Database connection string, examples:

jdbc:oracle:thin:@${host}:${port}:${db}

jdbc:postgresql://${host}:${port}/${db}

jdbc:jtds:sqlserver://${host}:${port}/${db}

user (required)

Database username

pass (required)

Database password

javaDataSourceName (required)

Datasource stereotype name

javaJdbcTemplateName (optional, default jdbcTemplate)

JdbcTemplate stereotype name

jndiDataSourceName (required)

Datasource JNDI name

outputConfigFileName (optional)

Default value ${project.artifactId}-context.xml

outParameterCode (optional - default value OUT_RETURN_CODE)

Output parameter code to evaluate process.

If code is Zero (O), OK

If code is not Zero (0), throw SQLException (OUT_RETURN_MSG, null, OUT_RETURN_CODE)

outParameterMessage (optional - default value OUT_RETURN_MSG)

Output parameter message.

javaPackageName (required)

Package name for Java classes

jsonNonNull (optional - default value false) (since 1.7.12)

Add @JsonInclude(JsonInclude.Include.NON_NULL) annotation.

includes -> include sp (optional, default .*)

Regular expression to include procedure and functions names, example SP_YES.*

excludes -> exclude sp (optional, default none)

Regular expression to exclude procedure and functions names, example SP_NOT.*

resultset -> resultset (optional, default .*)

Regular expression to find resultset on procedure and functions names, example SP_YES.*

Command line support

mvn clean package -Dautoplsp.driver=... -Dautoplsp.connectionString=... -Dautoplsp.user=... -Dautoplsp.pass=...

POM Basic Configuration (include all procedure and function)

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>...</version>
    <executions>
        <execution>
            <goals>
                <goal>generator</goal>
            </goals>
            <configuration>
                <driver>...</driver>
                <connectionString>...</connectionString>
                <user>...</user>
                <pass>...</pass>
                <javaDataSourceName>...DataSource</javaDataSourceName>
                <jndiDataSourceName>JDBC/...</jndiDataSourceName>
                <javaPackageName>...</javaPackageName>
            </configuration>
        </execution>
    </executions>
    <dependencies>
        <dependency>
            <groupId>...driver..</groupId>
            <artifactId>..driver..</artifactId>
            <version>..version..</version>
        </dependency>
    </dependencies>
</plugin>

POM Basic Configuration (include one procedure)

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>...</version>
    <executions>
        <execution>
            <goals>
                <goal>generator</goal>
            </goals>
            <configuration>
                <driver>...</driver>
                <connectionString>...</connectionString>
                <user>...</user>
                <pass>...</pass>
                <javaDataSourceName>...DataSource</javaDataSourceName>
                <jndiDataSourceName>JDBC/...</jndiDataSourceName>
                <outputDirectory>...</outputDirectory>
                <javaPackageName>...</javaPackageName>
                <includes>
                    <param>SP_ADD_VALUES</param>
                </includes>
            </configuration>
        </execution>
    </executions>
    <dependencies>
        <dependency>
            <groupId>...driver..</groupId>
            <artifactId>..driver..</artifactId>
            <version>..version..</version>
        </dependency>
    </dependencies>
</plugin>

POM Basic Configuration (include two procedures)

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>...</version>
    <executions>
        <execution>
            <goals>
                <goal>generator</goal>
            </goals>
            <configuration>
                <driver>...</driver>
                <connectionString>...</connectionString>
                <user>...</user>
                <pass>...</pass>
                <javaDataSourceName>...DataSource</javaDataSourceName>
                <jndiDataSourceName>JDBC/...</jndiDataSourceName>
                <outputDirectory>...</outputDirectory>
                <javaPackageName>...</javaPackageName>
                <includes>
                    <param>SP_ADD_VALUES</param>
                    <param>SP_SUB_VALUES</param>
                </includes>
            </configuration>
        </execution>
    </executions>
    <dependencies>
        <dependency>
            <groupId>...driver..</groupId>
            <artifactId>..driver..</artifactId>
            <version>..version..</version>
        </dependency>
    </dependencies>
</plugin>

POM Basic Configuration (exclude one procedure)

<plugin>
    <groupId>com.github.yadickson</groupId>
    <artifactId>autoplsp</artifactId>
    <version>...</version>
    <executions>
        <execution>
            <goals>
                <goal>generator</goal>
            </goals>
            <configuration>
                <driver>...</driver>
                <connectionString>...</connectionString>
                <user>...</user>
                <pass>...</pass>
                <javaDataSourceName>...DataSource</javaDataSourceName>
                <jndiDataSourceName>JDBC/...</jndiDataSourceName>
                <outputDirectory>...</outputDirectory>
                <javaPackageName>...</javaPackageName>
                <excludes>
                    <exculde>SP_DIV_VALUES</exculde>
                </excludes>
            </configuration>
        </execution>
    </executions>
    <dependencies>
        <dependency>
            <groupId>...driver..</groupId>
            <artifactId>..driver..</artifactId>
            <version>..version..</version>
        </dependency>
    </dependencies>
</plugin>

How to evaluate result code

Examples

CREATE OR REPLACE PROCEDURE SP_PROCEDURE
(
    OUT_P_CODE OUT NUMBER,
    OUR_P_MSG OUT VARCHAR2
)
AS
BEGIN

    NULL;

END SP_PROCEDURE;

CREATE OR REPLACE FUNCTION FN_FUNCTION
(
    OUT_P_CODE OUT NUMBER,
    OUR_P_MSG OUT VARCHAR2
)
RETURN NUMBER
AS
BEGIN

    RETURN 0;

END FN_FUNCTION;

Build project

mvn clean package install

Configuration file generated

spring/database/[outputConfigFileName]

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="
            http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.0.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx.xsd">

    <bean id="..." name="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" >
        <property name="jndiName" value="..." />
        <property name="resourceRef" value="true" />
        <property name="proxyInterface" value="javax.sql.DataSource" />
    </bean>
    
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="..."/>
    </bean>

    <bean id="..." name="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" >
        <property name="dataSource" ref="..." />
    </bean>

    <context:component-scan base-package="....repository"/>

</beans>

Configuration in the parent project

Add import resource in root-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">

    ...

    <import resource="classpath*:spring/database/[outputConfigFileName]" />

</beans>

Transaction annotation example

@Service
public class CustomServiceImpl implements CustomService {

...

    @Transactional(rollbackFor = CustomException.class)
    @Override
    public Long customMethod() throws CustomException {
        dao1.execute(...);
        dao2.execute(...);
    }
}

Версии библиотеки

Версия
1.7.28 3 февр. 2020 г.
1.7.27 3 февр. 2020 г.
1.7.26 28 янв. 2020 г.
1.7.25 28 янв. 2020 г.
1.7.24 21 янв. 2020 г.
1.7.23 20 янв. 2020 г.
1.7.22 17 янв. 2020 г.
1.7.21 14 янв. 2020 г.
1.7.20 13 янв. 2020 г.
1.7.19 30 дек. 2019 г.
1.7.18 28 нояб. 2019 г.
1.7.17 27 нояб. 2019 г.
1.7.15 8 авг. 2019 г.
1.7.14 31 июл. 2019 г.
1.7.11 29 июл. 2019 г.
1.7.10 29 июл. 2019 г.
1.7.9 26 июл. 2019 г.
1.7.8 24 июл. 2019 г.
1.7.7 23 июл. 2019 г.
1.7.6 22 июл. 2019 г.
1.7.5 22 мая 2019 г.
1.7.4 3 мая 2019 г.
1.7.3 26 апр. 2019 г.
1.7.2 26 апр. 2019 г.
1.7.1 18 нояб. 2018 г.
1.7.0 16 нояб. 2018 г.
1.6.0 25 сент. 2018 г.
1.5.4 17 авг. 2018 г.
1.5.2 10 авг. 2018 г.
1.5.0 16 июл. 2018 г.
1.4.2 13 июл. 2018 г.
1.4.1 13 июл. 2018 г.
1.4.0 12 июл. 2018 г.
1.3.3 14 мая 2018 г.
1.3.2 14 мая 2018 г.
1.3.1 11 мая 2018 г.
1.3.0 11 мая 2018 г.
1.2.0 20 февр. 2018 г.
1.1.13 9 янв. 2018 г.
1.1.12 8 янв. 2018 г.
1.1.11 24 нояб. 2017 г.

Maven Auto PLSQL/SP Generator Plugin

Лицензия

Категории

Группа

Идентификатор

Последняя версия

Дата

Тип

Описание

Ссылка на сайт

Организация-разработчик

Система контроля версий

Скачать autoplsp

Как подключить последнюю версию

Зависимости

compile (7)

test (3)

Модули Проекта

Maven Auto PLSQL/SP Generator Plugin

Support

Oracle

PostgresSQL

SQL Server

POM properties

POM dependencies

Oracle

PostgreSQL

SQL Server

POM plugin config

driver (required)

connectionString (required)

user (required)

pass (required)

javaDataSourceName (required)

javaJdbcTemplateName (optional, default jdbcTemplate)

jndiDataSourceName (required)

outputConfigFileName (optional)

outParameterCode (optional - default value OUT_RETURN_CODE)

outParameterMessage (optional - default value OUT_RETURN_MSG)

javaPackageName (required)

jsonNonNull (optional - default value false) (since 1.7.12)

includes -> include sp (optional, default .*)

excludes -> exclude sp (optional, default none)

resultset -> resultset (optional, default .*)

Command line support

POM Basic Configuration (include all procedure and function)

POM Basic Configuration (include one procedure)

POM Basic Configuration (include two procedures)

POM Basic Configuration (exclude one procedure)

How to evaluate result code

Build project

Configuration file generated

Configuration in the parent project

Transaction annotation example

Версии библиотеки