senthilm

for the first case , sometimes it gives , org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failedorg.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failedCaused by: org.hibernate.TransactionException: JDBC rollback failed at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170) at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:581) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722) at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)

Hi all, I am using jasperserver 3.5.0 with oracle 9i. Here i want to create a jasper report , i used the foll steps, Report Wizard - Naming ---> Report Wizard - Main JRXML --> Report Wizard - Locate Data Source-- and finish When i give finish it gives following exception, 17:29:31,187 ERROR AbstractFlushingEventListener,http-8080-3:301 - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResou rce] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate(HibernateTemplate.java:806) at org.springframework.orm.hibernate3.HibernateTemplate.execute(Hibernat......... 17:29:31,515 ERROR HibernateDaoImpl,http-8080-3:82 - Hibernate DataAccessException org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCExcep tion: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource] Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResou rce] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja But it allows plaint jrxml deployment , but here when i click the report after creating report it gives, org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem] org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem] Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) How can i solve this? Pls advise me.. Regards, Senthilm

Hi all, I already built my Jasperserver for oracle using jasperserver source build 3.5.0. After doing some others things, when i doing this build again i am facing the following issue, I have all the lib including ojdbc-14.jar. upto the foll cmds , everything fine, js-ant clean-config js-ant gen-config js-ant add-jdbc-driver js-ant build-cewhen i give js-ant build-js-ddl-ce, it gives the folling error, ................ ................. [exec] [ERROR] BUILD ERROR [exec] [iNFO] ------------------------------------------------------------- ----------- [exec] [iNFO] An Ant BuildException has occured: Class Not Found: JDBC driv er oracle.jdbc.driver.OracleDriver could not be loaded [exec] [exec] [iNFO] ------------------------------------------------------------- ----------- [exec] [iNFO] For more information, run Maven with the -e switch [exec] [iNFO] ------------------------------------------------------------- ----------- [exec] [iNFO] Total time: 52 seconds [exec] [iNFO] Finished at: Thu Mar 11 10:22:46 IST 2010 [exec] [iNFO] Final Memory: 16M/30M [exec] [iNFO] ------------------------------------------------------------- ----------- BUILD FAILED D:\JASPER\jasperserver-3.5.0-src\jasperserver\buildomatic\conf_source\db \defaultTargets.xml:154: The following error occurred while executing this line: D:\JASPER\jasperserver-3.5.0-src\jasperserver\buildomatic\dev.xml:11: ex ec returned: 1 What would be the problem? Pls advise me? Thanks & Regards, Senthilkumar.M

Yes. We can do this(jasperserver with oracle 9i) using jasperserver source build. For further details pls Refer - JasperServer-Source-Build-Guide. Regards, Senthilm

Yes teodor, It's working now.. thanks. But one thing regarding this. When i use Jasperviewer report from in API. It contains "Save" button which gives us to save to the format hwatever we wish(jasperprint,pdf,excel...). But here it doesn't contain "Save" button report. Is it becaz of written stream in applet? or is there any way to ahieve this "save" button? Thanks and Regards, senthilm Post Edited by senthilm at 09/08/2009 07:23

ok thanks teodor. i do that from scratch. i used absolute URLs, because it cannot find the Applet class(Which is in WEB-INF/classes) Regards, senthilm

