Thread: jdbc Batch update stack trace

jdbc Batch update stack trace

From
"Mario Rodriguez Villanea"
Date:
Batch entry 0 [Ljava.lang.Object;@2a6f16 was aborted.
 at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2St
atement.java:105)
 at
com.capitales.db.common.DBConnection.getDatafromWriteBatch(DBConnection.
java:233)
 at
com.capitales.db.common.DBConnection.executeComplexUpdateBatch(DBConnect
ion.java:73)
 at
com.capitales.db.ecoanalisis.handlers.ImportEcoanalisis.agregarImportEco
analisis(ImportEcoanalisis.java:169)
 at
com.capitales.imports.ecoanalisis.EcoanalisisProcessor.processImportData
(EcoanalisisProcessor.java:79)
 at
com.capitales.imports.ecoanalisis.EcoanalisisImporter.startImportProcess
(EcoanalisisImporter.java:83)
 at
com.capitales.imports.ecoanalisis.EcoanalisisImporter.startImportProcess
(EcoanalisisImporter.java:62)
 at com.capitales.imports.Prueba.<init>(Prueba.java:28)
 at com.capitales.imports.Prueba.main(Prueba.java:35)



____________________________________
Mario A. Rodríguez Villanea
mrodriguez@avanticatec.com
Tel Of    : 2839100
Tel Hab : 2933432
Avantica Technologies
http://www.avanticatec.com <http://www.avanticatec.com/>



Re: jdbc Batch update stack trace

From
Barry Lind
Date:
Mario,

In looking at the code a bit here is one thing you can look at.  The
exception you are getting back is a nested exception.  SQLException has
a getNextException() method.  If you call that on this exception you
will have the real exception that is causing the failure.

thanks,
--Barry

PS.  I will check in a fix that improves the below error message a bit.



Mario Rodriguez Villanea wrote:
> Batch entry 0 [Ljava.lang.Object;@2a6f16 was aborted.
>  at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2St
> atement.java:105)
>  at
> com.capitales.db.common.DBConnection.getDatafromWriteBatch(DBConnection.
> java:233)
>  at
> com.capitales.db.common.DBConnection.executeComplexUpdateBatch(DBConnect
> ion.java:73)
>  at
> com.capitales.db.ecoanalisis.handlers.ImportEcoanalisis.agregarImportEco
> analisis(ImportEcoanalisis.java:169)
>  at
> com.capitales.imports.ecoanalisis.EcoanalisisProcessor.processImportData
> (EcoanalisisProcessor.java:79)
>  at
> com.capitales.imports.ecoanalisis.EcoanalisisImporter.startImportProcess
> (EcoanalisisImporter.java:83)
>  at
> com.capitales.imports.ecoanalisis.EcoanalisisImporter.startImportProcess
> (EcoanalisisImporter.java:62)
>  at com.capitales.imports.Prueba.<init>(Prueba.java:28)
>  at com.capitales.imports.Prueba.main(Prueba.java:35)
>
>
>
> ____________________________________
> Mario A. Rodríguez Villanea
> mrodriguez@avanticatec.com
> Tel Of    : 2839100
> Tel Hab : 2933432
> Avantica Technologies
> http://www.avanticatec.com <http://www.avanticatec.com/>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>