Register / Login

Win a copy of Resilient Oracle PL/SQL: Building Resilient Database Solutions for Continuous Operation this week in the JDBC and Relational Databases forum!

Ayoma Wijethunga

Ranch Hand

+ Follow

40 Posts 1 Threads 0 Cows

since Mar 07, 2010

Ayoma likes ...

IntelliJ IDE

Firefox Browser

Tomcat Server

Merit badge: grant badges

For More

Sri Lanka

http://www.ayomaonline.com

Cows and Likes

Cows

Total received

0

In last 30 days

0

Total given

0

Likes

Total received

0

Received in last 30 days

0

Total given

0

Given in last 30 days

0

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Ayoma Wijethunga

Call method from another class

Dustin Schreader wrote:oh oops thanks for that. But The error still persists.
GuiDropOutStack.java:99: illegal character: \160 DropOutStack myStack = new DropOutStack(); ^

"\160" is the Unicode representation of "non-breaking space"

My suggestion is to simply select that entire line, remove it and type it without copying and pasting. You might have pasted a \160 from some html page or a PDF to your source code.

Hope this helps.

P.S.. - Great.. Seems like it was solved while i was typing..

12 years ago

Refresh chart in jsp according to MySQL database

Yeh.. Devaka is correct.. There is no point of trying to implement AJAX if you are almost new. Try some articles. Most of all do some practice. Anyway this is how you should implement the code I added you few days before.

Code for http://localhost/Employee/chartex.jsp

<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="org.jfree.chart.ChartFactory"%>
<%@ page import="org.jfree.chart.ChartUtilities"%>
<%@ page import="org.jfree.chart.JFreeChart"%>
<%@ page import="org.jfree.chart.plot.PlotOrientation"%>
<%@ page import="org.jfree.data.*"%>
<%@ page import="org.jfree.data.jdbc.JDBCCategoryDataset"%>
<%@ page import="org.jfree.chart.renderer.category.CategoryItemRenderer"%>
<%@ page import="org.jfree.chart.plot.CategoryPlot"%>
<%@ page import="org.jfree.chart.plot.PlotOrientation"%>
<%@ page import="java.awt.Color"%>
<%
String query = "SELECT * from chart";
JDBCCategoryDataset dataset = new JDBCCategoryDataset(
"jdbc:mysql://localhost:3306/s2sgateway",
"com.mysql.jdbc.Driver", "root", "meet**");
dataset.executeQuery(query);
JFreeChart chart = ChartFactory.createBarChart3D("Stock Update",
"stock", "price", dataset,
PlotOrientation.VERTICAL, true, true, false);
CategoryPlot plot = chart.getCategoryPlot();
CategoryItemRenderer renderer = plot.getRenderer();
renderer.setSeriesPaint(0, Color.green);
try {
ChartUtilities
.saveChartAsJPEG(
new File(
"c:\\s2s worksspace\\s2sgateway\\WebContent\\chart.jpeg"),
chart, 500, 450);
} catch (IOException e) {
System.out.println("Problem in creating chart.");
}
%>

Code for http://localhost/Employee/display.html

My advice - "Do NOT use this code unless you really understand it".. Go through tutorials and learn what is behind all this. Hope this helps.

Regards.

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

Ah ok... you asked for 30second auto refresh, didn't you? I send you the code for that. In your new code, you are not using AJAX part at all. It's just there and that trick won't be effective unless you put JSP and HTML in separate files. That's why we don't use JSP to access data base or for business logic.

Anyway let me just make it easy for you. Use this HTML instead of what you are using now. So you'll get 30second auto reload.

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

Anyway, ignore that if code is working as same as you expected, with 30second auto refresh.

Regards...

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

Meet Garvalia wrote:Thank you ayoma once again

You are welcome Meet.. As I can see, one more change is required to make this work correctly. Your browser error log might be showing some errors at the moment.

Are you writing the AJAX part in JSP itself? Or do you have a JSP file and a HTML file separately for AJAX request.

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

Yes. As Devaka mentioned, it is not clear what to say as a reply.

Anyway in this kind of a project you'll surely have to go for a client side technology. If you are more familiar with JavaScript, then no problem go ahead with JavaScript+ AJAX. Or else you can use JavaFX or similar technology. JSP seems to be a must, as you have already selected JSP as your server side language. Then MySQL really couples with Java and that sounds to be a good choice.

So your choice "Ajax+java script+My sql+java server pages" is a good one. Finally checkout Netbeans IDE. I'm a Netbeans fan at the moment

Regards.

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

I think this topic is in the wrong forum (" JavaRanch » Forums » Products » Other Open Source Projects ")

13 years ago

Other Open Source Projects

Refresh chart in jsp according to MySQL database

Devaka Cooray wrote:
Please note that accessing the database from a JSP is a really bad practice.

Yeh that's why I asked if he is going to host this in an actual environment.. Also absolute path like "c:\s2s worksspace\s2sgateway\WebContent\chart.jpg" is not a good idea..

13 years ago

Send SMS from my website

Anyhow you'll have to pay for a SMS gateway, to make a universal SMS messenger. It'll cost you per SMS.

Some web sites provide free SMS services to limited number of service providers using techniques like email2sms. Those are not universal as told before.

13 years ago

when the learning curve ends

Yeh true! Foundation is the most important thing. Once you have a strong foundation you can build the rest so quickly.

grab what you need for a given project and ignore the rest.

100% agreed. I have done this in practice. Few real life projects will surely make you learn everything you really need.

Regards and good luck!

13 years ago

Refresh chart in jsp according to MySQL database

OK.. Are you going to host this application is a actual server. Anyway I'll stick with this code and try to give you a solution.

So, you are saving the generated chart by using "ChartUtilities.saveChartAsJPEG();" method, and displaying the saved image in a HTML file.

In that case, what you can do is simply making few AJAX requests from time to time. Here is an example with JQuery

Hope this helps.

Regards.

13 years ago

Other Open Source Projects

Fetching information from database in jsp

fredrick esedo wrote:Is there any other dependecy jar file i need to install so that this error below will stop occuring

No.. This has nothing to do with dependencies. The error is generated from here:

So do a print as mentioned below and check weather you have produced the name correctly after all those String manipulations.

Regards,

13 years ago

Writing JSP from scratch

Aman Goel wrote:Hi Guys. People directly write JSP pages. That's the advantage of JSP over servlet.

Mainly, in a servlet you write the Java code and embedded some HTML syntax in it. But with JSP you write HTML and embedded some Java code in it. Well, that's in simple language.

So in MVC, JSPs are used (and should be used) in constructing the view and Servlets are used as controllers.

So my idea is that discussing advantage of JSP over servlet is not possible because both are used in two different fields.

13 years ago

* Welcome Tariq Ahmed, Dan Orlando, John C. Bland II & Joel Hooks

John C. Bland Ii wrote:Thanks folks! I look forward to some geek speak on the threads. ;-)

Sounds interesting! I'm here reading you thoughts and ramblings.

Regards

13 years ago

* Welcome Tariq Ahmed, Dan Orlando, John C. Bland II & Joel Hooks

Gopinath Karyadath wrote:
Hope JavaRanch will start JavaFX forum very soon.

Already there - JavaFX Forum

13 years ago