Java EE (Java Enterprise Edition) General Discussion

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.

WebSphere 6.1.0 and JSF

843844Jan 16 2008

Hi All,

I try to start application on WebSphere version 6.1.0 trial and it does not work because WAS uses own JSF (com.ibm.ws.webcontainer_2.0.0.jar). I found out that class loader mode should be set to PARENT_LAST. it's necessary to use JSF libraries from web-inf/lib. Otherwise, WebSphere will continue to use its own JSF implementation.

I tried to change Class Loader as below but it did not work:

Enterprise Applications > app1 > Class loader

1. Class loader order -> Classes loaded with parent class loader first
2. WAR class loader policy -> Single class loader for application

The following error appears:

Extension processor failed to initialize in factory: com.ibm.ws.jsp.webcontainerext.ws.WASJSPExtensionFactory@313a313a
java.lang.NoSuchMethodError: com/sun/faces/util/Util.getLogger(Ljava/lang/String;)Ljava/util/logging/Logger;
at com.sun.faces.application.WebappLifecycleListener.<clinit>(WebappLifecycleListener.java:67)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:177)

Does anybody know how resolve this problem?

Thanks.

damorgan

Use a WHERE clause.

WHERE col1 <> 'Y'
AND col2 <> 'Y'

user626688

No. It will not work.. because by using <>'Y' i will get ID 40 also, which i donot want because in some other occurences of 40 there are 'Y'. I want only those values for which there is no 'Y' in any of its occurences. If an ID has 'Y' anywhere then that ID disqualifies even if it has 'N' for both DEF_BILL and DEF_SH in any of its occurences... Thanks.. I think we may have to think further with GROUP BY....

Tubby

This should be of help...

ME_XE?with data as
  2  (
  3     select 1 as col1, 'Y' as col2 from dual union all
  4     select 1 as col1, 'N' as col2 from dual union all
  5     select 2 as col1, 'Y' as col2 from dual union all
  6     select 3 as col1, 'N' as col2 from dual
  7  )
  8  select col1, col2, SUM(decode(col2, 'Y', 1, 'N', 0)) over (partition by col1) as keepers
  9  from data
 10  /

              COL1 COL            KEEPERS
------------------ --- ------------------
                 1 Y                    1
                 1 N                    1
                 2 Y                    1
                 3 N                    0

4 rows selected.

Elapsed: 00:00:00.01
ME_XE?
ME_XE?
ME_XE?with data as
  2  (
  3     select 1 as col1, 'Y' as col2 from dual union all
  4     select 1 as col1, 'N' as col2 from dual union all
  5     select 2 as col1, 'Y' as col2 from dual union all
  6     select 3 as col1, 'N' as col2 from dual
  7  ),
  8     step_2 as
  9  (
 10     select col1, col2, SUM(decode(col2, 'Y', 1, 'N', 0)) over (partition by col1) as keepers
 11     from data
 12  )
 13  select *
 14  from step_2
 15  where keepers = 0
 16  /

              COL1 COL            KEEPERS
------------------ --- ------------------
                 3 N                    0

1 row selected.

Elapsed: 00:00:00.00
ME_XE?

629718

table t_idfile
data in T_idfile is as below:

ID col1 col2
20 N N
20 N Y
20 Y N
30 N N
30 N N
40 Y Y
40 N N
40 N Y

select id from t_idfile where col1 = 'N' and col2 = 'N' and id not in (select id from t_idfile where col1= 'Y' or col2 = 'Y');

615436

Although, it might be better to specify the predicates"col1 = 'N' and col2 = 'N'" in WHERE clause for performance,
I thought that it is not necessary to specify the predicates.
Like this:

SELECT DISTINCT
       id
  FROM ID_Tbl
 WHERE id NOT IN
          (SELECT id
             FROM ID_Tbl
            WHERE def_bill = 'Y' OR def_sh = 'Y'
          )
;

Generally speaking, you can use [NOT] EXISTS predicate instead of [NOT] IN predicate.

SELECT DISTINCT
       id
  FROM ID_Tbl A
 WHERE NOT EXISTS
       (SELECT *
          FROM ID_Tbl B
         WHERE B.id = A.id
           AND (def_bill = 'Y' OR def_sh = 'Y')
       )
;

Another ideas are:

SELECT id
  FROM ID_Tbl
 GROUP BY id 
HAVING COUNT(CASE def_bill WHEN 'N' THEN 0 END) = COUNT(*)
   AND COUNT(CASE def_sh   WHEN 'N' THEN 0 END) = COUNT(*)
;

SELECT id
  FROM ID_Tbl
 GROUP BY id 
HAVING SUM(INSTR(def_bill, 'N')) = COUNT(*)
   AND SUM(INSTR(def_sh  , 'N')) = COUNT(*)
;

SELECT id
  FROM ID_Tbl
 GROUP BY id 
HAVING MAX(def_bill) = 'N' AND MIN(def_bill) = 'N'
   AND MAX(def_sh  ) = 'N' AND MIN(def_sh  ) = 'N'
;

user626688

Thanks

user626688

Thanks dear

Aketi Jyuuzou

select id
  from ID_Tbl
group by ID
having min(case when 'N' = all(DEF_BILL,DEF_SH) then 1 else 0 end) = 1;

similar threads(OTN)
585154
551338
621506

similar threads(OTN-Japan)
http://otn.oracle.co.jp/forum/thread.jspa?threadID=35002855
http://otn.oracle.co.jp/forum/thread.jspa?threadID=35003244

1 - 8

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2008

Added on Jan 16 2008

#javaserver-faces

0 comments

192 views

Java EE (Java Enterprise Edition) General Discussion

WebSphere 6.1.0 and JSF

Comments

Post Details