[jira] [Commented] (BEAM-12693) WriteToJdbc does not respect 'statement' parameter in python

["Beam JIRA Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/BEAM-12693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17427818#comment-17427818 ] 

Beam JIRA Bot commented on BEAM-12693:
--------------------------------------

This issue was marked "stale-P2" and has not received a public comment in 14 days. It is now automatically moved to P3. If you are still affected by it, you can comment and move it back to P2.

> WriteToJdbc does not respect 'statement' parameter in python
> ------------------------------------------------------------
>
>                 Key: BEAM-12693
>                 URL: https://issues.apache.org/jira/browse/BEAM-12693
>             Project: Beam
>          Issue Type: Bug
>          Components: io-java-jdbc, io-py-common
>    Affects Versions: 2.31.0
>            Reporter: ege ucak
>            Priority: P3
>
> I need to insert geometry into my postgresql database. My pipeline stage is a follows;
> {code:python}
> // code placeholder
> | 'Write jdbc' >> WriteToJdbc(                  jdbc_url='jdbc:postgresql://localhost:5432/postgre',                    driver_class_name='org.postgresql.Driver', table_name='test',                username='postgres', password='postgres',
> statement="""INSERT INTO test
> VALUES(?, ?, ?, ST_GeomFromText(?), ?, ?, ?, ?, ?, ?)"""
> {code}
> I expect this code to write data to database and cast my text into geometry type while inserting. But it does not work.
>   



--
This message was sent by Atlassian Jira
(v8.3.4#803005)