0 Replies Latest reply on Oct 13, 2014 9:37 PM by Bryan Cheung

    Problem of generating Crystal Report XI under JBoss 7 with SQL Server 2012

    Bryan Cheung Newbie

      Dear All Experts,

       

      I am a newbies of Crystal Report. Since it is migrating the Crystal Report from exist platform to JBoss 7 with SQL Server 2012.

      But the problem that after generating Crystal Report, it throws out the following Exception:

       

      Exception:

      15:07:31,130 INFO  [org.apache.struts.tiles.TilesRequestProcessor] (http--127.0.0.1-8080-1) Tiles definition factory found for request processor ''.

      15:07:47,444 INFO  [td.etid.internal.report.Rp101Handler] (http--127.0.0.1-8080-1) reportName: C:\u04\tdetid\CrReports\RSrp101.rpt

      15:07:47,444 INFO  [stdout] (http--127.0.0.1-8080-1) tableAlias: rp101

      15:07:47,444 INFO  [stdout] (http--127.0.0.1-8080-1) OpenReportOptions._openAsReadOnly: 524288

      15:07:50,287 ERROR [com.crystaldecisions.reports.reportdefinition.ReportDefinition] (http--127.0.0.1-8080-1) Report printer was not valid, switching to default printer.

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) java.lang.NullPointerException

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at com.businessobjects.samples.JRCHelperSample.addDiscreteParameterValue(Unknown Source)

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at td.etid.internal.report.Rp101Handler.build(Unknown Source)

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at td.etid.internal.servlet.Rp101.doGet(Unknown Source)

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at td.etid.internal.servlet.Rp101.doPost(Unknown Source)

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

      15:07:51,599 ERROR [stderr] (http--127.0.0.1-8080-1) at td.etid.internal.servlet.GenericInternalServlet.service(Unknown Source)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      15:07:51,615 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

      15:07:51,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

      15:07:51,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

      15:07:51,630 ERROR [stderr] (http--127.0.0.1-8080-1) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

      15:07:51,630 ERROR [stderr] (http--127.0.0.1-8080-1) at java.lang.Thread.run(Thread.java:745)

       

      For my source code,

      Hashtable<String, String> env = new Hashtable<String, String>();

      env.put(Context.INITIAL_CONTEXT_FACTORY, "org.jboss.as.naming.InitialContextFactory");

      env.put(Context.PROVIDER_URL, "");

      env.put(Context.URL_PKG_PREFIXES, "org.jboss.naming:org.jnp.interfaces");

       

       

      Context ctx = new InitialContext(env);

      DataSource datasource = (DataSource) ctx.lookup(url);

      Connection conn = datasource.getConnection();

        stmt = conn.prepareCall(query, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

        stmt.setTimestamp(1, submissionStart);

        stmt.setTimestamp(2, submissionEnd);

        stmt.setInt(3, batchID);

        stmt.setString(4, insurerID);

        stmt.setInt(5, seqNo);

        rs = stmt.executeQuery();

       

        if (type.equalsIgnoreCase("preview")) {

        ReportClientDocument clientDoc = new ReportClientDocument();

        String reportName = "C:\\u04\\tdetid\\CrReports\\RSrp101.rpt";

        logger.logInfo("reportName: " + reportName);

       

        String tableAlias = "rp101";

        System.out.println("tableAlias: " + tableAlias);

        System.out.println("OpenReportOptions._openAsReadOnly: " + OpenReportOptions._openAsReadOnly);

        clientDoc.open(reportName, OpenReportOptions._openAsReadOnly); // throw exception here

       

        System.out.println("clientDoc.open()");

        //ResultSet

        JRCHelperSample.passResultSet(clientDoc, rs, tableAlias, "");

      System.out.println("submissionStart: ");

        if(submissionStart != null) {

        System.out.println("submissionStart: " + df.format(submissionStart));

        JRCHelperSample.addDiscreteParameterValue(clientDoc,

        "@submissionStart", "", df.format(submissionStart));

        } else {

        JRCHelperSample.addDiscreteParameterValue(clientDoc,

        "@submissionStart", "", "");

        }

      ........

       

      I am setting the JNDI named as java:/INTERNAL_DS and set in the standalone.xml in JBoss7

      and I am trying to use ODBC to connect from Crystal Report through JNDI in JBoss7 to SQL Server 2012.

       

       

      Since I want to use ODBC, the CRConfig.xml without configuration.

       

       

      The Crystal Report in Crystal Report Designer can successfully preview. So the Crystal Report is in valid.

       

       

      Thanks all experts.