This discussion is archived
12 Replies Latest reply: Aug 22, 2013 3:40 AM by LT.ora RSS

Oracle reports 10g – local printing problems

LT.ora Explorer
Currently Being Moderated

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 Explorer
    Currently Being Moderated

    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çoisDegrelle Oracle ACE
    Currently Being Moderated

    No error, even in the Java Console ?

    Francois

  • 3. Re: Oracle reports 10g – local printing problems
    LT.ora Explorer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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çoisDegrelle Oracle ACE
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 ?

  • 7. Re: Oracle reports 10g – local printing problems
    LT.ora Explorer
    Currently Being Moderated

    Hello FrançoisDegrelle,

    Please guide me

    - LT.ora

  • 8. Re: Oracle reports 10g – local printing problems
    FrançoisDegrelle Oracle ACE
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    Signing the Jar didn't solve the issue

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points