Rashid Darvesh

Ranch Hand
+ Follow
since Feb 13, 2004
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
1
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Rashid Darvesh

Hi Guys,
We have been having issues with jsp compilation exception on oracle app server. the issue is that when we deploy the application everything is fine, its after a day or some we get a random jspcompilation exception on any page. its really adhoc we cant say a particular jsp page, we have to redeploy and scrub the work directory and the application deployment directory and again the app is fine only for a day or two until the bug resurfaces again. Is there a way we can forecefully compile the jsp when the application gets deployed in the container. we are using oc4j 10.1.2 container. Please let me know ASAP
Thanks
Rashid
[ December 12, 2007: Message edited by: Bear Bibeault ]
13 years ago
Thanks Ryan
Really hard to find the reason behind this.

Anyway it works
Thanks
hi guys
i have a very simple function getname which return string
FUNCTION GETNAME RETURN VARCHAR2 IS
BEGIN
RETURN 'PORTAL';
END;
everytng is fine and i call it using spring stored procedure class
public class MyStoredProcedure extends StoredProcedure{
private static final String SQL = "GETNAME";
public MyStoredProcedure(DataSource ds) {
setDataSource(ds);
setFunction(true);
setSql(SQL);
declareParameter(new SqlOutParameter("returnname", Types.VARCHAR));
compile();
}

public Map execute() {
Map inputs = new HashMap();
return execute(inputs);
}
}
and this is my main class which tests it
public class StoredProcedureTest {
public static void main(String[] args) {
StoredProcedureTest t = new StoredProcedureTest();
t.test();
System.out.println("Done!");
}

void test() {
DriverManagerDataSource ds = new DriverManagerDataSource();
ds.setDriverClassName("oracle.jdbc.OracleDriver");
ds.setUrl("jdbc racle:thin:@xxx:1521:xxx");
ds.setUsername("xx");
ds.setPassword("xx");
try{
MyStoredProcedure sproc = new MyStoredProcedure(ds);

Map results = sproc.execute();
printMap(results);
}catch(Exception e){
e.printStackTrace();
}
}

private static void printMap(Map results) {
for (Iterator it = results.entrySet().iterator(); it.hasNext(); ) {
System.out.println(it.next());
}
}
}
This works fine and i get the result as portal.
the issue happens is when i add a parameter to getname function so my oracle function looks like
FUNCTION GETNAME (username IN VARCHAR2) RETURN VARCHAR2 IS
BEGIN
RETURN 'PORTAL';
END;
now i get the returnname output value as null the follogin is the changes to my Stored procedure class, i add one input parameter and now in the main test class i get the return name variable as empty

public class MyStoredProcedure extends StoredProcedure{
private static final String SQL = "GETNAME";
public MyStoredProcedure(DataSource ds) {
setDataSource(ds);
setFunction(true);
setSql(SQL);
declareParameter(new SqlParameter("username",Types.VARCHAR));
declareParameter(new SqlOutParameter("returnname", Types.VARCHAR));
compile();
}

public Map execute() {
// the 'sysdate' sproc has no input parameters, so an empty Map is supplied...
Map inputs = new HashMap();
inputs.put("username","john");
return execute(inputs);
}
}

May i know what i am doing wrong

thanks
Hello
Do any body has any guess.
i tried to upload this file from console and it says invalid file.
Thanks
Rashid
13 years ago
Hi,
could anybody please let me know how to deploy aar (Axis archive) file in oracle applicaiton server.

Please let me know

Rashid
13 years ago
For advanced use cases this is good but please be aware there is no exception handling

http://www.makemyinfo.com/Tutorial.do?action=getTutorial&tutId=T0005.jsp
does anybody has any idea
Rashid
13 years ago
Hi
i have a page which takes a lot fo time.
the problem is when my struts action is complete i use tiles. the normal practise is when your action is complete direct the page to wating.jsp page and that page has a tag something like this
<html>
<HEADER>
<META HTTP-EQUIV="Refresh" CONTENT="0; URL=long_timeTaking_page">
</HEADER>
Please wait
</html>
but my issue is in my struts config file i am forwarding it to a tiles def. Did anybody figure out how to solve this with tiles.
Thanks
Rashid
13 years ago