[resolved] Null column in Databse

[AbiJeev]

Hi ,
  I have nullable columns in database(Integer/Date). When I pass null from file (csv file), its throwing error like ,, is not a type of integer like that.
Input FIle:
A,B,,D.
kindly let me know how to handle this.

[Anonymous]

Hi
I have written a wrong Java code in my previous post, it is column value that should be checked and convert to null if it is '0000', I have edited my post. There is no a direct way to replace 0000 with null, you have to write Java code to do it.
Best regards
Shong

[AbiJeev]

Hi Shong,
  Thank you so much for the code, will it replace only the last before column value as null?, because Am not sure of the column 

[Anonymous]

Hi Shong,
  Thank you so much for the code, will it replace only the last before column value as null?, because Am not sure of the column 

I don't understand your question. BTW, are you a Java programmer?
Best regards
Shong

[AbiJeev]

hi Shong,
The below code will replace only the last column value correct? I don't know which column I will get that 0000 value it may be 1st column or 4th or last. And I am not a Java programmer, I know only the basics of Java.

[Anonymous · Accepted solution]

Hi 
Yes, the above code only check the last column, if the problem might exist in any a column, you need to iterate each column, for example:

ncount=row1.c.getColumnCount();
for(int i=0;i<ncount;i++){
column=row1.c.getColumnMetadata(i);
columnName=column.getName();
String columnValue=(String)row1.c.getColumnValue(columnName);
if(columnValue.contains("0000")){
row1.c.setColumnValue(i, null);
}
}

Best regards
Shong

[AbiJeev]

hi Shong,
Thank you so much.

[AbiJeev]

hi ,
  One more doubt is there a way to remove one column from dynamic schema from incoming file based on column name before loading into database?