Hello everyone I have posted this on the ant forum. The reason for this post on maven forum is that I am not sure where the problem is originating from. I am trying to use ddlutils with maven. No ready ddlutils plugin available for maven. So I am working with ant-run plugin. When I run the maven pom file, I get the following output. You can notice here that the echo statement echoes the driver value from the properties file first time and then after that it does not. I am not sure why this is happening. Could somebody throw somelight on this.
Thanks Venkat My config: <property file="./resources/ddlutils/Database.properties" prefix="db" /> <echo>${db.driver}</echo> <taskdef classname="org.apache.ddlutils.task.DatabaseToDdlTask" name="databaseToDdl" classpathref="maven.compile.classpath" /> <databaseToDdl usedelimitedsqlidentifiers="true" modelname="lean" verbosity="DEBUG"> <database driverclassname="org.postgresql.Driver" url="${db.url}" username="${db.username}" password="${db.password}" /> <writeschematofile outputfile="./resources/database/schema-lean.xml" /> </databaseToDdl> Error Stack Trace: ven...@ubuntu:~/leanpm/implementation$ sudo mvn -e install + Error stacktraces are turned on. [INFO] Scanning for projects... [INFO] Reactor build order: [INFO] LeanPM [INFO] Applications [INFO] LeanPM parent [INFO] LeanPMJAR [INFO] LeanPMWAR [INFO] LeanPMEAR [INFO] AllModules [INFO] BuildTools [INFO] Delivery [INFO] ------------------------------------------------------------------------ [INFO] Building LeanPM [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [antrun:run {execution: ddlutils-compile}] [INFO] Executing tasks [echo] org.postgresql.Driver Borrowed connection org.apache.commons.dbcp.poolableconnect...@19abd2b from data source Returning connection org.apache.commons.dbcp.poolableconnect...@19abd2b to data source. Remaining connections: None Written schema to /home/venkat/leanpm/implementation/resources/database/schema-lean.xml [INFO] Executed tasks [INFO] [site:attach-descriptor] [INFO] [install:install] [INFO] Installing /home/venkat/leanpm/implementation/pom.xml to /.m2/repository/com/oniryx/leanPM/LeanPM/0.1-SNAPSHOT/LeanPM-0.1-SNAPSHOT.pom [INFO] ------------------------------------------------------------------------ [INFO] Building Applications [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [antrun:run {execution: ddlutils-compile}] [INFO] Executing tasks [echo] ${db.driver} [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] An Ant BuildException has occured: Could not read the schema from the specified database: Could not get a connection from the datasource No suitable driver [INFO] ------------------------------------------------------------------------ [INFO] Trace org.apache.maven.lifecycle.LifecycleExecutionException: An Ant BuildException has occured: Could not read the schema from the specified database: Could not get a connection from the datasource at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:499) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:478) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:291) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142) at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129) at org.apache.maven.cli.MavenCli.main(MavenCli.java:287) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315) at org.codehaus.classworlds.Launcher.launch(Launcher.java:255) at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430) at org.codehaus.classworlds.Launcher.main(Launcher.java:375) Caused by: org.apache.maven.plugin.MojoExecutionException: An Ant BuildException has occured: Could not read the schema from the specified database: Could not get a connection from the datasource at org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:131) at org.apache.maven.plugin.antrun.AntRunMojo.execute(AntRunMojo.java:98) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:558) ... 16 more Caused by: Could not read the schema from the specified database: Could not get a connection from the datasource at org.apache.ddlutils.task.DatabaseToDdlTask.readModel(DatabaseToDdlTask.java:188) at org.apache.ddlutils.task.DatabaseTaskBase.execute(DatabaseTaskBase.java:365) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.maven.plugin.antrun.AbstractAntMojo.executeTasks(AbstractAntMojo.java:118) ... 19 more Caused by: org.apache.ddlutils.DatabaseOperationException: Could not get a connection from the datasource at org.apache.ddlutils.util.JdbcSupport.borrowConnection(JdbcSupport.java:151) at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1900) at org.apache.ddlutils.task.DatabaseToDdlTask.readModel(DatabaseToDdlTask.java:181) ... 29 more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL '${db.url}' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.apache.ddlutils.util.JdbcSupport.borrowConnection(JdbcSupport.java:134) ... 31 more Caused by: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:264) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:773) ... 33 more [INFO] ------------------------------------------------------------------------ [INFO] Total time: 17 seconds [INFO] Finished at: Wed Feb 24 14:43:26 MST 2010 [INFO] Final Memory: 18M/81M [INFO] ------------------------------------------------------------------------ -- View this message in context: http://old.nabble.com/Ant-%2C-maven-%2C-antrun-%2C-ddlutils-tp27714325p27714325.html Sent from the Maven - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org