March 2008 - Posts

2
Comments

Parsing Excel Date with POI - JXLS by lamia

Just a quick post from me here. I couldn't find any resources on the internet, I couldn't remember how I found this solution. Here's the scenerio. When you try to parse and Excel sheet using JXLS, unless your Excel sheet column is formatted...
Filed under: ,
0
Comments

Passing an Array in a PL/SQL Function/Procedure by lamia

Note: The code provided will not compile. It should only serve as a guide! We had a performance issue and one of the solutions I came to to prevent excessive rountrip from my Java application to the database is to pass the things I need as an array to...
Filed under:
0
Comments

Exception handling in PL/SQL by lamia

Note: I'm doing this code inside a Package. I've never written an PL/SQL program outside of a Package. You can declare exception everywhere inside a PL/SQL Stored Procedure or Function. PROCEDURE MY_PROC(V_ARG_SOMETHING IN MY_TBL.MY_FIELD%TYPE...
Filed under:
0
Comments

Could not open ejb-jar.xml in Deployment Descriptor Editor in RAD7 by lamia

We downloaded our project from JDK 1.5 to JDK 1.4. The step would obviously bring out some issues and the most annoying one I've come to experience so far is when I couldn't open my ejb-jar in the deployment descriptor editor. The solution was...
Filed under: ,
1
Comments

Resetting a session-scoped ActionForm member value by lamia

I had a session-scoped session form and when a user clicks on a button, I wanted the value to be reset. I tried to do something like myForm.setValue(""); but it didn't do the job for some reason. Of course, I'm doing the usual struts...
Filed under: