Search results for query: *

Hi, I am newbie to right stored procedure. In my Sp i have 3 cursors. i have to pass the value of first cursor to second & third cursor. Here is my sp. CREATE PROCEDURE DB2ADMIN.GETOLDVEHICLE_AMF(IN carrAcctNum integer, IN fleetNum smallint, IN fleetMonth smallint, IN fleetCCYY smallint, IN...

hi, i am new for writting sp. Here is my sp.. CREATE PROCEDURE DB2ADMIN.DELETE_FEE_ENTRY (IN accountNbr integer, In fltNbr smallint, IN fltExpMM smallint, IN fltExpCCYY smallint,IN suppNbr smallint, OUT OUT_SQLCODE int)...

hi, i am getting SQL0104N An unexpected token "<cursor declaration>" was found following "". Expected tokens may include: "<SQL statement>". Here is my stored procedure-- <code> CREATE PROCEDURE DB2ADMIN.GETVEHICLES(IN carrAcctNum integer, IN fleetNum smallint, IN fleetMonth smallint, IN...

I am using postgres 8.0. I have a table trn. create table trn (trn_id int, trn_file bytea); insert into trn(1,"myFile.doc"); myFile.doc is a wordfile. I have successfully inserted data in trn table. Now i want to retrieve trn table and change the contents of myFile.doc. But by using this...

hi, stefanwagner's, Thanks for reply, You are right..i am replacing '\\' with '\\\\\\\\'. But when i usr regExp = '(d*-d*-d)', it can't match to original string.. i.e matches() = false and my replacement not happend. here is my snippet... String fnp =null; //String regExp =...

hi, I am using postgres 7.4.6 and java 1.4. I have created a table, like create table usr (usr_id varchar(15), usr_filename_pattern varchar(1024)); insert into usr values ('A', '(d*-d*-d)'); insert into usr values ('B', '(dd-dd-dd)'); insert into usr...

Hi, All, i have problem in postgres db insert.. Here is my problem. i have created table like..(for this question purpose only---Actual table defination is different) 1) Create table tab1(usr_id varchar(15), usr_name varchar(20),usr_filename_pattern varchar(1024)); insert table tab1...

Hi, all, i have problem in postgres db insert.. Here is my problem. i have created table like.. 1) Create table tab1(usr_id varchar(15), usr_name varchar(20),usr_filename_pattern varchar(1024)); insert table tab1 values('A','Mr. A','A\\d\\d\\d\\d'); Record is successfully...

hi, Venu, Thank you very much for your reply. But Still i have some confusion.. actually i am developing web application using struts/servlet/jsp .. here is my jsp page for your ready reference. ***** <%@ page import=" app.util.Profile, app.database.HospitalDAO...

i am new in jsp. can any body give me an idea how i can add multiple selection from dropdown and added this multiple selection in one int field of database... e.g. drop down contens 0|1|2|3|4|5|6|7.... user has selected 3|5|6|7 added into database as 3|5|6|7 as per multiple...

hi, Sedj, Thanks for reply.. you have answer me And your constructors for the class "XmlDocument" look like ... but i can't understand what you say.. Actuly i am using dbxml.jar in which XmlDocument class resides.. i have not write it... pl. reply specific solution for this proble...

hi, I got the error...(Constructor is not visible).. here is my code... ***** import java.io.FileWriter; import java.io.IOException; import org.apache.struts.action.*; import javax.servlet.http.*; import javax.xml.parsers.*; import javax.xml.transform.*; import...

sorry, Method name i have change.. getDoctorNameFromHosId(int hosId) to getDoctorNameUsingHosId(int hosId) ketan

sorry, Method name i have change.. getDoctorNameFromHosId(int hosId) to getDoctorNameUsingHosId(int hosId) ketan

Hi, i am newbie to struts/jsp/java.. here is server.log snippet... 18:01:51,442 ERROR [Engine] ApplicationDispatcher[/action] Servlet.service() for servlet jsp threw exception java.lang.NoSuchMethodError: app.database.DoctorDAO.getDoctorNameFromHosId(I)Ljava/util/ArrayList; at...

Hi, i am newbie to struts/jsp/java.. here is server.log snippet... 18:01:51,442 ERROR [Engine] ApplicationDispatcher[/action] Servlet.service() for servlet jsp threw exception java.lang.NoSuchMethodError: app.database.DoctorDAO.getDoctorNameFromHosId(I)Ljava/util/ArrayList; at...

hi, sedj, Thanks for replay... i have added LD_LIBRARY_PATH=actual/path/of/.so also put .so file in /usr/lib dir and restart the jboss server and try to execute the web application ...but it give me the same error java.lang.UnsatisfiedLinkError: no db_java-4.3 in java.library.path...

i think i have to change the run.sh of jboss server. but how? here is my run.sh for your ready reference.. ***** #!/bin/sh ### ====================================================================== ### ## ## ## JBoss...

hi, dian & sedj Thanks for repaly.. I am sure that i am using servlet, so this exception thrown by server side. i have to set somthing on jboss server. As per my knowledge, i have to change run.sh for jboss. make change such that while executing java programm it directly take...

hi, Dian, Thanks for replay.. you are right ..i am using servlet... But it is not practically possible to put this shared library on every user computer...because for web application, user can access the application worldwide.. pl. give other solution.. ketan