Skip to Main Content

Embedded Technologies

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

JVM support for PPC HP h5500 + Web Service Execution

843849Nov 21 2004 — edited Feb 7 2005
Hi,
Well i have a HP PPC h5500 (P2 400mhz, 128 mb RAM, WIN CE) and i want to execute Semantic Web Services on it. The softwares i will be using require Java 1.3 or above. The api or S/W i'll be requiring are :

1) Java OWL-S api
2) RDF Parsers (jena api)
3). XSLT parser api
4). WSDL parser (AXIS soap engine)

In all i'll be using XML parsing regressively. I have read from few sources that there are currently 3 JVM's available for PPC and all of them have JDk 1.1.8 support :

1). IBM J9 JVM
2). NSICOM's CrEme JVM
3). Insignia's Jeode JVM (comes in bundle with the above specified PPC)

Now is that true that SUN has no J2ME specification (JVM) for PPCs ?

I have seen few JSRs at sun.com like JSR 172: J2METM Web Services Specification and JSR 75: PDA Optional Packages for the J2METM Platform, so how could these be put into use ?

What about performance issues if anybody has experienced this practically ?

What could be the best solution for me i mean JVM to select from above or anyother if available that should support JDK 1.3 of above ?

Why there are those 2 JSRs avaialble if sun doesnot provide JVM for PDAs ?

I will also be requiring an application server on my PPC and somebody has suggested me to check Jetty for that + soap engine AXIS, so all this seems little resource requiring but i'm not sure whether this works or not.

In all i'm in desperate need to check for all these situations but i'm quite confused
in how to get myself started. i'm very much new to this J2ME environemnt so need some help.....

Pls do also suggest me some meaningful pointers where i can assess how much resources does my PPC support.

Few more info about my PPC if i'm not wrong : MIDP 2.0/CLDC 1.1, CDC/Foundation/Personal Profile 1.0, JSR-075 FileConnection and PIM optional packages on either profile.

Looking forward to some good replies.
Regards.

Comments

munky
Sample data?
Expected output?
CREATE TABLE and INSERT statements?

Please provide us with enough information to give you a solution. You may want to look up CONNECT_BY_ROOT.

Cheers

Ben
user5605610
SELECT empno,
ename,
job,
mgr,
hiredate,
level
FROM emp
START WITH mgr IS NULL
CONNECT BY PRIOR empno = mgr


7839 KING PRESIDENT 1
7566 JONES MANAGER 2
7788 SCOTT ANALYST 3
7876 ADAMS CLERK 4
7902 FORD ANALYST 3
7369 SMITH CLERK 4
7698 BLAKE MANAGER 2
7499 ALLEN SALESMAN 3
7521 WARD SALESMAN 3
7654 MARTIN SALESMAN 3
7844 TURNER SALESMAN 3
7900 JAMES CLERK 3
7782 CLARK MANAGER 2
7934 MILLER CLERK 3


For example if child_name = 'MILLER' in the where clause, it should return 'KING'.

Thanks.
munky
Hi
SELECT     empno,
           ename,
           job,
           mgr,
           hiredate,
           LEVEL,
           CONNECT_BY_ROOT ename
FROM       emp
START WITH mgr IS NULL
CONNECT BY PRIOR empno = mgr
You should be able to work it out from that.

Cheers

Ben
user5605610
But, nee to search for the root level manager for a given employee. My input would be employee name.

Thanks
Frank Kulash
Hi,

What you posted is a Top-Down Query , but what you want is a Bottom-Up Query . Just reverse the CONNECT BY condition, and add the WHERE clause:
SELECT 	empno, 
	ename, 
	job, 
	mgr, 
	hiredate,
	level 
FROM 	emp 
WHERE	CONNECT_BY_ISLEAF	= 1
START WITH  ename	= 'MILLER'
CONNECT BY  empno 	= PRIOR mgr
;
"Leaf", as in "CONNECT_BY_IS<b>LEAF</b>" is relative to the CONNECT BY clause, which may be exactly the opposite of how you normally view the data.
A "leaf" is a node that at LEVEL=n, not connected to any nodes at LEVEL=(n+1).
In this query, the only node that is a leaf is the one you might normally think of as the root.
munky
So.. no attempt to work it out then?

What about
WITH my_data AS
(
 SELECT     empno,
            ename,
            job,
            mgr,
            hiredate,
            LEVEL,
            CONNECT_BY_ROOT ename AS root_boy
 FROM       emp
 START WITH mgr IS NULL
 CONNECT BY PRIOR empno = mgr
)
SELECT root_boy
FROM   my_data 
WHERE  ename = :p_name
Cheers

Ben
NSK2KSN
Answer
TRY THIS,
SELECT     ename, PRIOR  ename MGRNAME
      FROM emp
     WHERE ename = <INPUT YOUR ENAME HERE>
START WITH mgr IS NULL
CONNECT BY PRIOR empno = mgr
Edited by: NSK2KSN on Aug 9, 2010 6:10 PM
Marked as Answer by user5605610 · Sep 27 2020
munky
Oops, yeah use Frank's - much neater. I'd keep the root_boy alias though! ;)
munky
Hi

You've marked the incorrect answer correct. It will give you the wrong results. It only goes back one level - not to the root.

Cheers

Ben
1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 7 2005
Added on Nov 21 2004
1 comment
156 views