Sign Up ›
  • Raphl
  • NEWBIE
  • 0 Points
  • Member since 2007
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
SOLVED
8 replies

Dataloader to SQL database error Cannot pass NULL HELP!

Hi All,
 
i think i posted this somewhere else but i cant find it!
 
I have successfully conntecd our SQL server to salesforce.com using hte dataloader. it works great sending all the data unless on field is blank (null) then the whole job crashes;
 
this is the error i am getting:
Code:
(DatabaseContext.java:204) - Error creating PreparedStatement for the database configuration insertHangtagOrder. Error replacing parameter: FirstName with value: null of type: null. Sql error: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.. 
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver. 
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) 
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) 
at com.microsoft.jdbc.base.BasePreparedStatement.validateSqlType(Unknown Source) 
at com.microsoft.jdbc.base.BasePreparedStatement.setObjectInternal(Unknown Source) 
at com.microsoft.jdbc.base.BasePreparedStatement.setObject(Unknown Source) 
at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:165) 
at com.salesforce.lexiloader.dao.database.DatabaseContext.setSqlParamValues(DatabaseContext.java:197) 
at com.salesforce.lexiloader.dao.database.DatabaseWriter.writeRowList(DatabaseWriter.java:143) 
at com.salesforce.lexiloader.action.visitor.QueryVisitor.writeExtraction(QueryVisitor.java:185) 
at com.salesforce.lexiloader.action.visitor.QueryVisitor.visit(QueryVisitor.java:111) 
at com.salesforce.lexiloader.action.ExtractAction.execute(ExtractAction.java:108) 
at com.salesforce.lexiloader.controller.Controller.executeAction(Controller.java:126) 
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.java:136) 
at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.java:228)

 
This job works great when all the feilds contain data and crashes every time there is a null.
 
any ideas? Salesforce suppost says they cant help coz its custom code...
 
Thanks

Dave