AmaterasERD cannot import mixed-case Oracle table names

• Rapporteur: rita_gwen
• Propriétaire: takezoe
• Type: Bogues
• État: Ouvert [Owner assigned]
• Composant: AmaterasERD
• Jalon: (Aucun)
• Priorité: 5 - moyen
• Sévérité: 5 - moyen
• Résolution: Aucun
• Fichier: Aucun

Détails

By default Oracle capitalizes all database object names. If names are used in quotes (qualified names), their case is preserved. For example :

CREATE TABLE Customer (name varchar2(100));

creates a table CUSTOMER. But

CREATE TABLE "Customer" (name varchar2(100));

creates table with the name Customer. AmaterasERD cannot import tables with qualified names. Exception stack trace is below:

!ENTRY net.java.amateras.db 4 4 2009-03-20 17:02:09.757
!MESSAGE Error
!STACK 0
java.sql.SQLException: ORA-00903: invalid table name

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1615)
	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1580)
	at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3485)
	at net.java.amateras.db.dialect.DefaultSchemaLoader.loadIndexModels(DefaultSchemaLoader.java:168)
	at net.java.amateras.db.dialect.DefaultSchemaLoader.getTableInfo(DefaultSchemaLoader.java:156)
	at net.java.amateras.db.dialect.DefaultSchemaLoader.loadSchema(DefaultSchemaLoader.java:39)
	at net.java.amateras.db.wizard.NewDiagramWizardPage2.importTables(NewDiagramWizardPage2.java:273)
	at net.java.amateras.db.visual.action.ImportFromJDBCAction$ImportFromJDBCWizard.performFinish(ImportFromJDBCAction.java:52)
	at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:742)
	at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:373)
	at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:616)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
	at org.eclipse.jface.window.Window.open(Window.java:796)
	at net.java.amateras.db.visual.action.ImportFromJDBCAction.run(ImportFromJDBCAction.java:30)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
	at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)

Ticket History (1/1 Histories)

2009-03-21 06:15 Updated by: rita_gwen

• New Ticket "AmaterasERD cannot import mixed-case Oracle table names" created