<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>org.sqlproc</groupId>
    <artifactId>sql-processor-parent</artifactId>
    <version>3.2.1</version>
    <packaging>pom</packaging>
    <name>SQL Processor, Parent Module</name>
    <description>SQL Processor, Parent Module</description>
    <url>https://github.com/hudec/sql-processor/wiki</url>

    <prerequisites>
        <maven>3.0</maven>
    </prerequisites>

    <parent>
        <groupId>org.sonatype.oss</groupId>
        <artifactId>oss-parent</artifactId>
        <version>5</version>
    </parent>

    <modules>
        <module>sql-processor</module>
        <module>sql-processor-hibernate</module>
        <module>sql-processor-spring</module>
        <module>sql-processor-beans</module>
        <module>sql-processor-archetypes</module>
    </modules>

    <properties>
        <version.antlr>3.5.2</version.antlr>
        <version.hibernate>4.1.7.Final</version.hibernate>
        <version.hibernate-validator>4.3.1.Final</version.hibernate-validator>
        <version.spring>4.3.1.RELEASE</version.spring>
        <version.aspectjweaver>1.6.12</version.aspectjweaver>
        <version.log4j>1.2.17</version.log4j>
        <version.slf4j>1.7.21</version.slf4j>
        <version.junit>4.12</version.junit>
        <version.dbunit>2.5.2</version.dbunit>
        <version.hsqldb>2.3.2</version.hsqldb>
        <version.h2>1.4.192</version.h2>
        <version.javassist>3.12.1.GA</version.javassist>
        <version.oracle>11.2.0.3</version.oracle>
        <version.mysql>5.1.18</version.mysql>
        <version.postgresql>9.1-901.jdbc4</version.postgresql>
        <version.informix>3.5</version.informix>
        <version.mssql>4.1</version.mssql>
        <version.db2>3.52.95</version.db2>
        <version.beanutils>1.9.2</version.beanutils>
        <version.dbcp>1.4</version.dbcp>
        <version.validation>1.1.0.Final</version.validation>

        <db.dialect>org.hibernate.dialect.HSQLDialect</db.dialect>
        <db.driver>org.hsqldb.jdbcDriver</db.driver>
        <db.url>jdbc:hsqldb:mem:sqlproc</db.url>
        <db.username>sa</db.username>
        <db.password />
        <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
        <DDL_CREATE_DB>ddl/hsqldb.ddl</DDL_CREATE_DB>
        <DDL_DROP_DB />
        <DB_TYPE>HSQLDB</DB_TYPE>
        <DATATYPE_FACTORY>org.dbunit.ext.hsqldb.HsqldbDataTypeFactory</DATATYPE_FACTORY>
    </properties>

    <scm>
        <url>scm:git:git@github.com:hudec/sql-processor.git</url>
        <connection>scm:git:git@github.com:hudec/sql-processor.git</connection>
        <developerConnection>scm:git:git@github.com:hudec/sql-processor.git</developerConnection>
    </scm>

    <licenses>
        <license>
            <name>GNU Lesser General Public License</name>
            <url>http://www.gnu.org/licenses/lgpl-2.1.txt</url>
        </license>
    </licenses>

    <build>
        <testResources>
            <testResource>
                <directory>src/test/resources</directory>
                <filtering>true</filtering>
            </testResource>
        </testResources>
        <plugins>
            <plugin>
                <artifactId>maven-source-plugin</artifactId>
                <version>3.0.0</version>
                <executions>
                    <execution>
                        <id>attach-sources</id>
                        <goals>
                            <goal>jar</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.5.1</version>
                <configuration>
                    <source>1.7</source>
                    <target>1.7</target>
                    <compilerVersion>1.7</compilerVersion>
                    <encoding>UTF-8</encoding>
                    <!--encoding>${file.encoding}</encoding -->
                    <optimize>true</optimize>
                </configuration>
            </plugin>
            <plugin>
                <artifactId>maven-resources-plugin</artifactId>
                <version>2.7</version>
                <configuration>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <artifactId>maven-surefire-plugin</artifactId>
                <version>2.19.1</version>
                <configuration>
                    <argLine>-Dfile.encoding=UTF-8</argLine>
                    <forkMode>once</forkMode>
                    <childDelegation>false</childDelegation>
                </configuration>
            </plugin>
            <plugin>
                <artifactId>maven-javadoc-plugin</artifactId>
                <version>2.10.3</version>
                <configuration>
                    <encoding>UTF-8</encoding>
                    <show>private</show>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.codehaus.mojo</groupId>
                <artifactId>versions-maven-plugin</artifactId>
                <version>2.2</version>
            </plugin>
        </plugins>
    </build>

    <dependencyManagement>
        <dependencies>
            <!-- ANTLR -->
            <dependency>
                <groupId>org.antlr</groupId>
                <artifactId>antlr</artifactId>
                <version>${version.antlr}</version>
            </dependency>
            <dependency>
                <groupId>org.antlr</groupId>
                <artifactId>antlr-runtime</artifactId>
                <version>${version.antlr}</version>
            </dependency>

            <!-- LOG -->
            <dependency>
                <groupId>org.slf4j</groupId>
                <artifactId>slf4j-log4j12</artifactId>
                <version>${version.slf4j}</version>
            </dependency>

            <!-- REFLECTION -->
            <dependency>
                <groupId>commons-beanutils</groupId>
                <artifactId>commons-beanutils</artifactId>
                <version>${version.beanutils}</version>
            </dependency>

            <!-- HIBERNATE -->
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>${version.hibernate}</version>
            </dependency>

            <!-- SPRING -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${version.spring}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${version.spring}</version>
            </dependency>

            <!-- TEST -->
            <dependency>
                <groupId>javassist</groupId>
                <artifactId>javassist</artifactId>
                <version>${version.javassist}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>${version.log4j}</version>
                <!-- scope>test</scope -->
                <exclusions>
                    <exclusion>
                        <artifactId>mail</artifactId>
                        <groupId>javax.mail</groupId>
                    </exclusion>
                    <exclusion>
                        <artifactId>jms</artifactId>
                        <groupId>javax.jms</groupId>
                    </exclusion>
                    <exclusion>
                        <artifactId>jmxtools</artifactId>
                        <groupId>com.sun.jdmk</groupId>
                    </exclusion>
                    <exclusion>
                        <artifactId>jmxri</artifactId>
                        <groupId>com.sun.jmx</groupId>
                    </exclusion>
                </exclusions>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>${version.junit}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.dbunit</groupId>
                <artifactId>dbunit</artifactId>
                <version>${version.dbunit}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.hsqldb</groupId>
                <artifactId>hsqldb</artifactId>
                <version>${version.hsqldb}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>com.h2database</groupId>
                <artifactId>h2</artifactId>
                <version>${version.h2}</version>
            </dependency>
            <dependency>
                <groupId>commons-dbcp</groupId>
                <artifactId>commons-dbcp</artifactId>
                <version>${version.dbcp}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>javax.validation</groupId>
                <artifactId>validation-api</artifactId>
                <version>${version.validation}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-validator</artifactId>
                <version>${version.hibernate-validator}</version>
                <scope>test</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <profiles>
        <profile>
            <id>oracle</id>
            <properties>
                <db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect>
                <db.driver>oracle.jdbc.OracleDriver</db.driver>
                <db.url>jdbc:oracle:thin:@127.0.0.1:1521:xe</db.url>
                <db.username>sql</db.username>
                <db.password>sql</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>ORACLE</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.oracle.Oracle10DataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.oracle</groupId>
                    <artifactId>ojdbc6</artifactId>
                    <version>${version.oracle}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>oracle-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.Oracle10gDialect</db.dialect>
                <db.driver>oracle.jdbc.OracleDriver</db.driver>
                <db.url>jdbc:oracle:thin:@oracle:1521:ora11g</db.url>
                <db.username>sql</db.username>
                <db.password>sql</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>ORACLE</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.oracle.Oracle10DataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.oracle</groupId>
                    <artifactId>ojdbc6</artifactId>
                    <version>${version.oracle}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>mysql</id>
            <properties>
                <db.dialect>org.hibernate.dialect.MySQL5Dialect</db.dialect>
                <db.driver>com.mysql.jdbc.Driver</db.driver>
                <db.url>jdbc:mysql://127.0.0.1:3306/sqlproc?zeroDateTimeBehavior=convertToNull</db.url>
                <db.username>sqlproc</db.username>
                <db.password>sqlproc</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>MYSQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.mysql.MySqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>${version.mysql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>mysql-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.MySQL5Dialect</db.dialect>
                <db.driver>com.mysql.jdbc.Driver</db.driver>
                <db.url>jdbc:mysql://mysql:3306/sqlproc?zeroDateTimeBehavior=convertToNull</db.url>
                <db.username>sqlproc</db.username>
                <db.password>sqlproc</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>MYSQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.mysql.MySqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>${version.mysql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>postgresql</id>
            <properties>
                <db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect>
                <db.driver>org.postgresql.Driver</db.driver>
                <db.url>jdbc:postgresql://127.0.0.1:5432/sql</db.url>
                <db.username>sql</db.username>
                <db.password>sql</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>POSTGRESQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.postgresql.PostgresqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>postgresql</groupId>
                    <artifactId>postgresql</artifactId>
                    <version>${version.postgresql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>postgresql-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.PostgreSQLDialect</db.dialect>
                <db.driver>org.postgresql.Driver</db.driver>
                <db.url>jdbc:postgresql://komin:5432/sql</db.url>
                <db.username>sql</db.username>
                <db.password>sql</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>POSTGRESQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.postgresql.PostgresqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>postgresql</groupId>
                    <artifactId>postgresql</artifactId>
                    <version>${version.postgresql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>informix</id>
            <properties>
                <db.dialect>org.hibernate.dialect.InformixDialect</db.dialect>
                <db.driver>com.informix.jdbc.IfxDriver</db.driver>
                <db.url>jdbc:informix-sqli://localhost:1556/sql:informixserver=popel_ais3;DB_LOCALE=en_US.57372</db.url>
                <db.username>sql</db.username>
                <db.password>sql123</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>INFORMIX</DB_TYPE>
                <DATATYPE_FACTORY>org.sqlproc.engine.type.InformixDbUnitDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.ibm.informix</groupId>
                    <artifactId>ifxjdbc</artifactId>
                    <version>${version.informix}</version>
                    <scope>test</scope>
                </dependency>
                <dependency>
                    <groupId>com.ibm.informix</groupId>
                    <artifactId>ifxjdbcx</artifactId>
                    <version>${version.informix}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>informix-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.InformixDialect</db.dialect>
                <db.driver>com.informix.jdbc.IfxDriver</db.driver>
                <db.url>jdbc:informix-sqli://prach:1556/sql:informixserver=popel_ais3;DB_LOCALE=en_US.57372</db.url>
                <db.username>sql</db.username>
                <db.password>sql</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>INFORMIX</DB_TYPE>
                <DATATYPE_FACTORY>org.sqlproc.engine.type.InformixDbUnitDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.ibm.informix</groupId>
                    <artifactId>ifxjdbc</artifactId>
                    <version>${version.informix}</version>
                    <scope>test</scope>
                </dependency>
                <dependency>
                    <groupId>com.ibm.informix</groupId>
                    <artifactId>ifxjdbcx</artifactId>
                    <version>${version.informix}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>mssql</id>
            <properties>
                <db.dialect>org.hibernate.dialect.SQLServer2008Dialect</db.dialect>
                <db.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</db.driver>
                <db.url>jdbc:sqlserver://mrkev:1433;databaseName=hudec;selectMethod=direct;sendTimeAsDatetime=true;sendStringParametersAsUnicode=true</db.url>
                <db.username>hudec</db.username>
                <db.password>passwd</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>MSSQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.mssql.MsSqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.microsoft.sqlserver</groupId>
                    <artifactId>sqljdbc4</artifactId>
                    <version>${version.mssql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>mssql-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.SQLServer2008Dialect</db.dialect>
                <db.driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</db.driver>
                <db.url>jdbc:sqlserver://mrkev:1433;databaseName=sql;selectMethod=direct;sendTimeAsDatetime=true;sendStringParametersAsUnicode=true</db.url>
                <db.username>hudec</db.username>
                <db.password>passwd</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>MSSQL</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.mssql.MsSqlDataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.microsoft.sqlserver</groupId>
                    <artifactId>sqljdbc4</artifactId>
                    <version>${version.mssql}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>h2</id>
            <properties>
                <db.dialect>org.hibernate.dialect.H2Dialect</db.dialect>
                <db.driver>org.h2.Driver</db.driver>
                <db.url>jdbc:h2:mem:demo</db.url>
                <db.username>sa</db.username>
                <db.password />
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB>ddl/h2.ddl</DDL_CREATE_DB>
                <DDL_DROP_DB />
                <DB_TYPE>H2</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.h2.H2DataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.h2database</groupId>
                    <artifactId>h2</artifactId>
                    <version>${version.h2}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>db2-bamboo</id>
            <properties>
                <db.dialect>org.hibernate.dialect.DB2Dialect</db.dialect>
                <db.driver>com.ibm.db2.jcc.DB2Driver</db.driver>
                <db.url>jdbc:db2://db2:50000/sql:deferPrepares=0;progressiveStreaming=2;</db.url>
                <db.username>db2inst1</db.username>
                <db.password>db2inst1</db.password>
                <CONFIGURATION_NAME>hibernate.cfg.xml</CONFIGURATION_NAME>
                <DDL_CREATE_DB />
                <DDL_DROP_DB />
                <DB_TYPE>DB2</DB_TYPE>
                <DATATYPE_FACTORY>org.dbunit.ext.db2.Db2DataTypeFactory</DATATYPE_FACTORY>
            </properties>
            <dependencies>
                <dependency>
                    <groupId>com.ibm.db2</groupId>
                    <artifactId>db2-jdbc</artifactId>
                    <version>${version.db2}</version>
                    <scope>test</scope>
                </dependency>
            </dependencies>
        </profile>
        <profile>
            <id>release-sign-artifacts</id>
            <activation>
                <property>
                    <name>performRelease</name>
                    <value>true</value>
                </property>
            </activation>
            <build>
                <plugins>
                    <plugin>
                        <groupId>org.apache.maven.plugins</groupId>
                        <artifactId>maven-gpg-plugin</artifactId>
                        <version>1.6</version>
                        <executions>
                            <execution>
                                <id>sign-artifacts</id>
                                <phase>verify</phase>
                                <goals>
                                    <goal>sign</goal>
                                </goals>
                            </execution>
                        </executions>
                    </plugin>
                </plugins>
            </build>
        </profile>
        <profile>
            <id>javadoc-for-svn</id>
            <build>
                <plugins>
                    <plugin>
                        <groupId>org.apache.maven.plugins</groupId>
                        <artifactId>maven-javadoc-plugin</artifactId>
                        <configuration>
                            <excludePackageNames>org.sqlproc.engine.impl</excludePackageNames>
                            <outputDirectory>${basedir}</outputDirectory>
                            <reportOutputDirectory>${basedir}</reportOutputDirectory>
                            <destDir>javadoc</destDir>
                            <encoding>UTF-8</encoding>
                        </configuration>
                    </plugin>
                </plugins>
            </build>
        </profile>
    </profiles>

    <repositories>
        <repository>
            <id>central</id>
            <url>http://repo1.maven.org/maven2</url>
        </repository>
        <repository>
            <id>jboss-public-repository-group</id>
            <url>https://repository.jboss.org/nexus/content/groups/public-jboss/</url>
        </repository>
    </repositories>

    <developers>
        <developer>
            <id>whudec</id>
            <name>Vladimir Hudec</name>
            <email>Vladimir.Hudec@gmail.com</email>
            <roles>
                <role>project-leader</role>
                <role>developer</role>
            </roles>
        </developer>
    </developers>
</project>
