Re: Web/Informix Connectivity Suggestions

London, Johnny wrote: > > We want to query our Online 7.x database through a web > interface. We are > looking for > solutions for database connectivity . We can always use CGI, > but the scalability and non-persistent connection are issues there. > > I've played with LiveWire a bit. It seems decent, but I really have > nothing to compare it to. > > Any experiences you would like to share? > > BTW, must be a UNIX solution. No NT here. > > Thanks > Johnny > > londonj@hastings-ent.com We have an interface based on an extension to the isqlperl module but ported to JAVA. A middleware connection manager runs on a Unix box and talks to the 7.X engine. JAVA applets or applications can talk to the database with only a 9K byte class file upload. This works in ALL JDK1.02 and JDK1.1 browsers without the overhead of JDBC. In addition to JAVA the system supports perl5. The package performs great and packs a lot of punch for just about any Web enabled database application you can imagine. The toolkit and source are availible for $25K US for unlimited internal use. The function library (perl5 - JAVA is the same) is as follows (javadoc is available at http://quark.quantumsi.com/java/docs/:) - Jon NAME ISQL.pm - Perl5 dynamic interface to Informix Databases, Copyright 1996,1997 Quantum Systems Integrators, Inc. all rights reserved. SYNOPSIS use ISQL; # functions $status = &isql_execute($sttmnt_or_id, @params); $id = &isql_open($statement, @params); @titles = &isql_titles($id); $sttmnt = &isql_statement($id); $type = &isql_type($id); @types = &isql_columns($id); @row = &isql_fetch($sttmnt_or_id, @params); $status = &isql_close($id); $status = &isql_shutdown(); @databases = &isql_databases(); @status = &isql_get_schema(table, filename, ownership, extents {,fn,nn} ); @status = &isql_load($table, $filename, $delim, $update, $nullcvt {,$debug}); @status = &isql_unload($cmd, $file, $delim, $compress, $checksum); $errmsg = &isql_msg([$code]); @sqlca = &isql_ca(); # exports $isql_code; $isql_autoclose; $isql_attrib; $isql_database; $isql_transactions; $isql_ansi; $isql_online; SIMPLE EXAMPLE use ISQL; &isql_execute("database test") || die "select db test ... $isql_code\\n"; $cid = &isql_open( "select tabname from systables where tabid > 100") || die "open statement ... $isql_code\\n"; while(@row = &isql_fetch($cid)) { printf STDERR "row: @row\\n"; }