Social Office isn´t working with mysql database

[Paul Dunkler, módosítva 14 év-val korábban]

Hey guys,

i´ve read, that there were several people on this board, experienced problems, when changing the database from social office from the internal database to mysql - So i tried it and got many errors too! I will post them here and hope, that anyone out there can help me. The only configuration i´ve made is this in the portal-ext.properties:

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/intranet?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=lportal
jdbc.default.password=lportal

Displaying the home page is working properly, but when i try to login, i get the same exception as Ravinder Singh mentioned before in this post: http://www.liferay.com/web/guest/community/forums/-/message_boards/message/3981382

So - it would be very nice, if someone out there knows about the problem or can do a fix on this ;) If you need more information, please let me know

Here is the full Stack Trace of the Liferay-Startup where you can see the hibernate-exception
Using CATALINA_BASE: /var/www/liferay-social-office-1.5b/tomcat-6.0.18
Using CATALINA_HOME: /var/www/liferay-social-office-1.5b/tomcat-6.0.18
Using CATALINA_TMPDIR: /var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp
Using JRE_HOME: /usr
06.10.2009 07:58:05 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/amd64/server:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/lib/amd64:/usr/lib/jvm/java-1.5.0-sun-1.5.0.17/jre/../lib/amd64
06.10.2009 07:58:05 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector
INFO: Using a shared selector for servlet write/read
06.10.2009 07:58:05 org.apache.coyote.http11.Http11NioProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
06.10.2009 07:58:05 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3798 ms
06.10.2009 07:58:05 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
06.10.2009 07:58:05 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Loading jar:file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/ROOT/WEB-INF/classes/portal-ext.properties
Loading jar:file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/captcha.properties
07:58:36,223 INFO [PortalImpl:258] Portal lib directory /var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Standard Edition 5.2.3 (Augustine / Build 5203 / May 20, 2009)
07:59:04,016 ERROR [JDBCExceptionReporter:101] Table 'intranet.Lock_' doesn't exist
07:59:04,534 WARN [ReleaseLocalServiceImpl:122] Table 'intranet.Release_' doesn't exist
07:59:04,536 INFO [ReleaseLocalServiceImpl:135] Create tables and populate with default data
07:59:10,413 INFO [DBUtil:500] Database does not support case sensitive queries
07:59:11,624 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyProcessSuite
07:59:11,627 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyProperties
07:59:11,629 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyLucene
07:59:11,632 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyMySQL
07:59:11,882 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyCounter
07:59:11,916 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyUUID
07:59:11,928 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyBlogs
07:59:12,173 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyBookmarks
07:59:12,181 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
07:59:12,189 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyGroup
07:59:12,197 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyImageGallery
07:59:12,205 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyJournal
07:59:12,230 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyLayout
07:59:12,238 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyMessageBoards
07:59:12,266 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyOrganization
07:59:12,271 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifySocial
07:59:12,273 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyUser
07:59:12,289 INFO [VerifyProcess:51] Verifying com.liferay.portal.verify.VerifyWiki
07:59:16,655 INFO [ServerDetector:103] Detected server tomcat
07:59:17,038 INFO [HotDeployUtil:63] Initializing hot deploy manager 954884045
07:59:17,581 INFO [AutoDeployDir:107] Auto deploy scanner started for /var/www/liferay-social-office-1.5b/deploy
07:59:25,475 INFO [LuceneServlet:65] Indexing Lucene on startup
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/0-chat-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/0-chat-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/0-chat-portlet/WEB-INF/classes/service.properties
07:59:27,360 INFO [ServiceComponentLocalServiceImpl:269] Running Chat SQL scripts for the first time
07:59:27,476 WARN [DBUtil:473] BLOB/TEXT column 'content' used in key specification without a key length: create index IX_2A17A23F on Chat_Entry (fromUserId, toUserId, content);
07:59:27,715 INFO [PortletHotDeployListener:229] Registering portlets for chat-portlet
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/0-chat-portlet/WEB-INF/classes/portlet.properties
07:59:28,383 INFO [PortletHotDeployListener:348] 1 portlet for chat-portlet is available for use
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/1-contacts-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/1-contacts-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/1-contacts-portlet/WEB-INF/classes/service.properties
07:59:29,815 INFO [ServiceComponentLocalServiceImpl:269] Running Contacts SQL scripts for the first time
07:59:30,011 INFO [HookHotDeployListener:189] Registering hook for contacts-portlet
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/1-contacts-portlet/WEB-INF/classes/portal.properties
07:59:30,228 INFO [HookHotDeployListener:384] Hook for contacts-portlet is available for use
07:59:30,231 INFO [PortletHotDeployListener:229] Registering portlets for contacts-portlet
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/1-contacts-portlet/WEB-INF/classes/portlet.properties
07:59:30,533 INFO [PortletHotDeployListener:348] 1 portlet for contacts-portlet is available for use
07:59:31,342 INFO [PortletHotDeployListener:229] Registering portlets for mail-portlet
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/2-mail-portlet/WEB-INF/classes/portlet.properties
07:59:31,709 INFO [PortletHotDeployListener:348] 1 portlet for mail-portlet is available for use
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/so-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/so-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/so-portlet/WEB-INF/classes/service.properties
07:59:33,236 INFO [ServiceComponentLocalServiceImpl:269] Running SO SQL scripts for the first time
07:59:33,403 INFO [HookHotDeployListener:189] Registering hook for so-portlet
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/webapps/so-portlet/WEB-INF/classes/portal.properties
07:59:36,126 WARN [ThemeLocalServiceImpl:131] No theme found for specified theme id so_WAR_sotheme. Returning the default theme.
07:59:36,213 WARN [ThemeLocalServiceImpl:131] No theme found for specified theme id so_WAR_sotheme. Returning the default theme.
07:59:39,087 ERROR [JDBCExceptionReporter:101] Incorrect string value: '\xD0\xA1\xD0\xB0\xD0\xB9...' for column 'preferences' at row 1
07:59:39,101 ERROR [HotDeployUtil:110] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for so-portlet
com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for so-portlet
at com.liferay.portal.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:57)
at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:102)
at com.liferay.portal.kernel.deploy.hot.HotDeployUtil._doFireDeployEvent(HotDeployUtil.java:107)
at com.liferay.portal.kernel.deploy.hot.HotDeployUtil._fireDeployEvent(HotDeployUtil.java:152)
at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:42)
at com.liferay.portal.kernel.servlet.PortletContextListener.portalInit(PortletContextListener.java:112)
at com.liferay.portal.kernel.util.PortalInitableUtil.init(PortalInitableUtil.java:47)
at com.liferay.portal.kernel.servlet.PortletContextListener.contextInitialized(PortletContextListener.java:108)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.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:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
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: com.liferay.portal.kernel.events.ActionException: com.liferay.portal.ModelListenerException: java.io.IOException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.so.hook.events.StartupAction.run(StartupAction.java:74)
at com.liferay.portal.kernel.events.InvokerSimpleAction.run(InvokerSimpleAction.java:51)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvent(HookHotDeployListener.java:587)
at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvents(HookHotDeployListener.java:648)
at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:242)
at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:99)
... 30 more
Caused by: com.liferay.portal.ModelListenerException: java.io.IOException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutSetListener.java:80)
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutSetListener.java:58)
at com.liferay.portal.model.InvokerModelListener.onAfterCreate(InvokerModelListener.java:69)
at com.liferay.portal.service.persistence.LayoutSetPersistenceImpl.update(LayoutSetPersistenceImpl.java:282)
at com.liferay.portal.service.impl.LayoutSetLocalServiceImpl.addLayoutSet(LayoutSetLocalServiceImpl.java:83)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy27.addLayoutSet(Unknown Source)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:179)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupLocalServiceImpl.java:104)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy22.addGroup(Unknown Source)
at com.liferay.portal.service.impl.UserLocalServiceImpl.addUser(UserLocalServiceImpl.java:405)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy71.addUser(Unknown Source)
at com.liferay.portal.service.UserLocalServiceUtil.addUser(UserLocalServiceUtil.java:148)
at com.liferay.so.hook.events.StartupAction.setupUsers(StartupAction.java:376)
at com.liferay.so.hook.events.StartupAction.doRun(StartupAction.java:88)
at com.liferay.so.hook.events.StartupAction.run(StartupAction.java:71)
... 35 more
Caused by: java.io.IOException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.portlet.PortletPreferencesImpl.store(PortletPreferencesImpl.java:252)
at com.liferay.so.hook.listeners.LayoutSetListener.updatePortletTitle(LayoutSetListener.java:353)
at com.liferay.so.hook.listeners.LayoutSetListener.addUserLayouts(LayoutSetListener.java:172)
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutSetListener.java:76)
... 85 more
07:59:39,109 INFO [PortletHotDeployListener:229] Registering portlets for so-portlet
07:59:39,840 INFO [PortletHotDeployListener:353] 4 portlets for so-portlet are available for use
07:59:40,214 INFO [ThemeHotDeployListener:89] Registering themes for so-theme
07:59:40,384 INFO [ThemeHotDeployListener:113] 1 theme for so-theme is available for use
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/3-tms-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/3-tms-portlet/WEB-INF/classes/service.properties
Loading file:/var/www/liferay-social-office-1.5b/tomcat-6.0.18/temp/3-tms-portlet/WEB-INF/classes/service.properties
07:59:42,123 INFO [ServiceComponentLocalServiceImpl:269] Running TMS SQL scripts for the first time
07:59:42,358 INFO [PortletHotDeployListener:229] Registering portlets for tms-portlet
07:59:42,614 INFO [PortletHotDeployListener:348] 1 portlet for tms-portlet is available for use
07:59:43,316 INFO [PortletHotDeployListener:229] Registering portlets for todays-events-portlet
07:59:43,569 INFO [PortletHotDeployListener:348] 1 portlet for todays-events-portlet is available for use
07:59:47,048 INFO [PortletHotDeployListener:229] Registering portlets for weather-portlet
07:59:47,285 INFO [PortletHotDeployListener:348] 1 portlet for weather-portlet is available for use
07:59:48,893 INFO [PortletHotDeployListener:229] Registering portlets for wysiwyg-portlet
07:59:49,081 INFO [PortletHotDeployListener:348] 1 portlet for wysiwyg-portlet is available for use
06.10.2009 07:59:49 org.apache.coyote.http11.Http11NioProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
06.10.2009 07:59:49 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
06.10.2009 07:59:49 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=1/56 config=null
06.10.2009 07:59:49 org.apache.catalina.startup.Catalina start
INFO: Server startup in 103933 ms

