[GitHub] [beam] damccorm opened a new issue, #21091: WriteToJdbc does not respect 'statement' parameter in python

[GitBox <gi...@apache.org>]

damccorm opened a new issue, #21091:
URL: https://github.com/apache/beam/issues/21091

   I need to insert geometry into my postgresql database. My pipeline stage is a follows;
   ```
   
   // 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(?), ?, ?, ?, ?,
   ?, ?)"""
   
   ```
   
   I expect this code to write data to database and cast my text into geometry type while inserting. But it does not work.
     
   
   Imported from Jira [BEAM-12693](https://issues.apache.org/jira/browse/BEAM-12693). Original Jira may contain additional context.
   Reported by: egeucak.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org