Free jdbc gateway software for linux

Wap-IRC gateway allows you to chat on IRC with any WAP-enabled mobile phone. It works by running the server program on a Unix-like system that is accessible over the Internet. It doesnt require phones which have programs written in Java.
I am Tomas Vilda, student studying at University of Vilnius, Lithuania. I started interested in wap when I bought my first wap enabled mobile phone. I searched for the running irc-wap gateway. But with no success. Actually, I found some, but no such, that I make to connect to specified IRC server. Then I found wapirc gateway written by Alan Cox . I tried it on my FreeBSD server. During compilation I got error, because of bad Makefile. So I compiled it by correcting Makefile and ran successful. My mobile is Siemens C55. To start using this wapirc gateway I have to make some modifications. They are listed below.
Enhancements:
- cgi/main():refresh included into main-cgi, saves us .htaccess and external wmlscript
- cgi/write_wml(): fixed bug in linked nicks with ACTIONs and * in there.
- server/parseinput(): Added /me Command for * ACTION in channels
- cgi/write_card(): get refresh timer from config.h
- server/removeallitems(): doing a list cleanup when disconnecting, so we can rejoin after quit without part
- server/print_out(): screenbuffer with latest messages, scrolling top down
- cgi/write_card(): reload on a regular basis, when not typing something in. New formular works on more phones, informative header
- cgi/wml_link()/wml_header(): wml1.2 compatible links/input field for accesskey element
- cgi/write_wml(): new linewise printout, italic makeup, nicks are linked setting defaultvalues for talking on channels and privat.
- cgi/main(): Expire header
- Makefile: make install

This is the IRC gateway for Microsoft(tm) Messenger.

You probably wonder what this is and why I wrote this. Some more information can be found in the DESIGN document that is included in this package.

