Ticket #15647

AmaterasERD cannot import mixed-case Oracle table names

Date d'ouverture: 2009-03-21 06:15 Dernière mise à jour: 2009-03-21 06:15

Rapporteur:
Propriétaire:
Type:
État:
Ouvert [Owner assigned]
Composant:
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

Attachment File List

No attachments

Modifier

Please login to add comment to this ticket » Connexion