Mail Archive Home | exo-portal List | Febuary 2008 Index
| <-- Date Index --> | <-- Thread Index --> |
Hi,Yes i always have the problem. I will try to send you the backup of the database today.
Thank you Emmanuel Peter Nedonosko a écrit :
Hi, sorry for delay...Can you run your application on clean database (MySQL) and confirm that the problem still exists. if it still exists can you send a backup of that database (start of JCR with your error, nothing more).Thanks of feedback, Peter.2008/2/7, Emmanuel Rias <emmanuel.rias@xxxxxxxx <mailto:emmanuel.rias@xxxxxxxx>>:Hello, I try to link Exo with a mysql database (i had all the problems related in this thread) but now i have another exception. Do you have any idea ? Thank you Emmanuel The exception: javax.jcr.RepositoryException: Invalid Internal QName '__root_parent' Should sta rt of '[': Invalid Internal QName '__root_parent' Should start of '[' at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection. itemData(JDBCStorageConnection.java:693) at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection. getItemByIdentifier(JDBCStorageConnection.java:492) at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection. getItemData(JDBCStorageConnection.java:448) at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersis tentDataManager.getItemData(WorkspacePersistentDataManager.java:147) at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorksp aceDataManager.getChildNodesData(CacheableWorkspaceDataManager.java:241) at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorksp aceDataManager.getChildNodesData(CacheableWorkspaceDataManager.java:198) at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceS upportedWorkspaceDataManager.getChildNodesData(ACLInheritanceSupportedWorkspaceD ataManager.java:114) at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWork spaceDataManager.getChildNodesData(VersionableWorkspaceDataManager.java:79) at org.exoplatform.services.jcr.impl.util.NodeDataReader.read(NodeDataRe ader.java:142) at org.exoplatform.services.jcr.impl.core.NamespaceDataPersister.loadNam espaces(NamespaceDataPersister.java:233) at org.exoplatform.services.jcr.impl.core.NamespaceRegistryImpl.loadFrom Storage(NamespaceRegistryImpl.java:193) at org.exoplatform.services.jcr.impl.RepositoryContainer.load(Repository Container.java:382) at org.exoplatform.services.jcr.impl.RepositoryContainer.start(Repositor yContainer.java:254) at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.createReposit ory(RepositoryServiceImpl.java:128) at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.init(Reposito ryServiceImpl.java:272) at org.exoplatform.services.jcr.impl.RepositoryServiceImpl.start(Reposit oryServiceImpl.java:210) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor .java:75) at org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.ja va:113) at org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoCont ainer.java:369) at org.exoplatform.container.PortalContainer.start(PortalContainer.java: 84) at org.exoplatform.container.RootContainer.createPortalContainer(RootCon tainer.java:103) at org.exoplatform.portal.application.PortalController.init(PortalContro ller.java:65) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper. java:1161) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:98 1) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex t.java:4045) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4 351) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase .java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77 1) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja va:626) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j ava:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488 ) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java :311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl eSupport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443 ) at org.apache.catalina.core.StandardService.start(StandardService.java:5 16) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710 ) at org.apache.catalina.startup.Catalina.start(Catalina.java:566) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.exoplatform.services.jcr.datamodel.IllegalNameException: Invalid Internal QName '__root_parent' Should start of '[' at org.exoplatform.services.jcr.datamodel.InternalQName.parse(InternalQN ame.java:45) at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection. traverseQPath(JDBCStorageConnection.java:563) at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection. itemData(JDBCStorageConnection.java:681) ... 51 more Benjamin Mestrallet a écrit : > Kito, > > Feel free to complete the wiki too, it is open in write to anyone who > has register there > > Thanks > > Benj > > On Feb 1, 2008, at 6:55 PM, Kito D. Mann wrote: > >> Peter, >> >> >> >> Thanks for the info. I'll give it a shot. I was referring, however, >> to the several steps involved in order to simply configure MySQL. >> Editing three different files isn't quite intuitive, and it's not all >> documented in the Wiki. >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Kito D. Mann - Author, JavaServer Faces in Action >> http://www.virtua.com <http://www.virtua.com/> - JSF/Java EE >> consulting, training, and mentoring >> http://www.JSFCentral.com <http://www.jsfcentral.com/> - JavaServer >> Faces FAQ, news, and info >> >> >> >> *From:* pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx> [mailto:pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx>] *On Behalf >> Of *Peter Nedonosko >> *Sent:* Friday, February 01, 2008 3:39 AM >> *To:* kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>> >> *Cc:* Vitaliy Obmanyuk; exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> >> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>>; exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx> >> <mailto:exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx>> >> *Subject:* Re: [exoplatform] problems with MySQL >> >> >> >> >> >> 2008/1/31, Kito D. Mann <kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>>>: >> >> Peter, >> >> >> >> Thanks for the reply. Would it help if I just changed the database to >> latin1? >> >> >> yes, it will work >> >> >> >> Also, this is a pretty complicated process in comparison to eXo >> 1.x. Is this going to be simplified in the future? >> >> >> if you talk about the mysql utf8 support - yes, we'll a dedicated >> dialect in next 1.8 release >> >> Thank you for feedback. >> >> Regards, Peter. >> >> >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~>> Kito D. Mann - Author, JavaServer Faces in Action >> http://www.virtua.com <http://www.virtua.com/> - JSF/Java EE >> consulting, training, and mentoring >> http://www.JSFCentral.com <http://www.jsfcentral.com/> - >> JavaServer Faces FAQ, news, and info >> >> >> >> *From:* pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx> <mailto:pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx>> >> [mailto:pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx> <mailto:pnedonosko@xxxxxxxxx <mailto:pnedonosko@xxxxxxxxx>>] *On >> Behalf Of *Peter Nedonosko >> *Sent:* Thursday, January 31, 2008 4:03 AM >> *To:* kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>> >> *Cc:* Vitaliy Obmanyuk; exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> >> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>>; exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx> >> <mailto:exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx>> >> >> >> *Subject:* Re: [exoplatform] problems with MySQL >> >> >> >> Hi, >> >> 2008/1/31, Kito D. Mann <kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>>>: >> >> Vitaly, >> >> >> >> Thanks for the quick reply. You were right – I missed that change >> in database-configuration.xml. The dialect also needed to be >> changed in two other config files: conf/jcr/jcr-configuration.xml >> and conf/jcr/repository-configuration.xml. It'd be nice if >> changing the info in one file was sufficient J. >> >> >> >> At any rate, eXo is now having a problem creating keys in tables: >> >> >> it's a UTF-8 case only. >> Because we assume that user will use latin1 char.set we made >> index length maximum. >> >> You have to use prefixed index in file jcr-sjdbc.mysql.sql file >> (see jcr-sjdbc.mysql-utf8.sql). These files located in >> exo.jcr.component.core-xxx.jar. >> >> CREATE UNIQUE INDEX JCR_IDX_MITEM_PARENT ON JCR_MITEM(PARENT_ID, >> NAME(300), I_INDEX, I_CLASS, VERSION DESC); >> CREATE UNIQUE INDEX JCR_IDX_MITEM_PARENT_NAME ON >> JCR_MITEM(I_CLASS, PARENT_ID, NAME(300), I_INDEX, VERSION DESC); >> >> I.e. you should change file in jcr jar. >> >> >> Regards, Peter. >> >> 2008/01/28 12:33:52:500 EST [INFO] JDBCWorkspaceDataContainer - >> Using a dialect 'MySQL' >> >> … >> >> 2008/01/28 12:33:52:546 EST [ERROR] JDBCWorkspaceDataContainer - >> Error of init db org.exoplatform.services.jcr. >> >> ength is 765 bytes; . Last command: CREATE UNIQUE INDEX >> JCR_IDX_SITEM_PARENT ON JCR_SITEM(CONTAINER_NAME, PAREN >> >> f DataSource: 'system'. Reason: Specified key was too long; max >> key length is 765 bytes; . Last command: CREATE >> >> orage.jdbc.init.DBInitializerException: Could not create db >> schema of DataSource: 'system'. Reason: Specified k >> >> AME, I_INDEX, I_CLASS, VERSION) >> >> at>> org.exoplatform.services.jcr.impl.storage.jdbc.init.DBInitializer.init(DBInitializer.java:292)>> >> at>> org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspaceDataContainer.initDatabase(JDBCWorkspace>> >> at>> org.exoplatform.services.jcr.impl.storage.jdbc.JDBCWorkspaceDataContainer.<init>(JDBCWorkspaceDataCo>> >> at>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)>> >> at>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)>> >> at >> java.lang.reflect.Constructor.newInstance(Constructor.java:494) >> >> at>> org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:131)>> >> at>> org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:57>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:322)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceOfType(DefaultPicoContainer.java>> >> at>> org.exoplatform.services.jcr.impl.RepositoryContainer.registerWorkspace(RepositoryContainer.java:155>> >> at>> org.exoplatform.services.jcr.impl.RepositoryContainer.registerWorkspacesComponents(RepositoryContain>> >> at>> org.exoplatform.services.jcr.impl.RepositoryContainer.registerComponents(RepositoryContainer.java:32>> >> at>> org.exoplatform.services.jcr.impl.RepositoryContainer.<init>(RepositoryContainer.java:93)>> >> at>> org.exoplatform.services.jcr.impl.RepositoryServiceImpl.createRepository(RepositoryServiceImpl.java:>> >> at>> org.exoplatform.services.jcr.impl.RepositoryServiceImpl.init(RepositoryServiceImpl.java:272)>> >> at>> org.exoplatform.services.jcr.impl.RepositoryServiceImpl.start(RepositoryServiceImpl.java:210)>> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >> at>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)>> >> at java.lang.reflect.Method.invoke(Method.java:585) >> >> at>> org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:75)>> >> at>> org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.java:113)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoContainer.java:369)>> >> at>> org.exoplatform.container.PortalContainer.start(PortalContainer.java:84)>> >> at>> org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:103)>> >> at>> org.exoplatform.portal.application.PortalController.init(PortalController.java:65)>> >> at>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)>> >> at>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)>> >> at>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4044)>> >> at>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)>> >> at>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)>> >> at>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)>> >> at>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)>> >> at>> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)>> >> at>> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)>> >> at>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)>> >> at>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)>> >> at>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)>> >> at>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)>> >> at>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)>> >> at>> org.apache.catalina.core.StandardHost.start(StandardHost.java:719)>> >> at>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)>> >> at>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)>> >> at>> org.apache.catalina.core.StandardService.start(StandardService.java:448)>> >> at>> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)>> >> at >> org.apache.catalina.startup.Catalina.start(Catalina.java:552) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >> at>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)>> >> at java.lang.reflect.Method.invoke(Method.java:585) >> >> at >> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) >> >> at >> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) >> >> Caused by: java.sql.SQLException: Specified key was too long; max >> key length is 765 bytes >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) >> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) >> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) >> >> at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) >> >> at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935) >> >> at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873) >> >> at>> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)>> >> at>> org.exoplatform.services.jcr.impl.storage.jdbc.init.DBInitializer.init(DBInitializer.java:263)>> >> ... 53 more >> >> >> >> Any ideas? >> >> >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~>> Kito D. Mann - Author, JavaServer Faces in Action >> http://www.virtua.com <http://www.virtua.com/> - JSF/Java EE >> consulting, training, and mentoring >> http://www.JSFCentral.com <http://www.jsfcentral.com/> - >> JavaServer Faces FAQ, news, and info >> phone: +1 203-653-2989 >> fax: +1 203-653-2988 >> >> >> >> *From:* Vitaliy Obmanyuk [mailto:vetalok@xxxxxxxxx <mailto:vetalok@xxxxxxxxx> >> <mailto:vetalok@xxxxxxxxx <mailto:vetalok@xxxxxxxxx>>] >> *Sent:* Monday, January 28, 2008 11:18 AM >> *To:* kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>> >> *Cc:* exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>>; >> exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx> <mailto:exo-portal@xxxxxxx <mailto:exo-portal@xxxxxxx>> >> *Subject:* Re: [exoplatform] problems with MySQL >> >> >> >> Hello Kito, >> you wrote: >> ... >> <property name="driverClassName" value="org.hsqldb.jdbcDriver"/> >> >> <property name="url">> value="jdbc:mysql://localhost:3307/exo2?relaxAutoCommit=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8"/>>> >> you should use mysql DB driver instead of >> <property name="driverClassName" value="org.hsqldb.jdbcDriver"/> >> >> please look into workspace configuration, there should be mysql >> dialect: >> >> <property name="dialect" value="mysql" /> >> >> HTH >> >> 2008/1/28, Kito D. Mann <kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx> <mailto:kmann@xxxxxxxxxx <mailto:kmann@xxxxxxxxxx>>>: >> >> Hello, >> >> >> >> I'm working with eXo 2 r2329 on Windows XP and when I tried to >> switch from Hypersonic to MySQL 5.0.24a, I got the following >> exception: >> >> >> >> ERROR: cannot create portal container. ServletContext: >> org.apache.catalina.core.ApplicationContextFacade@423da9 >> >> java.lang.RuntimeException: Cannot instantiate component class >> org.exoplatform.services.jcr.impl.RepositoryServiceImpl >> >> at>> org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:76)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:322)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getComponentInstancesOfType(DefaultPicoContainer.java:281)>> >> at>> org.exoplatform.container.PortalContainer.getComponentInstancesOfType(PortalContainer.java:112)>> >> at>> org.picocontainer.defaults.LifecycleVisitor.visitContainer(LifecycleVisitor.java:97)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.accept(DefaultPicoContainer.java:416)>> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >> at>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)>> >> at java.lang.reflect.Method.invoke(Method.java:585) >> >> at>> org.picocontainer.defaults.AbstractPicoVisitor.traverse(AbstractPicoVisitor.java:32)>> >> at>> org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:63)>> >> at>> org.picocontainer.defaults.LifecycleVisitor.start(LifecycleVisitor.java:113)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.start(DefaultPicoContainer.java:369)>> >> at>> org.exoplatform.container.PortalContainer.start(PortalContainer.java:84)>> >> at>> org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:103)>> >> at>> org.exoplatform.portal.application.PortalController.init(PortalController.java:65)>> >> at>> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)>> >> at>> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)>> >> at>> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4044)>> >> at>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)>> >> at>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)>> >> at>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)>> >> at>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)>> >> at>> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)>> >> at>> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)>> >> at>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)>> >> at>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)>> >> at>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)>> >> at>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)>> >> at>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)>> >> at>> org.apache.catalina.core.StandardHost.start(StandardHost.java:719)>> >> at>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)>> >> at>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)>> >> at>> org.apache.catalina.core.StandardService.start(StandardService.java:448)>> >> at>> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)>> >> at >> org.apache.catalina.startup.Catalina.start(Catalina.java:552) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >> at>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)>> >> at java.lang.reflect.Method.invoke(Method.java:585) >> >> at >> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) >> >> at >> org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) >> >> Caused by: java.lang.RuntimeException: Cannot instantiate >> component class>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl>> >> at>> org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:76)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:322)>> >> at>> org.picocontainer.defaults.DefaultPicoContainer.getComponentInstanceOfType(DefaultPicoContainer.java:313)>> >> at>> org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:123)>> >> at>> org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:57)>> >> ... 42 more >> >> Caused by: java.lang.reflect.InvocationTargetException >> >> at>> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)>> >> at>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)>> >> at>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)>> >> at >> java.lang.reflect.Constructor.newInstance(Constructor.java:494) >> >> at>> org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:131)>> >> at>> org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:57)>> >> ... 46 more >> >> Caused by:>> org.exoplatform.services.jcr.config.RepositoryConfigurationException:>> Fail to init from xml! Reason:>> org.exoplatform.services.jcr.config.RepositoryConfigurationException:>> Database exception. java.sql.SQLException: Column length too big >> for colu >> >> mn 'CONFIG' (max = 65535); use BLOB or TEXT instead. SQL: CREATE >> TABLE JCR_CONFIG (NAME VARCHAR(64) NOT NULL, CONFIG >> VARBINARY(102400) NOT NULL, CONSTRAINT JCR_CONFIG_PK PRIMARY >> KEY(NAME)) >> >> at>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.<init>(RepositoryServiceConfigurationImpl.java:98)>> >> ... 52 more >> >> Caused by:>> org.exoplatform.services.jcr.config.RepositoryConfigurationException:>> Database exception. java.sql.SQLException: Column length too big >> for column 'CONFIG' (max = 65535); use BLOB or TEXT instead. SQL: >> CREATE TABLE JCR_CONFIG (NAME VARCHAR(64) N >> >> OT NULL, CONFIG VARBINARY(102400) NOT NULL, CONSTRAINT >> JCR_CONFIG_PK PRIMARY KEY(NAME)) >> >> at>> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.write(JDBCConfigurationPersister.java:271)>> >> at>> org.exoplatform.services.jcr.impl.config.RepositoryServiceConfigurationImpl.<init>(RepositoryServiceConfigurationImpl.java:90)>> >> ... 52 more >> >> Caused by: java.sql.SQLException: Column length too big for >> column 'CONFIG' (max = 65535); use BLOB or TEXT instead >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) >> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) >> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) >> >> at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) >> >> at com.mysql.jdbc.Statement.executeUpdate(Statement.java:935) >> >> at com.mysql.jdbc.Statement.executeUpdate(Statement.java:873) >> >> at>> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)>> >> at>> org.exoplatform.services.jcr.impl.config.JDBCConfigurationPersister.write(JDBCConfigurationPersister.java:226)>> >> ... 53 more >> >> >> >> I have modified database-configuration.xml in the >> porta/WEB-INF/conf/database directory: >> >> >> >> <?xml version="1.0" encoding="ISO-8859-1"?> >> >> <configuration> >> >> <component> >> >>>> <key>org.exoplatform.services.database.impl.ExoCacheProvider</key>>> >>>> <type>org.exoplatform.services.database.impl.ExoCacheProvider</type>>> >> </component> >> >> >> >> <component> >>>> <key>org.exoplatform.services.database.HibernateService</key>>> >> <jmx-name>database:type=HibernateService</jmx-name> >> >>>> <type>org.exoplatform.services.database.impl.HibernateServiceImpl</type>>> >> <init-params> >> >> <properties-param> >> >> <name>hibernate.properties</name> >> >> <description>Default Hibernate Service</description> >> >> <property name="hibernate.show_sql" value="false"/> >> >> <property name="hibernate.cglib.use_reflection_optimizer" >> value="true"/> >> >> <property name="hibernate.connection.url">> value="jdbc:mysql://localhost:3307/exo2?relaxAutoCommit=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8"/>>> >> <property name="hibernate.connection.driver_class" >> value="com.mysql.jdbc.Driver"/> >> >> <property name="hibernate.connection.autocommit" >> value="true"/> >> >> <property name="hibernate.connection.username" value="name"/> >> >> <property name="hibernate.connection.password" >> value="password"/> >> >> <property name="hibernate.dialect" >> value="org.hibernate.dialect.MySQLDialect"/> >> >> <property name="hibernate.c3p0.min_size" value="5"/> >> >> <property name="hibernate.c3p0.max_size" value="20"/> >> >> <property name="hibernate.c3p0.timeout" value="1800"/> >> >> <property name="hibernate.c3p0.max_statements" value="50"/> >> >> </properties-param> >> >> </init-params> >> >> </component> >> >> >> >> <external-component-plugins> >> >>>> <target-component>org.exoplatform.services.naming.InitialContextInitializer</target-component>>> >> <component-plugin> >> >> <name>bind.datasource</name> >> >> <set-method>addPlugin</set-method> >> >>>> <type>org.exoplatform.services.naming.BindReferencePlugin</type>>> >> <init-params> >> >> <value-param> >> >> <name>bind-name</name> >> >> <value>jdbcexo</value> >> >> </value-param> >> >> <value-param> >> >> <name>class-name</name> >> >> <value>javax.sql.DataSource</value> >> >> </value-param> >> >> <value-param> >> >> <name>factory</name> >> >> >> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> >> >> </value-param> >> >> <properties-param> >> >> <name>ref-addresses</name> >> >> <description>ref-addresses</description> >> >> <property name="driverClassName" >> value="org.hsqldb.jdbcDriver"/> >> >> <property name="url">> value="jdbc:mysql://localhost:3307/exo2?relaxAutoCommit=true&autoReconnect=true&useUnicode=true&characterEncoding=utf8"/>>> >> <property name="username" value="name"/> >> >> <property name="password" value="password"/> >> >> </properties-param> >> >> </init-params> >> >> </component-plugin> >> >> </external-component-plugins> >> >> </configuration> >> >> </configuration> >> >> >> >> And, of course, everything was fine before I changed this file to >> point to MySQL instead of Hypersonic. The database does actually >> exist, and the user has the proper rights. However, no tables >> have been created. >> >> >> >> Any ideas? >> >> >>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~>> Kito D. Mann - Author, JavaServer Faces in Action >> http://www.virtua.com <http://www.virtua.com/> - JSF/Java EE >> consulting, training, and mentoring >> http://www.JSFCentral.com <http://www.jsfcentral.com/> - >> JavaServer Faces FAQ, news, and info >> phone: +1 203-653-2989 >> fax: +1 203-653-2988 >> >> >> >> >> >> -- >> You receive this message as a subscriber of the >> exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>> mailing list. >> To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx> >> <mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx>> >> For general help: mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx> >> <mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx>>?subject=help >> OW2 mailing lists service home page: http://www.ow2.org/wws >> >> >> >> >> -- >> Best regards, >> Vitaliy >> >> >> >> -- >> You receive this message as a subscriber of the >> exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>> mailing list. >> To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx> >> <mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx>> >> For general help: mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx> >> <mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx>>?subject=help >> OW2 mailing lists service home page: http://www.ow2.org/wws >> >> >> >> >> >> >> -- >> You receive this message as a subscriber of the exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> >> <mailto:exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx>> mailing list. >> To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx> >> For general help: mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx>?subject=help >> OW2 mailing lists service home page: http://www.ow2.org/wws > > ------------------------------------------------------------------------ > > > -- > You receive this message as a subscriber of the exoplatform@xxxxxxx <mailto:exoplatform@xxxxxxx> mailing list. > To unsubscribe: mailto:exoplatform-unsubscribe@xxxxxxx <mailto:exoplatform-unsubscribe@xxxxxxx> > For general help: mailto:sympa@xxxxxxx <mailto:sympa@xxxxxxx>?subject=help > OW2 mailing lists service home page: http://www.ow2.org/wws >
| <-- Date Index --> | <-- Thread Index --> |
Powered by MHonArc.
Copyright © 2006-2007, OW2 Consortium | contact | webmaster.