Here's what's happening here. I reboot the server and then run the JSP. The server log shows no errors. A new client session is connected.
I'll quote the Database Performance in full. Bear with me, I've not often examined raw SQL commands. I've added my guesses as to what I believe each segment signifies.
loadAllRecords?
select scratch.scratchid, scratch.user_name, scratch.pword1, scratch.pword2, scratch.user_status, scratch.person_first, scratch.person_last, scratch.company_name, scratch.first_last_name, scratch.job_func, scratch.phone_ac1, scratch.phone_ac2, scratch.phone_ac3, scratch.phone_cc1, scratch.phone_cc2, scratch.phone_cc3, scratch.phone_local1, scratch.phone_local2, scratch.phone_local3, scratch.email1, scratch.email2, scratch.email3, scratch.web1, scratch.web2, scratch.web3, scratch.sev_id, scratch.peo_id, scratch.sec_id, scratch.com_id, scratch.cus_sup_status, scratch.peo_city, scratch.com_city, scratch.peo_pcode, scratch.com_pcode, scratch.peo_region, scratch.com_region, scratch.peo_street_no, scratch.com_street_no, scratch.peo_street_name, scratch.com_street_name, scratch.peo_suite, scratch.com_suite, scratch.com_street_detail, scratch.peo_street_detail, scratch.peo_country, scratch.com_country, scratch.calc_match_name, scratch.peo_fullname, scratch.peo_search_fullname, scratch.peo_first1, scratch.peo_last1, scratch.calc_match_com, scratch.cust_supp, scratch.source1, scratch.fmp_contactid, scratch.fmp_calldate, scratch.creation, scratch.creation_by_id, scratch.com_street_name1, scratch.peo_street_name1, scratch.cpjoin_id, scratch.email_id, scratch.phone_id, scratch.contact_id, scratch.client_phone_id, scratch.client_cpjoin_id, scratch.client_email_id, scratch.client_id, scratch.locale_timezone, scratch.locale_lang, scratch.locale_time_zone, scratch.user_name_lc from scratch where scratch.scratchid in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
newRecord?
insert into scratch ( scratchid, user_name, pword1, pword2, user_status, person_first, person_last, company_name, first_last_name, job_func, phone_ac1, phone_ac2, phone_ac3, phone_cc1, phone_cc2, phone_cc3, phone_local1, phone_local2, phone_local3, email1, email2, email3, web1, web2, web3, sev_id, peo_id, sec_id, com_id, cus_sup_status, peo_city, com_city, peo_pcode, com_pcode, peo_region, com_region, peo_street_no, com_street_no, peo_street_name, com_street_name, peo_suite, com_suite, com_street_detail, peo_street_detail, peo_country, com_country, calc_match_name, peo_fullname, peo_search_fullname, peo_first1, peo_last1, calc_match_com, cust_supp, source1, fmp_contactid, fmp_calldate, creation, creation_by_id, com_street_name1, peo_street_name1, cpjoin_id, email_id, phone_id, contact_id, client_phone_id, client_cpjoin_id, client_email_id, client_id, locale_timezone, locale_lang, locale_time_zone, user_name_lc) values ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
saveData?
select scratch.scratchid from scratch order by scratch.scratchid
This last item has a "Count = 2". Unfamiliar with the count column.
If I'm interpreting the above correctly, Servoy is sending the newRecord request to the back end. If so, the question now is what's Sybase doing with it, why is it not acting on it. Is there an appropriate Sybase log to look at?