Viswa Ambal

Greenhorn
+ Follow
since Aug 21, 2007
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
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 Viswa Ambal

Ejb is costly and it depends the application server you are using and based on the requirement. If you are trying with your own interest, you can go for Spring - ORM(Hibernate/iBatis).
Displaying millions of record is not a problem if you follow
1) Implement the pagination concept in ORM level
2) Fetch values on click of every 'next>>'

Hope you got some idea!
You can pass array(1D, 2D, ...). This is driver dependent. If you use Oracle as DB, you have to wrap your ordinary connection with OracleConnection.You should use ARRAY and ArrayDescriptor to pass the array.
Hope will give some idea.
16 years ago
Work around :
we can use Dojo tool kit for storing javascript object.

Disadv :
Each jsp page load will load the dojo library create performance issue.
16 years ago
JSP
Hope is clear with with Query.
Again....
I'm trying to store the Javascript Object to HttpSession of JSP/Servlet.
Will it be possible to store a Javascript Object in HttpSession?
If it is not possible , any other way to retain the Javascript Object?

Hope is clear now

-Visamal
16 years ago
JSP
Hi,
Is it possible to store javascript object in HttpSession (in JSP)?
If possible please help me with sample code.
If not please suggest for alteration.

Thanks in advance.

-Visamal
16 years ago
JSP
Hi,
It is working fine.
It is because of Driver Version conflict.

Thanks.
-Visa
Hi all,
Below is the code to call Stored Procedure(SP).

RetrieveTerTemplateProc retTerTemplateProc = new RetrieveTerTemplateProc(
ServiceLocator.getInstance().getTMDataSource(), "DELETE_TERRITORY_PR");
try {
Map myMap = retTerTemplateProc.execute(territoryId);
_log.info("Map size :: "+myMap.size());
} catch (Exception e) {
throw new MarshSQLException("ERROR IN APPROVAL SQL", e);
}

RetrieveTerTemplateProc(Inner class)
------------------------
class RetrieveTerTemplateProc extends StoredProcedure {
public RetrieveTerTemplateProc(DataSource ds, String spName) {
super(ds, spName);
declareParameter(new SqlParameter("p_territory_id", Types.VARCHAR));
declareParameter(new SqlOutParameter("v_error", Types.NUMERIC));//errorcode
declareParameter(new SqlOutParameter("v_error_msg", Types.VARCHAR));//error msg
compile();
}
public Map execute(int territoryId) {
Map inParam = new HashMap();
inParam.put("p_territory_id", String.valueOf(territoryId));
return super.execute(inParam);
}
}
-----------------------------------
It gets failed at super.execute(inParam); line.
If I check with the log no response from Oracle.
After some 10-15 mts it gives below message in log file.
ThreadMonitor W WSVR0605W: Thread "ORB.thread.pool : 1" (00000066) has been active for 634359 milliseconds and may be hung. There are 1 threads in total in the server that may be hung.

After this the server went to hung state.

If I try for simple SQL call with JdbcTemplate it is working fine and fetching all values.But for Stored Procedure is not responding.

I'm using Oracle9i Enterprise Edition Release 9.2.0.1.0 as back end.
Driver is Oracle JDBC driver 10.1.0.2.0

Quries :
1) is it because of Driver version?
2) what is the impact of setFunction(true) not provided in the code?

Please help me .....

Regards, Visa.