Hi Can somebody help me out...........?????????? I m stucked up at one point in trying to implement multiple databases support of torque-maven plugin. Its all working fine except when I go to initialize for two databases in pom.xml. And I have added two plugins for 2 different databases. But it creates table for one database only, the one that is defined first in pom.xml. And it creates table of second database in first database also. (I m working in maven2.0) Kindly help me out how to initialize two databases in pom.xml????????? Here is my pom.xml
<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>dbtorquetrial</groupId> <artifactId>db-torque-trial-plugin</artifactId> <packaging>maven-plugin</packaging> <version>0.0.1-SNAPSHOT</version> <name>db-torque-trial-plugin Maven Mojo</name> <url>http://maven.apache.org</url> <dependencies> <!--Adding org apache maven dependency--> <dependency> <groupId>org.apache.maven</groupId> <artifactId>maven-plugin-api</artifactId> <version>2.0</version> </dependency> <!--Adding junit dependency--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <!--adding database related TORQUE dependencIES --> <dependency> <artifactId>torque</artifactId> <groupId>torque</groupId> <scope>system</scope> <systemPath>E:\jar\torque-3.3.jar</systemPath> <version>3.3</version> </dependency> <!--adding COMMONS-CONFIGURATION dependency --> <dependency> <artifactId>commons-configuration</artifactId> <groupId>commons-configuration</groupId> <scope>system</scope> <systemPath>E:\jar\commons-configuration-1.5.jar</systemPath> <version>1.5</version> </dependency> <!-- Adding plexus dependency --> <dependency> <artifactId>plexus-utils</artifactId> <groupId>org.codehaus.plexus</groupId> <version>1.0.4</version> <type>jar</type> </dependency> <!-- Adding cli dependency --> <dependency> <artifactId>commons-cli</artifactId> <groupId> commons-cli</groupId> <version>1.0</version> <type>jar</type> </dependency> <!--adding VILLAGE dependency --> <dependency> <artifactId>village</artifactId> <groupId>org.apache.torque</groupId> <scope>system</scope> <systemPath>E:\jar\village-3.3.jar</systemPath> <version>3.3</version> <type>jar</type> </dependency> <!--adding COMMONS-LANG dependency --> <dependency> <groupId>commons-lang</groupId> <artifactId>commons-lang</artifactId> <version>2.3</version> <scope>system</scope> <systemPath>E:\jar\commons-lang-2.3.jar</systemPath> </dependency> <!--adding COMMONS-LOGGING dependency --> <dependency> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> <version>1.1</version> <scope>system</scope> <systemPath>E:\jar\commons-logging-1.1.jar</systemPath> </dependency> <!-- Adding COMMONS-COLLECTIONS dependency --> <dependency> <groupId>commons-collections</groupId> <artifactId>commons-collections</artifactId> <version>3.2</version> </dependency> <!-- Adding COMMONS-BEANUTILS dependency --> <dependency> <groupId>commons-beanutils</groupId> <artifactId>commons-beanutils-core</artifactId> <version>1.7.0</version> </dependency> <!-- Adding COMMONS-DBCP dependency --> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.2.2</version> </dependency> <!--adding COMMONS-LANG dependency --> <dependency> <groupId>avalon-framework</groupId> <artifactId>avalon-framework-api</artifactId> <version>4.3</version> </dependency> <!--adding AVALON-LOGKIT dependency --> <dependency> <groupId>avalon-logkit</groupId> <artifactId>avalon-logkit</artifactId> <version>2.1</version> <type>jar</type> </dependency> <!--adding COMMONS-POOL dependency --> <dependency> <groupId>commons-pool</groupId> <artifactId>commons-pool</artifactId> <version>1.3</version> <exclusions> <exclusion> <groupId>javax.sql</groupId> <artifactId>jdbc-stdext</artifactId> </exclusion> </exclusions> </dependency> <!--adding JCS dependency --> <dependency> <groupId>jcs</groupId> <artifactId>jcs</artifactId> <version>1.3</version> <exclusions> <exclusion> <groupId>javax.sql</groupId> <artifactId>jdbc-stdext</artifactId> </exclusion> </exclusions> </dependency> <!--adding XERCES dependency --> <dependency> <groupId>xerces</groupId> <artifactId>xercesImpl</artifactId> <version>2.6.2</version> </dependency> <!--adding XML-APIS dependency --> <dependency> <groupId>xml-apis</groupId> <artifactId>xml-apis</artifactId> <version>2.0.2</version> </dependency> <!--adding mysql connector dependency --> <dependency> <artifactId>mysql-connector-java</artifactId> <groupId>mysql</groupId> <version>3.1.12</version> </dependency> </dependencies> <build> <finalName>db-torque-trial</finalName> <plugins> <!-- Adding torque plugin 2 for database access --> <plugin> <groupId>org.apache.db.torque</groupId> <artifactId>torque-maven-plugin</artifactId> <configuration> <targetDatabase>mysql</targetDatabase> <targetPackage></targetPackage> <driver>org.gjt.mm.mysql.Driver</driver> <url>jdbc:mysql://localhost:3306/bookstore</url> <user>root</user> <password>1234</password> </configuration> <executions> <execution> <phase>generate-sources</phase> <goals> <goal>om</goal> <goal>documentation</goal> </goals> </execution> </executions> <dependencies> <dependency> <artifactId>mysql-connector-java</artifactId> <groupId>mysql</groupId> <version>3.1.12</version> <type>jar</type> </dependency> </dependencies> </plugin> <!-- End of torque plugin 2 for database access --> <!-- Adding torque plugin for database access --> <plugin> <groupId>org.apache.db.torque</groupId> <artifactId>torque-maven-plugin</artifactId> <configuration> <targetDatabase>mysql</targetDatabase> <targetPackage></targetPackage> <driver>org.gjt.mm.mysql.Driver</driver> <url>jdbc:mysql://192.168.41.116:3306/bookstore2</url> <user>root</user> <password>root</password> </configuration> <executions> <execution> <phase>generate-sources</phase> <goals> <goal>om</goal> <goal>documentation</goal> </goals> </execution> </executions> <dependencies> <dependency> <artifactId>mysql-connector-java</artifactId> <groupId>mysql</groupId> <version>3.1.12</version> <type>jar</type> </dependency> </dependencies> </plugin> <!-- End of torque plugin for database access --> </plugins> </build> </project> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 10:30 AM To: [email protected] Subject: [EMAIL PROTECTED]: Project db-torque (in module db-torque) failed To whom it may engage... This is an automated request, but not an unsolicited one. For more information please visit http://gump.apache.org/nagged.html, and/or contact the folk at [EMAIL PROTECTED] Project db-torque has an issue affecting its community integration. This issue affects 1 projects. The current state of this project is 'Failed', with reason 'Configuration Failed'. For reference only, the following projects are affected by this: - db-torque : Persistence Layer Full details are available at: http://vmgump.apache.org/gump/public/db-torque/db-torque/index.html That said, some information snippets are provided here. The following annotations (debug/informational/warning/error messages) were provided: -DEBUG- Sole output [torque-18062008.jar] identifier set to project name -INFO- Failed with reason configuration failed -ERROR- Bad Dependency. Project: xml-apis : unknown to *this* workspace -DEBUG- Extracted fallback artifacts from Gump Repository To subscribe to this information via syndicated feeds: - RSS: http://vmgump.apache.org/gump/public/db-torque/db-torque/rss.xml - Atom: http://vmgump.apache.org/gump/public/db-torque/db-torque/atom.xml ============================== Gump Tracking Only === Produced by Gump version 2.3. Gump Run 21001618062008, vmgump:vmgump-public:21001618062008 Gump E-mail Identifier (unique within run) #244. -- Apache Gump http://gump.apache.org/ [Instance: vmgump] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
