Skip to Main Content

Java Development Tools

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!

Reg : Shared Application Issue in Master-Detail Relationship

713435Sep 11 2009 — edited Sep 14 2009
Hi,

I have created a Master-Detail relationship using Read-Only View Objects between EMP and DEPT table. After creation I have deployed the same as ADFLibraryJAR and used them in 2 different application as Shared Library.

In *1st Application* I have used EMP Table in a JSFF Page.
In the *2nd Application* I have used the DEPT table independently in a JSFF Page.

After creation of the individual Applications I have deployed their View Controllers as ADFLibraryJAR and used the same in a different application(MainApplication).

In the Main Application, I have created a JSPX with a Horizontal Splitter and dropped the respective individiual Bounded Task Flow's in Left and Right facets of the Horizontal Splitter.

After rendering the file, the expected output is that on click of the EMP Table from 1st Application, should trigger the DEPT Table to display the relevant Department Details as I have already declared a Master-Detail relationship in the base Entity of the Shared Applications.

Also I have given Partial Trigger for Department Region to refresh based on Employee Region. Hence refresh happens. But the Department details isn't displaying the relevant data.

Is this approach correct ? If so why ain't I getting the department table details.

REASON for Approach : I am trying to have a central access on Entity Objects for my Project. Hence have created Entity, View Objects, View Links in an individual Application and shared the same.

Kindly guide.

--
Dominic

Comments

Can you try with latest version of 1.8 java

Java SE Development Kit 8 - Downloads

user11980779

#echo $JAVA_HOME

/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162

#which java

/u01/orabin/system/sqlcl/jdk_8u162/jdk1.8.0_162/bin/java

#java -version

java version "1.8.0_162"

Java(TM) SE Runtime Environment (build 1.8.0_162-b12)

Java HotSpot(TM) 64-Bit Server VM (build 25.162-b12, mixed mode)

#/u01/orabin/system/sqlcl/dbtools-sqlcl-18.1.0/bin/sql

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

user11980779

I do not get the "Access is denied"

Steve S.

I'm getting the same issue with sql 18.1.1 and java 1.8.0.72.

sql     

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

java version "1.8.0_172"

Java(TM) SE Runtime Environment (build 1.8.0_172-b11)

Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)

Steve

user11980779

I´ve opened a SR and the engineer confirmed that there is an issue with jline.jar in 18.1 version.

Workaround: replace jline.jar from 18.1 by the one provided by 17.4

user11980779

The bug number is 28086841: SQLCL COMMAND FAILS TO START WITH ERROR JANSI (NOT FOUND IN JAVA.LIBRARY.PATH)

According to the engineer this bug should be fixed in upcoming 18.2 release

user11980779

issue not fixed in 18.2

bug note is now public and it says fixed in 18.3

user11980779

issue not fixed in 18.3 either

onedbguru

Yep, same problem in 18.3.0.259.2029

(Solaris 10)

unsupported major.minor version 52.0

OR

Exception in thread "main" java.lang.UnsatisfiedLinkError: Could not load library. Reasons: [no jansi in java.library.path]

        at org.fusesource.hawtjni.runtime.Library.doLoad(Library.java:182)

        at org.fusesource.hawtjni.runtime.Library.load(Library.java:140)

        at org.fusesource.jansi.internal.CLibrary.<clinit>(CLibrary.java:42)

        at org.fusesource.jansi.AnsiConsole.wrapOutputStream(AnsiConsole.java:48)

        at org.fusesource.jansi.AnsiConsole.<clinit>(AnsiConsole.java:38)

        at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:429)

java version "1.8.0_172"

Java(TM) SE Runtime Environment (build 1.8.0_172-b25)

Java HotSpot(TM) 64-Bit Server VM (build 25.172-b25, mixed mode)

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

Post Details

Locked on Oct 12 2009
Added on Sep 11 2009
1 comment
281 views