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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Laurent ROCHE <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]>; [email protected] 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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Laurent ROCHE <[EMAIL PROTECTED]> À : [email protected] 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 [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Written schema to C:\Projects\fims\trunk\sql\schema_test.xml [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] to data source. [databaseToDdl] Remaining connections: None [databaseToDdl] Borrowed connection [EMAIL PROTECTED] from data source [databaseToDdl] Returning connection [EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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
