Vazzdoin Rocko

Hi,
I am working on a Swings application in which i've created a static Container which is used to enter some form fields. When i submit on this form the control is sent back to login frame which is aseparate
container. But the form Container doesn't go invisble. i've used the following code to make it invisble :
MainFrame.container.setvisible(false);
but it is not going invisible and remains intact in the background. Please suggest me how can i make it invisible.
Thanks.

Thanks Mr. Martin.
My problem has been resolved. i already knew that Binary is a keyword but never thought that it would affect column names too.. i thought it's scope is upto Table names only. Well , it's not a problme any more as i've renamed the column and my code is working fine now. Thank you very much for the guidance

Hi,
I'm trying to insert an .exe file into mysql blob field in the database. I;ve tried to both ways i.e LOAD_FILE method and FileInputStream method at the local and remote Database server,
but it is consistently giving an error.The stacktrace of the error is : :

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'binary) values('abc','19541a2746e08a6b8f5145bdbaa23e45','http:jadhjkhdf/dasdas',' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.Util.getInstance(Util.java:384)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
at temp1.copyFile.main(copyFile.java:45)

The code i'm using is given below :
Connection conn = cnnctr.sqlConn(); PreparedStatement psmnt = null; try { FileInputStream fis; String binpath = "/root/Desktop/binary2.exe"; File binary = new File(binpath); String insrt_qry = "insert into binaries(folder_id, md5, url_name, bin_name, binary) values(?,?,?,?,?)"; // String insrt_qry = "insert into binaries(folder_id, md5, url_name, bin_name, binary) values('abc','19541a2746e08a6b8f5145bdbaa23e45','http:jadhjkhdf/dasdas','bin2',LOADFILE('/root/Desktop/binary2.exe'))"; psmnt = conn.prepareStatement("insert into binaries(folder_id, md5, url_name, bin_name, binary) " + "values(?,?,?,?,?)"); // System.out.println(insrt_qry); // Statement st = conn.createStatement(); psmnt = conn.prepareStatement(insrt_qry); psmnt.setString(1, "abc"); psmnt.setString(2, "19541a2746e08a6b8f5145bdbaa23e45"); psmnt.setString(3, "http:jadhjkhdf/dasdas"); psmnt.setString(4, "bin2"); fis = new FileInputStream(binary); psmnt.setBinaryStream(5, (InputStream) fis, (int) (binary.length())); System.out.println("insertion"); int s = psmnt.executeUpdate(); if (s > 0) { System.out.println("Uploaded successfully !"); } else { System.out.println("unsucessfull to upload image."); } } catch(Exception e) { e.printStackTrace(); } finally { conn.close(); psmnt.close(); }

Please help me in resolving this issue. I guess my code is all correct and there is some ado with the Mysql version.
The current mysql version shown by my RHEL machin is :

mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0

Sorry for the use of abbreviations. And yeah, i was also thinking that JSP's not gonna help. I must try with applets. Thanks for the reply.

Hi.
I want to ping some IP from my webpage and want to display the ping result in command prompt on the client side. i.e. when a client would b accessing my jsp page from any location,the DOS prompt should pop up on his screen and should start pinging the given IP which would be provided as parameter from the previous JSP page.

The range axis is showing a number count with respect to the dates on the domain axis. And i don't understand what do you mean by "Is plot a category plot?" Please brief it a bit so that i can answer it.

Okay Here is the code

JAVA CODE

package graph; import org.apache.batik.svggen.font.Font; import org.jfree.data.*; import java.awt.Color; import java.awt.GradientPaint; import java.io.*; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.*; import java.util.Date; import de.laures.cewolf.*; import java.io.Serializable; import org.jfree.chart.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; import org.jfree.chart.labels.StandardCategoryToolTipGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.IntervalMarker; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.data.general.*; import org.jfree.data.category.*; import org.jfree.ui.Layer; import org.jfree.ui.RectangleAnchor; import org.jfree.ui.TextAnchor; import de.laures.cewolf.cpp.SeriesPaintProcessor; import javax.servlet.*; import com.sun.org.apache.bcel.internal.generic.DADD; import java.sql.*; import javax.sql.*; import javax.naming.*; import java.io.File; import org.w3c.dom.*; //import graph.DateBean; import de.laures.cewolf.*; public class Dbdataprovider implements DatasetProducer,Serializable,ChartPostProcessor { private DataSource dbsrc = null; String stdate; String enddate; String node; int count42=0; String date=null; String Errormsg="No Data Avaiable"; public void setStdate( String value ) { stdate = value; } public void setEnddate( String value ) { enddate = value; } public void setnode( String value ) { node = value; } public String getStdate() { return stdate; } public String getEnddate() { return enddate; } public String getnode() { return node; } public void setDatasource(DataSource indb) { dbsrc = indb; } public String getProducerId() { return "graph.dbdata"; } public Object produceDataset(Map arg0)throws DatasetProduceException { DefaultCategoryDataset dataset = new DefaultCategoryDataset(); Connection conn = null; PreparedStatement salesquery = null; ResultSet res,rs,rs1 = null; try { conn = dbsrc.getConnection(); Statement st = conn.createStatement(); if(node.equals("all")) { String qry = "Select node_id from node"; rs = st.executeQuery(qry); while(rs.next()) { String node = rs.getString(1); String node_name = "DCH_"+node; String query="select count(*),date(timestamp) from binary_log where node_id="+node+" and date(timestamp) between '"+stdate+"' and '"+enddate+"' group by date(timestamp)"; Statement st2 = conn.createStatement(); rs1 = st2.executeQuery(query); while(rs1.next()) { count42 = rs1.getInt(1); date = rs1.getString(2); dataset.addValue(count42,node_name,date); } } } else { String qry1 = "select count(*),date(timestamp) from binary_log where node_id="+node+" and date(timestamp) between '"+stdate+"' and '"+enddate+"' group by date(timestamp)"; res = st.executeQuery(qry1); while(res.next()) { dataset.addValue(res.getInt(1), "BinaryData",res.getString(2)); } } } catch(Exception e) { e.printStackTrace(); } return dataset; } public boolean hasExpired(Map arg0, Date arg1) { return false; } public void processChart (Object chart, Map params) { CategoryPlot plot = (CategoryPlot) ((JFreeChart) chart).getPlot(); CategoryAxis xAxis = (CategoryAxis)plot.getDomainAxis(); xAxis.setCategoryLabelPositions(CategoryLabelPositions.UP_45); plot.setNoDataMessage(Errormsg); plot.setDomainGridlinePaint (Color.white); plot.setDomainGridlinesVisible (true); plot.setRangeGridlinePaint (Color.white); NumberAxis numberaxis = (NumberAxis)plot.getRangeAxis (); numberaxis.setStandardTickUnits (NumberAxis.createIntegerTickUnits ()); BarRenderer barrenderer = (BarRenderer) plot.getRenderer (); barrenderer.setDrawBarOutline (false); /* setting the bar width*/ barrenderer.setMaximumBarWidth(0.01); GradientPaint gradientpaint = new GradientPaint (0.0F, 0.0F, Color.blue,0.0F, 0.0F, new Color (0, 0, 64)); GradientPaint gradientpaint1 = new GradientPaint (0.0F, 0.0F, Color.green, 0.0F, 0.0F, new Color (0, 64, 0)); GradientPaint gradientpaint2 = new GradientPaint (0.0F, 0.0F, Color.red, 0.0F, 0.0F, new Color (64, 0, 0)); barrenderer.setSeriesPaint (0, gradientpaint); barrenderer.setSeriesPaint (1, gradientpaint1); barrenderer.setSeriesPaint (2, gradientpaint2); IntervalMarker intervalmarker = new IntervalMarker (4.5D,7.5D); intervalmarker .setLabelAnchor (RectangleAnchor.LEFT); intervalmarker .setLabelTextAnchor (TextAnchor.CENTER_LEFT); intervalmarker .setPaint (new Color (222, 222, 255, 128)); plot.addRangeMarker (intervalmarker, Layer.BACKGROUND); Color[] colors = new Color[] { Color.BLUE, Color.magenta, Color.YELLOW, Color.GREEN, Color.GRAY }; for (int i = 0; i < 4; i++) { // String colorStr = (String) params.get(String.valueOf(i)); plot.getRenderer().setSeriesPaint(i, colors[i]); } } }

JSP PAGE

<jsp:useBean id="dbdata" class="graph.Dbdataprovider" /> <jsp:setProperty name="dbdata" property="stdate" value="<%= date1%>"/> <jsp:setProperty name="dbdata" property="enddate" value="<%= date2%>" /> <jsp:setProperty name="dbdata" property="node" value="<%= n %>" /> <jsp:setProperty name="dbdata" property="datasource" value="${testdb}" /> <cewolf:chart id="dbchart" type="line" title="DCH" xaxislabel="Date" yaxislabel="Count" > <cewolf:data> <cewolf:producer id="dbdata" usecache="false"/> </cewolf:data> <cewolf:chartpostprocessor id="dbdata"></cewolf:chartpostprocessor> </cewolf:chart> <cewolf:img chartid="dbchart" renderer="cewolf" width="800" height="500" />

I think that should make you more clear where the problem is... Thanks in advance.

Exactly.. the problem is the same.I'm unable to get the line graph :-(

Here it is....

Well it's an error message in the image. can't copy it. And i tried to put the screenshot and previewed it before posting it but the screenshot is shown kind of broken and not opening that's why
i put the URL. anyways i'm trying to put the screenshot let's see if it opens.

Wohh...Thanks for the advice, here i was on mistake. I had put the cache="true". now changed it to "false" and the cache problem is over now. But now i'm again not able to draw line graph again though
i'm pretty much able to draw bar graph but when i try to plot line graph it comes up with the error image instead of graph image as below
screenshot
May be some problem with the de.laures.cewolf Library ?? please help.

Well the problem has been resolved. Now the line graph is getting plotted but when i try to plot graph with some other values/parametres(date,to-from) then it again shows the graph with the previously provided parametres only... unless i logout and login again and come to the graph page and provide new values. I'm unable to understand where the problem is.

Then do it requires to type cast first.. if yes then how can i do it ?? i can also post my Java code if you require to review it., just ask.
Thanks for the reply.

Hello,
I'm trying to plot a line graph using cewolf library in my JSP page. But i'm getting the error and the stack trace is mentioned below in the end.
The datasource is being fetched from a java file where all the processing is being done.
The bar graph is plotted when i use the same code with the following tag
<cewolf:chart id="dbchart" type="verticalbar3d" title="DCH" xaxislabel="Date" yaxislabel="Count" >
But this code gives error whenever i replace "verticalbar3d" with the "line" in the 'type' parameter. i.e.
<cewolf:chart id="dbchart" type="line" title="DCH" xaxislabel="Date" yaxislabel="Count" >

i can't figure out where the problem is.
The below written is the JSP code i'm using.

<jsp:useBean id="dbdata" class="graph.Dbdataprovider" /> <jsp:setProperty name="dbdata" property="stdate" value="<%= date1%>"/> <jsp:setProperty name="dbdata" property="enddate" value="<%= date2%>" /> <jsp:setProperty name="dbdata" property="node" value="<%= n %>" /> <jsp:setProperty name="dbdata" property="datasource" value="${testdb}" /> <cewolf:chart id="dbchart" type="line" title="DCH" xaxislabel="Date" yaxislabel="Count" > <cewolf:data> <cewolf:producer id="dbdata" usecache="false"/> </cewolf:data> <cewolf:chartpostprocessor id="dbdata"></cewolf:chartpostprocessor> </cewolf:chart> <cewolf:img chartid="dbchart" renderer="cewolf" width="800" height="500"/>

Whenever i execute this code , no line graph comes up and the graph area is replaced by an error image showing text "de.laures.cewolf.PreProcessingException raised"

PRINT STACK :

SEVERE: CewolfServlet: java.lang.ClassCastException raised by post processor 'graph.Dbdataprovider@15e2075'.
Post processing of this post processor has been ignored.
de.laures.cewolf.PostProcessingException: java.lang.ClassCastException raised by post processor 'graph.Dbdataprovider@15e2075'.
Post processing of this post processor has been ignored.
at de.laures.cewolf.taglib.AbstractChartDefinition.getChart(AbstractChartDefinition.java:161)
at de.laures.cewolf.taglib.ChartImageDefinition.ensureRendered(ChartImageDefinition.java:137)
at de.laures.cewolf.taglib.ChartImageDefinition.getSize(ChartImageDefinition.java:146)
at de.laures.cewolf.CewolfRenderer.doGet(CewolfRenderer.java:153)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

Hello,
i am working on a JSP,Servlet based web site and i want some chart library through which i can show some live monitoring information,from the values fetched from databas, using line graphs. Please help me by suggesting some Linux based Java(JSP,Servlet) graph library( Paid/Free ) which should be agile,easy to use and with as less dependencies as possible.
Thanks.