12 Replies Latest reply: Aug 22, 2013 5:40 AM by LT.ora RSS

    Oracle reports 10g – local printing problems

    LT.ora

      looking for solutions to print directly to the clients local printer

       

      after going through all the forum and posts and blogs I found webtuil to be a good solution; the code to call is :

      client_host('\\server\sharefolder\printfile.bat');

      and inside the batch file

      acrord32/p/h  \\server\sharefolder\rpt.pdf

      but the solution is still slow; can somebody suggest some faster solutions/Alternative please,

      Thanks

        • 1. Re: Oracle reports 10g – local printing problems
          LT.ora

          I would love to go for the DirectPrint Java Bean from Casey Bowden ;

          I've followed all instructions but no errors neither any actions while clicking on

          [ list printers ] button

          • 2. Re: Oracle reports 10g – local printing problems
            François Degrelle

            No error, even in the Java Console ?

            Francois

            • 3. Re: Oracle reports 10g – local printing problems
              LT.ora

              nope I might be missing something;

              java console :

               

              Java Plug-in 1.6.0_33

              Using JRE version 1.6.0_33-b03 Java HotSpot(TM) Client VM

              User home directory = C:\Users\Administrator

               

               

              ----------------------------------------------------

              c:   clear console window

              f:   finalize objects on finalization queue

              g:   garbage collect

              h:   display this help message

              l:   dump classloader list

              m:   print memory usage

              o:   trigger logging

              q:   hide console

              r:   reload policy configuration

              s:   dump system and deployment properties

              t:   dump thread list

              v:   dump thread stack

              x:   clear classloader cache

              0-5: set trace level to <n>

              ----------------------------------------------------

               

               

              proxyHost=null

              proxyPort=0

              connectMode=HTTP, native.

              Forms Applet version is : 10.1.2.0

               

              but I do get error in design time :

               

              FRM-13008: Cannot find JavaBean with name 'dsd.printing.DirectPrint'

               

              • 4. Re: Oracle reports 10g – local printing problems
                LT.ora

                Hey @FrançoisDegrelle

                 

                My mistake, I was running it on an application server; when I executed on http://localhost I found the following error :

                 

                Java Plug-in 1.6.0_33

                Using JRE version 1.6.0_33-b03 Java HotSpot(TM) Client VM

                User home directory = C:\Users\Administrator

                ----------------------------------------------------

                c:   clear console window

                f:   finalize objects on finalization queue

                g:   garbage collect

                h:   display this help message

                l:   dump classloader list

                m:   print memory usage

                o:   trigger logging

                q:   hide console

                r:   reload policy configuration

                s:   dump system and deployment properties

                t:   dump thread list

                v:   dump thread stack

                x:   clear classloader cache

                0-5: set trace level to <n>

                ----------------------------------------------------

                proxyHost=null

                proxyPort=0

                connectMode=HTTP, native.

                Forms Applet version is : 10.1.2.0

                java.lang.ClassNotFoundException: dsd.printing.DirectPrint

                  at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)

                  at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)

                  at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)

                  at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)

                  at java.lang.ClassLoader.loadClass(Unknown Source)

                  at java.lang.Class.forName0(Native Method)

                  at java.lang.Class.forName(Unknown Source)

                  at oracle.forms.handler.UICommon.instantiate(Unknown Source)

                  at oracle.forms.handler.UICommon.onCreate(Unknown Source)

                  at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)

                  at oracle.forms.engine.Runform.onCreateHandler(Unknown Source)

                  at oracle.forms.engine.Runform.processMessage(Unknown Source)

                  at oracle.forms.engine.Runform.processSet(Unknown Source)

                  at oracle.forms.engine.Runform.onMessageReal(Unknown Source)

                  at oracle.forms.engine.Runform.onMessage(Unknown Source)

                  at oracle.forms.engine.Runform.sendInitialMessage(Unknown Source)

                  at oracle.forms.engine.Runform.startRunform(Unknown Source)

                  at oracle.forms.engine.Main.createRunform(Unknown Source)

                  at oracle.forms.engine.Main.start(Unknown Source)

                  at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)

                  at java.lang.Thread.run(Unknown Source)

                what can be done?

                • 5. Re: Oracle reports 10g – local printing problems
                  François Degrelle

                  This means that the corresponding JAR file(s) are not copied to your /forms/java folder, or not added to the archive tags of your /forms/server/formsweb.cfg file.

                  Check the steps required for this installation in the article.

                   

                  Francois

                  • 6. Re: Oracle reports 10g – local printing problems
                    LT.ora

                    I tried downloading from http://192.168.9.13:8889/forms/java/DirectPrint.jar and I was able to do so successfully

                    and the formsweb.cfg file :

                    # Forms applet archive setting for JInitiator

                    archive_jini=frmall_jinit.jar,facticons.jar,DirectPrint.jar,PDFBox-0.7.3.jar,FontBox-0.1.0.jar

                    # Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)

                    archive=frmall.jar,facticons.jar,DirectPrint.jar,PDFBox-0.7.3.jar,FontBox-0.1.0.jar

                     

                    is it required to do so ? to create the DirectPrint.jar ? or can I directly use DirectPrint.jar ?

                    • 8. Re: Oracle reports 10g – local printing problems
                      François Degrelle

                      I told you all I know. Ensure you update EVERY occurence of the archive tags in your formsweb.cfg file.

                      I cannot say more.

                      Francois

                      • 9. Re: Oracle reports 10g – local printing problems
                        LT.ora

                        Thanks FrançoisDegrelle,

                         

                        After going through formsweb.cfg file, I found couple of case sensitive filename;

                        I rectified them now I get :

                        Java Plug-in 1.6.0_33

                        Using JRE version 1.6.0_33-b03 Java HotSpot(TM) Client VM

                        User home directory = C:\Users\Administrator

                        ----------------------------------------------------

                        c:   clear console window

                        f:   finalize objects on finalization queue

                        g:   garbage collect

                        h:   display this help message

                        l:   dump classloader list

                        m:   print memory usage

                        o:   trigger logging

                        q:   hide console

                        r:   reload policy configuration

                        s:   dump system and deployment properties

                        t:   dump thread list

                        v:   dump thread stack

                        x:   clear classloader cache

                        0-5: set trace level to <n>

                        ----------------------------------------------------

                        DEBUG MESSAGE DirectPrint0: Setting debug_enable: false.

                        DEBUG MESSAGE DirectPrint0: Setting debug_enable: true.

                        DEBUG MESSAGE DirectPrint0: Hello to debug.

                        DEBUG MESSAGE DirectPrint0: LIST_CLIENT_PRINTERS: TRUE

                        DEBUG MESSAGE DirectPrint0: Client Printer 0: Microsoft XPS Document Writer

                        DEBUG MESSAGE DirectPrint0: Client Printer 1: \\192.168.3.100\Brother QL-700

                        • 10. Re: Oracle reports 10g – local printing problems
                          LT.ora

                          1 more help needed

                          DEBUG MESSAGE DirectPrint1: DIRECT_PRINT_PDF_URL: http://192.168.9.13/rptBarCodePrint.pdf

                          DEBUG MESSAGE DirectPrint1: Printing URL: http://192.168.9.13/rptBarCodePrint.pdf

                          DEBUG MESSAGE DirectPrint1: access denied (java.util.PropertyPermission java.io.tmpdir read)

                          I found that Simplest solution is just to sign the applet.


                          how to sign the jar file? or what actually is the error java.util.PropertyPermission java.io.tmpdir read

                          • 12. Re: Oracle reports 10g – local printing problems
                            LT.ora

                            Signing the Jar didn't solve the issue