when i take off the columns with date type, i get:
ERROR {org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault
Message: Error in 'SQLQuery.processPreNormalQuery': empty String
DS Code: DATABASE_ERROR
M.R.Aaquibah Nashry
*Intern, Engineering*
Mobile : +94 773946123
Tel : +94 112662541
[email protected]
On Mon, Jun 15, 2015 at 10:37 AM, Aaquibah Nashry <[email protected]> wrote:
> 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