and my EmbeddedViewerApp15 is.. public class EmbeddedViewerApp15 extends javax.swing.JApplet { private JasperPrint jasperPrint = null; public EmbeddedViewerApp15() { initComponents(); } public void init() { String url = getParameter("REPORT_URL"); System.out.println("==============url ================= "+url); if (url != null) { try { //JOptionPane.showMessageDialog(this, url); //JOptionPane.showMessageDialog(this, "Hi"+getCodeBase()); //JOptionPane.showMessageDialog(this, "URL : "+new URL(getCodeBase(), url)); jasperPrint = (JasperPrint)JRLoader.loadObject(new URL(getCodeBase(), url)); if (jasperPrint != null) { JRViewerSimple15 viewer = new JRViewerSimple15(jasperPrint); this.pnlMain.add(viewer, BorderLayout.CENTER); } JOptionPane.showMessageDialog(this, "Hi"); } catch (Exception e) { StringWriter swriter = new StringWriter(); PrintWriter pwriter = new PrintWriter(swriter); e.printStackTrace(pwriter); JOptionPane.showMessageDialog(this, swriter.toString()); } } else { JOptionPane.showMessageDialog(this, "Source URL not specified"); } } private void initComponents() {//GEN-BEGIN:initComponents pnlMain = new javax.swing.JPanel(); pnlMain.setLayout(new java.awt.BorderLayout()); getContentPane().add(pnlMain, java.awt.BorderLayout.CENTER); }//GEN-END:initComponents // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JPanel pnlMain; // End of variables declaration//GEN-END:variables }

Thank you Teodor, Yes, that is valid URL (ie http://localhost/PrintReport.do ) In PrintReportAction..\ public class PrintReportAction extends Action { public ActionForward execute(ActionMapping mapping, ActionForm actionForm, HttpServletRequest request, HttpServletResponse response) throws Exception { WSClient client = new WSClient( request.getSession().getServletContext().getInitParameter("jasperserver_repository_ws_url"), "jasperadmin", "jasperadmin"); java.util.Map hashMap = new java.util.HashMap(); JasperPrint jasperPrint = null; try { hashMap.put( "uri", "/reports/myReports/Bar_chart_details" ); jasperPrint = client.runReport( "/reports/myReports/Bar_chart_details", hashMap ); } catch (JRException e) { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head>"); out.println("<title>JasperReports - Web Application Sample</title>"); out.println("<link rel=\"stylesheet\" type=\"text/css\" href=\"../stylesheet.css\" title=\"Style\">"); out.println("</head>"); out.println("<body bgcolor=\"white\">"); out.println("<span class=\"bnew\">JasperReports encountered this error :</span>"); out.println("<pre>"); e.printStackTrace(out); out.println("</pre>"); out.println("</body>"); out.println("</html>"); return null; } if (jasperPrint != null) { response.setContentType("application/octet-stream"); ServletOutputStream ouputStream = response.getOutputStream(); ObjectOutputStream oos = new ObjectOutputStream(ouputStream); oos.writeObject(jasperPrint); oos.flush(); oos.close(); ouputStream.flush(); ouputStream.close(); } else { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head>"); out.println("<title>JasperReports - Web Application Sample</title>"); out.println("<link rel=\"stylesheet\" type=\"text/css\" href=\"../stylesheet.css\" title=\"Style\">"); out.println("</head>"); out.println("<body bgcolor=\"white\">"); out.println("<span class=\"bold\">Empty response.</span>"); out.println("</body>"); out.println("</html>"); } return null; } } above is the code in PrintReportAction. and my jsp is <APPLET CODE = "EmbeddedViewerApp15.class" CODEBASE = "http://localhost/images/" WIDTH = "600" HEIGHT = "400"> <PARAM NAME = ARCHIVE VALUE = "http://localhost/images/jasperreports-3.5.2-applet.jar,http://localhost/images/commons-logging-1.0.2.jar,http://localhost/images/commons-collections-3.2.jar" > <PARAM NAME = CODEBASE VALUE = "http://localhost" > <PARAM NAME="type" VALUE="application/x-java-applet;version=1.2.2"> <PARAM NAME="scriptable" VALUE="false"> <PARAM NAME = "REPORT_URL" VALUE ="/PrintReport.do"> </APPLET> Thanks in advance, Senthilm

Hi all, I am using jasperserver 3.5.2 CE. and using reports which deployed in jasperserver from my struts application. When i use jasperviewer it doen't open in client browser. it open in server machine(JBoss + struts). So i decided to use sample webapp application in jasper reports. (using from Applet). When i use it in my application i am getting the following error. /uploads/projects/jasperreports/image/error.bmp It would be great if anybody help me to solve this problem. Regards, Senthilm Post Edited by senthilm at 08/19/2009 05:20

Hi all, I am trying to use Jasperserver Webservice API to run reports. and i want to make it secured. so i am trying to use "TrustedIpAddress" in applicationContext-security.xml. But i don't know what are all the steps involved in configuring this to work. Can anybody help me solve this.. Thanks & Regards, senthilm

Hi all, I deployed my reports in jasperserver3.5.0(using jrxml). Now i want view reports from my web application. Here i want to do some authendication. i found something called portletAuthenticationProcessingFilter in applicationContext-security.xml of jasperserver which deployed in tomcat. But i don't know about this. can anybody tell me regarding this? Regards, senthilm

halfer Wrote: Sorry, I should have said Jasper Server *Community Edition* works fine for us. We don't use Professional Edition. Hi, i want to connect oracle 9i with jasperserver 3.5.0 CE. I used JasperServer-3.5.0-Source-Build-Guide to create orace build script and deployed jasperserver into tomcat. and i created one sample report using jrxml file in jasperserver. But i trying to view the report i am getting following error. It would be great if u help me to fix this error.. 18:07:04,156 WARN JDBCExceptionReporter,http-8080-1:77 - SQL Error: 17090, SQLState: null 18:07:04,156 ERROR JDBCExceptionReporter,http-8080-1:78 - operation not allowed: streams type cannot be used in batching 18:07:04,156 ERROR AbstractFlushingEventListener,http-8080-1:301 - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2217) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2610) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:562) Thanks & Regards, Senthilm

Yes. it is working. but i am getting error while viewing report after the creation of report from jrxml file. Error is.. 11:09:08,738 WARN JDBCExceptionReporter,http-8080-2:77 - SQL Error: 17090, SQLS tate: null 11:09:08,738 ERROR JDBCExceptionReporter,http-8080-2:78 - operation not allowed: streams type cannot be used in batching 11:09:08,738 ERROR AbstractFlushingEventListener,http-8080-2:301 - Could not syn chronize database state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft. jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException (SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac tEntityPersister.java:2217) at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac tEntityPersister.java:2610) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja va:52) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) can anybody tell me how to fix the above Error? Thanks in Advance, senthilm Post Edited by senthilm at 07/29/2009 05:38

Hi sherman, I have JasperServer-Source-Build-Guide.pdf. It contains only for mysql and PostgreSQL. How can i build oracle script for JS 3.5.0 CE? i want to configure JS 3.50 with oracle 9i. Kindly help me to proceed.. Thanks & Regards, senthilm

Thank you all. senthilm

ok. i want to try it in CE. i am new to jasper. can u tell me how to create such report and save it in Ad hoc Components/topics folder? Thank you, senthilm

Yes pradeep. it is working.. Thank you, senthilm

Hi javed , thank you for ur response. I am using Community Edition. is it possible on this? Thanks & Regards, senthilm

Hi all, I am new to Jasperserver and very much interested to use jasperserver. Actually i have jasperserver-3.5.0-bin and iReport-3.0.0 and i want to create dynamic report and deploy into jasperserver. which means i want to give the control to user to design his structure or template of the report dynamically. is it possible in jasperserver? Kindly help me to proceed further.. Thanks in advance, senthilm

i have these files in lib dir, ojdbc14.jar and ocrs12.zip and i am trying to use jasper server with oracle 9i in tomcat

Hi, I too getting the same error. Can u tell me how u fixed this? Thanks & Regards, senthilm

Hi , I am too looking for jasperserver with oracle in tomcat. Kindly send me the neccessary configurations and oracle DDL. Thanks in advance, Senthilm (senthilm.aynara@gmail.com)