This week's book giveaway is in the Programmer Certification forum.
We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 and have Jeanne Boyarsky & Scott Selikoff on-line!
See this thread for details.
Win a copy of OCP Oracle Certified Professional Java SE 11 Programmer I Study Guide: Exam 1Z0-815 this week in the Programmer Certification 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara

invoking data from database using web service.

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

i'm new to web services. i tried with some sample programs ( helloworld service) in web services using eclipse.
Now i want to invoke the data from sql server using web services and for tat retrieved data, have to create chart, in eclipse.

i tried this without using web service. ( using cewolf to create chart)

EmployeesByDeptAndQtr .java :


jsp code :

web.xml

it is working without any error. Now i want is, to implement this as in web service.
Can anyone help me? Its soo urgent.
Thanks in advance

-Vanitha
 
Ranch Hand
Posts: 144
Oracle Fedora Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the boards. Before discussing your problem, you will want to update your code to close your database resources (ResultSet, Connection, .etc). It is preferred if you encapuslate your code within code tags and try to do some space formatting when posting on the message board. It makes it a little easier to read. Just a reminder, that this community will not write code for you. You can receive design ideas/feedback or help trouble shooting though, but we are NotACodeMill.

With that out of the way. What do you want to accomplish by turning this into a web service? What are your requirements? Inputs/Outputs? Do you want to return the data from the sql or a renedered chart? What type of web service are you trying to create: SOAP or REST? We cannot help unless you TellTheDetails.
 
Vanitha Prakash
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
oh.. tats fyn. i'm new to tis community.

my requirement s to retreieve the data from sql server using SOAP web serives ( for example, a table with columns like , name,age,salary )
after retreiving those datas, i wnt to produce a chart. ( bar chart for name Vs Salary)
 
Bartender
Posts: 4106
72
Hibernate Fedora Chrome
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Vanitha Prakash,

Please use code tags (UseCodeTags) when posting code in the forums. I've edited this for you.
 
Vanitha Prakash
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks vijitha kumara... hereafter i'll post my codes in code tags.
 
What a stench! Central nervous system shutting down. Save yourself tiny ad!
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!