search

baztian / jaydebeapi

JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.
GNU Lesser General Public License v3.0
365 stars 148 forks source link

XML data to string? #223

Open wavewater opened 1 year ago

wavewater commented 1 year ago

Perhaps this issue is similar to #76

I am reading an XML column from DB2. When fetching and printing the data, I get an object but I want the XML string.

conn = jaydebeapi.connect(driver_class,connection_url,credentials,driver_path)

curs= conn.cursor() curs.execute("select * from TEST_XML ") print(curs.fetchall())

Output is: [(1, <jaydebeapi.com.ibm.db2.jcc.am.dc object at 0x7fc8ecdc03b0>)]

Instead <jaydebeapi.com.ibm.db2.jcc.am.dc object at 0x7fc8ecdc03b0> I would like to get the XML String