0 Replies Latest reply on Apr 21, 2013 9:52 PM by currying

    gatein、mssql2012、jtds

    currying

      09:41:29,768 INFO  [exo.jcr.component.core.JDBCWorkspaceDataContainer] (MSC service thread 1-4) dialect:MSSQL, source-name:java:/jdbcjcr_portal, db-structure-type:isolated, update-storage:true, max-buffer-size:204800, swap-directory:F:\work\java_workspace\GateIn-3.5.0.Final-jbossas7\standalone\data/gatein/jcr/system_portal, value storage provider: []

      09:41:29,875 WARN  [exo.jcr.component.core.DBInitializer] (MSC service thread 1-4) An error occurs while creating the tables it could be due to some existing tables that have not been properly created earlier. Please drop manually the tables of the workspace 'system' and try again.

      09:41:29,878 ERROR [exo.jcr.component.core.JDBCWorkspaceDataContainer] (MSC service thread 1-4) Error of init db org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create the DB schema of the workspace 'system'. Reason: 数据库中已存在名为 'JCR_ISYSTEM' 的对象。; 数据库中已存在名为 'JCR_ISYSTEM' 的对象。; 数据库中已存在名为 'JCR_ISYSTEM' 的对象。. Last command: CREATE TABLE JCR_ISYSTEM(   ID VARCHAR(96) NOT NULL,   PARENT_ID VARCHAR(96) NOT NULL,   NAME VARCHAR(512) NOT NULL,   VERSION INTEGER NOT NULL,    I_CLASS INTEGER NOT NULL,   I_INDEX INTEGER NOT NULL,   N_ORDER_NUM INTEGER,   P_TYPE INTEGER,    P_MULTIVALUED INTEGER,    CONSTRAINT JCR_PK_ISYSTEM PRIMARY KEY(ID),   CONSTRAINT JCR_FK_ISYSTEM_PARENT FOREIGN KEY(PARENT_ID) REFERENCES JCR_ISYSTEM(ID)  ): org.exoplatform.services.jcr.impl.util.jdbc.DBInitializerException: Could not create the DB schema of the workspace 'system'. Reason: 数据库中已存在名为 'JCR_ISYSTEM' 的对象。; 数据库中已存在名为 'JCR_ISYSTEM' 的对象。; 数据库中已存在名为 'JCR_ISYSTEM' 的对象。. Last command: CREATE TABLE JCR_ISYSTEM(   ID VARCHAR(96) NOT NULL,   PARENT_ID VARCHAR(96) NOT NULL,   NAME VARCHAR(512) NOT NULL,   VERSION INTEGER NOT NULL,    I_CLASS INTEGER NOT NULL,   I_INDEX INTEGER NOT NULL,   N_ORDER_NUM INTEGER,   P_TYPE INTEGER,    P_MULTIVALUED INTEGER,    CONSTRAINT JCR_PK_ISYSTEM PRIMARY KEY(ID),   CONSTRAINT JCR_FK_ISYSTEM_PARENT FOREIGN KEY(PARENT_ID) REFERENCES JCR_ISYSTEM(ID)  )

                at org.exoplatform.services.jcr.impl.util.jdbc.DBInitializer.init(DBInitializer.java:319) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.initDatabase(CQJDBCWorkspaceDataContainer.java:190) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspaceDataContainer.<init>(JDBCWorkspaceDataContainer.java:321) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.CQJDBCWorkspaceDataContainer.<init>(CQJDBCWorkspaceDataContainer.java:84) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_17]

                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_17]

                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_17]

                at java.lang.reflect.Constructor.newInstance(Constructor.java:525) [rt.jar:1.7.0_17]

                at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:421) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:97) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.management.ManageableComponentAdapter.getComponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.ConcurrentPicoContainer.getInstance(ConcurrentPicoContainer.java:468) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanceOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.CachingContainer.getComponentInstanceOfType(CachingContainer.java:139) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer$2.run(RepositoryContainer.java:377) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer$2.run(RepositoryContainer.java:356) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:310) [exo.kernel.commons-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer.registerWorkspace(RepositoryContainer.java:355) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer.registerWorkspacesComponents(RepositoryContainer.java:808) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer.registerComponents(RepositoryContainer.java:719) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer.access$300(RepositoryContainer.java:98) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer$1.run(RepositoryContainer.java:166) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer$1.run(RepositoryContainer.java:158) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:310) [exo.kernel.commons-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryContainer.<init>(RepositoryContainer.java:157) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.createRepository(RepositoryServiceImpl.java:138) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.init(RepositoryServiceImpl.java:323) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.start(RepositoryServiceImpl.java:279) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_17]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_17]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_17]

                at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_17]

                at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:100) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:554) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.ExoContainer.start(ExoContainer.java:269) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.PortalContainer.start(PortalContainer.java:656) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.ExoContainer.start(ExoContainer.java:257) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:674) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:342) [exo.kernel.container-2.4.0-GA.jar:2.4.0-GA]

                at org.gatein.integration.jboss.as7.web.StartupService.start(StartupService.java:50)

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811)

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_17]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_17]

                at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_17]

      Caused by: java.sql.SQLException: 数据库中已存在名为 'JCR_ISYSTEM' 的对象。

                at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)

                at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)

                at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)

                at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)

                at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)

                at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)

                at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:371)

                at org.exoplatform.services.jcr.impl.util.jdbc.DBInitializer$2.run(DBInitializer.java:279) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedExceptionAction(SecurityHelper.java:310) [exo.kernel.commons-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedSQLExceptionAction(SecurityHelper.java:121) [exo.kernel.commons-2.4.0-GA.jar:2.4.0-GA]

                at org.exoplatform.services.jcr.impl.util.jdbc.DBInitializer.init(DBInitializer.java:275) [exo.jcr.component.core-1.15.0-GA.jar:1.15.0-GA]

                ... 45 more