.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

Accessing a Java Class from within SQL Server

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

I have a Java Class that I want to be able to access from within a SQL Server Stored procedure.  I know you can access C# and other .Net code, but can you also access a regular Java class this way?

View Complete Post

More Related Resource Links

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Accessing Functions from a Class



I am a PHP developer and am running into a lot of issues with C# and .NET. I would like to be able to do the following in C#. (i'm not sure if it should be done this way though)

C# File:

using System;
using System.Data.Odbc;
using System.Data;
using System.Configuration;

partial class site_functions : System.Web.UI.Page

protected void Main(object sender, EventArgs e)

public static void open_database()
OdbcConnection myConn;
OdbcDataReader MyReader = null;
string strConnection = ConfigurationSettings.AppSettings["dbConnect"];

myConn = new OdbcConnection(strConnection);

public void close_database()

public void Read_Database()
//do something


<%@ Page Language="C#" CodeFile="site-functions.cs" Inherits="site_functions" ContentType="text/html" ResponseEncoding="utf-8" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

Server Farms: Application Center 2000 Offers World-Class Scalability


Application Center 2000 simplifies the deployment of a Microsoft .NET-based application to clusters, which are shared-nothing, loosely coupled computers that appear as one virtual computer. This allows all the computers in Application Center 2000 clusters to provide the same service or Web application at the same time. This article explains network load balancing and component load balancing for COM+ components with Application Center 2000. Accessing the features of Application Center 2000 though the MMC snap-in interface and the command-line interface for batching administrative tasks is also covered.

Panos Kougiouris

MSDN Magazine May 2001

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: Accessing SharePoint 2010 Data on the Server

This video provides an overview of approaches for accessing SharePoint 2010 data by using the server-side APIs. (Length: 3:32)

Accessing file on remote server


       I need help to achieve the following.
       I have integrated the Single Sign On to my webapplication. Service Provider(SP) is developing in .net platform and windows server.Identity Provider (IdP) is configured in apache and linux server.
       For authentication I am redirecting the user to IdP and authenticate at IdP and return back to my .net website. So I have user's database in IdP as a db file user.db (see the apache configuration below) for authenticating user.
          <Location /idp/Authn/RemoteUser>
               AuthType Basic

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

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

read string and lable value from sql server by class

hi,i want to create multi language cms project,i don't like use resourse component visual studio.please help me to create class for resourcestring and use for lable and string value.and cms user can add new language by xml and webform anybody help to me

JAVA calling SQL Server Procedure

Reply Contact I have a JAVA developer asking me this question.  I am not sure how to answer him.  I am not sure I understand his question.  He is using JAVA to call my procedure. "Is there some conclusive signal returned by the the SP result that would letus know whether it succeeded or failed? I'm currently looking for the word "exception" in the error message, but that hardly seems conclusive to me." lcerni

Access Denied and Null Returned while Accessing Web Services from remote server.

Please go through following scenario.  I am writing a web Service and one of its web method, I want it to download a png file in form of buffer from remote server. And My consume application will write that buffer retured by Web service in to file on User's Computer. However, I am able to do this using Local Web Service but when I published that service on my web server, I always get null retuned And even in one of my test code while copying file from that server , I always get Access Denied.  Following things I have done for above issue. 1] I even tried making the Anonymous user for the web service the system administrator (with the correct password), to no avail. 2] I also tried sharing out the folder I'm pulling files from to allow access from Everyone.   [Previously same service was working fine on another remote server with IIS 7.0, we checked server IIS Settings but in vain.]   if you know where we are mistaken please guide me to resolve this issue as its very urgent. Please go through following scenario.                  

Not able to access Class methods when deployed on a remote server?

I have a web service project. In the project I have a class named "Piper"In testing the web service in localhost mode in the VS IDE, I can access membersof the class, such as my method "Proceed" and property "Comber" The problem I am having is that when the web service is deployed to the serverin staging, or the deployment server, I am not able to access any methods of my class. Onlythe properties. This is very strange? As they are both public and I can access them when I run the project in local host in the IDE. Does anyone know what the problem might be?Here is a simplified example of my class. Public Class Piper Public Sub Proceed() End Sub Public Property Comber() As Boolean  Get   Return True  End Get  Set(ByVal value As Boolean)       _comber = value  End SetEnd Property End Class

Accessing the command prompt of the server computer in c#

Hi ,I'm developing a web application in asp.net using  C# and need to access the command prompt of the server computer.After accessing it I need to run a "ABC.bat" file in the server computer which is in folder "E:\Test".The absolute path of the server is "\\MyServer"Any help to achieve this ( or any other alternative suggestions) would be greatly appreciated....ThanksPS: I need to run the ABC.bat file on the server machine as the bat file runs couple of more applications which are licensed to that server machine.

Accessing image file in local machine from server

 Hi i have a  .JPG file in my local machine which has  to be sent as body of SMTP mail. Path of image D://foldername//imagename.jpg The code I run is in the server m\c. I want it to access my local machine's d:\ folder to get the image file. But it is accessing the server m\c's d:\ folder. How can this be done? Thanks Amuda.RG  

Namespace Conflict while accessing webservice from java script






Hi All,

I am using Asp.Net with C# , I am trying to access web service from java script using below code


DCen.RC.RController.Update(_User, _UserId, _ContObjId, _IsUnrAllowed, _UserRatiowed, _Localed,  SucceededCallback, FailedCallback);<br/>

The above line is working fine in my local env. but when i am trying to deploy it on server it through exception and said "DCen not Defined "

Plese help me out


Thanks in advance

Accessing Client Devices & Upload to Server


I'm in the process of creating a ASP.NET page that will allow the user to upload PDF files stored on a CD onto the server. I have written a piece of code that checks for an .ini file and then goes into a specific folder that will save the PDF files to a folder I have specified on my computer. Now that works fine in localhost, but when I uploaded it to the server it stopped working. 

I get a 404 error everytime I click on the button to upload. I suspect i'm not correctly accessing the client's cd drive because the path to their drive isn't correct.

01.Protected Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click  
02.       Dim fileReader As String = "" 
03.       Dim intCount As Integer = 1  
04.       Dim strFileName As String = "D:INI FILES\"  ' TODO: CHANGE PATH  
05.       Dim fFile As New FileInfo(strFileName)  
06.       Dim files() As String = Directory.GetFiles("D:\PDF\")  
07.       Dim intNumOfFiles As Integer = CInt(files.Length()) - 1  

Accessing Stored Procedure Of SQL Server From Popup window


Hello everybody.

I have a parent window parent.aspx and a popup window popup.aspx. parent.aspx has a confirm button which on click open popup.aspx. This popup.aspx holds a filled application form like leave application form of employees and a email sending button. That button on click send emails to the specified email addresses with attachment. The

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