Re: [Wrapper-user] Upgrading Java Wrapper Service

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

I just found the correct PATH to resolve my issue below, however, NOW, I am getting a LOGIN FAILED on the SQL Server.  I logged into the SQL Server with the login that I'm using via the application and I was able to login without issue.

Here is the error:

INFO   | jvm 1    | 2013/11/20 10:46:04 | PassThrougDBConnection.connect() SQLException in connect:com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "ATMoPOSt" requested by the login. The login failed. ClientConnectionId:d06df967-b5b6-48a0-b11a-01017506a293
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.complete(SQLServerConnection.java:2665)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2910)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at java.sql.DriverManager.getConnection(Unknown Source)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at java.sql.DriverManager.getConnection(Unknown Source)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.util.db.PassThroughDBConnection.connect(PassThroughDBConnection.java:181)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.util.db.PassThroughDBConnection.<init>(PassThroughDBConnection.java:452)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.util.db.PassThroughDBConnection.clone(PassThroughDBConnection.java:61)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.ATM.processor.SQLProcessor.setConnection(SQLProcessor.java:42)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.ATM.ATMServer.loadXmlConfiguration(ATMServer.java:621)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.ATM.ATMServer.checkConfiguration(ATMServer.java:1060)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at com.sharpbancsystems.ATM.ATMServer.run(ATMServer.java:1132)
INFO   | jvm 1    | 2013/11/20 10:46:04 |      at java.lang.Thread.run(Unknown Source)
INFO   | jvm 1    | 2013/11/20 10:46:04 |
INFO   | jvm 1    | 2013/11/20 10:46:04 | jdbc:sqlserver://10.10.30.130;databaseName=ATMoPOSt;integratedSecurity=true;EnableBulkLoad=true;BulkLoadBatchSize=1000
INFO   | jvm 1    | 2013/11/20 10:46:04 | DB properties:{}
INFO   | jvm 1    | 2013/11/20 10:46:04 |  ****************jdbc:sqlserver://10.10.30.130;databaseName=ATMoPOSt;integratedSecurity=true;EnableBulkLoad=true;BulkLoadBatchSize=1000,1.6.0_45
INFO   | jvm 1    | 2013/11/20 10:46:04 | PassThrougDBConnection.connect() SQLException in connect:com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "ATMoPOSt" requested by the login. The login failed. ClientConnectionId:9bb2d1be-52d9-4dfb-bf79-3562d8fe1343

From: Melinda Savoy
Sent: Wednesday, November 20, 2013 09:24
To: wra...@li...
Subject: Upgrading Java Wrapper Service

We just installed a NEW version of the Java Wrapper Service on a new 64-bit system from a 32-bit system and JVM but now getting 2 errors below BOLDED and HIGHLIGHTED IN RED and the new version of the sqljdbc_auth.dll is there in the java.path.library and I'm not certain why it cannot be found.  Any help/direction would be greatly appreciated.  Thank you.

Melinda Savoy
Sharp BancSystems, Inc.
Senior Java Developer

* E:  me...@sh...<mailto:me...@sh...>
* O: 817.438.2161

"We understand that e-mail is a simple and cost effective method of communication, however items such as requests and inquiries needing immediate attention should not be sent via e-mail. Also, sensitive personal and account information like account numbers, Social Security numbers, passwords, or PIN numbers should not be sent by e-mail. Because an e-mail message may not be immediately reviewed by a company representative, you should contact the company by telephone, or in person for items needing immediate attention. Furthermore, this e-mail and any attached files may contain confidential and/or privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive this e-mail for the recipient), please contact the sender by reply e-mail and delete all copies of this email"