Worklight Appcenter应用程序Android App上传SQL错误 [英] Worklight Appcenter Application Android App upload SQL Error

问题描述

我正在尝试使用Worklight ApplicationCenter控制台安装IBMApplicationCenter.apk（Worklight服务器附带的Appcenter应用程序）。这会导致此SQL错误：

由以下原因引起：< openjpa-1.2.2-r422266：898935非致命一般错误> org.apache.openjpa.persistence.PersistenceException：数据截断：日期时间值不正确：''对于第1行的'CREATED'列{prepstmnt 428593325 INSERT INTO APPLICATION_MD（ACTIVE，APNS_CERTIFICATE_PASSWORD，APNS_GATEWAY，CREATED，DESCRIPTION，IS_INSTALLER，LABEL，MANDATORY， OS，PKG，READY_PROD，RESOURCE_TYPE，UPDATED，VENDOR，VERSION，VERSION_NAME，VERSION_NUM，AUTHOR，ACL）VALUES（？，？，？，？，？，？，？，？，？，？，？，？，？， ？，？，？，？，？，？）[params =（String）Y，（String），（String），（Timestamp）2013-05-28 11：37：28.433，（String）已编译的包文件Android版本的Application ...，（String）N，（String）IBM App Center，（String）N，（String）Android，（String）com.ibm.appcenter@Android，（String）N，（String ）apk，（Timestamp）2013-05-28 11：37：28.433，（String），（String）1，（String）1.0，（double）1.0000099998474121，（int）2，（int）2]} [code = 0，state = 22001]

我在上传时遇到类似数据类型转换和截断的问题Worklight Console中的e应用程序。见：

worklight-wlapp-deployment-sql-error-for-gadgets-table-on-mysql

让我想知道是否有Worklight Enterprise安装附带的架构的问题。我已经尝试过清理并重新创建Appcenter架构。

解决方案

从你的另一个问题，我得出结论你使用的是MySQL。 / p>

确保您没有使用MySQL 5.6或更高版本。 MySQL 5.5和MySQL 5.6之间的日期和时间戳行为发生了变化。

Worklight与MySQL 5.1和5.5兼容。有关详细信息，请参阅 IBM Worklight Application Center 5.0.6系统要求。

I am trying to install IBMApplicationCenter.apk ( Appcenter application shipped with Worklight server for android ),using the Worklight ApplicationCenter console. This results in this SQL Error:

Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Data truncation: Incorrect datetime value: '' for column 'CREATED' at row 1 {prepstmnt 428593325 INSERT INTO APPLICATION_MD (ACTIVE, APNS_CERTIFICATE_PASSWORD, APNS_GATEWAY, CREATED, DESCRIPTION, IS_INSTALLER, LABEL, MANDATORY, OS, PKG, READY_PROD, RESOURCE_TYPE, UPDATED, VENDOR, VERSION, VERSION_NAME, VERSION_NUM, AUTHOR, ACL) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) Y, (String) , (String) , (Timestamp) 2013-05-28 11:37:28.433, (String) The compiled package file for the Android version of the Application..., (String) N, (String) IBM App Center, (String) N, (String) Android, (String) com.ibm.appcenter@Android, (String) N, (String) apk, (Timestamp) 2013-05-28 11:37:28.433, (String) , (String) 1, (String) 1.0, (double) 1.0000099998474121, (int) 2, (int) 2]} [code=0, state=22001]

I had similar issues with the data type conversions and truncation while uploading the apps in Worklight Console. See this :

worklight-wlapp-deployment-sql-error-for-gadgets-table-on-mysql

Make me wonder whether there are issues with the schemas that are shipped with the Worklight Enterprise installation. I have tried cleaning and re-creating the Appcenter schema.

解决方案

From your other question, I conclude that you use MySQL.

Make sure you are not using MySQL 5.6 or later. There have been changes in date and timestamp behaviors between MySQL 5.5 and MySQL 5.6.

Worklight is compatible with MySQL 5.1 and 5.5. For details, see IBM Worklight Application Center 5.0.6 System Requirements.

这篇关于Worklight Appcenter应用程序Android App上传SQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！