Thirumurugan Sivaji

Hi,
I have created a web application using struts1.2. When I run the application using Firefox it works fine. But when I run it using IE6 the browser will be blank it is not displaying any content and even any error message. Anybody have solution please share with me.

Hi,

I want to read all the tables from a schema, and read all columns for the particular table, based on the column datatype and its length i need to insert the values .

Ex:
SELECT TABLE_NAME FROM USER_TABLES; wil return all the tables, from the result i need to loop the resutset

select COLUMN_NAME,DATA_TYPE,DATA_LENGTH from USER_TAB_COLUMNS where table_name = <eachtable from the above query>



create or replace PROCEDURE CREATEINSERT IS cursor tableCursor is SELECT TABLE_NAME FROM USER_TABLES UT; TABLE_NM USER_TABLES.TABLE_NAME%TYPE; BEGIN open tableCursor; loop fetch tableCursor into TABLE_NM; exit when tableCursor%NOTFOUND; INSERTRECORDS(TABLE_NM); end loop; close tableCursor; END CREATEINSERT;



procedure for INSERTRECORDS:
------------------------------------

CREATE OR REPLACE PROCEDURE INSERTRECORDS(tblname in varchar2) AS col_name USER_TAB_COLUMNS.COLUMN_NAME%TYPE; data_typ USER_TAB_COLUMNS.DATA_TYPE%TYPE; data_len USER_TAB_COLUMNS.DATA_LENGTH%TYPE; cursor colCursor is SELECT COLUMN_NAME,DATA_TYPE,DATA_LENGTH from USER_TAB_COLUMNS WHERE TABLE_NAME = tblname; BEGIN open colCursor; loop fetch colCursor into col_name,data_typ,data_len; exit when colCursor%NOTFOUND; if(tblname='A3') then insert into A3(eid) values ('1'); end if; end loop; close colCursor; END INSERTRECORDS;




Problem:

From the 1st procedure im getting each table and pass the value to second procedure. From the second procedure with in the cursor i need to get all the columns
in a single step, so that i can insert values into table ..

Hi,
I have a search condition with multiple searches based on input. If I give employee number records to be fetched by emloyee number only and if I give employee no, designation and name starts with some string(like s,sar etc.,). How to write a single query in sql.properties file of IBM WACs framework to do multiple searches. Like I can use :_WHERE_AND(condition1,condition2,condition3 etc). How to write like condition1 and condition2 or name like 'sa%' of '%s%',

Thanks in advance

Hi,
Thanks for your input but it is not the one I wanted. I can get the list of processes and process IDs through Runtime.exec("tasklist"); command. My question is if there are more than one processes with same name(for eg if you open 2 command prompt the task manager will display 2 cmd.exe) how do I identify which process(like cmd.exe) will points to which task(like command prompt).

Thanks in advance

Hi,
I have to do coding for the following scenario,

Suppose when 4 jar files are executed then 4 java.exe will present in task manager. How could I find that which java.exe is executing which jar file.

If anybody have an idea or code please let me know.

Thanks in advance

Hi,
I have validated url that starts with http:// using

URL url = new URL(strUrl); URLConnection connection = url.openConnection(); if (connection instanceof HttpURLConnection) { HttpURLConnection httpConnection = (HttpURLConnection)connection; httpConnection.connect(); int response = httpConnection.getResponseCode(); } return response;

but, How to validate url that starts with https://, when I give https:// format exception occurs that certificate is required. How to do that?.

Thanks in advance

Hi,
I have to do process monitoring in java. I have done process monitoring using thread for unique processes (eg. cmd.exe,alg.exe,smss.exe etc.). How to monitor multiple processes with same name for eg I have opened 4 command prompts in different times(say interval of 15sec,20sec,30sec etc) so that 4 cmd.exe will be runnung. how can I monitor those 4 processes and displays it.


Thanks in advance

Hi,
I have two text fields in my JSP called ipAddress and processName. When I click the submit button I have to find and get the status of the Process and memory usage in bytes and also in percentage for that particular process name.Can anyone give me the Java code for performing the above task that support all Operating System.

Hi,
I tried with "focusElement" attribute in form tag but it is not working. In JSP itself says warning that it is a invalid attribute. Do you know any other methods to focus the field.

Hi
I want to set a focus to input field at the time of form load in struts2 as like <html:form action="doLogin" focus="loginId"> in struts1.x. Please give me a solution for the above scenario.

Thanks in advance,
Thirumurugan Sivaji

Hi,

Anybody can give me the code for the following scenario,

I am reading the list of employee details(empId,empname and designation) from database as an arraylist. I want to write those arraylist data into a file and download the same file as a stream.

Thanks & Regards
Thirumurugan Sivaji

Hi,
How to set locale in index.jsp itself in struts like session.setAttribute("org.apache.struts.action.LOCALE",new Locale("ja")); in struts1. If anyone known please reply me ASAP.

Thanks in advance
Thirumurugan Sivaji

Hi,

It's working fine with UNION.
create or replace PROCEDURE SPP_SELECT_EMPLOYEES ( empId IN VARCHAR2 , empRole IN VARCHAR2 , emp_cur OUT SYS_REFCURSOR , resultOut OUT NUMBER ) IS CURSOR emp_cursor IS SELECT EMP_ID,EMP_NAME,EMP_ROLE from ITS_M_USER WHERE EMP_ROLE= empRole AND empId is null AND empRole is not null UNION SELECT EMP_ID,EMP_NAME,EMP_ROLE from ITS_M_USER WHERE EMP_ID=empId AND empId is not null AND empRole is null UNION SELECT EMP_ID,EMP_NAME,EMP_ROLE from ITS_M_USER WHERE EMP_ID=empId AND EMP_ROLE=empRole AND empId is not null AND empRole is not null UNION SELECT EMP_ID,EMP_NAME,EMP_ROLE from ITS_M_USER WHERE empId is null AND empRole is null; currId ITS_M_USER.EMP_ID%TYPE; currName ITS_M_USER.EMP_NAME%TYPE; currRole ITS_M_USER.EMP_ROLE%TYPE; BEGIN open emp_cursor; loop FETCH emp_cursor INTO currId,currName,currRole; exit when emp_cursor%NOTFOUND; dbms_output.PUT_LINE(currId||' ' ||currName||' ' ||currRole); end loop; close emp_cursor; resultOut := 101; END SPP_SELECT_EMPLOYEES;

The above procedure is working fine and printing the values.
How to store the value of emp_cursor(CURSOR) into emp_cur(REFCURSOR which is an OUT parameter) or how to return emp_cursor?.

Hi,

I tried with UNION but the Procedure did not compile and it gives the following error

Error(10,6): Encountered the symbol "UNION" when expecting one of the following: begin function package procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current cursor

Hi,

Place as many classes as you want inside the hibernate mapping file as follows,
<hibernate-mapping>
<class name="event.Employee" table="employee">
<id name="id" >
<generator class="increment"></generator>
</id>
<property name="empId" column="EMP_ID"/>
<property name="empName" column="EMP_NAME"/>
<property name="empPwd" column="EMP_PASSWORD"/>
</class>
<class name="event.Employee" table="dept">
<id name="id" >
<generator class="increment"></generator>
</id>
<property name="empId" column="EMP_ID"/>
</class>
</hibernate-mapping>