Worklight中的.wlapp文件部署错误 [英] .wlapp file deployment error in Worklight
问题描述
我正在将我在Eclise的开发环境中的Worklight应用程序迁移到Tomcat 7上的测试环境,将MySQL作为我的Worklight数据库。
I am migrating a Worklight application from my development environment in Eclise to a Testing environment on Tomcat 7, with MySQL as my Worklight database.
我按照给出的说明进行操作@ Worklight Guide 和< a href =http://pic.dhe.ibm.com/infocenter/wrklight/v5r0m6/index.jsp?topic=/com.ibm.worklight.help.doc/admin/t_setting_up_your_my_sql_database_manually.html\"rel =nofollow > IBM指南,用于设置MySql for Worklight 。
I followed the instructions given @ Worklight Guide and IBM Guide for setting up MySql for Worklight.
通过Worklight Console进行部署时,控制台部署适配器没有问题,但在部署.wlapp文件时,有一个数据库错误:
When deploying via Worklight Console, the console deploys adapters without a problem, but while deploying the .wlapp files, there is a DB error:
[部署.wlapp时的错误,大小为4.5MB]
无法部署应用程序'XXXXXXXX.wlapp'。 :通过mysql_send_long_data()设置的预备
语句的参数长于
'max_allowed_packet'字节{prepstmnt 940490894 INSERT INTO
APP_SYNC_DATA(appDeployableKey,deployable,deployableHash,
lastPersistentPropertyChange) VALUES(?,?,?,?)[params =(String)
jqmMultipageSite1-android-1.0,(InputStream)
java.io.ByteArrayInputStream@5083c762,(String)
4acdb5054a0bd4ec908ad282bb95d183bbbdd217, (长)1369395093111]}
[代码= 1105,州= HY000]
Failed to deploy application 'XXXXXXXX.wlapp'. : Parameter of prepared statement which is set through mysql_send_long_data() is longer than 'max_allowed_packet' bytes {prepstmnt 940490894 INSERT INTO APP_SYNC_DATA (appDeployableKey, deployable, deployableHash, lastPersistentPropertyChange) VALUES (?, ?, ?, ?) [params=(String) jqmMultipageSite1-android-1.0, (InputStream) java.io.ByteArrayInputStream@5083c762, (String) 4acdb5054a0bd4ec908ad282bb95d183bbbdd217, (long) 1369395093111]} [code=1105, state=HY000]
[部署wlapp时出错]对于大小为1.5 MB的iPhone]
无法部署应用程序'xxxxxxxxx.wlapp'。 :数据截断:
日期时间值不正确:''第1行第'LAST_UPDATE_TIME'行'
{prepstmnt 362762411 INSERT INTO GADGETS(DISP_IN_GALLERY,
LAST_UPDATE_TIME,NAME)VALUES(?,?,? )[params =(int)1,(Timestamp)
2013-05-24 17:10:06.322,(String)jqmMultipageSite1]} [code = 0,
state = 22001
Failed to deploy application 'xxxxxxxxx.wlapp'. : Data truncation: Incorrect datetime value: '' for column 'LAST_UPDATE_TIME' at row 1 {prepstmnt 362762411 INSERT INTO GADGETS (DISP_IN_GALLERY, LAST_UPDATE_TIME, NAME) VALUES (?, ?, ?) [params=(int) 1, (Timestamp) 2013-05-24 17:10:06.322, (String) jqmMultipageSite1]} [code=0, state=22001
推荐答案
错误非常简单。 .wlapp文件的部署失败,因为MySQL中的属性 max_allowed_packet
的值太低(默认为1MB)。
The error is pretty much straight forward. The deployment of the .wlapp files fails because the value of the property max_allowed_packet
in MySQL is too low (by default it is 1MB).
看起来你链接的MySQL指南错过了一些(重要)步骤。
请尝试以下说明:
It seems like the MySQL guide you've linked to misses some (important) steps.
Try these instructions:
- 找到属于MySQL安装的文件
my.ini
- 在其中,找到<$>部分c $ c> [mysqld]
- 在部分名称下方粘贴:
max_allowed_packet = 500M
- 重新启动MySQL服务
- 重新部署.wlapp文件
- Locate the file
my.ini
belonging to your MySQL installation - In it, find the section
[mysqld]
- Underneath the section name, paste this:
max_allowed_packet=500M
- Re-start the MySQL service
- Re-deploy the .wlapp files
部署现在应该通过。
这篇关于Worklight中的.wlapp文件部署错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!