search

timabell / sqlHawk

Database management / migration tooling. Java / JDBC based.
http://timabell.github.com/sqlHawk/
GNU General Public License v3.0
8 stars 4 forks source link

no sql error shown when stored proc update fails #37

Closed timabell closed 12 years ago

timabell commented 12 years ago

get a stack trace but need the error thrown by the server

Updating existing database... java.lang.Exception: Error updating proc myproc1 at uk.co.timwise.sqlhawk.db.write.DbWriter.write(DbWriter.java:70) at uk.co.timwise.sqlhawk.SchemaMapper.writeDb(SchemaMapper.java:195) at uk.co.timwise.sqlhawk.SchemaMapper.RunMapping(SchemaMapper.java:102) at uk.co.timwise.sqlhawk.Main.main(Main.java:55) Caused by: java.sql.SQLException: Invalid column name 'SendToGpc'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:558) at uk.co.timwise.sqlhawk.db.write.DbWriter.write(DbWriter.java:67) ... 3 more

timabell commented 12 years ago

clearly I'm an idiot. looking further down the stack trace reveals the error "Caused by: java.sql.SQLException: Invalid column name 'SendToGpc'."