Thread: [Squirrel-sql-users] How to print out ErrorCode for any SQLExceptions
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Paolo O. <pao...@gm...> - 2005-07-20 11:38:21
|
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 |
From: Gerd W. <bir...@t-...> - 2005-07-20 22:03:33
|
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 > |
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 >> > > |
From: Rob M. <Rob...@co...> - 2005-07-21 12:46:56
|
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 > All, I plan to upload the next snapshot on Saturday morning (July 23rd US-EDT). If anyone needs it sooner, please let me know. In the future, my plan is to upload snapshots every Saturday morning, unless we need one sooner, or in case the trunk is in a bad state. I plan to limit the number of available snapshots to 4. Any given snapshot will have two files - a java archive which contains the platform independent installer (courtesy of IzPack) and a gzip'd tarball that contains the source. If anyone has suggestions or questions, please feel free to speak up. Rob CollabraSpace - Revolutionary Collaboration Visit us at http://www.collabraspace.com This message has been scanned for viruses by ClamAV v0.83 |
From: Rob M. <Rob...@co...> - 2005-07-23 12:34:21
|
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 >> > Paolo, The snapshot (squirrel-sql-Snapshot-20050716_1356-install.jar) is available for download. Rob CollabraSpace - Revolutionary Collaboration Visit us at http://www.collabraspace.com This message has been scanned for viruses by ClamAV v0.83 |