.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Exception with MS-SQL Server,JDBC and XA Transactions

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :Sql Server

Hi, I'm getting the following exception in my log when I try to perform an XA transaction:

javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc_SQLServerException: failed to create the XA control connection. Error: "The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_init_ex', database 'master' schema 'dbo'

I followed these tutorials Understanding XA Transactions and How to make MSSQL Server XA Datasource Work? After following the first tutorial I also ran the following command in SSMS:

(change) use master GO
EXEC sp_addrolemember [SqlJDBCXAUser], 'MyUserName' GO

I'll also add that I ran

use master GO EXEC sp_gratdbaccess 'MyUserName','MyUserName' GO

to verify that the user has access to the master db and I got an error that "the user already exists in the current database". Lastly I verified, via SSMS, that the role SqlJDBCXAUser does have EXECUTE granted in regard to xp_sqljdbc_xa_init_ex .
The DB I'm using is obviously not maste

View Complete Post

More Related Resource Links

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

Data Points: SQL Server 2005 XML Support, Exception Handling, and More


SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.

John Papa

MSDN Magazine May 2006

Error Handling: Throwing Custom Exception Types from a Managed COM+ Server Application


Exception handling semantics in .NET are based on type, so you can create custom exceptions that have their own properties and methods. In .NET, exceptions are first-class citizens, and since they're the built-in error handling mechanism, all .NET-compliant languages must support exceptions. In addition, COM+ services are available to .NET code as Enterprise Services, so you can leverage exceptions in your Enterprise Services design.In this article the author describes custom exceptions, throwing exceptions across COM interop boundaries, and working with Enterprise Services.

Bob DeRemer

MSDN Magazine March 2004

clr assembly in sql server - working directory? and exception question

Hello, I have a small assembly in sql server 2008... it's pretty simple, but in the very rare circumstance that it may throw an exception I am catching it and writting to a log file. something like: using (StreamWriter sr = new StreamWriter(@".\ErrorLog.txt", true)) { sr.WriteLine("{0:G} ===> {1}", DateTime.Now, ex.Message); } I believe that should write the file to the working directory... 1. what would the working directory be for sql server 2008? the binn directory? 2. what would happen if a clr assembly added to sql server throws an exception that is not handled by your clr code?

How do I install SQL Server 2005 JDBC driver

I'm an new bie to "SQL Server 2005 JDBC Driver". I have downloaded SQL Server 2005 JDBC driver and extracted it to C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\. Is the installation complete now? How can I use this driver from my application? If there is a step-by-step instruction on whether we need to run some scripts in SQL Server or to configure some system variables, it would be great. Thanks in advance for your time in this.Cheeeeerrzzzz! S@kthi http://blogs.msdn.com/sqlsakthi | http://twitter.com/PowerSakthi Mark as Answer if it helps. This posting is provided "AS IS" with no warranties and confers no rights.

SQL Server JDBC Driver 1.2 Issue

