× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have a Java app that connects to a MS SQL Server using JDBC.  It reads
the requests from a data queue and writes the result set to a second
data queue.  This has been working for some time.  

I received a call this morning from a user saying that it crashed with
an error (see below).  A quick check revealed that the SQL Server had
been changed.  The server went from "//ip address\\beforename" to "//ip
address\\aftername".  I changed the program that writes to the data
queue but it still kept returning the same error.  The server admin
recreated the old server and the program worked.  I have debugged the
Java app and I know that it is using the new server.

Does the iSeries do some type connection sharing where it keeps using
the same (wrong) connection?


com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open user
default database. Login failed.
 at java.lang.Throwable.<init>(Throwable.java:195)

 at java.lang.Exception.<init>(Exception.java:41)

 at java.sql.SQLException.<init>(SQLException.java:40)

 at com.microsoft.sqlserver.jdbc.SQLServerException.<init>(Unknown
Source)                       
 at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Un
known Source)        
 at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)

 at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown
Source)                       
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
Source)                     
 at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

 at java.sql.DriverManager.getConnection(DriverManager.java:512)

 at java.sql.DriverManager.getConnection(DriverManager.java:193)

 at SQL.sqlQuery(SQL.java:108)

 at SQL.main(SQL.java:23)


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.