Re: FireBird JDBC connection problem

["Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx>]

    Hi Keith,

    Now you know how users feel when they get a no-content error message.
;-)

    I haven't used Firebird, but JDBC connection problems fall into a few
areas:

        Invalid JDBC URL.

            I assume this is OK since you use the same program, but worth
checking.  Is the connection string hard or soft coded?  May be worth
printing to verify.


        Setup problems or changes from the defaults.

            I saw something about a possible 3050 port ( the default )
conflict on Windows.  Did you verify the port Firebird is running on and use
the same for connecting?


        Socket or permission problems with type 4 drivers.

            Since the message included "Resource Exception", this is most
likely, although it may be some other type of resource.  I've used the
KnockKnock client and server apps in the Java Tutorial at

<
http://java.sun.com/docs/books/tutorial/networking/sockets/clientServer.html
>

to verify that connections and data passing work OK.  It's a good set
because you can move each program to the other box and add checks as
necessary.  Before I went to that effort, though, I noticed that
FBSQLException extends java.sql.SQLException.  That means you can probably
get more information from getNextException() and getSQLState().  You can
also check for warnings and FBSQLException has getErrorCode() and
getInternalException() methods that should be helpful as well.

    I also saw that there's a  JayBird JCA/JDBC Driver for Firebird  FAQ at

http://firebird.sourceforge.net/index.php?op=devel&sub=jdbc&id=faq#13

    I hope some of that helps.  Let us know the resolution, especially if it
is something that will affect all AS/400 systems.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: <Keith.McCully@xxxxxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 31, 2005 7:02 AM
Subject: FireBird JDBC connection problem


> Hi,
>
> I am attempting to connect to a Firebird (InterBase) database from the
> iSeries using the JayBird JDBC driver.
>
> However, in qshell I get the following message:
>
> org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to
> complete network request to host "217.34.115.98".
> Reason: Unable to complete network request to host "217.34.115.98".
>
> The Jaybird driver registers ok but the program fails at point of
> connection.
>
> However, when I run the same, simple connection test program from my PC,
> the connection works ok.
>
> Both the iSeries and my PC are on the same network and access the target
> host through the same gateway and sub-net mask.
>
> I can ping the host from the iSeries.
>
> Firebird is on a Win 2000 server and iSeries is v5r3 with JDK 1.4
>
> Any help or suggestions would be appreciated.
>
> Keith
>