[
https://issues.apache.org/jira/browse/BEAM-12693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17421538#comment-17421538
]
Beam JIRA Bot commented on BEAM-12693:
--------------------------------------
This issue is P2 but has been unassigned without any comment for 60 days so it
has been labeled "stale-P2". If this issue is still affecting you, we care!
Please comment and remove the label. Otherwise, in 14 days the issue will be
moved to P3.
Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed
explanation of what these priorities mean.
> 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: P2
> Labels: stale-P2
>
> 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)
