Hi Rob and Matthew,

Thank you both,  I got the correct URL with port number from our DBA.  Thanks so much for your help,

Vivian

 

 

Vivian Kreig | IS Supply Chain | Staples, Inc. | (508) 253-3696

-----Original Message-----
From: Robert Manning [mailto:robert.m.manning@gmail.com]
Sent: Saturday, June 28, 2008 10:38 AM
To:
Kreig, Vivian
Cc: Matthew Dahlman; squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] Configuring Squirrel for IBM DB2 App Driver

 

 

On Fri, Jun 27, 2008 at 5:50 PM, Kreig, Vivian <Vivian.Kreig@staples.com> wrote:

I get:  Unexpected Error occured attempting to open an SQL connection.

And the stack trace is:

ava.lang.NumberFormatException: For input string: "xxxxx"

            at java.lang.NumberFormatException.forInputString(Unknown Source)

            at java.lang.Integer.parseInt(Unknown Source)

            at java.lang.Integer.parseInt(Unknown Source)

            at com.ibm.db2.jcc.DB2Driver.tokenizeOptionalPortNumber(DB2Driver.java:493)

            at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:111)

            at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)


It appears that you may have left the "xxxxx" in the URL, where the jdbc driver expects a port number.   My url looks like this:

jdbc:db2://localhost:50001/dbcpdest

Try substituting your server's hostname for "localhost", your server's port for 50001 and your server's database name for "dbcpdest" in the url above.

Rob