aspose file tools*
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "Accessing database APIs (newbie)" Watch "Accessing database APIs (newbie)" New topic
Author

Accessing database APIs (newbie)

Michael McAuliffe
Greenhorn

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
Greenhorn

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
Marshal

Joined: Jan 10, 2002
Posts: 61054
    
  66

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Michael McAuliffe
Greenhorn

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
Marshal

Joined: Mar 22, 2005
Posts: 41572
    
  54
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.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Accessing database APIs (newbie)