db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: How to define Blob Field/Postgresql
Date Thu, 16 Jun 2005 14:22:39 GMT




Well, if I look at the error message, it says

"cannot drop the currently open database"

which seems to be the reason for the error.

If you run the sql script from a console, it should work.
I have no idea how to fix it to run within maven

    Thomas

"Ferruh Zamangoer" <ferruh.zamangoer@gmx.de> schrieb am 15.06.2005
09:52:50:

> 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:fischer@seitenbau.net]
> 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" <ferruh.zamangoer@gmx.de> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
Mime
View raw message