Hello, I'm trying to retrieve some column properties from a oracle database using oracle+zxjdbc:
jdbcUrl = '%(engine_dialect)s://%(username)s:%(password)s...@%(hostname)s:%(port)d/%(data base)s' % connection engine = sa.create_engine(jdbcUrl) inspector = sa.engine.reflection.Inspector(engine) tableNames = inspector.get_table_names() for tableName in tableNames[:4]: columns = inspector.get_columns(tableName) print tableName for column in columns: print " ", column['name'], ': ',str(column['type']) The program termintes with the exception Traceback (most recent call last): File "oracle-test-b.py", line 23, in <module> tableNames = inspector.get_table_names() File "/usr/local/lib/jython251/Lib/site-packages/sqlalchemy/engine/reflection.py" , line 98, in get_table_names tnames = self.dialect.get_table_names(self.conn, File "<string>", line 1, in <lambda> File "/usr/local/lib/jython251/Lib/site-packages/sqlalchemy/engine/reflection.py" , line 40, in cache ret = fn(self, con, *args, **kw) File "/usr/local/lib/jython251/Lib/site-packages/sqlalchemy/dialects/oracle/base. py", line 764, in get_table_names schema = self.denormalize_name(schema or self.default_schema_name) AttributeError: 'OracleDialect_zxjdbc' object has no attribute 'default_schema_name' Java 1.6.0 / Jython 2.5.1 / sqlalchemy 0.6.1 Thanks in advance. PS: any problems when using postgresql
smime.p7s
Description: S/MIME cryptographic signature