I'm getting "Wrapped java.lang.ArrayIndexOutOfBoundsException: -1" on DB read

[David Rothabuer]

I work with an integration engine that is java based. All my scripting is javascripting and I've run into a problem that I can't find a solution to.

I am getting this error when I attempt to read from my database

Wrapped java.lang.ArrayIndexOutOfBoundsException: -1
 

Here is the actual code (the "logger.error" lines tell Mirth to write the output to the dashboard)

if (rst.EOF == true) { blnExists = false; } else { blnExists = true; }
108:         //If Patient is in Temp Locate table and if TL account is an SDC account
109:         //Need to use a nested if to avoid an error if patient isn't in the database
 
110:         logger.error("TEST AWARE ORU: blnExists = " + blnExists);
 
111:         if (blnExists == true)        {
 
112:             logger.error("TEST AWARE ORU : " + rst.getString('PtAcct'));
 
113:             if (rst.getString("PtAcct").charAt(0) == "A") {
 
114:                  msg['PID']['PID.18']['PID.18.1'].toString() == rst.getString('PtAcct');
 
115:             }
 
116:         }
LINE NUMBER:    112
DETAILS:    Wrapped java.lang.ArrayIndexOutOfBoundsException: -1
 

Can anyone help? I've been working on this for a day and a half with no luck.

[Oralloy]

This is just a guess, but it looks like your recordset has no records in it, or there is no 'PtAcct' field.

[Dheeraj Joshi]

rst.getString('PtAcct')
 

You can't wrap more than one character in ' '. If it is string you must use " ".

rst.getString("PtAcct");
 

Regards
Dheeraj Joshi