I have a strange error with LCDS 2.5.1
I am using Microsoft Sql Server 2005 Express with Microsoft SQL Server
2005 JDBC Driver 1.2
When I do an update with the SQL assembler, I have the following error:
06/06 07:35:08 user [Flex] SQL Assembler jdbc exception on
operation=update-item
error=com.microsoft.sqlserver.jdbc.SQLServerException: The Java type
java.util.Date is not a supported type.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(Unknown
Source)
at com.microsoft.sqlserver.jdbc.DTV.executeOp(Unknown Source)
at com.microsoft.sqlserver.jdbc.AppDTVImpl.setValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.setValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Parameter.setValue(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(Unknown
Source)
at
flex.data.assemblers.SQLAssembler.setSQLParameters(SQLAssembler.java:1342)
at flex.data.assemblers.SQLAssembler.updateItem(SQLAssembler.java:1206)
at flex.data.adapters.JavaAdapter.doUpdateItem(JavaAdapter.java:1659)
at
flex.data.adapters.JavaAdapter.invokeAssemblerSync(JavaAdapter.java:1545)
at
flex.data.adapters.JavaAdapter.invokeBatchOperation(JavaAdapter.java:1410)
at flex.data.adapters.JavaAdapter.invoke(JavaAdapter.java:545)
at
flex.messaging.services.MessageService.serviceMessage(MessageService.java:252)
at flex.data.DataService.sendBatchToAdapter(DataService.java:1213)
at flex.data.DataService.serviceTransactedMessage(DataService.java:737)
at flex.data.DataService.serviceMessage(DataService.java:429)
at
flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1165)
at
flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:757)
at
flex.messaging.endpoints.rtmp.AbstractRTMPServer.dispatchMessage(AbstractRTMPServer.java:888)
at
flex.messaging.endpoints.rtmp.NIORTMPConnection$RTMPReader.run(NIORTMPConnection.java:424)
at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at
edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Unknown Source)
Any ideas what I am doing wrong?
If that can help, this is the vo I use:
package com.janusmediasoft.ctcsp.model.vo
{
[Managed]
[RemoteClass]
public class AccountVO
{
public var acc_no:String = "";
public var acc_name:String = "";
public var status:Boolean = false;
public var email:String = "";
public var tel:String = "";
public var mobile:String = "";
public var group_id:Number;
public var vpn_id:String = "";
public var start_d:Date;
public var stop_d:Date;
public var reset: Boolean = false;
public var apply:String = "";
public var apply_d:Date;
public var prog_allow_all:Boolean = false;
public var cir_allow_all:Boolean = false;
public var stype_allow_all:Boolean = false;
}
}
Thanks,
Benjamin