db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Laurent ROCHE <laurent_ro...@yahoo.com>
Subject Re : Re : Error at export: databaseToDdl
Date Mon, 22 Jan 2007 09:35:39 GMT
Even more info !
(as the old french saying goes: the night brings advice ;-) !)

The problem is that I have more one schema: it seems that if there are more than one schema
in PostgreSQL the export fails.

 
Have fun,
L@u
The Computing Froggy

----- Message d'origine ----
De : Laurent ROCHE <laurent_roche@yahoo.com>
À : Laurent ROCHE <laurent_roche@yahoo.com>; ddlutils-user@db.apache.org
Envoyé le : Dimanche, 21 Janvier 2007, 19h21mn 57s
Objet : Re : Error at export: databaseToDdl

Hi again,

I investigated a bit more: it's note related to the server ... but to the data !
And even the database, I am working on, is not working  !! ! :-(

So now, I am really interested in knowing what's wrong and know a bit more about the failing
query !

 
Have fun,
L@u
The Computing Froggy

----- Message d'origine ----
De : Laurent ROCHE <laurent_roche@yahoo.com>
À : ddlutils-user@db.apache.org
Envoyé le : Dimanche, 21 Janvier 2007, 18h26mn 19s
Objet : Error at export: databaseToDdl

Hi,

when doing an export of PostrgreSQL database with the ant Task databaseToDdl, I get a cryptic
error: 
(with verbosity="DEBUG")

export-test:
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Written schema to C:\Projects\fims\trunk\sql\schema_test.xml
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None
[databaseToDdl] Borrowed connection org.apache.commons.dbcp.PoolableConnection@b0bad7 from
data source
[databaseToDdl] Returning connection org.apache.commons.dbcp.PoolableConnection@b0bad7 to
data source.
[databaseToDdl] Remaining connections: None

BUILD FAILED
C:\Projects\fims\trunk\sql\build_t.xml:93: org.apache.ddlutils.DatabaseOperationException:
Error while performing a query

I suspect a connection error because different schemas on the same DB giev the same error.
However, on the same server with another db, there's no problems.

If somebody wants to investigate let me know what you (SQL scripts, ...) want and I will send
if off list.
I am not too bothered about this as I am not really exporting this db: I was just testing
something ... but I thought I should report it anyway.


Have fun,
L@u
The Computing Froggy




    

    
        
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses

http://fr.answers.yahoo.com





    

    
        
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses

http://fr.answers.yahoo.com





	

	
		
___________________________________________________________________________ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses

http://fr.answers.yahoo.com

Mime
View raw message