Oracle 12c 生成数据库表问题

longyu065

Bex5 V 3.5 版本因项目需要，现在使用Oracle 12c进行开发，现在通过修改Tomcat下的content.xml文件可以连接上数据（以下为content.xml中的修改部分）

但现在使用X5 Studio 开发时向数据库中生成表，生成失败，提示数据库连接不成功，如下图


控制台报错如下;
[ERROR] 生成数据库表：连接数据库失败，请检查数据源配置。 [com.justep.studio.createphysicaltable.wizard.ResultPage$3 2016-11-16 10:51:28]
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521/orcl
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at com.justep.db.util.ConnectionUtil.getConnection(Unknown Source)
        at com.justep.db.util.ConnectionUtil.getConnectionByDsName(Unknown Source)
        at com.justep.studio.createphysicaltable.controller.CreateTableActionController.getConnection(Unknown Source)
        at com.justep.studio.createphysicaltable.controller.CreateTableActionController.createTablesFromDefine(Unknown Source)
        at com.justep.studio.createphysicaltable.wizard.CreateTableWizard.createTables(Unknown Source)
        at com.justep.studio.createphysicaltable.wizard.ResultPage$3.run(Unknown Source)
        at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
        at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
        at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4144)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)
        at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
        at org.eclipse.jface.window.Window.open(Window.java:801)
        at com.justep.studio.createphysicaltable.wizard.CreateTableWizardDialog.show(Unknown Source)
        at com.justep.studio.createphysicaltable.wizard.CreateTableWizardDialog.show(Unknown Source)
        at com.justep.studio.ui.editors.ontology.OntologyMainPanel.generateDatabaseTables(Unknown Source)
        at com.justep.studio.ui.editors.ontology.OntologyMainPanel.access$100(Unknown Source)
        at com.justep.studio.ui.editors.ontology.OntologyMainPanel$4.widgetSelected(Unknown Source)
        at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
        at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
        at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
        at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
        at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
        at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)
        at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)
        at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)
        at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
        at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)
        at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
        at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

请问如何解决，谢谢

jishuang

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

studio中不是读取的context.xml中的是读取的studio\dropins\studio-app2\config\dscfg.xml中的

longyu065

jishuang 发表于 2016-11-16 13:04
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

studio中不是读取 ...

谢谢，成功了，之前就是不知道这个信息是在哪儿写。结贴吧