Re: Calling a Windows DLL

From: Lew Pitcher (Lew.Pitcher_at_td.com)
Date: 05/31/04


Date: Mon, 31 May 2004 08:51:22 -0400


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alan wrote:
> We have a windows application written in VB w/SQL Server (SQL2K) in
> the backend. Another application would like to have access to some of
> our data (read/only). Normally we would provide the data via our
> external interface DLL, but this is a Java application is running on
> Unix. We really don't want the java app hitting the database directly
> (even R/O) because when things change their app would then be broke
> and we get yelled at.....
>
> In the Windows world we simply make sure our external interface DLL
> doesn't change input or output interfaces and we make all necessary
> chages to the DLL behind the scene. Any suggestions on how best to
> approach this? We would like to maintian the interface layer since our
> developers are most familar with the application and database.

OK, write a Java class that encapsulates and isolates your database I/O, just
like you would have written a Windows DLL to do. Give that Java class to your
Unix developers to use instead of their direct access (presumably through JDBC),
and /you/ maintain the Java class when ever you change your database.

- --
Lew Pitcher
IT Consultant, Enterprise Application Architecture,
Enterprise Technology Solutions, TD Bank Financial Group

(Opinions expressed are my own, not my employers')
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)

iD8DBQFAuypHagVFX4UWr64RAuZaAKDpLbb0fZf1RjGIM5mR4dKP2480XQCg0IcB
f4Ly7vhz1WZ/i0gciHAPhFM=
=9mj4
-----END PGP SIGNATURE-----



Relevant Pages

  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)
  • RE: 2nd form with recordset of 1st
    ... processes using this table using optimistic locking? ... If this is a split database, is there a persistent connection to the back ... Every directory traversed requires Windows to ... > record source to be the 1st forms recordset? ...
    (microsoft.public.access.formscoding)
  • Re: OID/LDAP problem - Any help with a fix would be appreciated
    ... Make sure the windows workstation has SQLNET.ORA ... Hard error on read, ... The database "hang" only occurs when database links are used. ...
    (comp.databases.oracle.server)