Follow by Email

Tuesday, December 23, 2014

Spring : How to escape HTML in all the pages of your application

In Spring we can escape HTML in all JSP pages generated by < form > tags.
For entire application put below lines in your web.xml

For more details see the below stackoverflow thread

Wednesday, December 10, 2014

Tinymce multiple textareas block problem

Problem :

I am using Internet Explorer , I have 4 text editors in one page all TimyMCE , the problem I am facing is that I am able to enter text in first editor however when I click on next textarea I can't type anything in it however I can see the cursor blinking in it

I have also noticed
  1. If i use tab to go to 2nd editor I am able to type , but when I use mouse to click on that textarea I can't type.
  2. I have waited for enough time to allow scipts to be loaded properly but I still face the same problme.
I am running Internet explorer in below mode

meta http-equiv="X-UA-Compatible" content="IE=8"  Shifitng it to IE=9 seems to resolve problems , but I want to run my application as IE=8. 

Solution :

I found that the latest TinyMCE editor version 4.X was not working very welll will the older browser compatibility IE=8 , being in that mode is a must for me right now because of some other dependent scripts which create problems in IE=9 .
So I decided to use an older version of TinyMCE 3.X which appeared to be compatable and now the applicaiotn is working fine.


Tuesday, November 25, 2014

HTML TD Can't Wrap text , grows with the size of line and mess up the witdh of the TD

I am using Internet Explorer 9.

A dynamicaly generated text having a very long line when displayed in a TD in my HTML table mess up the whole width of the TD which basically grows to fit the whole line and doesn't automaticaly wrap text

applying wrap text CSS on TD is not working , The solution was to apply the below style at table level

style="width: 100%; table-layout: fixed;"

I didn't even need to apply text wraping to my TDs.

Below Thread was very helpfull

and the solution which worked for me in this thread is copy pasted below

table-layout:fixed will resolve the expanding cell problem, but will create a new one. IE by default will hide the overflow but Mozilla will render it outside the box.
Another solution would be to use: overflow:hidden;width:?px
<table style="table-layout:fixed; width:100px">
   <td style="overflow:hidden; width:50px;">fearofthedarkihaveaconstantfearofadark</td>
Since I am using IE I had to only use
style="width: 100%; table-layout: fixed;"
for my table.

Wednesday, October 8, 2014

oracle How can I tell where my database function was used
As mentioned in the above stackoverflow thread , below query can be used to find where your database function/procedure has been used.
The oracle documentation for all_sources can be found at below link 

Below post is also very informative

Thursday, September 25, 2014

Crystal report passing string date parameter to a report from my jsp page

Problem Statement :

Just found out that passing a string attribute from my jsp page to a crystal report is not working and the report was asking for the date parameter again.

Solution :

Thanks to a thread on stackoverflow , the solution was to create date string as

#9/25/2014# and then pass it to crystal report from my page and now it's working fine.


Monday, September 8, 2014

Eclipse saving workbench state hangs

I followed the below instructions in the blog

  • Make a backup of your “.metadata“-folder (very important!!) (this folder inside teh eclipse workbench/workspace folder)
  • navigate into the “.plugins“-folder located inside “.metadata
  • delete the folder “org.eclipse.ui.workbench
  • startup eclipse again and check if there is still everything you need


    and the problem was resolved , now when I close my eclipse it doesn't hang at saving workbench state.

    infact I have noticed that the eclipse is starting a closing faster than before.

    Usefull Oracle Database Queries

    Get the details of important oracle parameters such as "PASSWORD_LOCK_TIME" and "SESSIONS_PER_USER" etc

    select * from dba_profiles order by profiles

    Get the Name of the oracle instance

    SELECT sys_context('USERENV','DB_NAME') AS Instance FROM dual;
    Get the name of the current oracle instance and user id

     select name,user from v$database

    Query to see who has access to your package

    select grantee, table_name, privilege
         from dba_tab_privs
           table_name = 'YOUR_PACKAGE_NAME'

    I will keep adding other usefull queries here....