| newsgroup for Jasper? [message #199888] |
Wed, 08 November 2006 16:11 |
Eclipse User |
|
|
|
Originally posted by: mailrun.mail333.com
Hi is there newsgroup for Jasperreports?
I try to use JasperReports but have some problems.
Fount sample code like this:
try{
Class.forName("JDBC DRIVER CLASS");
Connection connection = DriverManager.getConnection("JDBC URL", "USER",
"PASSWORD");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM ORDERS");
return new JRResultSetDataSource(resultSet);
} catch (Exception e) {
throw new RuntimeException(e); }
my code is like this
String lang="";
resultSet = statement.executeQuery(strQuery);
while(resultSet.next()){
lang = resultSet.getString("ART_NAME");
System.out.println( " " + lang + " " );
//resultset is not empty!
}
JRResultSetDataSource jr=null;
jr = new JRResultSetDataSource(resultSet); //HERE is the error
any help?
SQL Exception: ResultSet not open. Operation 'next' not permitted. Verify
that autocommit is OFF.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unkno wn
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(U nknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(U nknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkIfClosed(Unkn own
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkExecIfClosed( Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unkno wn
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at
net.sf.jasperreports.engine.JRResultSetDataSource.next(JRRes ultSetDataSource.java:92)
at
net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSo urce(JRFillDataset.java:834)
at
net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDa taset.java:752)
at
net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFil ler.java:1019)
at
net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport (JRVerticalFiller.java:126)
at
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFil ler.java:758)
at
net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFil ler.java:685)
at
net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFille r.java:89)
at
net.sf.jasperreports.engine.JasperFillManager.fillReport(Jas perFillManager.java:601)
at
com.feratel.pos.ui.swt.UserStatusSetup$2.widgetSelected(User StatusSetup.java:270)
at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe ner.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2758)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:809 )
at org.eclipse.jface.window.Window.open(Window.java:787)
at
com.feratel.pos.ui.actions.ConfigureUsersAction.run(Configur eUsersAction.java:38)
at
com.feratel.pos.ui.actions.ConfigureUsersActionDelegate.run( ConfigureUsersActionDelegate.java:31)
at
org.eclipse.ui.internal.PluginAction.runWithEvent(PluginActi on.java:246)
at
org.eclipse.ui.internal.WWinPluginAction.runWithEvent(WWinPl uginAction.java:223)
at
org.eclipse.jface.action.ActionContributionItem.handleWidget Selection(ActionContributionItem.java:538)
at
org.eclipse.jface.action.ActionContributionItem.access$2(Act ionContributionItem.java:488)
at
org.eclipse.jface.action.ActionContributionItem$5.handleEven t(ActionContributionItem.java:400)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3125)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :2758)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:1699)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1663)
at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:367)
at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:143)
at com.feratel.pos.ui.POSApplication.run(POSApplication.java:62 )
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(Pl atformActivator.java:226)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:376)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:336 )
at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
at org.eclipse.core.launcher.Main.run(Main.java:977)
at org.eclipse.core.launcher.Main.main(Main.java:952)
|
|
|
Powered by
FUDForum. Page generated in 0.02679 seconds
Home