db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jason <jeac...@hardlight.com.au>
Subject postgres bytea broken
Date Wed, 12 Apr 2006 09:21:51 GMT
I have tried everything I can think of, but I just cant dump data out of 
bytea fields in postgres with ddlutils ant tasks. has anyone else had 
this problem? does anyone know a workaround/solution?

running ant 1.6.5
java 1.5
> 	<target name="database-dump-postgres" description="Dumps the database structure"
depends="getddldbinfo">
> 	  <taskdef name="databaseToDdl"
> 	           classname="org.apache.ddlutils.task.DatabaseToDdlTask">
> 	    <classpath refid="runtime-classpath"/>
> 	  </taskdef>
> 		<delete dir="${database.backup.path}/src/schema"></delete>
> 	  	<mkdir  dir="${database.backup.path}/src/schema"/>
> 	  <databaseToDdl modelName="MyModel" databaseType="postgresql" useDelimitedSqlIdentifiers="true">
> 	   <database url="jdbc:postgresql://${system.database.hostname}/${database.name}"
> 	              driverClassName="org.postgresql.Driver"
> 	        	  username="${database.user}"
> 	 	          password="${database.password}"/>
> 
> 	    <writeSchemaToFile 
> 	    	outputFile="${database.backup.path}/src/schema/${database.backup.path}-schema.xml"/>
> 
> 	    <writeDataToFile
> 	    	outputFile="${database.backup.path}/src/schema/${database.backup.path}-data.xml"/>
> 	  </databaseToDdl>
> 	</target>


for a table with def:
> CREATE TABLE binarydata (
>     binaryid bigint NOT NULL,
>     categoryid bigint,
>     name character varying(200),
>     mimetypeid bigint,
>     published boolean,
>     properties bytea,
>     binarydata bytea,
>     currentowner bigint DEFAULT 5,
>     modifieddate timestamp with time zone,
>     creationdate timestamp with time zone,
>     creator bigint DEFAULT 5
> );


I get this as schema:
> <table name="binarydata">
>       <column name="binaryid" primaryKey="true" required="true" type="BIGINT" size="8"
autoIncrement="false"/>
>       <column name="categoryid" primaryKey="false" required="false" type="BIGINT"
size="8" autoIncrement="false"/>
>       <column name="name" primaryKey="false" required="false" type="VARCHAR" size="50"
autoIncrement="false"/>
>       <column name="mimetypeid" primaryKey="false" required="false" type="BIGINT"
size="8" autoIncrement="false"/>
>       <column name="published" primaryKey="false" required="false" type="BIT" size="1"
autoIncrement="false"/>
>       <column name="properties" primaryKey="false" required="false" type="BINARY"
autoIncrement="false"/>
>       <column name="binarydata" primaryKey="false" required="false" type="BINARY"
autoIncrement="false"/>
>       <column name="currentowner" primaryKey="false" required="false" type="BIGINT"
size="8" default="5" autoIncrement="false"/>
>       <column name="modifieddate" primaryKey="false" required="false" type="TIMESTAMP"
size="8" autoIncrement="false"/>
>       <column name="creationdate" primaryKey="false" required="false" type="TIMESTAMP"
size="8" autoIncrement="false"/>
>       <column name="creator" primaryKey="false" required="false" type="BIGINT" size="8"
default="5" autoIncrement="false"/>
>       <unique name="aaaaabinarydata_pk">
>         <unique-column name="binaryid"/>
>       </unique>
>       <index name="categoryid">
>         <index-column name="categoryid"/>
>       </index>
>       <index name="datacatagorytreebinarydata">
>         <index-column name="categoryid"/>
>       </index>
>     </table>

I get this as data:
>   <binarydata binaryid="13" categoryid="1008" name="banner_info.jpg" mimetypeid="0"
published="0" binarydata="[B@1ce669e" currentowner="5" modifieddate="2005-
> 09-09 14:50:12.343" creationdate="2005-09-09 14:50:12.343" creator="5"/>

but the actual data in the binarydata field is NOT "[B@1ce669e"

I tried messing with the mappings and rebuilding from source but made no 
difference.

any help appreciated.

thanks




Mime
View raw message