jalveblad
13 years agoOccasional Contributor
JDBC request failing when selecting timestamp
Hi,
I have a JDBC request that is a simpe select:
When this test test runs it only responds with "Error getting response; null" in SoapUI. In the cmd-window you get from starting with the bat-file I get this log.
14:16:47,686 INFO [AbstractHttpRequestDesktopPanel] Error getting response for
[Check Stuff in DB]; null
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
If I change the * to a specific column name the test step works fine, except for the column that contains a timestamp.
If I run the query in a DB client such as DBVisualizer it can select the timestamp column.
So what can be causing this? A corrupt timestamp? Some hidden char in a timestamp somewhere?
Some info about my setup:
SoapUI 4.5.1 32-bit version running on Windows 7
Database, DB2 V9.5
I have a JDBC request that is a simpe select:
SELECT * FROM SCHEMA.TABLE WHERE COLUMN = 'my string'
When this test test runs it only responds with "Error getting response; null" in SoapUI. In the cmd-window you get from starting with the bat-file I get this log.
14:16:47,686 INFO [AbstractHttpRequestDesktopPanel] Error getting response for
[Check Stuff in DB]; null
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
If I change the * to a specific column name the test step works fine, except for the column that contains a timestamp.
If I run the query in a DB client such as DBVisualizer it can select the timestamp column.
So what can be causing this? A corrupt timestamp? Some hidden char in a timestamp somewhere?
Some info about my setup:
SoapUI 4.5.1 32-bit version running on Windows 7
Database, DB2 V9.5