Red Hat Bugzilla – Bug 112414
com.arsdigita.persistance..pdl.PDL creates/overwrites a 0 byte create.sql
Last modified: 2008-05-01 11:39:17 EDT
Description of problem: This is a problem I have with one particular project, where I am creating a content type. The class com.arsdigita.persistance..pdl.PDL creates two zero byte files, create.sql and drop-tables.sql in build/sql/<prj>/ddl/oracle-se This happens as part of the generate-ddl-<prj>-oracle-se ant task. Initially it was overwriting files that were correctly copied from my sql dir. After I renamed the files that kept turning up as zero bytes, it simply created them new. Version-Release number of selected component (if applicable): aplaws-2 dec-5 How reproducible: every time now Steps to Reproduce: 1. ant deploy 2. or ant build 3. Actual results: Expected results: Additional info: I found this out by copying the sql over then making the directory non-writable (to get an exception when an attempt was then made to create a new file). I will attach my project.xml and the output of ant deploy -v with the directory non-writable as above.
Created attachment 96635 [details] the project.xml Here's the porject.xml file for the offending project.
Created attachment 96636 [details] output from ant Created with ant deploy -v > ant.out 2>&1 and with the camden-cms-type-birdwatch/build/sql/camden-cms-type-birdwatch/ddl/oracle-se directory not-writable.
The zero byte files are create by the generate-ddl-<project-name> ant task.
I believe this problem was caused by mixing sql and pdl files, which then generated extra sql, some of which was incompatible. The situation resulted from following the November version of the CMS content type tutorial. The January version does not say to create any SQL and lets the PDL generator handle all SQL creation. This looks to work okay. Perhaps there is still some underlying bug that this has brought to light but the tutorial now works around it.