I have some questions regarding java in the database. From what I have read the efficiency of the java store procedures seem to have been deteriorated in SQL Anywhere 12, but I am wondering if I could use it anyway in SQL Anywhere 16. I am thinking of using java stored procedures in scheduled jobs in the database, so a scheduled job could "call" a java procedure...does anyone have any experience with this?
Then I wonder if it is possible for a java store procedure to call a ordinary procedure (watcom , t-sql procedure) in the database? Or can just a ordinary procedure call a java procedure?
asked 03 Jan '14, 04:21
Regarding your comment on deteriorated performance of java store procedures (SP) in SQL Anywhere 12, I cannot comment on this except to say that I know of no change that would have made a difference to Java SP performance.
From within a Java SP you can call a SQL SP using normal JDBC calls back into the database. There is several topics on Java SPs in the documentation: for example, start by reading here and here and here.
answered 03 Jan '14, 08:54