Forum Discussion

Perchishka's avatar
Perchishka
Occasional Contributor
9 years ago
Solved

JDBC request with date from another JDBC response and stored procedure

I have a JDBC response:

<Results>
    <ResultSet fetchSize="0">
        <Row rowNumber="1">
            <PS_SUBSCRIBE_DATA_290.CHANGED_DATE>2017-02-01 12:13:51.378</PS_SUBSCRIBE_DATA_290.CHANGED_DATE>
        </Row>
    </ResultSet>
</Results>

I need to use this date in another JDBC request

But also ineed to use stored procedure because of the name of the table.

 

I have a SQL query for DBeaver client  and it works: 

select * from get_partition_name('ps_subscribe_history','2017-02-01 12:13:51'::timestamp without time zone)

 

But when i want to do the same sql query in JDBC request:

select * from get_partition_name('ps_subscribe_history', '${JDBC Request#ResponseAsXml#PS_SUBSCRIBE_DATA_290.CHANGED_DATE}')

This produces an error :

 

2017-02-01 18:46:34 - Error getting response; org.postgresql.util.PSQLException: ERROR: invalid input syntax for type timestamp: ""Position: 58

 

Could you help me to resolve this problem?

 

Maybe this  error is caused by an incorrect date format ?

2017-02-01 12:13:51.378