Mrutyunjay Hanchinal

Hi,
I don't think there would be a maintenance issue. Also I have a requirement that the administrator of the application should be able to add and delete the fields from the screen, assign access privilege to each field etc.
For such requirement I think storion the GUI details in DB would be better solution.
Mrutyunjay

Hello,
I am looking for a J2EE framework that will allow me to maintain the GUI fields, parameters from databse like display text, type of control(Text field, combo box etc) and generate the GUI based on the data in DB.
Is there any j2ee framework that will allow me to do this?
Thanks

Hi All,
I need to create table from my Java code.
I need to specify default value to a column as 0.
If I specify with default keword as in Oracle it gives Syntax Error..
How do I do that?
Thanks
Mrutyunjay

Hi All,
I have a strange problem with Websphere.
I am having Websphere 3.5.02.
My application uses Stateless EJBs.
The flow of control is like this.
1. From JSP a servlet is invoked.
2. Servlet after some minor validations opens a thread by calling run method of a class that implements the runnable interface
3. servlet returns back to client with the message that the process is initiated.
4. In the thread class, a call to EJB is made.
5. In the EJB a stored proc is called.
6. The execution of stored proc takes atleast 40 mins.
7. The return string from stored proc is printed to console.
8. return is executed.
9. The return value from EJB is used in the Thread class.
Now my problem is Up to step 7 the process is fine. But after the print statement I am getting
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
javax.transaction.TransactionRolledbackException
I am not getting any other exception.
Please suggest what could be causing this problem.
Thanks,
Mrutyunjay.

Hi,
I want to know What is the advantage of using Ref Cursors over Normal cursor in pl/sql stored procedures?
I have heard that it is having more of dis- advantages than advantages Is that true?
Please let me know any good online resource that will elaborate on this.
Thanks,
Mrutyunjay.
-----------

Hi All,
I am trying to crate a Materialized view in Oracle 8i. This view is being created by joining 4 tables out of which 2 tables have very large number of records. When I try to create this snapshot, I do not get any error but the process never ends. What might be the problem?
Please Suggest.
Thanks,
Mrutyunjay.

Hi,
I used "select count(*) from v$open_cursor where USER_NAME='mm_user'" to find out the number of open cursors.
If I consider "OPEN_CURSORS determines the maximum number of cursors per user" as per Beksy,I feel that the number is the one which my application is using. Here mm_user is the user name my application uses to execute the stored procs.
I think now it is clear what is my problem
Thanks
Mrutyunjay.

Hi All,
I have a strange situation here...
I have the following the setup
- Oracle 8.1.7 server
- open_cursors=1000
When I run my application that uses stored procs.
I am using cursors in the stored proc and once I start my application, the number of open cursors raise from 0 to 64 and suddenly shoots to 1040.. later it comes down to 0.
As it is reducing to 0 I am concluding that I am closing all the opened cursors.
Once it reaches 1040 as open_cursors, application throws "ORA-01000 maximum open cursors exceeded"
Here are my questions
Is it possible that number of open_cursors raise above maximum set limit?
In my case how is it raising to 1040 (1040>1000).
What might be the reason for a sudden shoot from 60 to 1040...
Thanks in advance
Mrutyunjay.
----------

Hi,
Thanks Ashok for your reply.
It appears from the reply of Ashok that the key value pairs in property file get loaded on to memory and hence it is not an I/O or File read operation instead it is burden on the memory.
Is this understanding correct?
Please suggest
Thanks,
Mrutyunjay

Hi All,
I have a basic doubt about the resource bundle object. I wanted to know if the creation of ResoureBundle object loads the entire property file or will it just create the pointer to file and every request to a key will do an I/O operation?
I think that the file gets loaded into memory(Please correct if I am wrong). In that case I feel that use of too many property files reduces the performance of the application.
I hope my concern is clear.
Waiting for all of your response.
Thanks,
Mrutyunjay
[ June 20, 2002: Message edited by: Mrutyunjay Hanchinal ]

HI
I am writing a java component that gets some files from a FTP server. If the FTP server is behind the firewall and FTP access is blocked in the forewall then the client needs to be intimated that the firewall is stopping files being downloaded.
So I think before connnecting to FTP server, if I get the info that accessing FTP server is not possible, then I can flash a message saying FTP server is behind the firewall and is not possible to connect.
So how do I go about it?
Thanks
Mrutyunjay
[ March 19, 2002: Message edited by: Mrutyunjay Hanchinal ]

Hi David
Thanks for the reply.
I want to know the mechanism that is used in ResourceBundle class. Does this read from the hard drive every time a property is requested or does it cache the key value pairs in the memory
Thanks for the reply.
Mrutyunjay

HI all
I am planning to use property files in my application, to store the configurable values.
And access the same in servlets with use of ResourceBundle API in servlets.
Does this hamper my application's performance?
I have the other option of having a class that stores the values.
I want to know the mechanism that is used in ResourceBundle. Does this load the property file contents in to the memory or does it do a file operation
Thanks
Mrutyunjay

Hi all
I am experiencing a strange problem...
I have a Servlet which gets certain values from a property file.
I had deployed this once and later un-deployed the servlet.
And changed the property file.
Again deployed the servlet and I am getting the old values.
I thought this might be due to the cache and so cleaned all temp files.
NOw restarted the server without the property file in classpath.
When I access the servlet I am still getting the same old values
This is happening only in Websphere on Solaris and working fine in NT
I am using Websphere 3.5 advanced version on Solaris 7
Please help....
Thanks in advance
Mrutyunjay
[ March 11, 2002: Message edited by: Mrutyunjay Hanchinal ]

Hi
Thanks for the reply
I think the second approach suits me
I want to bother U one more time...
Is there a any way where in I can put only the output to file and not the commands that I have executed.
I am getting the contents of the file as this
=================================================
SQL> select 'insert into test values(' || empno ||')' from scott.emp;
'INSERTINTOTESTVALUES('||EMPNO||')'
-----------------------------------------------------------------
insert into test values(7369)
insert into test values(7499)
insert into test values(7521)
insert into test values(7566)
insert into test values(7654)
insert into test values(7698)
insert into test values(7782)
insert into test values(7788)
insert into test values(7839)
insert into test values(7844)
insert into test values(7876)
'INSERTINTOTESTVALUES('||EMPNO||')'
-----------------------------------------------------------------
insert into test values(7900)
insert into test values(7902)
insert into test values(7934)
14 rows selected.
SQL> spool off
=================================================
Thanks
Mrutyunjay