[Zsolt Balogh, módosítva 14 év-val korábban]

Hi,

You should create your database with UTF8 character set:

create database soffice character set utf8;

[Ryan Park, módosítva 14 év-val korábban]

I'm just curious, did recreating the table with "character set utf8" solve your problem?

[Karim HJ, módosítva 12 év-val korábban]

Ryan Park:

I'm just curious, did recreating the table with "character set utf8" solve your problem?

It worked for me.

[Dhandapani S, módosítva 12 év-val korábban]

Hi Karim,

Even i am trying to use mysql with social office. I have installed social office and i added datasource details in portal-ext.properties as like below.
##
## You can override portal.properties by specifying your own settings in this
## file.
##
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/competencyportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=root

Server is starting properly and loaded login page, when i seen user_ table in database, i seen only one user(default) that too is not admin. If i am tying to create any user, its not creating. can u please help me out?

Error in console is below :

05:04:29,385 ERROR [JDBCExceptionReporter:101] Incorrect string value: '\xD0\xA1
\xD0\xB0\xD0\xB9...' for column 'preferences' at row 1
05:04:29,479 ERROR [jsp:164] com.liferay.portal.ModelListenerException: java.io.
IOException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.excep
tion.GenericJDBCException: Could not execute JDBC batch update
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutS
etListener.java:80)
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutS
etListener.java:58)
at com.liferay.portal.model.InvokerModelListener.onAfterCreate(InvokerMo
delListener.java:69)
at com.liferay.portal.service.persistence.LayoutSetPersistenceImpl.updat
e(LayoutSetPersistenceImpl.java:282)
at com.liferay.portal.service.impl.LayoutSetLocalServiceImpl.addLayoutSe
t(LayoutSetLocalServiceImpl.java:83)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupL
ocalServiceImpl.java:179)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupL
ocalServiceImpl.java:104)
at com.liferay.portal.service.impl.UserLocalServiceImpl.addUser(UserLoca
lServiceImpl.java:405)
at com.liferay.portal.service.impl.UserServiceImpl.addUser(UserServiceIm
pl.java:191)
at com.liferay.portal.service.UserServiceUtil.addUser(UserServiceUtil.ja
va:91)
at com.liferay.portlet.login.action.CreateAccountAction.addUser(CreateAc
countAction.java:228)
at com.liferay.portlet.login.action.CreateAccountAction.processAction(Cr
eateAccountAction.java:94)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequ
estProcessor.java:179)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:19
6)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:80)

