Re: type 4 JDBC drivers
Posted in 1998
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Java & JDBC Development, Internationalization & Character Sets
This is a cryptographically signed message in MIME format. --------------ms2496D9752E149628C60CB300 Content-Type: multipart/mixed; boundary="------------B848CD9C46077D64C632EF0C" This is a multi-part message in MIME format. --------------B848CD9C46077D64C632EF0C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Wyan H. Jow wrote: > The type 4 driver for informix is finished beta testing and is due out near > the end of the month. > > peterwiley@hotmail.com wrote: > : In article <6q5iq5$n3f$1@client2.news.psi.net>, > : "Kingsley Idehen" <kidehen@openlinksw.com> wrote: > : > Mike, > : > Mike wrote in message > : > <902132501.26155.0.nnrp-01.c2de7bed@news.demon.co.uk>... > : > >In article <6nijot$g29$1@news.xmission.com>, mcanto@intec.unl.edu.ar wrote: > : > >> > : > >>Try http://www.openlinksw.com It has a free version with up 2 concurrent > : > >>users. > : > >>Byte byte! > : > > > : > >Is this type 4?? > : > > : > This isn't a type 4. > : > > : > But what really is the difference between a type 4 and type 3 Driver (when > : > one gets down to bare facts) ? > : > > : > Type 4 JDBC Drivers: > : > ================== > : > Marketing Definition: > : > > : > Type 4 Driver requires only a set of Java Classes (hopefully pure) and you > : > are connected to Informix DB. > : > > : > Technical Journey (how this is cobbled together): > : > The Informix I-Connect or I-Net protocol is re-written (or reversed > : > engineered for 3rd party Type 4 Drivers) in Java at the client end, thereby > : > enabling communication with the Informix I-connect Server which talks > : > sockets to the Informix Database Server. > : > > : > Object Implications: > : > Any ills associated with I-Connect will be inherited. > : > Any ills associated Database Specific Application development will be > : > inherited > : > > : > Total Cost of Ownership: > : > Deceitfully expensive over the long-term (you will be at the beck an cal of > : > the DB vendor). These drivers aren't free as far as total cost of ownership. > : > You will always pay more come deployment time. > : > > : > Type 3 JDBC Drivers: > : > ==================== > : > > : > Marketing Definition: > : > A Type 4 Driver provided by a Third Party, a third party not interested in > : > reverse engineering the Database Vendors Proprietary across the wire > : > protocol. The server piece provided by the third party is not different to > : > the Server Components that handles I-Connect calls en route to the Database > : > Server, the only difference being one is installed transparently with the DB > : > Server and the other isn't. > : > > : > Technical Journey (how this is cobbled together): > : > The JDBC Driver is implemented totally in Java and also implements a > : > database independent across the wire protocol (hence the server piece). The > : > Java classes are typically much smaller than those of type 4 drivers. > : > > : > Object Implications: > : > Inherit the benefits of database independence at the networking layer > : > Inherit the benefits of Database Independent Application development . > : > > : > Total Costs of Ownership: > : > > : > Low short and long term. > > : I'm not really interested in starting an argument; I just want a Type 4 JDBC > : driver for Informix. I will point out, however, that Oracle have a > : downloadable Type 4 JDBC driver for Oracle 7 & 8 which works fine and doesn't > : have any of the problems of cost, configuration etc. > > : I'll agree that a Type 4 driver from a 3rd party is probably no better than a > : Type 3 setup like Openlink's which works *extremely* well. The proper source > : of the driver, IMHO, however, is the database vendor. > > : Where's Informix' Type 4 driver? I'm looking at shifting development effort to > : Oracle because I'm now working in Java not 4GL. > > : Peter Wiley > > : -----== Posted via Deja News, The Leader in Internet Discussion ==----- > : http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > > -- > ***************************************************************** > * Wyan H. Jow * > * "I remember how, in college I got that part-time job as a * > * circus clown and the children would laugh and laugh at me. * > * I vowed, then and there, that I would get revenge." * > * - Jack Handey * > ***************************************************************** > Informix is currently beta testing pure Type 4 drivers. Our company is also interested in moving away from 4GL code to java. However I have not been able to determine how to get on the beta list or when they are going to release a public version of the drivers, for what price. --------------B848CD9C46077D64C632EF0C Content-Type: text/x-vcard; charset=us-ascii; name="bac.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Bradley Corner Content-Disposition: attachment; filename="bac.vcf" begin:vcard n:Corner;Bradley x-mozilla-html:TRUE org:Northeast Florida Multiple Listing Service, Inc. adr:;;;Jacksonville;Fl;32256;USA version:2.1 email;internet:bac@nefmls.com title:Information Systems Manager tel;fax:(904) 296-6226 tel;work:(904) 296-6121 x-mozilla-cpt:;0 fn:Bradley Corner end:vcard --------------B848CD9C46077D64C632EF0C-- --------------ms2496D9752E149628C60CB300 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIIXwYJKoZIhvcNAQcCoIIIUDCCCEwCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BowwggQKMIIDc6ADAgECAhAQDYvNM7nkTHmmNqQWIWzKMA0GCSqGSIb3DQEBAgUAMGIxETAP BgNVBAcTCEludGVybmV0MRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjE0MDIGA1UECxMrVmVy aVNpZ24gQ2xhc3MgMiBDQSAtIEluZGl2aWR1YWwgU3Vic2NyaWJlcjAeFw05ODAyMjcwMDAw MDBaFw05OTAyMjcyMzU5NTlaMIIBTTERMA8GA1UEBxMISW50ZXJuZXQxFzAVBgNVBAoTDlZl cmlTaWduLCBJbmMuMTQwMgYDVQQLEytWZXJpU2lnbiBDbGFzcyAyIENBIC0gSW5kaXZpZHVh bCBTdWJzY3JpYmVyMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvQ1BT IEluY29ycC4gYnkgUmVmLixMSUFCLkxURChjKTk2MSYwJAYDVQQLEx1EaWdpdGFsIElEIENs YXNzIDIgLSBOZXRzY2FwZTEZMBcGA1UEAxMQQnJhZGxleSBBIENvcm5lcjEdMBsGCSqGSIb3 DQEJARYOYmFjQG5lZm1scy5jb20xPzA9BgkqhkiG9w0BCQgUMDQ1MzEgUHJhdmVyIERyLiBO LiANCkphY2tzb252aWxsZSwgRmwNCjMyMjE3DQpVUzCBnzANBgkqhkiG9w0BAQEFAAOBjQAw gYkCgYEAxOdeUFyl46+6RwIokSqQ8nHKbUuM6HaFZyr9ljP5oPdjhRA6sVO6KM28GxD7Qu4F IWjxrxzLU9suK8BLIxpSZ7Vxt3pv+Ad4Pc4Ce9cwFfZaVED3aaKdRJ4yyQPYYxOspzJmZWPO WGhe3pd7IQ32o2+CErA+q+E/IUDp0ObePL8CAwEAAaOB0zCB0DAJBgNVHRMEAjAAMIGvBgNV HSAEgacwgDCABgtghkgBhvhFAQcBATCAMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy52ZXJp c2lnbi5jb20vQ1BTMGIGCCsGAQUFBwICMFYwFRYOVmVyaVNpZ24sIEluYy4wAwIBARo9VmVy aVNpZ24ncyBDUFMgaW5jb3JwLiBieSByZWZlcmVuY2UgbGlhYi4gbHRkLiAoYyk5NyBWZXJp U2lnbgAAAAAAADARBglghkgBhvhCAQEEBAMCB4AwDQYJKoZIhvcNAQECBQADgYEAimcXmGGq ACpYWUuE4BRyzcowUAxYWcdqibabW55l3//uIgHHmyW8CuQSEYKB8uHXZy8qXEHlZoa04xot qqdNn7lkPpAfieHoYDfCzzmwI7urJt/KA