RE: [exoplatform] problems with MySQL

Peter,

Thanks for the reply. Would it help if I just changed the database to latin1?

Also, this is a pretty complicated process in comparison to eXo 1.x. Is this going to be simplified in the future?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Kito D. Mann - Author, JavaServer Faces in Action
http://www.virtua.com - JSF/Java EE consulting, training, and mentoring
http://www.JSFCentral.com - JavaServer Faces FAQ, news, and info

From: pnedonosko@xxxxxxxxx [mailto:pnedonosko@xxxxxxxxx] On Behalf Of Peter Nedonosko
Sent: Thursday, January 31, 2008 4:03 AM
To: kmann@xxxxxxxxxx
Cc: Vitaliy Obmanyuk; exoplatform@xxxxxxx; exo-portal@xxxxxxx
Subject: Re: [exoplatform] problems with MySQL

Hi,

2008/1/31, Kito D. Mann <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?

From: Vitaliy Obmanyuk [mailto:vetalok@xxxxxxxxx]
Sent: Monday, January 28, 2008 11:18 AM
To: kmann@xxxxxxxxxx
Cc: exoplatform@xxxxxxx; exo-portal@xxxxxxx
Subject: Re: [exoplatform] problems with MySQL

Hello Kito,
you wrote:
...
<property name="driverClassName" value="org.hsqldb.jdbcDriver"/>

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>:

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)