Forum Discussion

Holly_Greger's avatar
Holly_Greger
Contributor
12 years ago

Help: Unable to retrieve Date columns from database

Using a DataSource to attempt to retrieve a couple of fields from the sql database using the com.microsoft.sqlserver.jdbc.SQLServerDriver.

I have to properties create EmployeeName, BeginDate & EndDate

Sample SQL Query

Select NameEmployee as EmployeeName, DateBegin as BeginDate, DateEnd as EndDate
From Job
Where EmployeeNumber = 'xyz'

The name comes back just fine, but the dates properties are empty. The dates in the Sql Server DB are populated (2011-02-10 00:00:00.000).

Any Help is greatly appreciated.

1 Reply

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    SmartBear Alumni (Retired)
    Hi!

    The reason is probably because soapUI has problem converting the data type of BeginDate and EndDate to a soapUI custom property.
    Do you get any errors in the soapui or error log tab in the bottom of the main soapUI window?

    --
    Regards

    Erik
    SmartBear Sweden