Hi,

I've been playing a bit with interclient 2.0 on redhat linux 7.

I have found that sql statements seem to work fine, but that at least the
DatabaseMetaData.getTables call kills interserver. I suspect the other
DatabaseMetaData calls that return info from the system tables may also not
work but I haven't tried them. The SQL generated for these system tables
queries in interserver looks a bit peculiar to me.

Has anyone else got these calls to work?

Is Firebird bugzilla the appropriate place to mention this?

I'm trying to fix this, and will announce success.

I also have:

1. an ant build script for interclient.

2. a change allowing interserver to be compiled using gcc on rh linux 7

namely
NetTCP.cpp
int
NetTCP::netOpen (int sockfd, int *newSockfd, int inetdflag)
{
register int tmpSockfd, childpid;
//david jencks 1-19-2001 begin
// int clilen, on; //original line
int on;
socklen_t clilen;
//david jencks 1-19-2001 end
struct sockaddr_in tcpCliAddr;

I have no way of telling what effect this change might have on other
platforms.

and finally
3. an ant optional task for executing sql scripts in an xml format,
including putting query results into xml. (this should work with any jdbc
driver, but I have only firebird) (this is not complete)

If anyone is interested in 1 or 3 I would be happy to send a copy.

On 2001.01.19 21:42:52 -0500 Mark O'Donohue wrote:
>
> Hi
>
> Status of interclient at Firebird.
>
> I've been heavily involved in Firebird, but come from a strong
> java/linux background and in fact that's the way I use it.
>
> Unfortunately I haven't been able to make it out of the forest of
> interbase to get into interclient much, I've built it locally a few
> times and Tom Coleman changed the build script for it, and Torsten added
> a few bug patches. Apart from that it's pretty much sat by itself. I
> can tell you that the code is fairly clean probably because it's also
> more recent.
>
> I did look at interclient 2.0 code vs interclient 1.5 and the
> differences were fairly minor, enough that i'd say to work with 2.0
> source rather than 1.5.
>
> Any help would be appreciated, and if you have questions along the way
> I'll be happy to answer them.
>
> Cheers
>
> Mark
>
> >
> > Message: 2
> > Date: Fri, 19 Jan 2001 09:19:24 +0100
> > From: "Arkadiusz Rychlinski" <A.Rychlinski@...>
> > Subject: Re: Borland or FireBird ?
> >
> > Probably you're right.
> >
> >
> > Before Interbase became Open Sourced people from Borland tried make
> > Interclient JDBC-2.0-compilant and
> > add some Interbase-specific options (like service manager or whatever
> it
> > is).
> >
> > In my opinion (I don't know all the truth) project FireBird does its
> best to
> > fix and improve RDBMS; things like
> > JDBC, ODBC etc. are untouched (everybody use Delphi with BDE, IBX or
> > IBObjects).
> >
> > I really need this JDBC 2 for Interbase, then I'm also ready to help in
> > works on Interclient.
>
>
>
> >
> > Arek
> >
> > ----- Original Message -----
> > From: "Richard Vowles" <rvowles@...>
> > To: <IB-Java@egroups.com>
> > Sent: Friday, January 19, 2001 6:03 AM
> > Subject: Re: [IB-Java] Borland or FireBird ?
> >
> >
> >> That is confusing me as well - it doesn't appear that anyone is
> working on
> >> Interclient 2.0?
> >>
> >
> >
> >
> >
> >
> > ________________________________________________________________________
> > ________________________________________________________________________
> >
> >
>
>
> --
> Your database needs YOU!
> http://firebird.sourceforge.net
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
>
>