I'm trying to run this simple query but I get a timeout exception.

jdbcPerformQuery("select attendance_codeid, to_char(att_date, 'dd/mm/yyyy') att_date, attendance.studentid, cc.course_number, section_number, cc.termid, yearid

from attendance inner join cc on attendance.ccid=cc.id

where termid>=2100

and(attendance_codeid=714 or attendance_codeid=707 or attendance_codeid=708 or attendance_codeid=710 or attendance_codeid=714 or attendance_codeid=717)";"timeout=10")

The query works fine in SQL developer.

Any ideas?

Thanks

It looks like you have a timeout of 10 seconds in your query. Perhaps the query runs longer in filemaker than it does in sql developer. Have you tried removing the timeout parameter?

That worked. Thanks!