I am using JDBC 1.2 driver to connect to Sql Server 2005 database and i am facing the application crash issues several times and javacores shows that the crash happens during JDBC call. This issue is happening several times in our application, please let me know if an upgraded driver version will fix the problem or to investigate the driver issue further NULL            1XMCURTHDINFO  Current Thread Details NULL           ---------------------- 3XMTHREADINFO      "WebContainer : 8" (TID:0x5946E100, sys_thread_t:0x51D052F0, state:R, native ID:0x000008AC) prio=5 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/PLPInputStream.getBytes(Bytecode PC:64(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/DDC.xmlPLPToObject(Bytecode PC:132(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/ServerDTVImpl.getValue(Bytecode PC:216(Compiled Code)) 4XESTACKTRACE          at com/microsoft/sqlserver/jdbc/DTV.getValue(Bytecode PC:216(Compiled Code)) 4XESTACKTRACE          at com/micro

SQL Server JDBC: java.lang.SecurityException: Invalid signature file digest?

Hi I am following these instructions for using SQL Server JDBC driver and using sqljdbc4.jar file: http://msdn.microsoft.com/en-us/library/ms378526.aspx When registering the driver to instruct JDBC Driver Manager which driver to load: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); It throws and exception: java.lang.SecurityException: Invalid signature file digest for Manifest main attributes What does this mean and how do I resolve it? NOTE: I followed a similar posting, but it did not resolve it: com.microsoft.sqlserver.jdbc.SQLServerException.class throws java.lang.SecurityException: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/ab35688e-ca33-423e-a9bd-54e30fcb5091/ Thanks Jeff in Seattle

Distributed Transactions fail on Linked server

We get the below error while performing a distributed transaction on linked server. We have several linked servers configured in the source server and all of them succeed with the distributed transaction except on one.   We did all the basic troubleshooting and moreover the distributed transactions work fine if we use a remote server instead.   Need your expert guidance in resolving this issue     Error:   OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" returned message "No transaction is active.". Msg 7391, Level 16, State 2, Line 3 The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" was unable to begin a distributed transaction.     Test code:   begin distributed transaction   select top 10 * from [SERVERNAME.REDMOND.CORP.MICROSOFT.COM].master.sys.objects   ROLLBACK     Source server :      Microsoft SQL Server 2008 (RTM) - 10.0.1779.0 (X64)        Nov 12 2008 12:10:04        Copyright (c) 1988-2008 Microsoft Corporation        Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (VM)     Target server :     Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)        Jul  9 2008 14:43:34        Copyright (c) 1988-2008 Microsoft Corporation        Enterprise Edition

SQL Server Configuration Manager Exception: 0x80010105

We're running SQL Server 2008 Standard edition version 10.0.2531.0 (SP1) 64-bit.  It is running on Windows Server 2008 R2. Whenever I connect to the SQL Server Configuration Manager, and look at the SQL Server Services, I get the message : The server threw an exception. [0x80010105]. Suggestions?Clint

Microsoft SQL Server 2005 JDBC Driver

I'm getting the following exception when attempting to connect to SQL Server 2005 using Microsoft's new JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host  has failed. java.net.ConnectException: Connection refused: connect The help docs suggest checking connectivity using telnet. So attempting to connect via telnet to generates: Could not open connection to the host, on port 23: Connect failed. So I try to start telnet: net start telnet I get the following error message: The service cannot be started either because it is disabled or because it has no enables devices associated with it. Can anyone help? Thanks

RPC Server Exception

System.Management.ManagementScope ms = new System.Management.ManagementScope("\\\\" + stringMachineName + "\\root\\cimv2", co); oq = new System.Management.ObjectQuery("SELECT * FROM Win32_processor"); query = new ManagementObjectSearcher(ms, oq); queryCollection = query.Get(); return queryCollection;   well guys i am trying to access remote system but in doing this some machines give mein following exception  System.interop.Runtime.COmException RPC SERVER IS unavailable (Exception from Hresult:0x800706BA)     can u help me this how to solve this JK

Unable to See List of Marked Transactions on New Server

I am trying to do a TFS test restore to new server following the TFS 2010 Backup and Restore processes below verbatim (SQL 2008 SP1): Backup TFS http://msdn.microsoft.com/en-us/library/ms253070.aspx Restore to Different Server http://msdn.microsoft.com/en-us/library/ms252516.aspx#RestoreDB Restore Single Server Deployment to New Hardware http://msdn.microsoft.com/en-us/library/ff459215.aspx I can restore the database to the restoring state on a new server; however, when applying the transaction log backup I don't see any marked transactions to restore to.  I don't even get a list to choose from.  I can restore the database to the original server successfully and can see list of marked transactions to restore to. Is there anything that we could keep me from seeing the list of marked transactions on the new server?  Does this have anything to do with the fact that the marks are stored in the msdb.dbo.logmarkhistory database? Thanks in Advance, Michael

Internal Server Error Exception when Searching (in CoreResultsWebPart::OnInit)

Hello, We are encountering an "Internal server error exception" when we attempt to search. The relevant error in the ULS log is:   CoreResultsWebPart::OnInit: Exception initializing: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.Office.Server.Search.WebControls.CoreResultsWebPart.SetPropertiesOnQueryReader()     at Microsoft.Office.Server.Search.WebControls.CoreResultsWebPart.OnInit(EventArgs e)   This is occurring on a fresh install of SharePoint Server 2010 Standard Edition running on a single-server farm.  We have tried:   ensuring that hotfix 976462 is installed (it is) ensuring that the "SharePoint Server Search" and "Search Query and Site Settings Service" services are running (they are) removing, then reinstalling the search application (tried, but with no luck) appending ":80" to the host of portion of the search result url to see if we get a different result (we do not) ensuring that the application pool is assigned correctly (it is) restarting the timer service restarting the search service rebooting For the sake of conversation, we'll say the server is named "pharaoh". It has the following AAMs: http://pharaoh:8888, Default Zone  (Central Admin) http://pharaoh, Default Zone   All services and applicati

SQL SERVER JDBC: WARNING: Failed to load the sqljdbc_auth.dll

Getting this warning when I run my application.  I have already read the posts that repeat the 'put it in your path mantra' over and over again.  Please, do not redirect me to those posts they are useless.  I am telling you I have this DLL in my java.library.path, and I know this because I can load the DLL with java.lang.System.loadLibrary.  i even tried the directions on the MSDN sight and put the install path directly into my java.library.path.  I still get the warning.  Your driver has a bug, please fix it.

Installing SharePoint 2010 with SQL Server 2008 - SQL Exception - Login Failed

Hello I've been trying to install SharePoint 2010 with SQL Server 2008 in my Windows Server 2008 R2 box. I've got the same error all the times. System Specifications Windows Server 2008 R2 SQL Server 2008 with SP1 SharePoint 2010 Enterprise 6GB RAM, 320GB HDD Installation Steps I followed Installed Windows Server 2008 R2 and joined it to our domain Logged in as domain administrator Installed SQL Server 2008 Selected the Local Service account for all the SQL Server 2008 services during installation Selected Mixed mode authentication Selected 'Add Current User' in all the other installation screens Installed SQL Server 2008 SP1 Installed SharePoint 2010 Selected Farm option Selected Complete Installation Tried to run the configuration wizard and got sqlexception error - login failed But i checked that the current user (domain admin) is having all the permissions. Also added the domain admin as Security Admin and DB Creator in SQL Server instance. Any ideas?  Regards NLV Visit SharePoint User group - India

Internal server error exception on search results page when no language is set in browser

We have some users who receive an internal server error exception when they enter a search query on our SPS 2010 site. The SharePoint log shows the following: Internal server error exception: System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() After some more diggin

Internal Server Exception

I have upgraded Sharepoint 2007 to SharePoint 2010.When trying to search for anything its showing the following error   Internal server error exception: Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: fcfbe563-4d9c-4818-ad20-894fda688c36   I am using Windows server Ebterprise edition Service Pack 2.How can I solve this issue
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend