Potter James

Greenhorn
+ Follow
since Aug 18, 2008
Merit badge: grant badges
For More
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
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Potter James

Originally posted by Herman Scheltinga:
hi Potter,

You are using the JDBC_ODBC bridge, it does not implement very much.
Here's some code:



cheers,
Herman




Can you say that where to insert that clearly..
hi

I tried to write a code that reads the data from excel sheet and writes into DB2 database.It worked perfectly .But if it has repetition fields, then also it inserts the data.So I used a primary key in the database to avoid repetition.Then I wrote a code which inserts data into database when there is no repetition of data.But if it contains repeatitive data, then it must rollback all the process in database or remove the data that is inserted through the program.I used save point and rollback for this action.
When i run the program it shows "java.lang.UnsupportedOperationException ".Can anyone help me out.
So my code is


<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body>
<%
Connection c;
Connection c1;
Statement stmnt;
Statement stmnt1;
Savepoint svpt1=null ;
int r=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc dbc:tt","",""); //excel DSN = tt
c1= DriverManager.getConnection("jdbc dbc :db2","",""); //DB2 DSN = db2

stmnt = c.createStatement();
stmnt1 = c1.createStatement();
ResultSet rs = stmnt.executeQuery("SELECT * FROM [Sheet1$]");
try
{
while(rs.next())
{
String a1=rs.getString("percen");
String a2=rs.getString("name");
svpt1 = c1.setSavepoint("first");
r= stmnt1.executeUpdate("INSERT INTO TAB1 VALUES('"+a1+"','"+a2+"');");//insert fields into database DB2
out.println(a1+" "+a2);

}
c1.commit();
response.sendRedirect("index.jsp");

}
catch(Exception e)
{
c1.rollback(svpt1);
}
}
catch(Exception e)
{
out.println(e);
}
%>
</body>
</html>


Manoj



[ October 22, 2008: Message edited by: Potter James ]

[ October 22, 2008: Message edited by: Potter James ]
[ October 22, 2008: Message edited by: Potter James ]
Thanks Martijn ,I finally came out of that error.I added a jar file called JCommon.jar to solve it .But now i landed in an another error

Exception in thread "main" java.lang.NoSuchMethodError: org.jfree.ui.RectangleInsets.<init>(DDDD)V
at org.jfree.chart.plot.Plot.<clinit>(Plot.java:192)
at org.jfree.chart.ChartFactory.createPieChart3D(ChartFactory.java:690)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluatePie3DChart(JRFillChart.java:2097)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluateChart(JRFillChart.java:1316)
at net.sf.jasperreports.engine.fill.JRFillChart.evaluateRenderer(JRFillChart.java:1237)
at net.sf.jasperreports.engine.fill.JRFillChart.resolveElement(JRFillChart.java:2998)
at net.sf.jasperreports.engine.fill.JRFillElement.resolveElement(JRFillElement.java:895)
at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1396)
at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveBoundElements(JRBaseFiller.java:1421)
at net.sf.jasperreports.engine.fill.JRBaseFiller.resolveReportBoundElements(JRBaseFiller.java:1431)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:907)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:120)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:889)
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:792)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at a.as.main(as.java:28)
When i searched in I came to know that this can be solved by adding jcommon.jar..But also this error is not going..
Is anyone having experience in solving this kind of situation.

[ September 15, 2008: Message edited by: Potter James ]
[ September 15, 2008: Message edited by: Potter James ]
Can you tell what the changes must i do.Also say me where it must be done in run...
sorry change the code to the foll one

import java.io.*;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperRunManager;
import java.sql.*;
import net.sf.jasperreports.view.JasperViewer;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.JasperReport;
import java.util.HashMap;

public class as
{
public static void main(String[] args)
{
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c= DriverManager.getConnection("jdbc dbc:access1","","");
System.out.println("starting");
JasperDesign jasperDesign = JRXmlLoader.load(new File("D:\\ALL IBM PROJECTS\\projects\\test\\WebContent\\WEB-INF\\test.jrxml"));
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null,c);
JasperViewer.viewReport(jasperPrint);
System.out.print("starting and now ending");
}
catch (Exception e)
{
String connectMsg = "Could not create the report "+ e.getMessage() + " " + e.getLocalizedMessage();
System.out.println(connectMsg);
}
}
}
Iam getting this type of error when i run the froll code in ecllipse.But this is not happening in case netbeans.Also i included the jar files.

import java.io.*;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperRunManager;
import java.sql.*;
import net.sf.jasperreports.view.JasperViewer;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.JasperReport;
import java.util.HashMap;

public class as
{
public static void main(String[] args)
{

try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c= DriverManager.getConnection("jdbc dbc:access1","","");
System.out.println("starting");
JasperCompileManager.compileReportToFile("D:\\ALL IBM PROJECTS\\projects\\test\\WebContent\\WEB-INF\\test.jrxml");
//JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null,c);

JasperFillManager.fillReportToFile("D:\\ALL IBM PROJECTS\\projects\\test\\WebContent\\WEB-INF\\test.jasper",new HashMap(),c);
JasperViewer.viewReport(jasperPrint);
System.out.print("starting and now ending");
}
catch (Exception e)
{
String connectMsg = "Could not create the report "+ e.getMessage() + " " + e.getLocalizedMessage();
System.out.println(connectMsg);
}

}
}
And the error

Exception in thread "main" java.lang.NoClassDefFoundError: org/jfree/util/PublicCloneable
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.visitChart(JRFillObjectFactory.java:719)
at net.sf.jasperreports.engine.base.JRBaseChart.visit(JRBaseChart.java:610)
at net.sf.jasperreports.engine.JRAbstractObjectFactory.getVisitResult(JRAbstractObjectFactory.java:91)
at net.sf.jasperreports.engine.fill.JRFillElementGroup.<init>(JRFillElementGroup.java:86)
at net.sf.jasperreports.engine.fill.JRFillElementContainer.<init>(JRFillElementContainer.java:91)
at net.sf.jasperreports.engine.fill.JRFillBand.<init>(JRFillBand.java:87)
at net.sf.jasperreports.engine.fill.JRFillObjectFactory.getBand(JRFillObjectFactory.java:522)
at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:528)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:77)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:59)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147)
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:188)
at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:94)
at a.as.main(as.java:47)

Can anyone help me out..I am in great need of it.
I have executed the code finally..Thanks a lot for your tips
Ok.Now just tell me where to put the folder JFREECHART in the java installation directory.I have put that in bin.Also tried to zip it in "src".It is working if i put the jfree folder and my program in bin.But my aim is to run the coding in a JSP page.It is not recognizing the jfree package in "import" command.
Can anyone tell me the way to recognise the JFREECHART to my java compiler step by step.I tried the way of setting class path.It did not work.So can someone tell a clear idea..