-----Original Message-----
From: Robert DiFalco [mailto:rdifalco@...]
Sent: Friday, October 18, 2002 3:09 PM
To: 'Firebird-Java@yahoogroups.com'
Subject: RE: [Firebird-Java] Re: SQLWarning for Dialect

Thanks roman. It is getting reported as a warning. When I reuse a connection
in my pool I do something like:

      if ( DEBUG )
      {
          for ( SQLWarning w = con.getWarnings(); w != null; w =
w.getNextWarning() )
              w.printStackTrace();
      }

      con.clearWarnings();

That's when I see it, the first time a connection is reused after being
created. We are using Firebird as our server which I am guessing only
supports dialect level 1. It turns out to be innocuous but not intermittent.
Should I do anything to prevent this from happening? Fwiw, we are planning
to move to Jaybird as soon as we get some breathing time and will definitely
try to contribute to the team. Thanks for your help on this stuff.

R.


-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Friday, October 18, 2002 2:51 PM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: SQLWarning for Dialect


Hi,

> Probably the wrong list but I get the following warning when
> creating connections with interclient 2.0. What's odd is that I
> only get them intermittently. Huh. Any thoughts?
>
> java.sql.SQLWarning: [interclient] Specified dialect not supported:
> The SQL Dialect has been changed to 1.

This warning means that InterClient would like to use dialect 3 (or
2), but database is in dialect 1. However, it is not clear to me why
do you get this warning intermittently. Also it is strange that
InterClient treats it as exceptions, not as warning.

You can try current version of Jaybird driver from the CVS. I
implemented more or less correct warning handling today (all warnings
are accumulated in connection, that is not quite correct, however
implementing it correctly would require few big changes in the
driver).

Also, InterClient is not maintained by Firebird team, so, even there
is a bug, it's not likely that it will be fixed. However, if you
like, you can join Firebird team and start improving InterClient.

Best regards,
Roman Rokytskyy


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.