[jira] Commented: (DDLUTILS-151) Can not export data if multiple schemas from PostgreSQL

[Laurent ROCHE (JIRA)]

    [ 
https://issues.apache.org/jira/browse/DDLUTILS-151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466950
 ] 

Laurent ROCHE commented on DDLUTILS-151:
----------------------------------------

As far as I can tell, that will fail in any cases, but here are 2 ant tasks 
that fails:

<target name="export-pg" description="Dumps db structure and data">
      <taskdef name="databaseToDdl"
              classname="org.apache.ddlutils.task.DatabaseToDdlTask">
         <classpath refid="classpath"/>
      </taskdef>

      <databaseToDdl modelName="fims" sortforeignkeys="false" 
schemapattern="export" >
         <database url="jdbc:postgresql://sirocco/fims_mpd_jan"
                 driverClassName="org.postgresql.Driver"
                 username="admin"
                 password="d0csea2"/>
         <writeSchemaToFile outputFile="schema.xml"/>
         <writeDataToFile outputFile="data.xml"/>
      </databaseToDdl>
</target>

<target name="export-small" description="Dumps db structure and data">
      <taskdef name="databaseToDdl"
              classname="org.apache.ddlutils.task.DatabaseToDdlTask">
         <classpath refid="classpath"/>
      </taskdef>

      <databaseToDdl modelName="fims" sortforeignkeys="false">
         <database url="jdbc:postgresql://sirocco/fims_small_mpd"
                 driverClassName="org.postgresql.Driver"
                 username="admin"
                 password="d0csea2"/>
         <writeSchemaToFile outputFile="schema.xml"/>
         <writeDataToFile outputFile="data-small.xml"/>
      </databaseToDdl>
</target>


Let me know if you need anything else.

> Can not export data if multiple schemas from PostgreSQL
> -------------------------------------------------------
>
>                 Key: DDLUTILS-151
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-151
>             Project: DdlUtils
>          Issue Type: Bug
>    Affects Versions: 1.0
>         Environment: PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC 
> gcc-4.0.gcc-opt (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)
> Ant tasks
>            Reporter: Laurent ROCHE
>         Assigned To: Thomas Dudziak
>
> When running an Ant Task, databaseToDdl with writeDataToFile on a PosgreSQL 
> database with more than the public database, DDL-Utils fails !
> The error message is:
>  org.apache.ddlutils.DatabaseOperationException: Error while performing a 
> query
> and adding the option verbosity="DEBUG" does not add more information.
> Cheers,
> [EMAIL PROTECTED]

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.