[jCharts-developers] problem in accesing dynamic data and no image is displaying on the browser

[pradeep k. <pra...@ya...>]

i want to create bar chart fom a database table 
  i written the below code but it is not displaying any image plz help me very urgent
   
   
   
   
   
  /***********************************************************************************************
 * File Info: $Id: BarChartServlet.java,v 1.5 2003/04/19 01:41:27 nathaniel_auvil Exp $
 * Copyright (C) 2002
 * Author: Nathaniel G. Auvil
 * Contributor(s):
 *
 * Copyright 2002 (C) Nathaniel G. Auvil. All Rights Reserved.
 *
 * Redistribution and use of this software and associated documentation ("Software"), with or
 * without modification, are permitted provided that the following conditions are met:
 *
 * 1. Redistributions of source code must retain copyright statements and notices.
 *  Redistributions must also contain a copy of this document.
 *
 * 2. Redistributions in binary form must reproduce the above copyright notice, this list of
 *  conditions and the following disclaimer in the documentation and/or other materials
 *  provided with the distribution.
 *
 * 3. The name "jCharts" or "Nathaniel G. Auvil" must not be used to endorse or promote
 *  products derived from this Software without prior written permission of Nathaniel G.
 *  Auvil.  For written permission, please contact nat...@us...
 *
 * 4. Products derived from this Software may not be called "jCharts" nor may "jCharts" appear
 *  in their names without prior written permission of Nathaniel G. Auvil. jCharts is a
 *  registered trademark of Nathaniel G. Auvil.
 *
 * 5. Due credit should be given to the jCharts Project (http://jcharts.sourceforge.net/).
 *
 * THIS SOFTWARE IS PROVIDED BY Nathaniel G. Auvil AND CONTRIBUTORS ``AS IS'' AND ANY
 * EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL
 * jCharts OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
 * IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE
 ************************************************************************************************/
  package com.objectplanet.chart.testing;
  
import org.jCharts.axisChart.AxisChart;
import org.jCharts.axisChart.customRenderers.axisValue.renderers.ValueLabelPosition;
import org.jCharts.axisChart.customRenderers.axisValue.renderers.ValueLabelRenderer;
import org.jCharts.chartData.AxisChartDataSet;
import org.jCharts.chartData.DataSeries;
import org.jCharts.chartData.interfaces.IAxisDataSeries;
import org.jCharts.encoders.ServletEncoderHelper;
import org.jCharts.properties.*;
import org.jCharts.properties.util.ChartFont;
import org.jCharts.types.ChartType;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.awt.*;
import java.io.IOException;
import java.io.*;
import java.util.*;
  public class barcheck extends HttpServlet {
    //---all of my charts serviced by this Servlet will have the same properties.
    private BarChartProperties barChartProperties;
    
    //---all of my charts serviced by this Servlet will have the same properties.
    protected LegendProperties legendProperties;
    protected AxisProperties axisProperties;
    protected ChartProperties chartProperties;
    
    protected int width = 550;
    protected int height = 360;
    
    
    /**********************************************************************************************
     *
     **********************************************************************************************/
    public void init() {
        this.legendProperties = new LegendProperties();
        this.chartProperties = new ChartProperties();
        this.axisProperties = new AxisProperties( false );
        ChartFont axisScaleFont = new ChartFont( new Font( "Georgia Negreta cursiva", Font.PLAIN, 13 ), Color.black );
        axisProperties.getXAxisProperties().setScaleChartFont( axisScaleFont );
        axisProperties.getYAxisProperties().setScaleChartFont( axisScaleFont );
        
        ChartFont axisTitleFont = new ChartFont( new Font( "Arial Narrow", Font.PLAIN, 14 ), Color.black );
        axisProperties.getXAxisProperties().setTitleChartFont( axisTitleFont );
        axisProperties.getYAxisProperties().setTitleChartFont( axisTitleFont );
        
        DataAxisProperties dataAxisProperties = (DataAxisProperties) axisProperties.getYAxisProperties();
        
        try {
            dataAxisProperties.setUserDefinedScale( -3000, 3000 );
        } catch( PropertyException propertyException ) {
            propertyException.printStackTrace();
        }
        
        dataAxisProperties.setRoundToNearest( 2 );
        
        ChartFont titleFont = new ChartFont( new Font( "Georgia Negreta cursiva", Font.PLAIN, 14 ), Color.black );
        this.chartProperties.setTitleFont( titleFont );
        
        this.barChartProperties = new BarChartProperties();
        
        ValueLabelRenderer valueLabelRenderer = new ValueLabelRenderer( false, false, true, -1 );
        valueLabelRenderer.setValueLabelPosition( ValueLabelPosition.ON_TOP );
        valueLabelRenderer.useVerticalLabels( false );
        barChartProperties.addPostRenderEventListener( valueLabelRenderer );
        
    }
    
    
    /**********************************************************************************************
     *
     **********************************************************************************************/
    public void service( HttpServletRequest req, HttpServletResponse httpServletResponse ) throws ServletException, IOException {
        try {
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            Connection con;
            con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:BSL","scott","tiger");
            System.out.println(con);
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select * from account");
            ResultSetMetaData rmd=rs.getMetaData();
            String xAxisTitle = rmd.getColumnLabel(1);
            String yAxisTitle = rmd.getColumnLabel(2);
            
            
            String[] xAxisLabels=new String[20];
            PrintWriter out=httpServletResponse.getWriter();
            int i=0;
           double[][] data = new double[20][20];
            int j=0;
            while(rs.next())
            {       
                 xAxisLabels[i]= rs.getString(2); 
                 data[i][0]=rs.getDouble(1) ;
                 i++;
            }   
            String title = "Micro$oft At Work";
            IAxisDataSeries dataSeries = new DataSeries( xAxisLabels, xAxisTitle, yAxisTitle, title );
            
            
            String[] legendLabels = {"Bugs"};
            Paint[] paints = new Paint[]{Color.yellow};
            dataSeries.addIAxisPlotDataSet( new AxisChartDataSet( data, legendLabels, paints, ChartType.BAR, this.barChartProperties ) );
            
            AxisChart axisChart = new AxisChart( dataSeries, this.chartProperties, this.axisProperties, this.legendProperties, this.width, this.height );
            ServletEncoderHelper.encodeJPEG13( axisChart, 1.0f, httpServletResponse );
        } catch( Throwable throwable ) {
            //HACK do your error handling here...
            throwable.printStackTrace();
        }
    }
}









 		
---------------------------------
 All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.