at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletF
ilterUtil.java:56)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java
:634)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImp
l.java:666)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletIm
pl.java:356)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAc
tion.java:607)
Caused by: java.io.IOException: com.liferay.portal.kernel.dao.orm.ORMException:
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch updat
e
at com.liferay.portlet.PortletPreferencesImpl.store(PortletPreferencesIm
pl.java:252)
at com.liferay.so.hook.listeners.LayoutSetListener.updatePortletTitle(La
youtSetListener.java:353)
at com.liferay.so.hook.listeners.LayoutSetListener.addUserLayouts(Layout
SetListener.java:172)
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutS
etListener.java:76)
at com.liferay.so.hook.listeners.LayoutSetListener.onAfterCreate(LayoutS
etListener.java:58)
at com.liferay.portal.model.InvokerModelListener.onAfterCreate(InvokerMo
delListener.java:69)
at com.liferay.portal.service.persistence.LayoutSetPersistenceImpl.updat
e(LayoutSetPersistenceImpl.java:282)
at com.liferay.portal.service.impl.LayoutSetLocalServiceImpl.addLayoutSe
t(LayoutSetLocalServiceImpl.java:83)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy27.addLayoutSet(Unknown Source)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupL
ocalServiceImpl.java:179)
at com.liferay.portal.service.impl.GroupLocalServiceImpl.addGroup(GroupL
ocalServiceImpl.java:104)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy22.addGroup(Unknown Source)
at com.liferay.portal.service.impl.UserLocalServiceImpl.addUser(UserLoca
lServiceImpl.java:405)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy71.addUser(Unknown Source)
at com.liferay.portal.service.impl.UserServiceImpl.addUser(UserServiceIm
pl.java:191)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
at $Proxy72.addUser(Unknown Source)
at com.liferay.portal.service.UserServiceUtil.addUser(UserServiceUtil.ja
va:91)
at com.liferay.portlet.login.action.CreateAccountAction.addUser(CreateAc
countAction.java:228)
at com.liferay.portlet.login.action.CreateAccountAction.processAction(Cr
eateAccountAction.java:94)
at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequ
estProcessor.java:179)
at com.liferay.portlet.StrutsPortlet.processAction(StrutsPortlet.java:19
6)
at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:80)

