Exception java.lang.StringIndexOutOfBoundsException: String index out of range: 0

Question

This my method and every time I run it always say "could not read column value from result set: cColor; String index out of range: 0" and throws Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: 0. Any Idea ? Can anybody tell me where's the error ?

    --OpenSession here--
    Query query = session.createSQLQuery("SELECT * FROM db.tblUnits "
            + "WHERE csTat = :paramStation AND cbrach = :paramLocId" 
            + "AND (cType = 'repo units' OR cType = 'svc units')")
            .setParameter("paramLocId", locId)
            .setParameter("paramStation", station);

    List<Object[]> oAvailableUnits = (List<Object[]>) query.list();

    --CloseSession here--

Your stack trace contains line numbers and file names that tell you where the error is. It's no good asking us here - especially if you don't share the stack trace. In any case, it's almost certainly not in the code that you've actually shown us here. — Dawood ibn Kareem
– Dawood ibn Kareem, Commented Aug 12, 2017 at 4:07
Typo. You are missing a white space between ":paramLocId" and "AND" on the continuing String concatenation on the next line. — Elliott Frisch
– Elliott Frisch, Commented Aug 12, 2017 at 4:14
I've got it, I just changed the cColor datatype char into varchar in the database then it works. But still, I don't why java cannot read the length of the datatype char. Anyway, thanks for your responds. — Gray
– Gray, Commented Aug 12, 2017 at 5:09

Gray · Accepted Answer · 2017-08-12 05:30:07Z

1

It happens that the cColor column is empty and its datatype is char, so I just changed the datatype into varchar because java cannot read the char datatype.

answered Aug 12, 2017 at 5:30

Gray

3871 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exception java.lang.StringIndexOutOfBoundsException: String index out of range: 0

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related