#113 Issue with SYS.XMLTYPE in Oracle 11g

[Anonymous]

Firstly, thank you for such a great tool. I just want to report a problem that I'm seeing with the new 5.0. It appears as if 5.0 has an issue with Oracle XMLTYPE columns. Attached is an image of the table definition. All of the other data types (number, varchar2, timestamp) run fine with Schema Spy on other tables. Thus my guess is it's the XMLTYPE column.

I am connecting to Oracle 11.1.7.0 with the Oracle JDBC client that comes as part of the Oracle 11.1.7.0 client. I am running Java SE 1.6.0_13. The machine that is running Schema Spy is using Windows Vista Enterprise 32-bit.

Attached is a copy of the crash information from Java. If you need anything else, please let me know.

Thanks again for the excellent program.

Robert Sillett

Using database properties:
[schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/ora.properties
Gathering schema details............................................................................
....................................................................................................
.................................13:31:59.782 WARNING: Table.initColumnAutoUpdate - Failed to determ
ine auto increment status: java.sql.SQLException: Closed Connection
13:31:59.827 WARNING: Table.initColumnAutoUpdate - SQL: select * from TROP."ENTITY_CLIENT_FIELD" whe
re 0 = 1
13:31:59.827 WARNING: Table.initIndexes - Failed to query index information with SQL: select null as
table_cat, owner as table_schem, table_name, 0 as NON_UNIQUE, null as index_qualifier, null as inde
x_name, 0 as type, 0 as ordinal_position, null as column_name, null as asc_or_desc, num_rows as card
inality, blocks as pages, null as filter_condition from all_tables where table_name = :table and own
er = :owner union select null as table_cat, i.owner as table_schem, i.table_name, decode (i.uniquene
ss, 'UNIQUE', 0, 1), null as index_qualifier, i.index_name, 1 as type, c.column_position as ordinal_
position, c.column_name, null as asc_or_desc, i.distinct_keys as cardinality, i.leaf_blocks as pages
, null as filter_condition from all_indexes i, all_ind_columns c where i.table_name = :table and i.o
wner = :owner and i.index_name = c.index_name and i.table_owner = c.table_owner and i.table_name = c
.table_name and i.owner = c.index_owner
13:31:59.834 WARNING: Table.initIndexes - java.sql.SQLException: Closed Connection
13:31:59.835 WARNING: Table.initIndexes - Unable to extract index info for table 'ENTITY_CLIENT_FIEL
D' in schema 'TROP': java.sql.SQLException: Closed Connection
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3127)
at oracle.jdbc.driver.T2CConnection.prepareStatement(T2CConnection.java:41)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3042)
at oracle.jdbc.driver.T2CConnection.prepareStatement(T2CConnection.java:41)
at oracle.jdbc.OracleDatabaseMetaData.getPrimaryKeys(OracleDatabaseMetaData.java:3324)
at net.sourceforge.schemaspy.model.Table.initPrimaryKeys(Table.java:235)
at net.sourceforge.schemaspy.model.Table.<init>(Table.java:90)
at net.sourceforge.schemaspy.model.Database$TableCreator.createImpl(Database.java:1003)
at net.sourceforge.schemaspy.model.Database$TableCreator.create(Database.java:999)
at net.sourceforge.schemaspy.model.Database.initTables(Database.java:259)
at net.sourceforge.schemaspy.model.Database.<init>(Database.java:71)
at net.sourceforge.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:211)
at net.sourceforge.schemaspy.Main.main(Main.java:42)

[Anonymous]

Table Definition

[John Currier]

I assume that this would be a bug in the Oracle JDBC driver since it appears to be oracle.jdbc.OracleDatabaseMetaData.getPrimaryKeys(OracleDatabaseMetaData.java:3324) that's blowing up.

Hopefully SchemaSpy continued to do its analysis of the database, right?

John