Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: Tracey KellyA former colleague had been successfully using a jdbc query node to perform a simple 'select * from <db.table>' where <db> is a sql database. This had been working fine but I needed to change the dbuser accessing the data and the node aquisition now fails with the error 'exited with no zero status'. Nothing else has changed, just the username and password.
I can, however, sucessfully pull data from the db using a db query node (with a pre-configured odbc connection) and the same salect statement. I can also pull the data using excel directly from the database so it seems to be an issue with the db user access and the jdbc query node.
Has anyone ever experienced this error before?
Why would jdbc query be used over db query for a simple 'select * from <table>' command?
Many Thanks