Subject Re: Lack of interest in Firebird/JDBC combination? was FW: [ib-support] How to connect with SQL dialect 3 using interclient (JDBC)
Author Herbert.Augustiny@sptroth.com
What OS are you using on the server? You need to use the same version of
interserver and interclient. On sourceforge you can find compiled versions
of interserver for win32 and linux. I am using the one for linux and it
works fine.

By the way, there is a list for java related IB/Firebird question:
IB-Java@yahoogroups.com and there is a java only client that seems to run
quite good (from what I hear on the list).

Regards,

Herbert



|--------+------------------------>
| | Agustin |
| | Gonzalez |
| | <aggonzalez@ac|
| | m.org> |
| | |
| | 14.12.2001 |
| | 15:33 |
| | Please respond|
| | to ib-support |
| | |
|--------+------------------------>
>--------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "ib-support@yahoogroups.com" <ib-support@yahoogroups.com> |
| cc: "'Herbert.Augustiny@...'" <Herbert.Augustiny@...>, "'.shevlandj@...'" <.shevlandj@...> |
| Subject: Lack of interest in Firebird/JDBC combination? was FW: [ib-support] How to connect with SQL dialect 3 using interclient |
| (JDBC) |
>--------------------------------------------------------------------------------------------------------------------------------------------|




Herbert,
I downloaded the interclient 2.0 compiled with the JDK 1.3. But now, the
interserver (V1.60) is complaining of a incompatible direvers (see stack
trace at the end).

It seems to me that I also need a new version of interserver but I don't
know where to find it...

IMPORTANT NOTE TO EVERYBODY IN THE LIST:
I only got ONE response to my email about issues with JDBC (thanks
Herbert!). To me this is a strong indication of a lack of people using
Firebird with Java. This is a shame since I think this is where the
potential of firebird is: a robust, open-source, RDBMS with a robust, fast,
up-to-date, JDBC driver. I am willing to contribute to this effort (i.e.
building & maintaining an open-source JDBC driver for Firebird) if nobody
wants to lead it or join the firebird/JDBC group if there is one. I believe
RDBMS are almost commodities today and their functionality stable and well
known. This is a great opportunity for Firebird to establish as the leader
in the open source RDBMS. But I believe Firebird won't achieve a
leadership position without a good, solid, up-to-date, open source, JDBC
driver.

---
Agustin Gonzalez, Principal
Town Lake Sotfware
www.townlakesoftware.com
(512) 248-9839

P.S. Stack trace:
interbase.interclient.BadInstallationException: [interclient] Installed
versions of InterClient and InterServer use incompatible client/server
protocol versions.
See API reference for exception
interbase.interclient.BadInstallationException
at
interbase.interclient.JDBCNet.receiveProtocolMessage(interbase/interclie
nt/JDBCNet.java:178)
at
interbase.interclient.JDBCNet.establishProtocol(interbase/interclient/JD
BCNet.java:132)
at
interbase.interclient.JDBCNet.<init>(interbase/interclient/JDBCNet.java:75)

at
interbase.interclient.Connection.connect(interbase/interclient/Connectio
n.java:317)
at
interbase.interclient.Connection.<init>(interbase/interclient/Connection
.java:285)
at interbase.interclient.Driver.connect(interbase/interclient/Driver.jav
a:204)
at java.sql.DriverManager.getConnection(DriverManager.java:517)

-----Original Message-----
From: Herbert.Augustiny@...
[SMTP:Herbert.Augustiny@...]
Sent: Wednesday, December 12, 2001 9:12 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] How to connect with SQL dialect 3 using
interclient (JDBC)

You need to use interclianet 2. You can get a compiled version 2.01from
the Firebird project on sourceforge.net

Herbert





Agustin Gonzalez <aggonzalez@...>
12.12.2001 16:18
Please respond to ib-support


To: "ib-support@yahoogroups.com" <ib-support@yahoogroups.com>
cc:
Subject: [ib-support] How to connect with SQL dialect 3
using interclient (JDBC)


I have interserver 1.60 and Interbase 6.0. I am trying to connect to a
"SQL
dialect 3" database in Interbase 6.0 using JDBC. Then I get the error:
"Client SQL dialect 1 does not support reference to DATE datatype"

I looked in the javadocs in the interserver docs but I can't seem to find
a
way to set the dialect property. Anybody knows how to do this?

Thanks,
---
Agustin Gonzalez, Principal
Town Lake Sotfware
www.townlakesoftware.com
(512) 248-9839



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





[Non-text portions of this message have been removed]



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/