Hi,
I am trying to import data from salesforce and save it in a mysql database.
I have written a proxy and a dataservice for this.
When there are no null values in the data to be imported, i am able to save
the data in mysql.
But when the data has null values, i get this:
ERROR {org.wso2.carbon.dataservices.core.description.query.SQLQuery} -
java.lang.NullPointerException
at org.wso2.carbon.dataservices.core.DBUtils.getDate(DBUtils.java:444)
at
org.wso2.carbon.dataservices.core.description.query.SQLQuery.setDateValue(SQLQuery.java:1869)
at
org.wso2.carbon.dataservices.core.description.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:1638)
at
org.wso2.carbon.dataservices.core.description.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:1588)
at
org.wso2.carbon.dataservices.core.description.query.SQLQuery.processPreNormalQuery(SQLQuery.java:806)
at
org.wso2.carbon.dataservices.core.description.query.SQLQuery.runPreQuery(SQLQuery.java:2301)
at
org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:275)
at
org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:188)
at
org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)
at
org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:61)
at
org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:474)
at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96)
at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:107)
at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.executeInOnly(DSOMDataSource.java:80)
at
org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processSingleRequest(SingleDataServiceRequest.java:116)
at
org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processRequest(SingleDataServiceRequest.java:67)
at
org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282)
at
org.wso2.carbon.dataservices.core.dispatch.BatchDataServiceRequest.processRequest(BatchDataServiceRequest.java:102)
at
org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282)
at
org.wso2.carbon.dataservices.core.DataServiceProcessor.dispatch(DataServiceProcessor.java:41)
at
org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:48)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)
at
org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:411)
at
org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183)
at
org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
[2015-06-15 10:13:48,269] ERROR
{org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault Message:
Error in 'SQLQuery.processPreNormalQuery': null
DS Code: DATABASE_ERROR
Is there a specific way to handle this?
Thanks in advance,
M.R.Aaquibah Nashry
*Intern, Engineering*
Mobile : +94 773946123
Tel : +94 112662541
[email protected]
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
