Win a copy of TDD for a Shopping Website LiveProject this week in the Testing forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

Accessing database APIs (newbie)

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Michael McAuliffe
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Sheriff
Posts: 67634
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You're still being way too vague:

To perform the update, it needs to execute APIs.

What APIs?
 
Michael McAuliffe
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Rancher
Posts: 43027
76
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
There is no beard big enough to make me comfortable enough with my masculinity to wear pink. Tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss
https://www.kickstarter.com/projects/paulwheaton/free-heat
reply
    Bookmark Topic Watch Topic
  • New Topic