My World A Blog On All The Things That Happen In My Life

Fixing Internet Explorer Crash on Launching Oracle Forms Application with jInitiator
on 27/06/2009 - like it?

I’ve been facing this really annoying problem for quite some time now. My job revolves around developing apps using Oracle Forms Builder. Oracle Forms applications, uses Java applets to run inside any browser, on most platforms. Here’s the kink – Oracle Forms applications by default uses Oracle’s jInitiator which is a JVM made by Oracle and allows a web enabled Oracle Forms client application to be run inside a web browser.

As much as I hate using Internet Explorer – I have to depend on it as the my app depends on other components which are designed on run on Internet Explorer only  

Till now I’ve been using Mozilla Firefox, but now the situation demands that I needed to use Internet Explorer. And when I launched Internet Explorer – Ka boom! Internet Explorer crashes. Did few things, such as disabling all addons, getting rid of Sun’s JVM et al, but made no difference.

[ad]

Finally, I came across a solution(or rather a workaround) – replace the jvm.dll in jinitiator directory with that present in Sun’s JRE 1.6. If you don’t want to install the whole bundle – just click here(jvm.dll, 2.2 MB), I’ve uploaded just the jvm.dll file, rename the original jvm.dll (present in jinitiator/bin/hotspot directory) to, say jvm.dll.old, and replace it with the one given in the above link. Restart the browser, IE shouldn’t crash anymore.

Tags: Forms, IE, Internet Explorer, jinitiator, oracle

Yes I’m alive!
on 14/06/2009 - like it?

It’s been  a while hasn’t it, since I last blogged ? *goes to next tab to check last manual blog post* April 19. God! Hadn’t realized its been so long since I last composed. Yes, I’m alive (hey you’re reading this aren’t ya?). I can hear the collective yells of “where the hell have you been”. Well – work. Been drowned, swamped, overloaded – basically been busy with shit loads of work.

Next question – Am I in Austin ?

(more…)

Tags: 3i, Austin, Chennai, Life, office, oracle, SQL, thoughts

The Power and Simplicity of Oracle Hierarchical Queries
on 19/01/2009 - like it?

They say “Necessity is the Power of Invention” – a quote which I fully understood the impact today. I’ve been trying to understand Oracle’s Hierarchical Queries for a while now, but never fully understood the situation under which or when it would be used. Yesterday I got a reason to use it. Let me begin.

(more…)

Tags: hierarchical queries, oracle, PL/SQL, query, SQL

Exporting and Importing An Oracle database from one schema/user to Another schema/user easily
on 01/12/2008 - like it?

Couple of days ago at work I was asked to create a new environment(schema, user) for specific application testing conditions. While that was no big deal, I was also asked to import all the data from existing production environment into a new environment – and I was in a bit of bother here – generally the whole importing/exporting is done by DBA’s not developers. While I knew the usage of exp and imp commands, creating schema would require stuff like tablespace creating, adding data files and more importantly – grants which I had NO clue on. So after a bit of experimenting and consulting with my fellow colleague Rupam, I finally managed to export and import the data. This post is on how-to go about doing it.

If you want to skip all the commands and all just get the import / export done in 1-click try Easy Dump Oracle 1.1 – a tool which I found on the database server after all the headbanging

Anyways here’s a step by step  process on how you export and import the data – do note that Easy Dump Oracle can import data ONLY if required grants are given to the user and tablespace has been allocated. For that you need to follow the below mentioned steps.

(more…)

Tags: data files, exp, export, imp, import, oracle, tablespace

PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle
on 11/08/2008 - like it?

Over the period of time that I’ve been working on PL/SQL, the one the thing that we end up doing often is reset the sequences we use for Primary keys in our tables. Why do we do that, you might wonder.

Consider this case:

(more…)

Tags: oracle, PL/SQL, Primary key, reset, sequence, SQL

Query For Displaying The Calender of The Current Year using SQL
on 24/06/2008 - like it?

Another of things I got via IpMessenger, this query(yes, its a QUERY, not even a full-blown code) returns the calender of the current year. Do note this query will work only in Oracle.

Here’s the query.
(more…)

Tags: calender, oracle, query, SQL