Pawan Choure

Greenhorn
+ Follow
since May 11, 2008
Pawan likes ...
Eclipse IDE Oracle Windows
Merit badge: grant badges
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
3
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Pawan Choure

Hi I am trying to download and install PMD plugin for eclipse but did not suceed in doing so.

I downloaded the following 2 zips
  • net.sourceforge.pmd.eclipse-3.2.6.v200903300643.zip (this version matches with the one which i installed online)
  • pmd-eclipse-1.8.0

  • Not sure which one to use and how to confiure it in eclipse.

    I search lot but did not find proper steps for the offine installation and configuration.


    Thanks in advance,
    Pawan
    Thanks for youe reply Ulf, Will surely try that, I just wanted to confirm , what will be the port number in that case or there is no need to provide port number in the URL.
    12 years ago
    I didn't get what you said about the physical IP, i have connected my andriod device with my pc using USB cable....
    12 years ago
    I have developed an application in android using ksoap2 which used local .NET webservice and it works perfectly fine on the Emulator but when i connected the device the application starts on he device but the web service call does not work

    I think i need to change the URL for the webservice.Given below is the current URL which i am using and it works on emulator but doesnt work on android device.

    String NAMESPACE = "http://tempuri.org/";
    String URL = "http://10.0.2.2:12736/InventoryWebService.asmx";



    I google and tried many options but no help , so can anyone have any idea regarding the same then please do reply.

    12 years ago
    Thanks for your reply.
    I got it working by divide by 100...
    12 years ago
    JSP
    Hi,
    I want to format a number as given below

    Number 5.75
    Expected output:5.75%



    Output is 575%
    which is wrong since the expected output is 5.75%

    I can achieve the expected output using


    but i dont want to use that. I want to use either percent or pattern to get the desired result.

    Thanks in advance......




    but when i am changing
    12 years ago
    JSP
    you can search for that plugin in Eclipse Market place.
    http://marketplace.eclipse.org/
    You can change the Port Number by Editing the Config.xml file is your user project.
    Given below is the sample location

    C:\Oracle\Middleware\user_projects\domains\base_domain\config\config.xml

    Edit that file.

    <server>
    <name>AdminServer</name>
    <listen-port>7007</listen-port> change this to the desired Port Number you want.
    <listen-address></listen-address>
    </server>
    12 years ago
    Hi,
    I want to know how can i permanently remove the GlassFish Server from GlassFish Tool Bundle for Eclipse.
    12 years ago
    Hi,
    I want to retrieve distinct result using decode function and given below are the queries for that.

    SELECT DISTINCT O.*, DECODE(TA,'AP',AMT,'AC1',AMT,'AC2',AMT,'AC3',AMT,'AC4',AMT,NULL) AS CA,
    DECODE(TA,'AD1',AMT,NULL) AS DA FROM HT O, HIS H, V_CV
    WHERE O.HID=H.HID AND H.HTYP='TRN' AND O.HID = V.HID AND V.CID = '5' ORDER BY CA ASC;

    which gives me

    HID TA PT AMT CA DA
    2 A V 4.1 4.1 null
    3 C V 14.02 14.02 null
    1 D V 5.1 null 5.1
    4 D V 6.21 null 6.21

    which is correct but i want to do sorting on two different column which do not exit in the database and they are dynamic.So i Modified the Query but i am getting duplicate results

    SELECT DISTINCT O.*,
    DECODE(o.TA,cr.TA,o.AMT,NULL) AS CA,
    DECODE(o.TA,de.TA,o.AMT,NULL) AS DA
    FROM HT O,
    HIS H,
    V_CV,
    (select TA from RTD where Ttype= 'C') cr,
    (select TA from RTD where Ttype= 'D') de
    WHERE
    O.HID=H.HID
    AND H.HTYP='TRN'
    AND O.HID = V.HID
    AND V.CID = '5'
    ORDER BY CA ASC

    which gives me

    HID TA PT AMT CA DA
    2 A V 4.1 4.1 null
    3 C V 14.02 14.02 null
    3 C V 14.02 null null
    1 D V 5.1 null 5.1
    1 D V 5.1 null null
    4 D V 6.21 null 6.21
    2 A V 4.1 null null

    which is obviously giving HID 2,3,1 as duplicate value since DECODE select a value and compares with all item where i want only single comparison.

    Any help regarding this would be appreciated.

    13 years ago
    I have to get two different result on the same table.First Result will be get first then added by Second result



    Custid Name Nextactiondt priorityscr lastacssts
    65 A 16-JUN-11 11.52 14-MAR-11
    84 B 16-JUN-11 1.38 14-MAR-11
    93 C 17-JUN-11 0 18-APR-11





    Custid Name Nextactiondt priorityscr lastacssts
    59 S 16-JUN-11 1212 16-JUN-11



    I want to club the result of the two query into 1 as follows.

    Custid Name Nextactiondt priorityscr lastacssts
    65 A 16-JUN-11 11.52 14-MAR-11
    84 B 16-JUN-11 1.38 14-MAR-11
    93 C 17-JUN-11 0 18-APR-11
    59 S 16-JUN-11 1212 16-JUN-11



    but when i am using UNION



    I am getting

    Custid Name Nextactiondt priorityscr lastacssts
    59 S 16-JUN-11 1212 16-JUN-11
    65 A 16-JUN-11 11.52 14-MAR-11
    84 B 16-JUN-11 1.38 14-MAR-11
    93 C 17-JUN-11 0 18-APR-11



    but that is different from what i expect

    Custid Name Nextactiondt priorityscr lastacssts
    65 A 16-JUN-11 11.52 14-MAR-11
    84 B 16-JUN-11 1.38 14-MAR-11
    93 C 17-JUN-11 0 18-APR-11
    59 S 16-JUN-11 1212 16-JUN-11



    so any one know how can i append the results of two queries into one since i have order by clause in both queries and i can club them together.
    Any help regarding this would be appreciated

    13 years ago
    Hi,
    Actually i want to select customers from the table whose lastacssts should be greater than the time i will be getting from Date object in JAVA.
    What i am doing is getting that value from JAVA date which returns the date object in following format

    Thu May 26 18:07:57 GMT+05:30 2011



    but when i want to execute the above query in ORACLE i am not getting the abbreviation CODE .Given below is the Oracle query i am executing


    The Datatype of lastacssts is Date in ORACLE


    I Get Following Error

    ORA-01857: not a valid time zone
    01857. 00000 - "not a valid time zone"
    *Cause:
    *Action:



    So anyone has any idea about how can i represent GMT in oracle Query because when i remove GMT from the query and just place +05:30 it runs fine but from JAVA
    I am getting GMT+05:30 and i cant separate GMT from +05:30.I searched on internet but did not find any solution for that.

    Any Help Regarding this would be appreciated.

    Thanks in advance
    13 years ago
    Hi,
    I want to include "<" in the named-native-query in the orm.xml.I am able to use ">" but for "<" It is showing tag Missing closing bracket
    Any Help Regarding this would be appreciated.
    Hi Vicky
    if you want user to input minimum 10 values then you can use Following Regular Expression


    This will make sure user will have to enter 10 Correct Values.Even if user enters 4 correct values the validation will fail since the pattern requires 10 input values.

    if you want it in range.for example user can enter minimum 2 and maximum 10 values then the regular expression will be



    Hope this will solve your problem.

    Matthew Brown wrote:What Paul's getting at is that that's a bit unusual. Would these be valid?
    11111111?
    111&11111
    1_1"1'1(1
    1*******1

    They don't have letters in. Are you really sure they should be valid? If not, then forget about the letters and define your requirements in terms of what is allowed, not what is forbidden.




    That is invalid but i have handled that and its working fine.i need regex for the following mentioned scenario.
    111111111:Valid
    11111111A:Invalid
    A11111111:Invalid
    1234F1111:Invalid
    13 years ago