Hello!
My SmartGWT version is:
While trying to send the values from the DateItem or TextItem they are sent as strange sequences of symbols like: <b>{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=1, 9=9, cM={1=1, 119=1, 120=1, 121=1}}</b> instead of <b>2012/01/19</b>. That is why I get a lot of the data truncation errors.
Example code:
Here the value is:
Datasource contents:
What is wrong in my logic?
My SmartGWT version is:
Code:
Manifest-Version: 1.0 Implementation-Vendor: Isomorphic Software, Inc. Isomorphic-SmartClient-Version: SC_SNAPSHOT-2011-01-05PowerEdition Created-By: 1.6.0_02 (Sun Microsystems Inc.) Isomorphic-SmartClient-Package-Date: 2011-01-05
Example code:
Code:
DataSource ds = DataSources.get("function_parameter_values");
final DSRequest addReq = new DSRequest();
addReq.setOperationType(DSOperationType.UPDATE);
addReq.setOperationId("updateFuncParamValuesByParamNameAndFunctionName");
addRecord.setAttribute("parameter_value", value);
ds.addData(addRecord, processCallback(callback), addReq);
Code:
String value = <field>.getValue().toString();
Code:
<DataSource
schema="scc"
dbName="Mysql"
tableName="function_parameter_values"
ID="function_parameter_values"
dataSourceVersion="1"
generatedBy="SC_SNAPSHOT-2011-02-28/EVAL Deployment 2011-03-01"
serverType="sql"
>
<fields>
<field primaryKey="true" name="parameter_id" hidden="true" type="integer" ></field>
<field primaryKey="true" name="process_id" hidden="true" type="integer"></field>
<field primaryKey="true" name="sequence" hidden="true" type="integer"></field>
<field name="value_number" hidden="true" type="float"></field>
<field name="value_text" hidden="true" type="string" length="50"></field>
<field name="value_date" hidden="true" type="datetime"></field>
<!-- <field name="function_id" hidden="true" type="integer" tableName="function_parameters"></field>
<field name="parameter_name" hidden="true" type="string" length="50" tableName="function_parameters"></field>
<field name="display_name" type="string" length="50" tableName="function_parameters"></field>
<field name="parameter_type" type="string" length="50" tableName="function_parameters"></field>
<field name="parameter_value" type="string" length="50" customSQL="true"></field>
-->
</fields>
<operationBindings>
<operationBinding operationType="update" operationId="updateFuncParamValuesByParamNameAndFunctionName" allowMultiUpdate="true">
<!-- We use update instead of insert because of existing trigger on process_functions table that creates empty values automatically!!! -->
<!-- fpv.process_id = $values.process_id,
fpv.sequence = $values.sequence,
fpv.parameter_id = fp.parameter_id,
-->
<customSQL>
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', $values.parameter_value, fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', $values.parameter_value, fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', $values.parameter_value, fpv.value_number)
WHERE
fn.function_name = $values.function_name AND
fp.parameter_name=$values.parameter_name AND
fpv.process_id=$values.process_id
</customSQL>
</operationBinding>
</operationBindings>
</DataSource>
Code:
=== 2012-01-15 18:43:51,433 [l0-5] INFO RequestContext - URL: '/scc/sc/IDACall', User-Agent: 'Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:8.0) Gecko/20100101 Firefox/8.0': Moz (Gecko) with Accept-Encoding header
=== 2012-01-15 18:43:51,436 [l0-2] INFO RequestContext - URL: '/scc/sc/IDACall', User-Agent: 'Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:8.0) Gecko/20100101 Firefox/8.0': Moz (Gecko) with Accept-Encoding header
=== 2012-01-15 18:43:51,440 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 0ms
=== 2012-01-15 18:43:51,442 [l0-2] DEBUG RPCManager - Processing 1 requests.
=== 2012-01-15 18:43:51,442 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
process_id:2
},
values:{
is_running:"should_rerun",
process_id:2
},
operationConfig:{
dataSource:"processes",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateProcessRunning",
oldValues:{
is_running:"should_rerun",
process_id:2
}
}
=== 2012-01-15 18:43:51,443 [l0-5] DEBUG XML - Parsed XML from (in memory stream): 6ms
=== 2012-01-15 18:43:51,448 [l0-2] DEBUG AppBase - [builtinApplication.updateProcessRunning] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,448 [l0-2] DEBUG AppBase - [builtinApplication.updateProcessRunning] No public zero-argument method named '_updateProcessRunning' found, performing generic datasource operation
=== 2012-01-15 18:43:51,448 [l0-2] INFO SQLDataSource - [builtinApplication.updateProcessRunning] Performing update operation with
criteria: {process_id:2} values: {is_running:"should_rerun",process_id:2}
=== 2012-01-15 18:43:51,451 [l0-5] DEBUG RPCManager - Processing 7 requests.
=== 2012-01-15 18:43:51,452 [l0-5] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
operationConfig:{
dataSource:"process_functions",
operationType:"remove"
},
appID:"builtinApplication",
operation:"deleteFunctionsFromProcessByProcessIdAndSequence",
oldValues:{
process_id:2,
sequence:1
}
}
=== 2012-01-15 18:43:51,452 [l0-5] DEBUG RPCManager - Request #2 (DSRequest) payload: {
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders"
},
operationConfig:{
dataSource:"process_functions",
operationType:"add"
},
appID:"builtinApplication",
operation:"addNewFunctionToProcessByFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders"
},
criteria:{
}
}
=== 2012-01-15 18:43:51,452 [l0-5] DEBUG RPCManager - Request #3 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"date_type",
parameter_value:"requested_date"
},
operationConfig:{
dataSource:"function_parameter_values",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateFuncParamValuesByParamNameAndFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"date_type",
parameter_value:"requested_date"
}
}
=== 2012-01-15 18:43:51,453 [l0-5] DEBUG RPCManager - Request #4 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"quantity_type",
parameter_value:"requested_quantity"
},
operationConfig:{
dataSource:"function_parameter_values",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateFuncParamValuesByParamNameAndFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"quantity_type",
parameter_value:"requested_quantity"
}
}
=== 2012-01-15 18:43:51,453 [l0-5] DEBUG RPCManager - Request #5 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"start_date",
parameter_value:{
"0":"2",
"1":"0",
"2":"1",
"3":"2",
"4":"/",
"5":"0",
"6":"1",
"7":"/",
"8":"0",
"9":"2",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
},
operationConfig:{
dataSource:"function_parameter_values",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateFuncParamValuesByParamNameAndFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"start_date",
parameter_value:{
"0":"2",
"1":"0",
"2":"1",
"3":"2",
"4":"/",
"5":"0",
"6":"1",
"7":"/",
"8":"0",
"9":"2",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
}
}
=== 2012-01-15 18:43:51,454 [l0-5] DEBUG RPCManager - Request #6 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"end_date",
parameter_value:{
"0":"2",
"1":"0",
"2":"1",
"3":"2",
"4":"/",
"5":"0",
"6":"1",
"7":"/",
"8":"1",
"9":"9",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
},
operationConfig:{
dataSource:"function_parameter_values",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateFuncParamValuesByParamNameAndFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"end_date",
parameter_value:{
"0":"2",
"1":"0",
"2":"1",
"3":"2",
"4":"/",
"5":"0",
"6":"1",
"7":"/",
"8":"1",
"9":"9",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
}
}
=== 2012-01-15 18:43:51,454 [l0-5] DEBUG RPCManager - Request #7 (DSRequest) payload: {
criteria:{
process_id:2,
sequence:1
},
values:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"interval_size",
parameter_value:{
"0":"d",
"1":"a",
"2":"y",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
},
operationConfig:{
dataSource:"function_parameter_values",
operationType:"update"
},
appID:"builtinApplication",
operation:"updateFuncParamValuesByParamNameAndFunctionName",
oldValues:{
process_id:2,
sequence:1,
function_name:"aggregate_customer_orders",
parameter_name:"interval_size",
parameter_value:{
"0":"d",
"1":"a",
"2":"y",
cM:{
"1":1,
"119":1,
"120":1,
"121":1
}
}
}
}
=== 2012-01-15 18:43:51,456 [l0-2] DEBUG PoolableSQLConnectionFactory - [builtinApplication.updateProcessRunning] Returning pooled Connection
=== 2012-01-15 18:43:51,461 [l0-2] DEBUG SQLTransaction - [builtinApplication.updateProcessRunning] Started new Mysql transaction "11560522"
=== 2012-01-15 18:43:51,461 [l0-2] INFO SQLDriver - [builtinApplication.updateProcessRunning] Executing SQL update on 'Mysql':
UPDATE processes
SET
is_running = 'should_rerun'
WHERE
process_id = 2
=== 2012-01-15 18:43:51,461 [l0-5] DEBUG AppBase - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,461 [l0-5] DEBUG AppBase - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] No public zero-argument method named '_deleteFunctionsFromProcessByProcessIdAndSequence' found, performing generic datasource operation
=== 2012-01-15 18:43:51,462 [l0-5] INFO SQLDataSource - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] Performing remove operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1}
=== 2012-01-15 18:43:51,463 [l0-2] DEBUG SQLDataSource - [builtinApplication.updateProcessRunning] update operation affected 1 rows
=== 2012-01-15 18:43:51,463 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2012-01-15 18:43:51,463 [l0-2] DEBUG SQLTransaction - Committing Mysql transaction "11560522"
=== 2012-01-15 18:43:51,469 [l0-5] DEBUG PoolableSQLConnectionFactory - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] Returning pooled Connection
=== 2012-01-15 18:43:51,469 [l0-5] DEBUG SQLTransaction - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] Started new Mysql transaction "26865435"
=== 2012-01-15 18:43:51,469 [l0-5] INFO SQLDriver - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] Executing SQL update on 'Mysql':
DELETE FROM process_functions
WHERE process_id = 2 AND sequence = 1
=== 2012-01-15 18:43:51,470 [l0-5] DEBUG SQLDataSource - [builtinApplication.deleteFunctionsFromProcessByProcessIdAndSequence] remove operation affected 1 rows
=== 2012-01-15 18:43:51,475 [l0-5] DEBUG AppBase - [builtinApplication.addNewFunctionToProcessByFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,475 [l0-5] DEBUG AppBase - [builtinApplication.addNewFunctionToProcessByFunctionName] No public zero-argument method named '_addNewFunctionToProcessByFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,475 [l0-5] INFO SQLDataSource - [builtinApplication.addNewFunctionToProcessByFunctionName] Performing add operation with
criteria: {} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders"}
=== 2012-01-15 18:43:51,475 [l0-5] DEBUG SQLValuesClause - [builtinApplication.addNewFunctionToProcessByFunctionName] Sequences: {}
=== 2012-01-15 18:43:51,477 [l0-5] INFO SQLDriver - [builtinApplication.addNewFunctionToProcessByFunctionName] Executing SQL update on 'Mysql':
INSERT INTO process_functions
(process_id, sequence, function_id)
SELECT 2 as process_id, 1 as sequence, function_id FROM functions WHERE function_name = 'aggregate_customer_orders' LIMIT 1
=== 2012-01-15 18:43:51,478 [l0-5] DEBUG SQLDataSource - [builtinApplication.addNewFunctionToProcessByFunctionName] add operation affected 1 rows
=== 2012-01-15 18:43:51,483 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,483 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No public zero-argument method named '_updateFuncParamValuesByParamNameAndFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,483 [l0-5] INFO SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Performing update operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders",parameter_name:"date_type",parameter_value:"requested_date"}
=== 2012-01-15 18:43:51,483 [l0-5] INFO SQLValuesClause - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Ignored data for non-existent columns: [function_name, parameter_name, parameter_value]
=== 2012-01-15 18:43:51,484 [l0-5] INFO SQLDriver - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Executing SQL update on 'Mysql':
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', 'requested_date', fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', 'requested_date', fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', 'requested_date', fpv.value_number)
WHERE
fn.function_name = 'aggregate_customer_orders' AND
fp.parameter_name='date_type' AND
fpv.process_id=2
=== 2012-01-15 18:43:51,485 [l0-5] DEBUG SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] update operation affected 1 rows
=== 2012-01-15 18:43:51,496 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,496 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No public zero-argument method named '_updateFuncParamValuesByParamNameAndFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,496 [l0-5] INFO SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Performing update operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders",parameter_name:"quantity_type",parameter_value:"requested_quantity"}
=== 2012-01-15 18:43:51,496 [l0-5] INFO SQLValuesClause - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Ignored data for non-existent columns: [function_name, parameter_name, parameter_value]
=== 2012-01-15 18:43:51,497 [l0-5] INFO SQLDriver - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Executing SQL update on 'Mysql':
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', 'requested_quantity', fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', 'requested_quantity', fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', 'requested_quantity', fpv.value_number)
WHERE
fn.function_name = 'aggregate_customer_orders' AND
fp.parameter_name='quantity_type' AND
fpv.process_id=2
=== 2012-01-15 18:43:51,498 [l0-5] DEBUG SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] update operation affected 1 rows
=== 2012-01-15 18:43:51,504 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,504 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No public zero-argument method named '_updateFuncParamValuesByParamNameAndFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,504 [l0-5] INFO SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Performing update operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders",parameter_name:"start_date",parameter_value:{"0":"2","1":"0","2":"1","3":"2","4":"/","5":"0","6":"1","7":"/","8":"0","9":"2",cM:{"1":1,"119":1,"120":1,"121":1}}}
=== 2012-01-15 18:43:51,504 [l0-5] INFO SQLValuesClause - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Ignored data for non-existent columns: [function_name, parameter_name, parameter_value]
=== 2012-01-15 18:43:51,505 [l0-5] INFO SQLDriver - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Executing SQL update on 'Mysql':
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=0, 9=2, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=0, 9=2, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=0, 9=2, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_number)
WHERE
fn.function_name = 'aggregate_customer_orders' AND
fp.parameter_name='start_date' AND
fpv.process_id=2
=== 2012-01-15 18:43:51,512 [l0-5] WARN RequestContext - dsRequest.execute() failed:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=0, 9=2, cM={1=1, 119=1, 120=1, 121=1}}' for column 'value_date' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3601)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:461)
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:415)
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:535)
at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:387)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1338)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeUpdate(SQLDataSource.java:228)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1054)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1443)
at com.barkawi.scc.server.Front.handleDSRequest(Front.java:56)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2012-01-15 18:43:51,518 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,518 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No public zero-argument method named '_updateFuncParamValuesByParamNameAndFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,518 [l0-5] INFO SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Performing update operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders",parameter_name:"end_date",parameter_value:{"0":"2","1":"0","2":"1","3":"2","4":"/","5":"0","6":"1","7":"/","8":"1","9":"9",cM:{"1":1,"119":1,"120":1,"121":1}}}
=== 2012-01-15 18:43:51,518 [l0-5] INFO SQLValuesClause - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Ignored data for non-existent columns: [function_name, parameter_name, parameter_value]
=== 2012-01-15 18:43:51,519 [l0-5] INFO SQLDriver - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Executing SQL update on 'Mysql':
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=1, 9=9, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=1, 9=9, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=1, 9=9, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_number)
WHERE
fn.function_name = 'aggregate_customer_orders' AND
fp.parameter_name='end_date' AND
fpv.process_id=2
=== 2012-01-15 18:43:51,520 [l0-5] WARN RequestContext - dsRequest.execute() failed:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '{0=2, 1=0, 2=1, 3=2, 4=/, 5=0, 6=1, 7=/, 8=1, 9=9, cM={1=1, 119=1, 120=1, 121=1}}' for column 'value_date' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3601)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at com.isomorphic.sql.SQLDriver.doUpdate(SQLDriver.java:461)
at com.isomorphic.sql.SQLDriver.update(SQLDriver.java:415)
at com.isomorphic.sql.SQLDriver.executeUpdate(SQLDriver.java:535)
at com.isomorphic.sql.SQLDataSource.executeNativeUpdate(SQLDataSource.java:387)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1338)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeUpdate(SQLDataSource.java:228)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1054)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1443)
at com.barkawi.scc.server.Front.handleDSRequest(Front.java:56)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:130)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:95)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2012-01-15 18:43:51,525 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-01-15 18:43:51,525 [l0-5] DEBUG AppBase - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] No public zero-argument method named '_updateFuncParamValuesByParamNameAndFunctionName' found, performing generic datasource operation
=== 2012-01-15 18:43:51,525 [l0-5] INFO SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Performing update operation with
criteria: {process_id:2,sequence:1} values: {process_id:2,sequence:1,function_name:"aggregate_customer_orders",parameter_name:"interval_size",parameter_value:{"0":"d","1":"a","2":"y",cM:{"1":1,"119":1,"120":1,"121":1}}}
=== 2012-01-15 18:43:51,525 [l0-5] INFO SQLValuesClause - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Ignored data for non-existent columns: [function_name, parameter_name, parameter_value]
=== 2012-01-15 18:43:51,526 [l0-5] INFO SQLDriver - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] Executing SQL update on 'Mysql':
UPDATE
function_parameter_values AS fpv
LEFT JOIN
function_parameters AS fp ON (fp.parameter_id = fpv.parameter_id)
LEFT JOIN
functions as fn ON (fp.function_id = fn.function_id)
SET
fpv.value_date = IF(fp.parameter_type = 'date', '{0=d, 1=a, 2=y, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_date),
fpv.value_text = IF(fp.parameter_type = 'text', '{0=d, 1=a, 2=y, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_text),
fpv.value_number = IF(fp.parameter_type = 'number', '{0=d, 1=a, 2=y, cM={1=1, 119=1, 120=1, 121=1}}', fpv.value_number)
WHERE
fn.function_name = 'aggregate_customer_orders' AND
fp.parameter_name='interval_size' AND
fpv.process_id=2
=== 2012-01-15 18:43:51,528 [l0-5] DEBUG SQLDataSource - [builtinApplication.updateFuncParamValuesByParamNameAndFunctionName] update operation affected 1 rows
=== 2012-01-15 18:43:51,528 [l0-5] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2012-01-15 18:43:51,528 [l0-5] DEBUG SQLTransaction - Rolling back Mysql transaction "26865435"
=== 2012-01-15 18:43:51,541 [l0-2] DEBUG SQLTransaction - Ending Mysql transaction "11560522"
=== 2012-01-15 18:43:51,543 [l0-2] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,543 [l0-2] INFO Compression - /scc/sc/IDACall: 120 -> 105 bytes
200 - POST /scc/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2011-01-05&isc_xhr=1&isc_tnum=13 (127.0.0.1) 105 bytes
Request headers
Host: 127.0.0.1:8888
User-Agent: Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:8.0) Gecko/20100101 Firefox/8.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en,en-us;q=0.7,ru;q=0.3
Accept-Encoding: gzip, deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Connection: keep-alive
Cookie: GLog=%7B%0D%20%20%20%20left%3A1125%2C%20%0D%20%20%20%20top%3A303%2C%20%0D%20%20%20%20width%3A640%2C%20%0D%20%20%20%20height%3A480%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready; JSESSIONID=1qsl1a9pk5j0u
Referer: http://127.0.0.1:8888/Scc.html
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
Content-Length: 1141
Pragma: no-cache
Cache-Control: no-cache
Response headers
X-Included-Test2: true
X-Included-Test: true
Expires: Sun, 15 Jan 2012 14:43:51 GMT
Content-Type: text/plain; charset=utf-8
Content-Length: 105
Content-Encoding: gzip
Cache-Control: no-cache
Pragma: no-cache
=== 2012-01-15 18:43:51,599 [l0-5] DEBUG SQLTransaction - Ending Mysql transaction "26865435"
=== 2012-01-15 18:43:51,600 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,600 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,601 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,601 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,601 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,601 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,602 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-01-15 18:43:51,602 [l0-5] INFO Compression - /scc/sc/IDACall: 899 -> 249 bytes
200 - POST /scc/sc/IDACall?isc_rpc=1&isc_v=SC_SNAPSHOT-2011-01-05&isc_xhr=1&isc_tnum=12 (127.0.0.1) 249 bytes
Request headers
Host: 127.0.0.1:8888
User-Agent: Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:8.0) Gecko/20100101 Firefox/8.0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en,en-us;q=0.7,ru;q=0.3
Accept-Encoding: gzip, deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Connection: keep-alive
Referer: http://127.0.0.1:8888/Scc.html
Cookie: GLog=%7B%0D%20%20%20%20left%3A1125%2C%20%0D%20%20%20%20top%3A303%2C%20%0D%20%20%20%20width%3A640%2C%20%0D%20%20%20%20height%3A480%2C%20%0D%20%20%20%20priorityDefaults%3A%7B%0D%20%20%20%20%20%20%20%20Log%3A4%0D%20%20%20%20%7D%2C%20%0D%20%20%20%20defaultPriority%3A3%2C%20%0D%20%20%20%20trackRPC%3Anull%0D%7D; isc_cState=ready; JSESSIONID=1qsl1a9pk5j0u
Content-Type: application/x-www-form-urlencoded; charset=UTF-8
Content-Length: 13278
Pragma: no-cache
Cache-Control: no-cache
Response headers
X-Included-Test2: true
X-Included-Test: true
Content-Type: text/plain; charset=utf-8
Content-Length: 249
Content-Encoding: gzip
Cache-Control: no-cache
Pragma: no-cache
Expires: Sun, 15 Jan 2012 14:43:51 GMT
Comment