//AMIS Technology Blog » Tools » Page 2

Tools

Everything that is not part of the final application

image.png

JavaOne 2012: The Big Stories

4

The show is over, the people are gone and the cleaning can start.

What do we take home from JavaOne 2012?

That depends on who you ask. Some people primarily will have taken goodies from the exhibition floors with them while other may have focused on less tangible goods and gone for inspiration and vision. After the heyday (2006/2007), some waning years and the robust recovery (2011) after an initially tentative turn around (2010) this year seems to have been one of consolidation and careful further evolution. Some choices have been made – not all of them popular but most apparently sensible and reliable because backed by commercial sense.

(more…)

image.png

JavaOne 2012: Strategy and Technical Keynote

0

JavaOne 2012 is underway.

While the double entendre of ‘SUNday’ no longer exists, this first day is still an important day. To set the stage, manage expectations, build on the atmosphere and layout the roadmap (starting that sometimes not even subtle massaging of the minds). The keynote sessions are the key events that define scope and themes for the conference.

Java is very much on the move again. After the virtual stand still just before and for a while after Oracle took over (from) Sun, last year saw a dramatic increase in the Java movement. This year that thread continues. Not with many spectacular announcement, but with a solid pursuit of earlier roadmaps and an apparently good collaboration between vendors in the Java space. The one big elephant in the room – that is actually not in the room at JavaOne – is Google. Otherwise for example, Oracle staff happily shared the stage for this keynote session with IBM.

This year’s overall slogan for JavaOne is: Make the future Java.

It is very much an invitation from Oracle to help bring the Java platform forward. In many ways: ideas, feedback, testing, propagating, creating code, joining JSR committees etc. Oracle and other vendors More >

SIG Event

WebLogic 12c released!

3

At December the 1st, 2011, Oracle announced it’s new major release, the 12c release. As Oracle added the i (internet) at its 8 release, the g(gridcomputing) at its 10 release, now the focus will be on the c(cloudcomputing).

Many new features come out of the fact that Oracle has made its key application server ready for the cloud, that is, ready for to run on enigineered systems, in fact its own Exalogic machine, Oracle’s solution for implementing the cloud.

So let’s take a look what this new release brings us, in this blogpost. There are several new features available in the 12c

New or enhanced WebLogic 12c features
  • JAVA EE 6 support all kinds of JEE6 specifications are implemented like :
    • JSF 2.0,Java Servlets 3.0 JPA 2.0 and EJB 3.1.
    • Managed Beans 1.0
  • WebLogic 12c also supports supports Java SE 7 (and Java SE 6).
    • Java language optimizations and Internationalization
    • Client and server support
    • SSL/TLS 1.2 in JSSE to support JAVA Socket Transport security
    • Converged Java VM:JRockit and HotSpot are  incorporated with the best features from both.The JVM convergence will be a multi-year process, which was confirmed during my presence at Oracle’s Publisher Seminar 2011 during
    More >
Vacatures bij AMIS services

ADF table filtering on MySQL is failing

0

Table filtering, aka Query by example, is a great feature of ADF tables. This feature provides filterboxes on top of a column(es).

and filters the data based on the values in the filterbox:

This works like a charm on an Oracle database, but when you use MySQL the filtering doesn’t work and actually doesn’t retrieve any data at all. As you can understand, this is not expected and definitely not wanted behaviour.

The first step in solving this behaviour was to enable logging (either via the weblogic diagnostic console or by adding -Djbo.debugoutput=console to the Java Options in the project properties Run configuration). In the log console we see that the SQL statement for this table collection / ViewObject now includes a where clause that includes the table filter value(s): ‘WHERE ( ( (EmployeesEo.FIRST_NAME LIKE ( :vc_temp_1 || ‘%’) ) ) )‘. This where clause with the % appended to the variable is automatically performed by the ADF framework.

As it turned out, this concatenation of the value with the % (:vc_temp || ‘%’) was the cause of our problem. This concatenation with a double pipe is a SQL92 standard. However with MySQL the concatenation is done with the concat function More >

Vacatures bij AMIS services

Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups

0

In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area. From 11gR2 on the incremental backup pieces will get the same tag as the datafile copies, and that’s actually different behaviour from pre- 11gR2 versions of the database.

I stumbled on this different behaviour when a backup script, that worked perfectly on 11gR2, got ported to 10gR2 and 11gR1 ( 11.1.7 ). The script contains a system cleanup of all incrementals, done before a certain date, specifying the tag of the copy [ 'COPY_DATABASE' ]. On 11gR2 the inc1 backups got deleted fine, but the delete on 10gR2 and 11gR1 just wouldn’t work.

By checking v$backup_piece…

select distinct tag from v$backup_piece where instr(tag,'TAG')=0;

…and getting no result, it became clear that the tag of the copy datafiles, was’t also the tag of the incrementals.

Once I knew, it was easy to correct the problem.

I just added the tag of my copy datafiles to the incremental backup, and that did the trick. All incrementals that were supposed to get cleared from the pre-11gR2 system, were deleted. The incrementals without tag, already on the system, were deleted

More >

Vacatures bij AMIS services

How to switch datafiles to FRA and back again

2

If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if you are in sudden need of extra disk space for your database, and the FRA still has ample space left. By switching one or more datafiles to the copy in FRA, you can very quickly use this extra disk space for your database, while not even having to shut down. I developed a view to generate all the rman commands to execute the switch to FRA, and the switch back to it’s original location and name. Use it at your own discretion.

CREATE OR REPLACE FORCE VIEW rman_switch_datafiles AS SELECT tablespace_name , file_name , file_id , '================================================'||chr(10) ||'  switch datafile '||file_id||' to copy in FRA  '||chr(10) ||'================================================'||chr(10) ||'run'||chr(10) ||'{'||chr(10) ||'sql ''alter tablespace '||tablespace_name||' offline'';' ||chr(10) ||'switch datafile '||file_id||' to copy;' ||chr(10) ||'recover datafile '||file_id||';' ||chr(10) ||'sql ''alter tablespace '||tablespace_name||' online'';'||chr(10) ||'}'||chr(10)  rman_switch2copy , More >
Go to Top