Ishita Saha

Hi,

I need to execute a perl script from a java program, I got some stuff on google:
import java.io.*; public class RunCommand { public static void main(String args[]) { Process process; try { process = Runtime.getRuntime().exec("cmd.exe /c:/perl/bin perl.exe basic.pl"); process.waitFor(); if(process.exitValue() == 0) { System.out.println("Command Successful"); try { BufferedReader in = new BufferedReader(new InputStreamReader(process.getInputStream())); String line = null; while ((line = in.readLine()) != null) { System.out.println(line); } } catch (IOException e) { e.printStackTrace(); } } else { System.out.println("Command Failure"); } } catch(Exception e) { System.out.println("Exception: "+ e.toString()); } } }

It gives me the output as: Command Successful
but I need to see the output which should be: "I have a no" (which is there in basic.pl)

also I tried running another script - which should create a txt file ( that is not happening either)

any help is appreciated.
Thanks!

I tried it other way and it worked:

tempClob = CLOB.createTemporary(connection,true, CLOB.DURATION_SESSION); tempClob.open(CLOB.MODE_READWRITE); // open the temporary CLOB in readwrite mode to enable writing Writer tempClobWriter = tempClob.getCharacterOutputStream(); // get the output stream to write tempClobWriter.write(sClobData); // write the data into the temporary CLOB

I found it from my collegue

It gives me following error:

ORA-22920: row containing the LOB value is not locked

Hi,

I need to write a simple program to fetch a column data which is clob (oracle 9.2)
and insert/modify it and save it back to database.

I tried to use java.sql.Clob which has a setString function but that gives me

**************************************
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.sql.CLOB.setString(CLOB.java:1148)

Please help me with this, I need this working urgently.
I also came to know that I can get a clob as a String and save back a String as a clob but that is not working in oracle 9.2.
I think that only works with oracle 10g

Regards

I shall give it a try. Thanks

Hi,

I need to code a program in Java with JDBC connection to ORACLE where I need to get say 200 rows from a table in database. Insert 50 more rows in the resultset and do some changes in the exisiting 200 rows (some column data) and then write it back to database. I

s there a way I can do this directly in the resultset and write back the result set (250 rows this time) back to database.

The other lenghty process will be to store the reslutset in a multidimensional array - do all changes in Array and then write the rows one by one. may be in a loop using prepared statement.

Can anybody please suggest a cleaner and faster approach.

Thanks in advance

Hi,

I have a small java application, which has a program that connects with database and update some data. Now I have to ship this application to a unix server.

could anybody please tell me how should i package this application (jar or something) and then what will be the command to run this application. There will not be any command line arguments needed to run this.

Thanks in advance.

Hi,

We have recently migrated our application from WAS5.x to WAS6.
The previous version of WAS was having IHS 1.3.28 and WAS6 is having IHS 610 installed.

we had a RewriteRule which was working fine in IHS 1.3.28 (httpd.conf) the same rule when I copy to httpd.conf 610 version, it works fine but the application context root starts giving 404 : File not found error
GET /App_root/index.html HTTP/1.1" 404 63 (from access_log)

the sample of the RewriteRule

RewriteEngine On
RewriteRule ^/$ /index.html [PT]
RewriteRule ^/(.*) /App_Root/$1 [PT]
RewriteRule ^/App_Root/(.*)/$ /App_Root/$1/index.html [PT]

I wanted to know if there is a difference between how these two version behave in terms of rewriteRule and what could be the resolution for this.

can anybody help there please.

Thanks!

Hi All,

I have tried following what is available on internet for enabling remote debugging of web application using tomcat and eclipse but somehow it is not working for me.

I am using jdk1.5.0_09, eclipse Version: 3.2.1, apache-tomcat-6.0.18 and com.sysdeo.eclipse.tomcat_3.2.1
I have set JVM arguments in eclipse -> windows -> perferences -> tomcat -> JVM Setting as
-Xdebug -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=1044

now i see the three icons for tomcat start, stop and restart but when I click on start icon I am getting following error:

ERROR: JDWP unable to get necessary JVMTI capabilities. ["debugInit.c",L279]

any idea what is missing or wrong here.........

quick response is appreciated
Thanks in advance.

ok, I understand that web application server provides servlet and EJB container in addition to web server.
what I still want to understand is that why do we need a web server If I am using a web application server.
Web Application server should be able to take care of everything - right?

but all the j2ee web applications I have seen are deployed on app server and web server, could you please help me to identify the unique features or responsibilities of web servers which are not present in app server.

Thanks
Ishita

Hi,

this is a very basic questions but I am still confused on this.
I want to understand difference between Web application server and web server, like we are using IBM WAS and IHS.

also Can I use only one of them without using other, like can I host a JSP on WAS without using IHS - I am not sure how to try and test this out.

also for one of the application we are using apache web server to host a perl based application
what is the difference between apache and IHS and how to make a choice between them.

Thanks in advance

Hi,

I have a JSP page where I have given two choices to the user.
Now based on the selected choice - I have to submit the form to a servlet.

To be specific there are two radio buttons -
if user select radio button 1 - he should be redirected to URl abc
if user select radio button 2 - he should be redirected to URl xyz

could anybody please guide me what approach I should take
Thanks

Hi,

Please let me know a good book on portal devlopment using Java/J2EE
which talks about decoraters, theme, access level security and all related stuff.

Thanks!

I have a requirement of reading a file record by record so this would be a text file being built from mainframe data.

I have to read it and display all column information with proper heading.
I want to know - what should be the best approach to read a file which doesn't contain just raw data but it contains records from a database.

Also this information needs to be displayed in a web page which keeps refreshing every 30 secs

Yeah - I have the commands and i am trying my hands on the same.

I run into a few questions like:

I am using something like:

1 START=$(date +%s)
2 remain=30
3 sleep $remain
4 END=$(date +%s)
5 DIFF=$(( $END - $START))
6 echo "it took $DIFF secs"
7 sqlplus -s user_id/PWD@host <<EOF>
8 exec stored_proc;
9 EXIT;
10 EOF

This logic may not seem to be much relevant but this in in draft version for now.
Now I need to perform while i am in SQL connection, but if i insert statements 1-6 inside 7-10. It gives me error for each of the command - not found error which is expected since they are not sql commands.

Can somebody tell me what should be the way to do this. Thanks.