チケット #15647

AmaterasERD cannot import mixed-case Oracle table names

登録: 2009-03-21 06:15 最終更新: 2009-03-21 06:15

報告者:
担当者:
チケットの種類:
状況:
オープン [担当者決定済み]
コンポーネント:
マイルストーン:
(未割り当て)
優先度:
5 - 中
重要度:
5 - 中
解決法:
なし

詳細

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)

添付ファイルリスト

添付ファイルはありません

チケットの履歴 (1 件中 1 件表示)

2009-03-21 06:15 更新者: rita_gwen
  • 新しいチケット "AmaterasERD cannot import mixed-case Oracle table names" が作成されました

編集

このチケットにコメントを追加するには、ログインが必要です » ログインする