|
From: Gerd W. <bir...@t-...> - 2005-07-21 05:50:30
|
I forgot: If several statements are executed in one run the log contains the erroneous SQL too. Gerd Wagner wrote: > Hi Paolo, > > is in CVS and will be in the next snapshot, see > http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128 > > > There will be a new Session property:'Write SQL Execution Errors to log > file'. If you check this, messages will be written to squirrel-sql.log. > For PostgreSQL the log entry will look like. > > 40096 [Thread-3] INFO > net.sourceforge.squirrel_sql.client.session.mainpanel.SQLResultExecuterPanel > - Error: java.sql.SQLException: ERROR: relation "wart" does not exist, > SQL State: 42P01, Error Code: 0 > > > Hope that's what you need. > > Gerd > > Paolo Orru wrote: > >> Hello, >> I'm a new user of SQuirreL SQL Client 2.0. >> >> I'm using it to execute arbitrary SQL instructions from a file. >> >> Is there any way to configure it to print out, in the log file, the >> ErrorCode (as integer number) relative to the SQLState code? >> >> In other words, for any Exception I need to get the vendorErrorCode. >> >> Thanks in advance, >> Paolo >> >> >> P.S. if it's important I'm using PosgreSQL 8 >> >> >> ------------------------------------------------------- >> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies >> from IBM. Find simple to follow Roadmaps, straightforward articles, >> informative Webcasts and more! Get everything you need to get up to >> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > |
