db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laurent ROCHE (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-151) Can not export data if multiple schemas from PostgreSQL
Date Wed, 24 Jan 2007 09:00:49 GMT

    [ 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,
> L@u

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


Mime
View raw message