What is IllegalStateException?

Question

I am trying to use the following Fastload API

connection ... etc is perfect.

---

I know exactly where it fails

 ...........  System.out.println(" Streaming " + dataFile);  pstmtFld.setAsciiStream(1, dataStream, -1); // This line fails  System.out.println("check the above line"); // This does not go to console  ........... 

Exception is

Exception in thread "main" java.lang.IllegalStateException: Sample failed.

[ODBC Teradata Driver] Invalid precision: cbColDef value out of range

---

Here is my table that I am trying to upload. It is a .csv format and when I open it via notepad it look like this

1,9,Win 2,9,Winc 3,9,Wi 

Why do I get this exception? How can I improve it? As far as I understand the problem is pstmtFld.setAsciiStream(1, dataStream, -1); does not accept the dataset somehow and throw an exception

Answer 1

Usually, IllegalStateException is used to indicate that "a method has been invoked at an illegal or inappropriate time." However, this doesn't look like a particularly typical use of it.

The code you've linked to shows that it can be thrown within that code at line 259 - but only after dumping a SQLException to standard output.

We can't tell what's wrong just from that exception - and better code would have used the original SQLException as a "cause" exception (or just let the original exception propagate up the stack) - but you should be able to see more details on standard output. Look at that information, and you should be able to see what caused the exception, and fix it.