Bulk Import is not working as expected...

[Jose John <jo...@yahoo.com>]

Hi There,
I am having a table with 73 columns. I am inserting the following row to the
table,
;;;;;;;;;;;;;;;;;;;;;;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
it goes in no problem. But when I try to insert the following, its not going
in.
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

All of my columns are varchar(150).

I am executing CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(?,?,?,?,?,?,?) from java
prepared statement for bulk import.

But if I do it from the sql prompt, its working.

Does anyone know why? Can anybody shed some light?

Thanks,
Jose John
-- 
View this message in context: http://www.nabble.com/Bulk-Import-is-not-working-as-expected...-tp22413663p22413663.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Bulk Import is not working as expected...

[Kathey Marsden <km...@sbcglobal.net>]

Jose John wrote:
> Hi There,
> I am having a table with 73 columns. I am inserting the following row to the
> table,
> ;;;;;;;;;;;;;;;;;;;;;;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
> it goes in no problem. But when I try to insert the following, its not going
> in.
> ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
>
> All of my columns are varchar(150).
>
> I am executing CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(?,?,?,?,?,?,?) from java
> prepared statement for bulk import.
>
> But if I do it from the sql prompt, its working.
>
> Does anyone know why? Can anybody shed some light?
>
> Thanks,
> Jose John
>   
Can you post the exception you are getting and your code, including how 
you set the parameters?

Thanks

Kathey