[TORQUE-101] Torques Maven2 Plugin is lacking IDBroker-Features (which the maven1 version provided)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3-RC1, 3.3-RC2
• Fix Version/s: 3.3-RC3
• Component/s: Maven 2 Plugin

Environment

mvn --version
Maven version: 2.0.7
Java version: 1.6.0_02
OS name: "linux" version: "2.6.17-12-generic" arch: "i386"

<plugin><groupId>org.apache.db.torque</groupId>
                 <artifactId>torque-maven-plugin</artifactId>
                 <version>3.3-RC2</version> [...]</plugin>

• Assignee: Unassigned
• Reporter: Marc Kannegiesser
• Created: 18/Sep/07 11:39
• Updated: 01/Oct/07 07:26
• Resolved: 01/Oct/07 07:25

Description

As already discussed with Thomas Fischer on the list [e-mail] it seems that the Maven2 plugin for Torque is lacking the feature of creating the init-statements for the IDBroker-Table.

I am currently porting an application to build with maven2. Everything seems to be fine except the creation of the IDBrokers ID_TABLE:

Torques maven1 plugin provided a goal named torque:id-table-init-sql which created .sql files for the initialisation of the IDBroker-Table. The content was like that:

insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (5101, 'poll', 1000, 10); [...]

These files dont get generated with the Maven2 version of the plugin. The only config-option which could have to do sth with this is idTableXmlFile of the sql-Mojo. Thomas sais this is needed by the underlaying ant-task but he also does not know where it is for exactly.

Please have a look at the mailinglist for more details: http://mail-archives.apache.org/mod_mbox/db-torque-user/200709.mbox/browser

Would it be possible to add this missing feature ( porting the maven1 plugins goal torque:id-table-init-sql ) soon? Then i could easily port my applications build-process to maven2.

Thanks in advance,

Marc

PS:

My config is like this (i tried several versions):

plugin>
<groupId>org.apache.db.torque</groupId>
<artifactId>torque-maven-plugin</artifactId>
<version>3.3-RC2</version>
<configuration>
<url>jdbc:mysql://localhost/mysoftware</url>
<reportFile>report.${project.artifact.artifactId}.sql.generation</reportFi
<runOnlyOnSchemaChange>false</runOnlyOnSchemaChange>
<targetDatabase>mysql</targetDatabase>
<schemaDir>${basedir}/src/torque-schemas</schemaDir>
<templatePath>${basedir}/src/torque-templates</templatePath>
<driver>org.gjt.mm.mysql.Driver</driver>
<user>root</user>
<password></password>
<schemaIncludes>*schema.xml</schemaIncludes>
<schemaExcludes>id-table-schema.xml</schemaExcludes>
<targetPackage>com.mycompany.mysoftware</targetPackage>
<idTableXmlFile>id-table-schema.xml</idTableXmlFile>
</configuration>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>3.1.12</version>
<type>jar</type>
</dependency>
</dependencies>
<executions>
<execution>
<id>Creating .sql files</id>
<phase>process-resources</phase>
<goals>
<goal>sql</goal>
</goals>
</execution>
<execution>
<id>OM Goal (Generating Classes, Beans, ...)</id>
<phase>process-resources</phase>
<goals>
<goal>om</goal>
</goals>
<configuration>
<enableJava5Features>true</enableJava5Features>
<complexObjectModel>true</complexObjectModel>
<generateBeans>true</generateBeans>
<beanSuffix>Bean</beanSuffix>
</configuration>
</execution>
<execution>
<id>Fire sql to the database!!!</id>
<phase>process-resources</phase>
<goals>
<goal>sqlExec</goal>
</goals>
</execution>
</executions>
</plugin>