Skip to Main Content

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.

Live (Completed) JSRs

kariannaJul 25 2016 — edited Aug 7 2016

This page lists the JSRs that have been completed during the lifetime of the Adopt A JSR programme and the JUGs, Individuals or organisations that adopted them,

thanks for helping improve Java! There's still plenty of work that can be done on these, especially if they are new. You can engage in educational efforts (workshops),

work on alternative implementations, work on maintenance fixes and much more!

Live JSRs (<= #300)

JUG/Individual/
Organisation
JSR-48
(WBEM Services)
JSR-107
(JCache)
JSR-236
(Concurrency utilities
for Java EE)

JSR 269

(Pluggable Annotation
Processing API)

JSR-286
(Portlet 2.0)
Hyderabad JUG107
LJC107 Page

Live JSRs (#301 <= #340)

JUG/Individual/
Organisation
JSR-308
(Type
Annotations)
JSR-310
(Date & Time)
JSR-321
(Trusted
Computing)

JSR 329

(Portlet 2.0 Bridge
for JSF 1.2)

JSR-331
(Constraints
Programming)

JSR 335

(Lambdas)

JSR 337

(Java 8)

JSR-338
(JPA 2.1)
JSR-339
(JAX-RS 2.0)
ChennaiChennai
Guadalajara JUGJSR 310JSR 339
Houston321 Link TBA
Hyderabad JUGHyderabad JUGHyderabad JUG
JoziJUGJSR 310JSR 335
LJC308 Page310 Page335 Page337 Link TBA339 Page
MoroccoJUG339 page
PeruJUG339 Link TBA
SouJava310335339 Link TBA
JogLoSemar#339
Java Hellenic User Group - JHUG339

Live JSRs (#340 --> #349)

JUG/Individual/
Organisation
JSR-340
(Servlet 3.1)
JSR-341
(EL 3.0)
JSR-342
(JavaEE 7)
JSR-343
(JMS 2.0)
JSR-344
(JSF 2.2)
JSR-345
(EJB 3.2)
JSR 346
(CDI 1.1)
JSR-348
(JCP.next)
JSR-349
(Bean Validation 1.1)
FASOJUG343 Link
Guadalajara JUGJSR 346
JUGC344 page346 page
LJC341 Page342 Page343 Page344 Page345 Page346 PageLJC JSR-348 Page349 Page
PeruJUG343 Link TBA
SouJava344 Link TBA348 Link TBA349 Link TBA
SouJava344 Link TBA348 Link TBA349 Link TBA
JogLoSemar#342#344#345

Live JSRs (#350 --> #359)

JUG/Individual/
Organisation
JSR-352
(Batch processing)
JSR-353
(JSON API)
JSR-354
(Money and Currency)
JSR-355
(JCP.next II)
JSR-356
(Websockets)

JSR-359

(SIP Servlet 2.0)

Bejug356 page
CEJUG354 Page
Chennai354 Page
CLOJUG354 Page
CongoJUG353 Link TBA
LJC352 Page353 Page354 Page355 Page356 Page359 Page
MoroccoJUG353 page
PeruJUG353 Link TBA
SouJava352 Link TBA353 Link TBA355 Link TBA
Toronto JUG353 Link TBA
JogLoSemar#356

Live JSRs (> #360)

JUG/Individual/
Organisation
JSR-360
(CDLC 2.0)
JSR-361
(ME Embedded Profile)
JSR-364
(Broadening Membership)
EGJUG364
MoroccoJUG364
LJCLink TBA
SouJava364

Back to Who Is Adopting JSRs

   

Comments

450441
Isn't DENSE_RANK() OVER (partition by c_id, name ... ) what you want?
Aketi Jyuuzou
with WorkView as (
SELECT 'GULSU1' NAME, 111 C_ID,10 as SortKey FROM DUAL UNION
SELECT 'GULSU1', 111,20 FROM DUAL UNION
SELECT 'GULSU1', 111,30 FROM DUAL UNION
SELECT 'GULSU1', 111,40 FROM DUAL UNION
SELECT 'GULSU1', 111,50 FROM DUAL UNION
SELECT 'GULSU1', 111,60 FROM DUAL UNION
SELECT 'GULSU1', 111,70 FROM DUAL UNION
SELECT 'GULSU1', 111,80 FROM DUAL UNION
SELECT 'GULSU1', 111,90 FROM DUAL UNION
SELECT 'GULSU2', 112,100 FROM DUAL UNION
SELECT 'GULSU2', 112,110 FROM DUAL UNION
SELECT 'GULSU2', 112,120 FROM DUAL UNION
SELECT 'GULSU2', 112,130 FROM DUAL UNION
SELECT 'GULSU2', 112,140 FROM DUAL UNION
SELECT 'GULSU2', 112,150 FROM DUAL UNION
SELECT 'GULSU2', 112,160 FROM DUAL UNION
SELECT 'GULSU1', 112,170 FROM DUAL UNION
SELECT 'GULSU1', 112,180 FROM DUAL)
select NAME,C_ID,SortKey,
sum(willSum) over(partition by NAME order by SortKey) as version
from (select NAME,C_ID,SortKey,
       case when lnnvl(NAME = Lag(NAME) over(order by SortKey))
            then 1 else 0 end as willSum
       from WorkView)
order by SortKey;

NAME    C_ID  SortKey  version
------  ----  -------  -------
GULSU1   111       10        1
GULSU1   111       20        1
GULSU1   111       30        1
GULSU1   111       40        1
GULSU1   111       50        1
GULSU1   111       60        1
GULSU1   111       70        1
GULSU1   111       80        1
GULSU1   111       90        1
GULSU2   112      100        1
GULSU2   112      110        1
GULSU2   112      120        1
GULSU2   112      130        1
GULSU2   112      140        1
GULSU2   112      150        1
GULSU2   112      160        1
GULSU1   112      170        2
GULSU1   112      180        2
On Oracke9i,
we must emulate lnnvl.

similar thread
450745

and my site :-)
http://www.geocities.jp/oraclesqlpuzzle/10-130.html
1 - 2

Post Details

Added on Jul 25 2016
0 comments
756 views