3 Replies Latest reply on Jun 9, 2010 8:04 AM by Mircea Markus

    SQLSyntaxErrorException

    Ana Muñoz Newbie

      Hello

       

      Set my cache, but sends me a  database error at startup (missing  left parenthesis).

       

      TableManipula E org.infinispan.loaders.jdbc.TableManipulation executeUpdateSql Error while creating table
                                       java.sql.SQLSyntaxErrorException: ORA-00906: falta el paréntesis izquierdo

       

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
          at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
          at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
          at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
          at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
          at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
          at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeUpdate(WSJdbcStatement.java:970)
          at org.infinispan.loaders.jdbc.TableManipulation.executeUpdateSql(TableManipulation.java:174)
          at org.infinispan.loaders.jdbc.TableManipulation.createTable(TableManipulation.java:152)
          at org.infinispan.loaders.jdbc.TableManipulation.start(TableManipulation.java:250)
          at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.doConnectionFactoryInitialization(JdbcStringBasedCacheStore.java:299)
          at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.start(JdbcStringBasedCacheStore.java:98)
          at org.infinispan.loaders.CacheLoaderManagerImpl.start(CacheLoaderManagerImpl.java:99)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
          at java.lang.reflect.Method.invoke(Method.java:599)
          at org.infinispan.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:170)
          at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:852)
          at org.infinispan.factories.AbstractComponentRegistry.internalStart(AbstractComponentRegistry.java:672)
          at org.infinispan.factories.AbstractComponentRegistry.start(AbstractComponentRegistry.java:574)
          at org.infinispan.factories.ComponentRegistry.start(ComponentRegistry.java:148)
          at org.infinispan.CacheDelegate.start(CacheDelegate.java:311)
          at org.infinispan.manager.DefaultCacheManager.createCache(DefaultCacheManager.java:507)
          at org.infinispan.manager.DefaultCacheManager.getCache(DefaultCacheManager.java:473)
          at com.GlobalBaseCache.<init>(GlobalBaseCache.java:102)
          at com.GlobalBaseCache.getInstance(GlobalBaseCache.java:184)
          at com.GlobalCache.<init>(GlobalCache.java:41)
          at com.ConfigurationCache.init(ConfigurationCache.java:39)
          at com.servlets.ConfiguracionInitServlet.init(ConfiguracionInitServlet.java:78)
          at javax.servlet.GenericServlet.init(GenericServlet.java:241)
          at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:325)
          at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:165)
          at com.ibm.ws.webcontainer.servlet.ServletWrapper.initialize(ServletWrapper.java:1588)
          at com.ibm.wsspi.webcontainer.extension.WebExtensionProcessor.createServletWrapper(WebExtensionProcessor.java:98)
          at com.ibm.ws.webcontainer.webapp.WebApp.initializeTargetMappings(WebApp.java:605)
          at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinish(WebApp.java:360)
          at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:292)
          at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:99)
          at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:167)
          at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:722)
          at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:607)
          at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:376)
          at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:668)
          at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1162)
          at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1313)
          at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:611)
          at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:938)
          at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:740)
          at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2092)
          at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:437)
          at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:122)
          at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:380)
          at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$300(CompositionUnitMgrImpl.java:105)
          at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:928)
          at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:349)
          at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)

       

      Thank you.