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