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

Reply via email to