Re: Java Tools for Informix

rburque@crocker.com wrote: :Serafim Fonseca wrote: :> :> Hello, :> :> Does anyone knows if there are any java tools to develope application :> using an Informix OnLine Database? :> :> Thanks in advance for your help. :> :> Serafim Fonseca :> :> ========================================================================== :> Serafim Fonseca e-mail: sf@dpx20.growela.pt :> Growela Portuguesa Calcado, Lda. phone : +351 2 9820510 :> S. Pedro Avioso, Castelo fax : +351 2 9812212 :> 4470 Maia - PORTUGAL :Sir, : I have been using Symantec Cafe, with dbAnywhere (also symantec) :ODBC driver(s) from Visigenic and Intersolv, Win NT 4.0, and an Informix :Connect (used to be called I-Net) native driver. It works :quite well but CLASSPATH must be set up with great care. :Also, the JDBC-ODBC bridge (downloadable from splash.java.com) works :with both those ODBC drivers. There is no way around buying an :Informix Connect driver. With ODBC drivers that are not based on Informix Connect there should be no need for Informix Connect. :JDK 1.1 beta (downloadable) which includes JDBC stuff also works with :the JDBC-Bridge and the above named drivers. :My database is Informix Online 7.2 running on HP-UX K400 machine - :big database (40 Gig), very fast 4 processor UNIX server with lots :of memory. :Informix is going to come out with a direct connect (Universal :Web Connect?) some time this spring I believe. See their site. Until :then you have to go through the ODBC layer, which is not a performance :penalty really but a nuisance. With something like the OpenLink ODBC drivers there should be no need for ODBC. As I understand it they have JDBC drivers that connects directly to their request broker on the server. As I understand it this also make part of the JDBC functionality implemented on the server with the same advantages as for their ODBC drivers. :Symanetec does not include any informix examples with their :dbAnywhere package, but they do define some tables in Oracle and :Sybase, so you will have to transform the database declarations. Shame on Informix for not talking more to Symantec. Do they believe they can do everything themselves (with their as not yet released Java development tools)? :Incidentally, I am using O'Reilly WebSite and I reccomend it for :use with java. There are simple but instructive examples of java for :both CGI and downloadable applets. You can download their website for :evaluation at www.ora.com. Runs on Win 95 or NT. :Good luck. :FYI I am rburque@holstein.com at work (get my mail their) Doesn't most of the above presume that you write standalone Java applications? Can an applet that run in a browser connect via JDBC to an ODBC driver on my machine? With the usual security setup in Java when the program is run as an applet it should only be able to communicate with the server from which it was downloaded, and as I see it the JDBC driver would have to be implemented there in this case. If this is was not the case wouldn't there be a significant whole in the Java applet security? Even for an application significant parts of JDBC should probably be implemented on the server for the same reasons this should be done for ODBC drivers. JDBC seems to be in the same need of additional security as ODBC. With Java however it is much simpler to run part of the application on the server and implement extra security in that part. There are other issues if the user is on the outside of a firewall and the database on the inside. Usually a full JDBC access to such a database from outside the firewall would defeate the purpose of the firewall as a protector of the database as far as I can see. We are still investigating these issues so any comments would be much appreciated. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org