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):
every time now
Steps to Reproduce:
1. ant deploy
2. or ant build
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]
Here's the porject.xml file for the offending project.
Created attachment 96636 [details]
output from ant
ant deploy -v > ant.out 2>&1
and with the
The zero byte files are create by the generate-ddl-<project-name> ant
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
Perhaps there is still some underlying bug that this has brought to
light but the tutorial now works around it.