rekha sen wrote:Please tell me how should I be doing,
Get the file and use the delimiter | and bring the values into ArrayList from TABLES SECTION
And also use 4 HASHMAP'S to get the first 4 columns values into table while loading the records from the ArrayList using iterator into INSERT PROCEDURE to load into TABLE.
Am I correct on this approach?
And I was mistaken. I had forgotten that the *** is actually part of the text. Sorry.Yesterday, I wrote:That won't work because you cannot match the *s
. . .
the column length is: 11
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 11
The header is skipped and the records are loaded into the DB.
Please see the record I wrote in my earlier email, it has no value in 2 places.
the column length is: 11
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 11
And where did you get that from? It is <rekha sen wrote: . . . <= . . .
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |