配置ORACLE 12C无法建表

Saint

2019-10-09 22:01:49 PRINT [main] com.x.program.center.Context - com.x.base.core.project.x_program_center loading datas, entity size:24.
<openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 fatal store error> org.apache.openjpa.persistence.OptimisticLockException: Unable to obtain an object lock on "null".
    at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5232)
    at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
    at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162)
    at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2231)
    at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42)
    at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1311)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1062)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:912)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
    at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
    at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
    at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
    at com.x.base.core.container.EntityManagerContainer.listAll(EntityManagerContainer.java:331)
    at com.x.program.center.Context.cleanupSchedule(Context.java:228)
    at com.x.program.center.Context.concrete(Context.java:170)
    at com.x.program.center.ApplicationServletContextListener.contextInitialized(ApplicationServletContextListener.java:13)
    at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:921)
    at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:554)
    at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:888)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:357)
    at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1443)
    at org.eclipse.jetty.quickstart.QuickStartWebApp.startWebapp(QuickStartWebApp.java:131)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1407)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:821)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:276)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
    at org.eclipse.jetty.quickstart.QuickStartWebApp.doStart(QuickStartWebApp.java:200)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:425)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.server.Server.start(Server.java:407)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.server.Server.doStart(Server.java:371)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at com.x.server.console.server.center.CenterServerTools.start(CenterServerTools.java:75)
    at com.x.server.console.server.Servers.startCenterServer(Servers.java:111)
    at com.x.server.console.Main.startCenterServer(Main.java:551)
    at com.x.server.console.Main.main(Main.java:202)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00942: table or view does not exist
{prepstmnt 812708838 SELECT t0.xid, t0.xcreateTime, t0.xscratchBoolean, t0.xscratchDate, t0.xscratchInteger, t0.xscratchString, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.
xclassName, t0.xcron, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xreportTime FROM CTE_SCHEDULE t0} [code=942, state=42000]    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171)
    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300)
    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1866)
    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290)
    at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:530)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:455)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422)
    at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:472)
    at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:254)
    at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:243)
    at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95)
    at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2183)
    at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36)
    ... 42 more
NestedThrowables:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1052)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:253)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:86)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:765)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:921)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3640)
    at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1384)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3687)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:302)
    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1169)
    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300)
    at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1866)
    at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290)
    at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:530)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:455)
    at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422)
    at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:472)
    at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:254)
    at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:243)
    at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95)
    at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2183)
    at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36)
    at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1311)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1062)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:912)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
    at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
    at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
    at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
    at com.x.base.core.container.EntityManagerContainer.listAll(EntityManagerContainer.java:331)
    at com.x.program.center.Context.cleanupSchedule(Context.java:228)
    at com.x.program.center.Context.concrete(Context.java:170)
    at com.x.program.center.ApplicationServletContextListener.contextInitialized(ApplicationServletContextListener.java:13)
    at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:921)
    at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:554)
    at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:888)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:357)
    at org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1443)
    at org.eclipse.jetty.quickstart.QuickStartWebApp.startWebapp(QuickStartWebApp.java:131)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1407)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:821)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:276)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:524)
    at org.eclipse.jetty.quickstart.QuickStartWebApp.doStart(QuickStartWebApp.java:200)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:117)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.server.handler.gzip.GzipHandler.doStart(GzipHandler.java:425)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169)
    at org.eclipse.jetty.server.Server.start(Server.java:407)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:106)
    at org.eclipse.jetty.server.Server.doStart(Server.java:371)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:72)
    at com.x.server.console.server.center.CenterServerTools.start(CenterServerTools.java:75)
    at com.x.server.console.server.Servers.startCenterServer(Servers.java:111)
    at com.x.server.console.Main.startCenterServer(Main.java:551)
    at com.x.server.console.Main.main(Main.java:202)
Caused by: Error : 942, Position : 258, Sql = SELECT t0.xid, t0.xcreateTime, t0.xscratchBoolean, t0.xscratchDate, t0.xscratchInteger, t0.xscratchString, t0.xsequence, t0.xupdateTime, t0.xdistributeFact
or, t0.xapplication, t0.xclassName, t0.xcron, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xreportTime FROM CTE_SCHEDULE t0, OriginalSql = SELECT t0.xid, t0.xcreateTime, t0.xscratchBoolean, t0.xscratchDate, t0.xscratchInteger, t0.xscratchString, t0.xsequence, t0.xupdateTime, t0.xdistributeFactor, t0.xapplication, t0.xclassName, t0.xcron, t0.xelapsed, t0.xfireTime, t0.xnode, t0.xreportTime FROM CTE_SCHEDULE t0, Error Msg = ORA-00942: table or view does not exist
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
    ... 72 more
数据库连接NODE可以连接

Saint

经过多次测试，对于稳定版和开发版都经过多次测试，并替换过jdbc预制的18C驱动，最终确定就是不支持12C的库，18C可以。19C未测试。这个坑有点大，显得不太靠谱

论坛管理员

我们是支持oracle 12c 的，如果表无法创建，建议先检查一下用户的权限！
并检查日志，是否有什么创建表的报错！

Saint

日志里只有这些，数据库已经给DBA的最高权限，版本12.2.
如果还有别的日志，是在什么位置？
使用的是PDB模式，是不是暂时不支持PDB？
这么改有问题吗？
[
    {
        "url":"jdbc:oracle:thin:@//127.10.0.1:1521/orclpdb1",
        "username" : "oa",
        "password" :"oracle",
        "includes": [],
        "excludes": [],
        "enable" : true
    }
]

论坛管理员

我们说明里有对数据库要求说明的

论坛管理员

小小管理员觉得  cdb 和pdb 模式 都是应该没问题的。有问题的话，日志应该也有一些报错，请先自查一下用户权限等基本问题
日志路径：o2server\logs