File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Web Services and the fly likes Accessing database APIs (newbie) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "Accessing database APIs (newbie)" Watch "Accessing database APIs (newbie)" New topic

Accessing database APIs (newbie)

Michael McAuliffe

Joined: Aug 22, 2008
Posts: 14
I'm converting a SQL Server Data Transformation Service (DTS) package to a Java program.

It required to call multiple database APIs (there are also web APIs) to update the database. The APIs are from a purchase vendor package.

What is the best way of doing this? It has been suggested that I use WSDL.

I'm new to Java and have read some on WSDL.
Vinod K Singh
Ranch Hand

Joined: Sep 30, 2008
Posts: 198
With so little information, I don't think anyone can help you out. Also by your post it is not clear if it is related to JDBC or web services.

My Blog
Michael McAuliffe

Joined: Aug 22, 2008
Posts: 14
I hope that I'm able to explain.

I'm writing a program that needs to update a SQL Server database. The program reads in a CSV file, write it to a SQL Server table. It then retrieves the rows from the table and edits the data. The next step is to retrieve the rows that are not in error and update the SQL Server tables with the data. To perform the update, it needs to execute APIs. The APIs are installed on both the database server and web server. They are the same.

The software package that was purchase has the same APIs executing on the database server and the web server.

I had asked some people that I know are more knowledgeable than I am and they suggested using WSDL.

Is there another way of calling an APIs other that using WSDL?
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63838

You're still being way too vague:
To perform the update, it needs to execute APIs.
What APIs?

[Asking smart questions] [About Bear] [Books by Bear]
Michael McAuliffe

Joined: Aug 22, 2008
Posts: 14
Whichever is easier to call for a beginner. I don't know XML. The current version of the program is using the database APIs, but it is written in a subset of vbscript, that is used by SQL Server.

Is it easier to use the database or web apis? Or is the coding the same?

I'm new to Java, WSDL, XML.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
I doubt that Java code can call any VBScript-type API that SQLServer offers. So the web service APIs are probably your only choice.

WSDL is a way to describe a web service API. You'll need it to create Java client code that can access those services. Most web services toolkits (like Apache Axis2) include tools that can take a WSDL and create that code for you.
I agree. Here's the link:
subject: Accessing database APIs (newbie)
It's not a secret anymore!