JDBC Driver for ILLUSTRA & Web Driver NSAPI option...

Posted in 1999

Topics: Performance & Tuning, Installation, Setup & Upgrades, SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Java & JDBC Development

Carlos Fernando Enguix — Fri, 26 Mar 1999 00:27:33 +1100 — source: Informix-list mailing list archive (1991-1998)

Dear colleague: I am an ILLUSTRA user... I am aware that probably the majority of you, you must have upgraded to Informix UIS The problem is that we had a grant with Informix to use ILLUSTRA and we are still using it. I have a couple of questions if anybody can give me some hints: 1) We developed some time ago a database search engine research prototype based on the ILLUSTRA ORDBMS. Anyway we are in the stage that we are going to make it publicly available. Erwin Kalvelagen developed a JDBC driver for ILLUSTRA. I am really in debt with this guy because he has been very kind offering me his driver for free. The database search engine indexing agent is multi-threaded and I tuned it to have up to 15 simulatenoeus threads. Each of them make client requests to ILLUSTRA. What I found is that due to the fact that the mijdbc driver is based on a double daemon architecture redirecting packets I have a suspicion that it slows down a lot the opening of connections and execution of SQL statements. In reality I can only have 3 simulatenous threads running, because the midaemon gets hanged spawning too many server requests. In other words is there any alternative JDBC driver for ILLUSTRA so I can compare. 2) We tried a couple of times trying to shift the Web DataBlade from cgi to NSAPI for performance issues. Unfortunately we always had trouble with this option even following the instructions in the Web DataBlade User's Guide. Can anybody provide us with an intuitive and easy example of how to set up the NSAPI WebDriver option. 3) In the case there is no JDBC driver for ILLUSTRA.... Would it require a big effort upgrade the ORDBMS into Informix latest version: 3.1 Respect to SQL3 DDL, DML and Select statements: based on ADT's(types), refs, sets and so on. 3.2 Rules: do they have the same syntax? 3.3. The ILLUSTRA API (LIBMI). Can SQL3 statements call to external C or JAVA functions. 3.4 ILLUSTRA Web DataBlade Web Applications: Does it change a lot the syntax in the Informix Data Director? Best regards! -- Carlos F. Enguix Decision Systems Laboratory Department of Business Systems The University of Wollongong Northfields Ave. Wollongong NSW 2522 E-mail: cfe01@wumpus.uow.edu.au Phone : (Aus) 02-42-215978 (Rest World) +61-2-42-215978 Fax : (Aus) 02-42-214474 (Rest World) +61-2-42-214474