at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletF
ilterUtil.java:56)
at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java
:634)
at com.liferay.portlet.InvokerPortletImpl.invokeAction(InvokerPortletImp
l.java:666)
at com.liferay.portlet.InvokerPortletImpl.processAction(InvokerPortletIm
pl.java:356)
at com.liferay.portal.action.LayoutAction.processPortletRequest(LayoutAc
tion.java:607)
at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.jav
a:427)
at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:194)

at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:236)
at com.liferay.portal.struts.PortalRequestProcessor.process(PortalReques
tProcessor.java:159)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.
java:607)
at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:845)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(St
ripFilter.java:181)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZip
Filter.java:147)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(
SecureFilter.java:285)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:302)
at com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServ
let.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETag
Filter.java:50)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(St
ripFilter.java:141)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZip
Filter.java:136)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(
SecureFilter.java:285)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(Ca
cheFilter.java:422)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processF
ilter(AutoLoginFilter.java:262)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.sso.opensso.OpenSSOFilter.processF
ilter(OpenSSOFilter.java:72)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFil
ter(NtlmPostFilter.java:91)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(Sharepoi
ntFilter.java:191)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.proc
essFilter(VirtualHostFilter.java:235)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.servlet.filters.threadlocalcache.ThreadLocalCacheF
ilter.processFilter(ThreadLocalCacheFilter.java:51)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter
.java:173)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java
:103)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewrit
eFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:286)
at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcesso
r.java:880)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.pr
ocess(Http11NioProtocol.java:719)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoin
t.java:2081)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:675)
at java.lang.Thread.run(Thread.java:595)



Thanks in advance

Dhandapani S

[Karim HJ, módosítva 12 év-val korábban]

Hi,
There is my mySQL for creating DB for my Social Office.

--CREATE DATABASE FOR SOCIAL OFFICE
-- DROP USER 'soportal_owner'@'localhost' ;
DROP DATABASE IF EXISTS `soportal` ;
-- CREATE DATABASE `soportal` IF NOT EXISTS `soportal` ;
CREATE DATABASE IF NOT EXISTS `soportal` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'soportal_owner'@'localhost' IDENTIFIED BY 'soportal_owner';
GRANT ALL PRIVILEGES ON `soportal`.* TO 'soportal_owner'@'localhost';

And the portal-ext.properties file :
# @author Karim
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost:3306/soportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=soportal_owner
jdbc.default.password=soportal_owner


I hope it will help,

Karim

[Cesar Pajares, módosítva 12 év-val korábban]

Social Office work correctly with mysql database if it's UTF-8

Create the database in mysql with the next command:

create database name_database character set utf8;