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.

I didn't get what you said about the physical IP, i have connected my andriod device with my pc using USB cable....

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.

Thanks for your reply.
I got it working by divide by 100...

Hi,
I want to format a number as given below

Number 5.75
Expected output:5.75%


<fmt:formatNumber value="5.75" type="percent" maxFractionDigits="4" maxIntegerDigits="4"/>
Output is 575%
which is wrong since the expected output is 5.75%

I can achieve the expected output using
<fmt:formatNumber value="5.75" maxFractionDigits="4" maxIntegerDigits="4"></fmt:formatNumber>%

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

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>

Hi,
I want to know how can i permanently remove the GlassFish Server from GlassFish Tool Bundle for Eclipse.

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.

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

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A' AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)<trunc(current_date) ORDER BY cust.nextactiondt,cust.priorityscr desc

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

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A' AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)=trunc(current_date) ORDER BY cust.lastacssts,cust.nextactiondt,cust.priorityscr desc

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

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A' AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)<trunc(current_date) UNION SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A' AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)=trunc(current_date) ORDER by 3,4 desc,5

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

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
SELECT distinct cust.custid FROM Customer cust WHERE cust.custid! = '123' AND (cust.lastacssts >TO_TIMESTAMP_TZ('Tue May 24 20:11:20 GMT+05:30 2011', ' DY MON DD HH24:MI:SS TZDTZH:TZM YYYY'))

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

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

^[A-Za-z0-9]{10}$"
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

^[A-Za-z0-9]{2,10}$"

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