You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-user@db.apache.org by Laurent ROCHE <la...@yahoo.com> on 2007/01/22 10:35:39 UTC

Re : Re : Error at export: databaseToDdl

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 <la...@yahoo.com>
À : Laurent ROCHE <la...@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 <la...@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