This software is written by Johannes Verelst and is licensed through the GPL license (http://www.gnu.org/licenses/gpl.html).

Note that this is pre-alpha code, it probably does a bit that you want, but dont email me bugreports or feature requests. It is under heavy development.

If this program doesnt run try to install corectly all required perl modules yourself.

The idea for this program came when I was getting annoyed by the fact that I had to use different programs for both IRC and MSN. Since I dont know of any good MSN clients that can do IRC too (on unix, ofcourse), I started thinking about the other way around: an IRC client that can do MSN.

When I saw a piece of software written by Adam Swann that allows easy connectivity to MSN with perl, I decided to write an IRC server in perl that would connect to MSN for you. This is the result.

JDBC is a Perl 5 interface to Java JDBC (via Inline::Java).

SYNOPSIS

use JDBC;

JDBC->load_driver("org.apache.derby.jdbc.EmbeddedDriver");

my $con = JDBC->getConnection($url, "test", "test");

my $s = $con->createStatement();

$s->executeUpdate("create table foo (foo int, bar varchar(200), primary key (foo))");
$s->executeUpdate("insert into foo (foo, bar) values (42,notthis)");
$s->executeUpdate("insert into foo (foo, bar) values (43,notthat)");

my $rs = $s->executeQuery("select foo, bar from foo");
while ($rs->next) {
my $foo = $rs->getInt(1);
my $bar = $rs->getString(2);
print "row: foo=$foo, bar=$barn";
}

This JDBC module provides an interface to the Java java.sql.* and javax.sql.* JDBC APIs.

Coherent Mail Gateway is intended to be a very easy to set up MTA using SMTP and POP3. Greylisting is used on the SMTP daemon to reduce spam.

In addition, quite a lot of checks on the validity of information from the SMTP client (such as claimed server name and sender) are carried out, and anyone caught telling lies is disconnected.

Grey-, black-, and white-listing are supported, as well as (optionally) ClamAV and Spamhaus. The target market is users with static IP addresses. Others can use the system, but its value will be limited to outgoing email.

TN3270RG is a TCP/IP TN3270 gateway that dynamically assigns resources to a connection from a pool of available addresses. Features include an easy to use web interface for management and a PostgreSQL database backend.
It is useful if you have a large number of machines connecting to a TN3270 host, but for whatever reason the host itself cannot assign resources from a pool. TN3270 will keep track of a pool of resources in a PostgreSQL database (should work with other databases as well) and dynamically allocate a resource to each connnection that goes through it.
Simply configure the daemon so it knows the address of the real TN3270 host, set the resource pool up using the web management software, and point your clients to the address of the gateway.
In the client configuration set your resource to what you have the replacement token set to (!_TN3270RG_RESOURCE_! by default) and when the daemon sees that resource go by, it will substitute the resource it has allocated for the connection and pass the rest of the data stream unaltered to the host.
TN3270 Resource Gateway project is designed to be fast and stable and should recover gracefully from most errors including unexpected disconnections and database errors. It is written in Perl and uses the POE framework.
Enhancements:
- This release uses Sys::Syslog (which is actively maintained and is included in the main Perl distribution).
- All Syslog calls have been updated to prevent a highly unlikely (but still possible) format string vulnerability.
- It cleanly exits from a SIGTERM with useful logging information.

SMBGate provides a gateway and firewall with authentication managed by a Samba Primary Domain Controller. The firewall rules are set on a per-user basis.

JdbcTool project is a collection of command line utilities for making your life easy when working with Java JDBC databases. Included are:

jdbctool:

An interactive command line tool for executing SQL statements.

jdbcdump:

Dump the contents of a database as SQL statements into a file, like mysqldump.

jdbcload

Execute SQL statements from a file (the opposite of jdbcdump)

Currently, only HSQLDB is supported.

Kannel WAP and SMS Gateway project is a WAP and SMS gateway.
SMS, short message services, are widely used all over the world in huge amounts. The main use for Kannel is to link HTTP based services to various SMS centers using obscure protocols.
WAP, short for Wireless Application Protocol, is a collection of languages and tools and an infrastructure for implementing services for mobile phones. Traditionally such services have worked via normal phone calls or short textual messages (e.g., SMS messages in GSM networks). Neither are very efficient to use, nor very user friendly. WAP makes it possible to implement services similar to the World Wide Web.
Unlike marketers claim, WAP does not bring the existing content of the Internet directly to the phone. There are too many technical and other problems for this to ever work properly. The main problem is that Internet content is mainly in the form of HTML pages, and they are written in such a way as to require fast connections, fast processors, large memories, big screens, audio output, and may require fairly efficient input mechanisms. Thats OK, since they hopefully work better for traditional computers and networks that way. However, portable phones have very slow processors, very little memory, abysmal and intermittent bandwidth, little screens and extremely awkward input mechanisms. Most existing HTML pages simply will not work on them.
WAP defines a completely new markup language, the Wireless Markup Language (WML), which is simpler and much more strictly defined than HTML. It also defines a scripting language, WMLScript, which all browsers are required to support. To make things even simpler for the phones, it even defines its own bitmap format (Wireless Bitmap, or WBMP).
HTTP is also too inefficient for wireless use. By using a semantically equivalent, but binary and compressed format it is possible to reduce the protocol overhead to a few bytes per request, instead of up to hundreds of bytes. Thus, WAP defines a new protocol stack to be used. However, to make things simpler also for the people actually implementing the services, WAP introduces a gateway between the phones and the servers providing content to the phones.
The WAP gateway talks to the phone using the WAP protocol stack, and translates the requests it receives to normal HTTP. Thus, the content providers can use any HTTP servers, and can utilize existing know-how about HTTP service implementation and administration.
In addition to protocol translations, the gateway also compresses the WML pages into a more compact form, to save bandwidth on the air and to further reduce the phones processing requirements. It also compiles WMLScript programs into a byte-code format.
Requierments:
- C compiler and development libraries and related tools.
- The gnome-xml (a.k.a. libxml) library, version 2.2.0 or newer. We recommend that you use libxml version 2.2.5. If you are installing it from your distributions packages, youll need libxml2-dev in addition to run-time libxml2 package libraries.
- Note: there is a bug in libxml version 2.2.3 and 2.2.4 that causes problems with character encoding in attributes. This problem is fixed in 2.2.5. See http://xmlsoft.org/xml.html.
- GNU Make.
- POSIX threads (pthread.h).
- GNU Bison 1.28 if you modify the WMLScript compiler.
- DocBook markup language tools (jade, jadetex, DocBook style-sheets, etc; see README.docbook), if you want to format the documentation (pre-formatted versions are available).
Enhancements:
- Various critical bugfixes since 1.4.0, including major SMSC protocols supported (SMPP, EMI/UCP, and GSM AT modem comands), HTTP layer fixes, and WAP WTP and WTP SAR layer fixes.
- The sendsms HTTP interface has been improved to obey the bearerbox message state for replies.