You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Ken Weiner (JIRA)" <ji...@apache.org> on 2006/04/13 06:32:59 UTC

[jira] Created: (DDLUTILS-90) writeSchemaSqlToFile task produces blank output file

writeSchemaSqlToFile task produces blank output file
----------------------------------------------------

         Key: DDLUTILS-90
         URL: http://issues.apache.org/jira/browse/DDLUTILS-90
     Project: DdlUtils
        Type: Bug

  Components: Ant Tasks  
    Reporter: Ken Weiner
 Assigned to: Thomas Dudziak 


Running

<writeSchemaSqlToFile outputFile="schema.sql"/>

results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:

<writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>

I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Vincent Siveton (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=comments#action_12415569 ] 

Vincent Siveton commented on DDLUTILS-90:
-----------------------------------------

Same bug with mySQL

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>          Key: DDLUTILS-90
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>     Reporter: Ken Weiner
>     Assignee: Thomas Dudziak

>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Ken Weiner (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=comments#action_12374390 ] 

Ken Weiner commented on DDLUTILS-90:
------------------------------------

I don't think I had a problem accessing the database because if I changed my schema file, I could see the results reflected in the database.  I also didn't see any error messages that indicated that there was an error.  The database I was using was HSQLDB.  Is it possible that HSQLDB does not support something that the alterDatabase function is trying to do, but is not reporting an error?

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>          Key: DDLUTILS-90
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>     Reporter: Ken Weiner
>     Assignee: Thomas Dudziak

>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=all ]

Thomas Dudziak updated DDLUTILS-90:
-----------------------------------

    Fix Version: 1.0

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>          Key: DDLUTILS-90
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>     Reporter: Ken Weiner
>     Assignee: Thomas Dudziak
>      Fix For: 1.0

>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Resolved: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=all ]

Thomas Dudziak resolved DDLUTILS-90.
------------------------------------

    Resolution: Fixed

I've changed the WriteSchemaSqlToFile subtask recently (DDLUTILS-92) so that it actually checks whether the live database can be accessed when alterDatabase=true. And if that is not the case, then it prints out a warning and switches to alterDatabase=false automatically.

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>                 Key: DDLUTILS-90
>                 URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Ant Tasks
>            Reporter: Ken Weiner
>         Assigned To: Thomas Dudziak
>             Fix For: 1.0
>
>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=comments#action_12374319 ] 

Thomas Dudziak commented on DDLUTILS-90:
----------------------------------------

Please make sure that you don't have a problem accessing the database because for alterDatabase=true, the database must be accessible to DdlUtils. If there is a problem, Ant should report an error.

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>          Key: DDLUTILS-90
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>     Reporter: Ken Weiner
>     Assignee: Thomas Dudziak

>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DDLUTILS-90) writeSchemaSqlToFile task produces empty output file

Posted by "Ken Weiner (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-90?page=all ]

Ken Weiner updated DDLUTILS-90:
-------------------------------

    Summary: writeSchemaSqlToFile task produces empty output file  (was: writeSchemaSqlToFile task produces blank output file)

> writeSchemaSqlToFile task produces empty output file
> ----------------------------------------------------
>
>          Key: DDLUTILS-90
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-90
>      Project: DdlUtils
>         Type: Bug

>   Components: Ant Tasks
>     Reporter: Ken Weiner
>     Assignee: Thomas Dudziak

>
> Running
> <writeSchemaSqlToFile outputFile="schema.sql"/>
> results in an empty schema.sql file, but setting the alterDatabase attribute to false results in a properly written schema.sql file like so:
> <writeSchemaSqlToFile alterDatabase="false" outputFile="schema.sql"/>
> I am guessing that the sql should be written to the file, no matter what the value of the alterDatabase attribute.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira