2 Replies Latest reply on Nov 5, 2007 7:23 AM by Mircea Markus

    changing name of jdbc.table.name?

    Bruce Springfield Apprentice

      Can we not change the name of the table used by JDBCCacheLoader?

      If I change the name to anything other than 'jbosscache' then as the POJOCache is started, I get the exception :

      org.jboss.cache.pojo.PojoCacheException: Failed starting org.jboss.cache.CacheException: Unable to start cache loaders

      .
      .
      .

      ORA-02264: name already used by an existing constraint


      full error text :

      19:00:05,369 ERROR [[Controller]] Servlet.service() for servlet Controller threw exception
      org.jboss.cache.pojo.PojoCacheException: Failed starting org.jboss.cache.CacheException: Unable to start cache loaders
      at org.jboss.cache.pojo.impl.PojoCacheImpl.start(PojoCacheImpl.java:262)
      at com.jboss.cache.POJOCacheImpl.start(POJOCacheImpl.java:161)
      at com.jboss.cache.POJOCacheImpl.(POJOCacheImpl.java:26)
      at com.jboss.cache.POJOCacheImpl.cacheInstance(POJOCacheImpl.java:33)
      at com.jboss.test.CacheTest.init(CacheTest.java:44)
      at com.jboss.test.CacheTest.start(CacheTest.java:211)
      at com.jboss.test.ControllerServlet.processRequest(ControllerServlet.java:36)
      at com.jboss.test.ControllerServlet.doGet(ControllerServlet.java:18)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
      at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: org.jboss.cache.CacheException: Unable to start cache loaders
      at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:384)
      at org.jboss.cache.CacheImpl.internalStart(CacheImpl.java:733)
      at org.jboss.cache.CacheImpl.start(CacheImpl.java:708)
      at org.jboss.cache.pojo.impl.PojoCacheImpl.start(PojoCacheImpl.java:258)
      ... 27 more
      Caused by: java.sql.SQLException: ORA-02264: name already used by an existing constraint

      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:1168)
      at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
      at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
      at org.jboss.cache.loader.AdjListJDBCCacheLoader.start(AdjListJDBCCacheLoader.java:251)
      at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:248)
      at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:378)
      ... 30 more