本文介绍了Worklight中的.wlapp文件部署错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 我正在将我在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 和 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_pa​​cket'字节{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_pa​​cket 的值太低(默认为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_pa​​cket = 500M 重新启动MySQL服务 重新部署.wlapp文件 Locate the file my.ini belonging to your MySQL installationIn it, find the section [mysqld]Underneath the section name, paste this: max_allowed_packet=500MRe-start the MySQL serviceRe-deploy the .wlapp files部署现在应该通过。 这篇关于Worklight中的.wlapp文件部署错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-29 01:13