JDeveloper – Updating a ViewObject’s Query Offline

While maintaining some JAX-WS Web Services I built using ADF Business Components (such as View Objects, Entity Objects, Application Modules, etc), I found a way to edit a View Object’s query without having a connection to the JDeveloper project’s database. This is useful for me because I work from home and do not always have easy access to the databases we work with, but still want to get a bit of work done, but it’s not quite obvious you can do this without directly editing the XML file.

To edit a ViewObject’s query offline:

  1. Open the View Object
  2. Go to the Query side tab
  3. Click the pencil icon above the query to open the query (you’ll be told you’re not connected– click OK)
  4. Make your changes and press Apply or OK.
  5. Here you’ll be told you’re not connected again, close the window by pressing X, but don’t click ok.
If you follow the instructions above, particularly closing the dialog rather than pressing OK, your ViewObject’s query should be edited! Just make sure to test it when you have access to the database again!

 

Screenshot of Offline View Object editing

Make sure not to press OK here! Just close the dialog.

 

Installing Glassfish on Ubuntu Server 11.04 (No GUI)

Because the self-extracting shell script used to install Glassfish requires the use of a GUI by default, installing Glassfish on a system like Ubuntu Server is not quite a straightforward is one may think.

To install Glassfish without a GUI, one must use a not-so-known silent install mode. To do this, an answer file (a text file that contains installation settings) must be supplied using argument -a, and argument -s must be supplied. For example:

./glassfish-3.1-unix.sh -a answerFileName -s

To generate an answer file, however, one must run the installer in trial mode:

./glassfish-3.1-unix.sh -n answerFileName

The only problem with this is that generating the answer file in trial mode also requires the use of a GUI. In my case, I wanted to install Glassfish on my Natty Ubuntu Server on Amazon EC2, which does not have a GUI. Using another Ubuntu machine I generated an answer file to install using silent mode (see above).

If you’d like to use the answer file I used: Click here. This answer file has the most basic settings set, with an admin password of “password.”

Hopefully this saves someone a little time!