Affects Version/s: 6.0.5 GA, 6.1.1 CE GA2, 6.1.20 EE GA2
Environment:Windows 7 Professional
Oracle Database 10g 10.0.2.0.3.0
Liferay 6.0.5 CE
Branch Version/s:6.1.x, 6.0.x
Backported to Branch:Committed
Similar Issues:Show 5 results
LPS-28063 Data Migration Does Not Work when going from Oracle to Mysql - Getting "Data too long" exception LPS-31078 Error after Data Migration LPS-32640 Tomcat bundle breaks JNDI LPS-52836 Document Library Data Migration does not support new dl.hook.impl classes LPS-27738 Data Migration not working
I crated a topic here: http://www.liferay.com/community/forums/-/message_boards/message/6462092
We are using Liferay with connection configured to use JNDI:
And this datasource is configured in JBoss (see liferay-ds.attached).
After, I create a new database called liferay6-copy in MySql server.
So, when I try to use the Control Panel -> Server Administration -> Data Migration, fill up the target database fields like this:
Driver class: com.mysql.jdbc.Driver
JDBC URL: jdbc:mysql://localhost:3306/lportal6-copy?useUnicode=true&characterEncoding=UTF-8
JDBC User name: root
JDBC password: root
During migration I got an error, see text file attached.
Debugging source code, I found the file DataSourceFactoryBean.java that has a method called createInstance(). In this method, there is a check to verify if the properties has the jndi.name key, if exists, will return a connection with JNDI, not the database specified in Data Migration page.
A workaround is change portal-ext.properties to use JDBC instead of JNDI and restart Liferay server. And finally I can run Data Migration, but I'm having other problem.