[sqlalchemy] Using Inspector with oracle+zxjdbc

[Witzel, Stefan]

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