Thanks Thomas I used binary and it works. Another problem is when I use
maven torque:create-db
D:\Develop\eclipse\workspace\CONFUOCO>maven torque:create-db
__ __
| \/ |__ _Apache__ ___
| |\/| / _` \ V / -_) ' \ ~ intelligent projects ~
|_| |_\__,_|\_/\___|_||_| v. 1.0.2
build:start:
torque:init:
torque:create-db:
[torque-data-model] Using classpath
[torque-data-model] Generating to file F:\Output\sql\create-db.sql
[echo]
Executing the create-db.sql script ...
[sql] Executing file: F:\Output\sql\create-db.sql
[sql] [ERROR] Failed to execute: drop database confuoco
[sql] [ERROR] org.postgresql.util.PSQLException: ERROR: cannot drop the
currently open database
[sql] [ERROR] Failed to execute: create database confuoco
[sql] [ERROR] org.postgresql.util.PSQLException: ERROR: database
"confuoco" already exists
[sql] 0 of 2 SQL statements executed successfully
BUILD SUCCESSFUL
Total time: 19 seconds
Finished at: Wed Jun 15 09:49:43 CEST 2005
Have you any idea, why this not works?
Regards
Ferruh
-----Ursprüngliche Nachricht-----
Von: Thomas Fischer [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 15. Juni 2005 08:28
An: Apache Torque Users List
Betreff: RE: How to define Blob Field/Postgresql
Hi,
Two possible solutions:
1) use BINARY instead of BLOB for postgresql.
2) locate the file templates/sql/base/postgresql/db.props in the generator
and replace the line
BLOB =
by
BLOB = BLOB
Thomas
"Ferruh Zamangoer" <[EMAIL PROTECTED]> schrieb am 14.06.2005
16:03:08:
> Hi,
>
>
>
> I have now installed my postgresql database and it works. I had noticed
> that in the generation of the sql script was an error. I have defined in
> schema.xml some fields, which are from type BLOB.
>
>
>
> <table name="WHITE_LIST" description="WHITE LIST TABLE"
>
> javaNamingMethod="underscore">
>
> <column
>
> name="ENTRY_ID"
>
> required="true"
>
> primaryKey="true"
>
> type="INTEGER"
>
> description="ENTRY_ID"/>
>
> <column
>
> name="CONTENT_ID"
>
> required="true"
>
> type="BLOB"
>
> description="CONTENT_ID"/>
>
> ……….
>
> </table>
>
>
>
> In the sql script I saw that no type is set for the CONTENT_ID Field
>
>
>
> CREATE TABLE WHITE_LIST
>
> (
>
> ENTRY_ID integer DEFAULT
> nextval('WHITE_LIST_SEQ') NOT NULL,
>
> CONTENT_ID NOT NULL,
>
> HASH_VALUE integer NOT NULL,
>
> CONTENT_ID_TYPE varchar (256) NOT
NULL,
>
> -- REFERENCES CONTENT
> (CONTENT_REGISTRATION_ID)
>
> CONTENT_REGISTRATION_ID integer NOT NULL,
>
> DATE date NOT NULL,
>
> DESCRIPTION varchar (256),
>
> PRIMARY KEY (ENTRY_ID)
>
> );
>
>
>
> Which type I have to set in schema that the sql script sets the right
data
> type?´
>
>
>
> I had edit manually the script and set bytea which is blob field in
> postgresql.
>
>
>
> Can anybody help?
>
>
>
> Regards
>
> Ferruh
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
