Hi, I am getting this error when trying to do query() and CreateTable() with XML data type on db2 database. (Using ibm_db_sa)
Any suggestions how to resolve this? from sqlalchemy import create_engine from sqlalchemy import MetaData from sqlalchemy import Table from sqlalchemy.schema import CreateTable from sqlalchemy.orm import sessionmaker db2_engine = create_engine('ibm_db_sa://user:pass@server:50001/DBNAME') meta = MetaData(bind=db2_engine, schema='udbadm') table1 = Table('table1', meta, autoload=True) Session = sessionmaker(bind=db2_engine) session = Session() res = session.query(table1).first() print(res) # Similar issue with CreateTable: # print(CreateTable(table1)) Traceback (most recent call last): File "defect_rep1.py", line 14, in <module> print(CreateTable(table1)) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\elements.py", line 506, in __str__ return unicode(self.compile()).encode('ascii', 'backslashreplace') File "<string>", line 1, in <lambda> File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\elements.py", line 494, in compile return self._compiler(dialect, bind=bind, **kw) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\ddl.py", line 26, in _compiler return dialect.ddl_compiler(dialect, self, **kw) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 190, in __init__ self.string = self.process(self.statement, **compile_kwargs) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 213, in process return obj._compiler_dispatch(self, **kwargs) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch return meth(self, **kw) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 2153, in visit_create_table (table.description, column.name, ce.args[0]) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\util\compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 2142, in visit_create_table and not first_pk) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 213, in process return obj._compiler_dispatch(self, **kwargs) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\visitors.py", line 81, in _compiler_dispatch return meth(self, **kw) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 2173, in visit_create_column first_pk=first_pk File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 2314, in get_column_specification column.type, type_expression=column) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\compiler.py", line 261, in process return type_._compiler_dispatch(self, **kw) File "C:\dev\test_ibm_db_sa\venv27\lib\site-packages\sqlalchemy\sql\visitors.py", line 79, in _compiler_dispatch raise exc.UnsupportedCompilationError(visitor, cls) sqlalchemy.exc.CompileError: (in table 'table1', column 'text_xml'): Compiler <sqlalchemy.sql.compiler.GenericTypeCompiler object at 0x03792BB0> can't render element of type <class 'ibm_db_sa.base.XML'> This is how the table is setup in DB2: CREATE TABLE UDBADM.TABLE1 ( ID_TEST CHARACTER(36) NOT NULL, TEXT_XML XML PRIMARY KEY (ID_TEST) ); Thanks, SL -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.