invoking data from database using web service.

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 :

package examples;   
     
import java.util.*;   
import java.sql.*;   
import java.io.Serializable;

import java.io.*;
  
import java.util.Date.*;
import java.util.Map.*;
  
import org.jfree.data.category.DefaultCategoryDataset;   
import de.laures.cewolf.DatasetProduceException;   
import de.laures.cewolf.DatasetProducer;

public class EmployeesByDeptAndQtr implements DatasetProducer, Serializable 
{   
	   
        String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   
        String url = "jdbc:sqlserver://IPADDRESS;" +
         "databaseName=testdb";     
  
        String  username = "*******";   
        String pass = "*******";   
          
         public Object produceDataset(Map params) throws DatasetProduceException {   
                
            try 
            {   
                	Class.forName(driverName);
                	
            } 
            catch (ClassNotFoundException e1)
            {   
                System.out.println(e1.getMessage());   
            }   
               
            DefaultCategoryDataset ds = new DefaultCategoryDataset();   
            Connection con = null;   
                
            try
            {   
            	 System.out.println("database connected");
            	 con = DriverManager.getConnection(url, username, pass);
                
            }
            catch(SQLException e)
            {   
                System.out.println(e.getMessage());   
            }   
               
             Statement st = null;   
             ResultSet rs = null;   
                   
                try {   
                    st = con.createStatement();   
                    st.executeQuery("select name,sal from employee");   
                    rs = st.getResultSet();   
                       
                    while(rs.next()) 
                    {   
                        // JDBC columns starts at 1   
                        String name = rs.getString(1);   
                        int sal = rs.getInt(2);   
                        ds.setValue(sal, "test", name);   
                    }   
                    } catch (SQLException e) 
                    {   
                        e.printStackTrace();   
                    }   
                  return ds;   
          } 
  
          public String getProducerId()
          {   
                  return "CategoryDataProducer";   
          }       
  
          public boolean hasExpired(Map params, java.util.Date since) {   
                  return false;   
          }        
  }

jsp code :

web.xml

<web-app>   
  <servlet>   
    <servlet-name>CewolfServlet</servlet-name>   
    <servlet-class>de.laures.cewolf.CewolfRenderer</servlet-class>   
  
    <init-param>   
        <param-name>storage</param-name>   
        <param-value>de.laures.cewolf.storage.TransientSessionStorage</param-value>   
    </init-param>   
  
    <init-param>   
        <param-name>overliburl</param-name>   
        <param-value>etc/overlib.js</param-value>   
    </init-param>   
  
    <init-param>   
        <param-name>debug</param-name>   
        <param-value>true</param-value>   
    </init-param>   
    <load-on-startup>1</load-on-startup>   
  </servlet>   
  
  <servlet-mapping>   
    <servlet-name>CewolfServlet</servlet-name>   
    <url-pattern>/cewolf/*</url-pattern>   
  </servlet-mapping>   
  
  <session-config>   
    <session-timeout>1</session-timeout>   
  </session-config>   
  
  <mime-mapping>   
      <extension>css</extension>   
      <mime-type>text/css</mime-type>   
  </mime-mapping>   
  
  <welcome-file-list>   
    <welcome-file>   
      index.html   
    </welcome-file>   
    <welcome-file>   
      index.htm   
    </welcome-file>   
  </welcome-file-list>   
       
<Context>   
  
  <Resource name="jdbc/testdb"  
            type="javax.sql.DataSource"  
            username="*******"  
            password="*******"  
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"  
            url="jdbc:sqlserver:IPADDRESS/testdb"/>   
  
</Context>
  
</web-app>

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

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.

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)

Hi Vanitha Prakash,

Please use code tags (UseCodeTags) when posting code in the forums. I've edited this for you.

Thanks vijitha kumara... hereafter i'll post my codes in code tags.