Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

invoking data from database using web service.

 
Vanitha Prakash
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
 
Mike Zal
Ranch Hand
Posts: 144
Fedora Java Oracle
  • 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)
 
Vijitha Kumara
Bartender
Pie
Posts: 3918
10
Chrome Fedora Hibernate
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic