Re: FireBird JDBC connection problem -- JAVA400-L

Hi Joe Sam,

Yes, something more descriptive would be helpful.......

1. Invalid JDBC URL

The database URL was hard coded, for now, in both cases and format is 
"jdbc:firebirdsql:ipaddress:c:/database/employee.gdb"
This uses the default port of 3050. I have also explicitly declared the 
port in the URL but makes no difference.

Another point from the Sourceforge FAQ, is that for accessing a windows 
server the URL format was given as :
"jdbc:firebirdsql:ipaddress:c:\\database\\employee.gdb" which, to me, 
makes sense but didn't work so I used 
"jdbc:firebirdsql:ipaddress:c:/database/employee.gdb" instead which did 
work from the PC client. Neither version appears to work from the iSeries.

If anyone has successfully connected to a Firebird database in Windows 
using the Jaybird JDBC driver on the iSeries then it would be nice to know 
the connection URL format used.

2. Setup problems or changes from the defaults.

Have confirmed with those managing the Firebird side of the interface that 
the port they are using is 3050. I have tested this by default and 
explicitly from my PC and results are consistant with this.

3. Socket or permission problems with type 4 drivers.

FBSQLException gives an error code of 335544721 (gds_network_error) and 
SQL State of HY000 (General error - no specific SQL state).

Internal Exception gives the same error message "Unable to complete 
network request to host "217.34.115.98" 

Unfortunately, I have no control over the other box and it would be 
extremely difficult to get server socket program running there. However, I 
did try running an echo client type program on the iSeries pointing at 
port 3050 on the Win server. Admittedly, there's nothing on the server 
side to echo the request but noticed that I did not get an IOException 
from that port whereas I did from other ports so the connection appears to 
have worked.

4. PTF

This is a new iSeries 810 box running v5r3. Have checked PTF levels ok.

5. From Here....

Currently thinking it might be due to a problem associated with character 
set translation (EBCDIC - ASCII). Tomorrow, I'll download the open source 
Firebird database and set up on my PC. At least that way I can test both 
sides of the interface.

Thanks for the suggestions & links.

Keith 








"Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx> 
Sent by: java400-l-bounces@xxxxxxxxxxxx
31/05/2005 20:08
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
cc

Subject
Re: FireBird JDBC connection problem







    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
>