Skip navigation.

Feed aggregator

Log Buffer #382, A Carnival of the Vanities for DBAs

Pythian Group - Fri, 2014-08-01 07:41

Leading the way are the blogs which are acting as beacons of information guiding the way towards new vistas of innovation. This Log Buffer edition appreciates that role and presents you with few of those blogs.


Is there any recommended duration after which Exalytics Server should be rebooted for optimal performance of Server?

GlassFish On the Cloud Consulting Services by C2B2

This introduction to SOA Governance series contains two videos. The first one explains SOA Governance and why we need it by using a case study. The second video introduces Oracle Enterprise Repository (OER), and how it can help with SOA Governanc.

Oracle BI APPs provide two data warehouse generated fiscal calendars OOTB.

If you’re a community manager who’s publishing, monitoring, engaging, and analyzing communities on multiple social networks manually and individually, you need a hug.

SQL Server:

Spackle: Making sure you can connect to the DAC

Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ways that the customer expects, and to prove that it does so for the lifetime of the system.

Set a security standard across environments that developers can see and run, but not change.

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.

One option to get notified when TempDB grows is to create a SQL Alert to fire a SQL Agent Job that will automatically send an email alerting the DBA when the Tempdb reaches a specific file size.


By default when using MySQL’s standard replication, all events are logged in the binary log and those binary log events are replicated to all slaves (it’s possible to filter out some schema).

Testing MySQL repository packages: how we make sure they work for you

If your project does not have something that you can adapt that quote to, odds are your testing is inadequate.

Compare and Synchronize with Updated Comparison Tools!

Beyond the FRM: ideas for a native MySQL Data Dictionary.

Categories: DBA Blogs

How to Load Informix DB2 Using SSIS

Chris Foot - Fri, 2014-08-01 04:30

Can Microsoft SQL Server and Informix DB2 environments integrate together? The answer is YES!! I have received an increasing amount of questions concerning wanting to cross platform ETL development work between the two. Driven from these questions, I want to dig deeper into regards to manipulating data between Microsoft SQL Server and Informix DB2.

Recently, I have been asked to load data to Informix DB2 using SSIS which is the focus of my topic. When I was tasked with this request, I did some research and started to develop a solution. However, I ran into some common issues that had unanswered questions in regards to writing via Informix ODBC with SSIS out on the internet. Unfortunately, to this day, I have not seen an actual step- by- step blog about this topic based on my own personal searches. With that being said, I decided to blog about it myself.

Let’s start with the basic information first. What do you need to successfully use Informix with your SQL Server environment?

You should know, at minimum, the following:

  • What versions of the driver you have
  • What version of SQL Server is installed on your server
  • What the version of your operating system is

The version of the driver can cause unforeseen issues when trying to load into Informix via SSIS. Check how your ODBC driver is registered. You can do this by simply checking both 32 bit and 64 bit ODBC Data Source Administrator. Here are the commands for 32 bit and 64 bit respectively:

32 Bit: C:\Windows\SysWOW64\odbcad32.exe

64 Bit: C:\Windows\system32\odbcad32.exe

As you can see, I do have both registered in my current environment:

32 Bit

Image and video hosting by TinyPic

64 Bit

Image and video hosting by TinyPic

This is a common issue I have seen between the two. No matter if you have SQL Server 32 Bit or 64 Bit, BIDS is a 32 bit platform application, and the runtime of BIDS needs to be set to reflect this. This is done in the solution properties.

Image and video hosting by TinyPic

In the properties, you click the debugging option and set Run64BitRunTime from True to False.

Image and video hosting by TinyPic

Now, you are ready to set up your connections and build your package. In your connection manager, select where your source data is coming from. For my example, it’s going to be SQL Server, so I need an OLE DB connection. The destination I will use is an ADO.NET connection manager.

Image and video hosting by TinyPic

Here is the little piece that took a while to figure out. Your connection string within your ADO.NET connection manager needs to have “delimident=y” as an argument within the connection string.

Image and video hosting by TinyPic

Now, my connection string reads as follows:

Dsn=INFORMIX ODBC;Driver={ifxoledbc};delimident=y

Notice that I do not have my UID or password passed in through the connection string because they are already stored on my server when I set them up in my Data Source ODBC Administrator.

From here, I am going to simply set up my Dataflow with a source and destination using the connection managers that I have created and map all of my columns.

Image and video hosting by TinyPic

That’s it! Now, all you have to do is run it and test it.

Image and video hosting by TinyPic

I have just written 27 records to Informix DB2 via SSIS using the Informix ODBC driver provided by IBM! Extracting, Transforming, and Loading data (ETL) sometimes requires outside drivers and connection managers which require us to learn new thing, and we are learning new things every day in the development world. I hope that you found my blog informative and that it helps others reduce the search for writing to Informix via SSIS. Stay tuned for my next blog post in the next few weeks.

The post How to Load Informix DB2 Using SSIS appeared first on Remote DBA Experts.

JSON Parsing is Cake with WebLogic Server 12.1.3

Steve Button - Thu, 2014-07-31 18:46
Another feature of WebLogic Server 12.1.3 that developers will find really useful is the inclusion of an implementation of JSR-353 Java API for JSON Processing.

See Chapter 10 Java API for JSON Processing in the Developing Applications for Oracle WebLogic Server book @

The original JSR submission for this API provides a good description of what it sets out to do.

JSR 353: JavaTM API for JSON Processing
This new API, working from the foundations provided by earlier implementations such as Jackson, Jettison and Google JSon, provides a standard API for working with JSON from Java. The goals and objectives of the API are described in the specification request as:
 JSON(JavaScript Object Notation) is a lightweight data-interchange format.

Many popular web services use JSON format for invoking and returning the data.

Currently Java applications use different implementation libraries to produce/consume JSON from the web services. Hence, there is a need to standardize a Java API for JSON so that applications that use JSON need not bundle the implementation libraries but use the API. Applications will be smaller in size and portable.

The goal of this specification is to develop such APIs to:
  • Produce and consume JSON text in a streaming fashion(similar to StAX API for XML)
  • Build a Java object model for JSON text using API classes(similar to DOM API for XML)
WebLogic Server 12.1.3 includes a module which contains the API/implementation of this relatively lightweight but important API, enabling developers and applications to more easily work with JSON in a portable, standard manner.

 Unlike JAX-RS 2.0 and JPA 2, both of which have pre-existing specification versions that need to be supported by default, there are no additional steps required for applications to use this API with WebLogic Server 12.1.3.  It's simply included as a default module of the server and available for any application to make use of.
The API and implementation is located in this jar file in a WebLogic Server 12.1.3 installation:


In the my previous post, Using the JAX-RS 2.0 Client API with WebLogic Server 12.1.3
I have a short example of using the API to parse an JAX-RS supplied InputStream to marshall a JSON payload into a Java object.

GeoIp g = new GeoIp();
JsonParser parser = Json.createParser(entityStream);
while (parser.hasNext()) {
switch ( {
case KEY_NAME:
String key = parser.getString();;
switch (key) {
case "ip":
case "country_name":
case "latitude":
case "longitude":
case "region_name":
case "city":
case "zipcode":
The Java EE 7 tutorial has a section showing how to use the new javax.json API which is well worth having a look at if working with JSON is your thing.

Arun Gupta also has a good hands-on lab under development for Java EE 7 that uses the JSON API to read and write JSON into Java objects that represent a movie database.   His examples collaborate with JAX-RS to issue both GET and POST calls to read and update data using JSON payload.

Parallel Execution Skew - Summary

Randolf Geist - Thu, 2014-07-31 16:37
I've published the final part of my video tutorial and the final part of my mini series "Parallel Execution Skew" at concluding what I planned to publish on the topic of Parallel Execution Skew.

Anyone regularly using Parallel Execution and/or relying on Parallel Execution for important, time critical processing should know this stuff. In my experience however almost no-one does, and therefore misses possibly huge opportunities for optimizing Parallel Execution performance.

Since all this was published over a longer period of time this post therefore is a summary with pointers to the material.

If you want to get an idea what the material is about, the following video summarizes the content:

Parallel Execution Skew in less than four minutes

Video Tutorial "Analysing Parallel Execution Skew":

Part 1: Introduction
Part 2: DFOs and DFO Trees
Part 3: Without Diagnostics / Tuning Pack license
Part 4: Using Diagnostics / Tuning Pack license

"Parallel Execution Skew" series at

Part 1: Introduction
Part 2: Demonstrating Skew
Part 3: 12c Hybrid Hash Distribution With Skew Detection
Part 4: Addressing Skew Using Manual Rewrites
Part 5: Skew Caused By Outer Joins

Oracle Database 12c Release 1 ( Generally Available

Oracle Database Server is now generally available under Oracle Software Delivery Website and...

We share our skills to maximize your revenue!
Categories: DBA Blogs

July Security Alert

Paul Wright - Thu, 2014-07-31 15:25
Hi Oracle Security Folks, The July Oracle Security Alert is out. My part is smaller than last quarter as just an In-Depth Credit, but Mr David Litchfield makes a triumphal return with some excellent new research. There is a CVSS 9 and a remote unauthenticated issue in this patch so worth installing this one. [...]

New Oracle Technology Network PHP Forum URL

Christopher Jones - Thu, 2014-07-31 12:29
The Oracle Technology Network (which promotes the development community) is upgrading its software platform and reorganizing some content. The PHP Oracle forum is now at The top level "PHP Developer Center" is at I notice my old bookmarks for the Developer Center redirect to its current location, but this doesn't seem true of some very old URLs for the forum.

Correction: PeopleSoft Interaction Hub Support Plans

PeopleSoft Technology Blog - Thu, 2014-07-31 12:25
In a recent post, we said that Extended Support for the PeopleSoft Interaction Hub was ending in October 2014.  To be clearer, Extended Support for release 9.0 is ending on that date.  Extended Support for release 9.1 and its revisions will be available until at least October 2018.  Sustaining support will be available for those releases beyond the Extended Support dates.  Look for the release of Revision 3 of the Interaction Hub soon.

Oracle Priority Service Infogram for 31-JUL-2013

Oracle Infogram - Thu, 2014-07-31 10:34

Oracle and NFS
From Martin’s Blog: Setting up Direct NFS on Oracle 12c.
From flashdba: New section: Oracle SLOB Testing. And no, it’s not about finding people with soup stains on their shirt and giving them multiple choice exams with essay.
GoldenGate Director Security, from Oracle DBA - Tips and Techniques.
From AMIS Technology Blog: Fastest way to a Virtual Machine with JDeveloper 12.1.3 and Oracle Database XE 11gR2 – on Ubuntu Linux 64 bit.
Discovering Fusion Applications in Oracle Enterprise Manager 12c, from the Oracle A-Team Chronicles.
Purging Data From the BPEL Store, from DZone.
From the Oracle Data Visualizations Blog: A Guide to Diagram – Part 8 – Diagram Container Groups.
org.openide.util.ContextGlobalProvider, from Geertjan’s Blog.
A closer look at Oracle IDM Auditing, from Java Code Geeks.
Big Data
From CIO: Oracle hopes to make SQL a lingua franca for big data.
Good Housekeeping
OraManageability brings us this article: Keeping a Tidy Software Library – Saved Patches
From ZDNet: Oracle prepares to unveil next-gen SPARC 7 processor.
From the Oracle E-Business Suite Support Blog:
Oracle Service Contracts – How to Drive Contract Coverage by Severity
Let's Talk About Reclassifications in Fixed Assets
Just Released! July 2014 Procurement Rollup Patch 18911810
How to Customize the Field Service Debrief Report
From Oracle E-Business Suite Technology
Latest Updates to AD and TXK Tools for EBS 12.2
E-Business Suite Plug-in for Enterprise Manager 12c Now Available
Shameless Boasting

Is your company’s HQ so cool people come film movies there? Ours is! ‘Terminator: Genesis’ Filming at Oracle Headquarters, from CBS.

MySQL 5.6.20-4 and Oracle Linux DTrace

Wim Coekaerts - Thu, 2014-07-31 09:57
The MySQL team just released MySQL 5.6.20. One of the cool new things for Oracle Linux users is the addition of MySQL DTrace probes. When you use Oracle Linux 6, or 7 with UEKr3 (3.8.x) and the latest DTrace utils/tools, then you can make use of this. MySQL 5.6 is available for install through ULN or from public-yum. You can just install it using yum.

# yum install mysql-community-server

Then install dtrace utils from ULN.

# yum install dtrace-utils

As root, enable DTrace and allow normal users to record trace information:

# modprobe fasttrap
# chmod 666 /dev/dtrace/helper

Start MySQL server.

# /etc/init.d/mysqld start

Now you can try out various dtrace scripts. You can find the reference manual for MySQL DTrace support here.


Save the script below as query.d.

#!/usr/sbin/dtrace -qws
#pragma D option strsize=1024

mysql*:::query-start /* using the mysql provider */

  self->query = copyinstr(arg0); /* Get the query */
  self->connid = arg1; /*  Get the connection ID */
  self->db = copyinstr(arg2); /* Get the DB name */
  self->who   = strjoin(copyinstr(arg3),strjoin("@",
     copyinstr(arg4))); /* Get the username */

  printf("%Y\t %20s\t  Connection ID: %d \t Database: %s \t Query: %s\n", 
     walltimestamp, self->who ,self->connid, self->db, self->query);


Run it, in another terminal, connect to MySQL server and run a few queries.

# dtrace -s query.d 
dtrace: script 'query.d' matched 22 probes
CPU     ID                    FUNCTION:NAME
  0   4133 _Z16dispatch_command19enum_server_commandP3THDPcj:query-start 2014 
    Jul 29 12:32:21 root@localhost	  Connection ID: 5 	 Database:  	 
    Query: select @@version_comment limit 1

  0   4133 _Z16dispatch_command19enum_server_commandP3THDPcj:query-start 2014 
    Jul 29 12:32:28 root@localhost	  Connection ID: 5 	 Database:  	 

  0   4133 _Z16dispatch_command19enum_server_commandP3THDPcj:query-start 2014 
    Jul 29 12:32:28 root@localhost	  Connection ID: 5 	 Database: database 	 
    Query: show databases

  0   4133 _Z16dispatch_command19enum_server_commandP3THDPcj:query-start 2014 
    Jul 29 12:32:28 root@localhost	  Connection ID: 5 	 Database: database 	 
    Query: show tables

  0   4133 _Z16dispatch_command19enum_server_commandP3THDPcj:query-start 2014 
    Jul 29 12:32:31 root@localhost	  Connection ID: 5 	 Database: database 	 
    Query: select * from foo

Example 2

Save the script below as statement.d.

#!/usr/sbin/dtrace -s

#pragma D option quiet

   printf("%-60s %-8s %-8s %-8s\n", "Query", "RowsU", "RowsM", "Dur (ms)");

mysql*:::update-start, mysql*:::insert-start,
mysql*:::delete-start, mysql*:::multi-delete-start,
mysql*:::multi-delete-done, mysql*:::select-start,
mysql*:::insert-select-start, mysql*:::multi-update-start
    self->query = copyinstr(arg0);
    self->querystart = timestamp;

mysql*:::insert-done, mysql*:::select-done,
mysql*:::delete-done, mysql*:::multi-delete-done, mysql*:::insert-select-done
/ self->querystart /
    this->elapsed = ((timestamp - self->querystart)/1000000);
    printf("%-60s %-8d %-8d %d\n",
    self->querystart = 0;

mysql*:::update-done, mysql*:::multi-update-done
/ self->querystart /
    this->elapsed = ((timestamp - self->querystart)/1000000);
    printf("%-60s %-8d %-8d %d\n",
    self->querystart = 0;

Run it and do a few queries.

# dtrace -s statement.d 
Query                                                        RowsU    RowsM    Dur (ms)
select @@version_comment limit 1                             0        1        0
SELECT DATABASE()                                            0        1        0
show databases                                               0        6        0
show tables                                                  0        2        0
select * from foo                                            0        1        0

A look at how RDX’s Additional Services can meet your needs: Series Kick-off [VIDEO]

Chris Foot - Thu, 2014-07-31 09:08


Today we’re kicking off a series about our additional offerings, because we think it’s important for your organization to leverage RDX’s full suite of data infrastructure services to improve your organization’s ability to turn raw information into actionable business knowledge.

From our Business Intelligence services – designed to get you the right information about your company to make savvy strategic decisions – to our application hosting, database security and non-database server monitoring, GoldenGate replication services, and support for Windows, MySQL and Oracle EBS, we’ve got every administration need you can think of covered.

We’ll take an in-depth look at each of these services in videos to come, so you can learn how they can benefit your business and choose the services that may be the most important to you.

For more information on our additional services, follow the link below for our Additional Services Whitepaper.

Tune in next time as we discuss the importance of Business Intelligence for your business!

The post A look at how RDX’s Additional Services can meet your needs: Series Kick-off [VIDEO] appeared first on Remote DBA Experts.

SQL Server and OS Error 1117, Error 9001, Error 823

Pythian Group - Thu, 2014-07-31 08:32

small__3212904193 Along with other administrators, life of us, the DBAs are no different but full of adventure.  At times, we encounter an issue which is very new for us, rather, one that we have not faced in the past.  Today, I will be writing about such case.  Not so long back, in the beginning of June, I was having my morning tea I got a page from a customer we normally do not receive pages from. While I was analyzing the error logs, I noticed several lines of error like the ones below:

2014-06-07 21:03:40.57 spid6s Error: 17053, Severity: 16, State: 1.
LogWriter: Operating system error 21(The device is not ready.) encountered.
2014-06-07 21:03:40.57 spid6s Write error during log flush.
2014-06-07 21:03:40.57 spid67 Error: 9001, Severity: 21, State: 4.
The log for database 'SSCDB' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
2014-06-07 21:03:40.58 spid67 Database SSCDB was shutdown due to error 9001 in routine 'XdesRMFull::Commit'. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.
2014-06-07 21:03:40.65 spid25s Error: 17053, Severity: 16, State: 1.
fcb::close-flush: Operating system error (null) encountered.
2014-06-07 21:03:40.65 spid25s Error: 17053, Severity: 16, State: 1.
fcb::close-flush: Operating system error (null) encountered.

I had never seen this kind of error in the past so my next step was to check Google , which returned too many results. There were two sites that were worthwhile: The first site covers the OS Error 1117 , a Microsoft KB article, whereas the second site by Erin Stellato ( B | T ) talks about other errors like Error 823, Error 9001.  Further, I checked the server details and found that it’s exactly what the issue is here,  the server is using  PVSCSI (Para Virtualized SCSI) controller to LSI on the VMWare host. 

Resolving the issue

I had a call with client and have his consent to restart the service. This was quick, and after it came back, I ran checkdb – “We are good!” I thought.

But wait. This was the temporary fix. Yes, you read that correctly. This was the temporary fix, and this issue is actually lies with the VMWare, it’s a known issue according to VMWare KB Article. To fix this issue, we’ll have to upgrade to vSphere 5.1 according to the VMWare KB article.

Please be advised that the first thing that I did here is to apply the temporary fix, the root cause analysis – I did that last, after the server is up and running fine.

photo credit: Andreas.  via photopin CC

Categories: DBA Blogs

Help Please! The UKOUG Partner of the Year awards

Duncan Davies - Thu, 2014-07-31 07:48

We’d really appreciate your help. But first, a bit of background:

The Partner of the Year awards is an annual awards ceremony held by the UK Oracle User Group. It allows customers to show appreciation for partners that have provided a service to them over the previous 12 months. As you would imagine, being voted a winner (for the categories that you operate in) is a wonderful accolade as it’s the end-users that have spoken.

Cedar Consulting has a long history of success in the competition, reflecting our long standing relationships with our clients. I wasn’t going to ask for votes this year, however I notice that many of our competitors are filling Twitter and LinkedIn with pleas so I feel that I should also ask for your vote.

If you’re an existing Cedar client site we’d love your vote. Also, if you are a recipient of any other Cedar service – and I guess here I’m talking about the free PeopleSoft and Fusion Weekly newsletters that we send out – we’d be very grateful if you gave 3 minutes of your time to vote for us.

What we’d like you to do:

1) Go to:

2) Fill in your company name, first name and surname. Then click Next.

3) Enter your email address in both fields, then click Next.

4) Select any checkboxes if you want ‘follow-up communications’ from the UKOUG, or leave all blank, and click Next.

5) Select Cedar Consulting from the drop-down, and click Next.

6) On the PeopleSoft page, select the Gold radio button on the Cedar Consulting row (note, it’s the 3rd column!), then click Next.

7) Repeat by selecting the Gold radio button on the Cedar Consulting row of the Fusion page, then click Next.

8) Click Submit.

And you’re done. Thank you very much. If you want some gratitude for your 3 minutes of effort drop me an email and I’ll thank you personally!

jQuery - loop through a Tabular Form

Denes Kubicek - Thu, 2014-07-31 07:48
This question is one of the frequently asked questions - "How do I loop through a tabular form using a dynamic action?". This example shows how to loop through a tabular form and set the values for each row to what ever you want. Using apex_application.g_fxx array is not an option for onload processes or dynamic actions. It can only be used in an on submit process. Using jQuery in a simple loop it is possible to read / set any of the values in any column. Try it out.

Categories: Development

Redstone’s John Klein Named Iowa Entrepreneur of the Year

WebCenter Team - Thu, 2014-07-31 07:42

Entrepreneurs’ Organization (EO) Iowa named member John Klein as “Entrepreneur of the Year” during their annual meeting on Tuesday, July 15, 2014 in Des Moines. Klein and partner, Jason Stortz, started their computer consulting business five years ago in Klein’s basement. Since its humble beginnings, Redstone Content Solutions has grown to become a nationally recognized leader among information technology service businesses. (source)

“John is recognized by his fellow EOers as a leader who lives the EO Vision of business growth, personal development and community engagement,” stated Rowena Crosbie, President, Tero International, Inc. “He exemplifies the EO core values each day.” 

Redstone also recently celebrated it's 5 year anniversary!

“Five years ago we set a standard to place our clients at the center of all that we do.  The company we have built and the successes we’ve enjoyed are the direct result of customer confidence in our mission and loyalty to our partnership”, comments John Klein, co-founder of Redstone.  “Without this support, our accomplishments would be far fewer and much less meaningful.”

Redstone delivers a full complement of strategic Oracle WebCenter consulting services – software development, implementation, training and support for customers across a wide range of industries. Redstone has achieved industry recognition as an innovative IT services organization that delivers global Oracle WebCenter solutions. The firm's solid track record for delivering results is a by-product of its investment in people, processes and technology. Read more about John Klein's EO Entrepreneur of the Year award and Redstone's recent accomplishments.

Congratulations John from all of us on the WebCenter team! 

An Introduction to PeopleTools 8.54 (part 2)

Duncan Davies - Thu, 2014-07-31 07:08
1. Introduction

The recently launched version of PeopleTools 8.54 contains a broad range of enhancements. Although we’ve had the GA (General Availability) release we can’t upgrade existing environments until the 8.54.02 patch, so now is a good time to perform a fresh sandbox install to investigate the details and highlight the areas that are of most interest.

As in the first part of this series, there is a lot of content to cover so I’ve spread it over several entries. This first part looked at the back-end, infrastructure and System Admin changes, whereas this post moves up the software stack with integration and reporting, and the final entry will finish with the Fluid UI.

2. Developer UI Enhancements

There have been a number of improvements to the User Interface – we’re not talking about Fluid, this is in the Classic UI too although these changes may also benefit Fluid pages).

a. Charting Enhancements

The development team have introduced some new charting types to the toolset. We were already able to select from quite a few options, however we’ve now got Gauges, the LED lights, Status Meters and Funnel charts.


b. Long Edit Box Character Counter

Previously people (myself included) have accomplished similar functionality – with varying levels of success – by inserting JavaScript onto the page. Now it’s natively built in to PeopleTools. A character counter can be activated on the properties on the Long Edit box control:

2-long edit setup

The result on-screen is like this:

3-long edit result

Note: this functionality doesn’t actually limit the text entry and if the user exceeds the limit it will show a negative number.

c. Pivot Grids

Pivot Grids have been enhanced in a lot of ways – there are almost 30 improvements listed in the Release Notes. Just picking a few, they now include the ability to restrict the number of rows shown in a Pivot Grid, PS Query drilling URLs and Bubble and Scatter charts are now available as Pivot Chart types.


3. Reporting a. BI Publisher

As of PeopleTools 8.54, BI Publisher now includes support for PCL (Printer Control Language) code in RTF templates. This allows for printing PDF with Secure Fonts, essential for the secure printing of cheques.

Also newly supported are digital signatures – which can be used to verify the sender and to ensure that it the output hasn’t been amended in transit, and updatable PDFs.

b. PS Query

PS Query now supports defaults for prompts:


There have been workarounds to achieve a similar result before, but it’s now built into the configuration pages so we don’t need to search online for the workaround each time we want to use it.

Also new with PS Query is the option to include image fields in your output. There are a number of display alternatives with image fields, either Image Data (in which case PS Query will display the image inline with the rest of the HTML result set), or a Base64 encoded data string representing the image with any output other than HTML, or – when the property is set to Image Hyperlink – a URL to the image will be returned instead of the image itself. When the URL is clicked, the image will be displayed in a new browser window.

6-query images

Additionally, all PS Queries can be exposed as REST services, and Microsoft Excel 2007 and above is supported thereby increasing the amount of rows you can download from a Query result set into Excel above the previous limit of 64 thousand.

Finally, PeopleTools 8.54 introduces a new Query type, the Composite Query. Composite Queries are a superset of Connected Queries (which have been in PeopleTools for a couple of releases). Composite Queries allow users to connect queries together and have the output presented as a flat result set (instead of the hierarchical data sets which were output from Connected Queries).

4. Batch Processing

One very visible improvement to the Process Scheduler is a new status window that slides in from the lower right corner to give updates on processing progress. This is a nice touch that I’m sure end-users will appreciate:

7-batch window

Secondly, Activity Guides can improve batch processes as steps – which is important if there’s something a bit more process intensive that’s needed as part of a sequence of steps.

Finally, App Engine program trace allows you to specify which sections to appear in the trace, rather than having to wade through the trace for an entire program. This needs to be enabled in the Process Scheduler config, in Configuration Manager, and then in the App Engine itself:


5. Other Enhancements

Other enhancements included in this version of PeopleTools are:

- There’s a WorkCenter to make the setting up of new Activity Guides easier, plus a cloning function which will be useful when similar – but slightly different – guides are needed.

- SES facets now include numerical and date ranges. Results can include images and report repository content.

- Change Assistant has now been decoupled from the PeopleSoft Image, enabling packages to be moved to subsequent environments without also needing to connect to the PeopleSoft Image (this was quite restricting in Tools 8.53). It also has a fresh new UI and can be scripting/configured via the command line

- Data Migration Workbench has received improvements to Application Data Sets (and define relationships between groups), plus merging, support for managed objects and an improved UI.

- PeopleSoft Test Framework now allows you to perform mass updates (updating a set of tests in one change), interaction with App Designer projects and some usability enhancements.

6. Conclusion

The next version of PeopleTools is bringing many improvements. Much is being made of the new User Interface – and rightly so – however there are other improvements that we will improve our workflow by making it both simpler and more efficient.

Test your Application with the WebLogic Maven plugin

Edwin Biemond - Thu, 2014-07-31 05:47
In this blogpost I will show you how easy it is to add some unit tests to your application when you use Maven together with the 12.1.3 Oracle software ( like WebLogic , JDeveloper or Eclipse OEPE). To demonstrate this, I will create a RESTful Person Service in JDeveloper 12.1.3 which will use the Maven project layout. We will do the following: Create a Project and Application based on a Maven

OTN APEX Forum again

Denes Kubicek - Thu, 2014-07-31 04:02
The OTN Forum is not available (again). This usefull but constantly changing forum now gives me the following message:

I am not sure why they are using jive for that. Maybe APEX would be a better solution.
Categories: Development

Don’t let database security woes outweigh EHR benefits

Chris Foot - Thu, 2014-07-31 01:40

Although the transition from paper to electronic health records hasn't been easy, it's certainly paid off.

Those in the medical industry can now access patient information more easily, allowing them to eliminate mistakes characterized by the use of tangible forms. However, organizations should be wary of the dangers EHR implementations pose to database security.

Eliminating grievous mistakes
That's not to say professionals should abandon EHR technology. The National Institute For Health Care Reform acknowledged how using EHR can eliminate what physicians, hospital administrators and others in the health care sector call "unintended discrepancies." These instances are essentially minor mishaps that can have major repercussions.

Unfortunately, fragmented delivery systems will provide inaccurate information regarding medications, especially when patients are being admitted to and released from hospitals. This can cause doctors to accidentally omit, duplicate or add unnecessary prescriptions. In a worst-case scenario, this could cause a person to overdose.

The benefits
The NIHCR outlined what facilities need to prevent these mistakes from occurring, and it starts with the implementation of an EHR system. Such technology can allow hospitals and personnel to:

  • Aggregate accurate, applicable pre-admission medication data
  • Compare hospital prescription orders to previous medications so physicians can make educated treatment decisions
  • Share relevant lists pertaining to medicines administered for the discharge phase with primary care doctors, nursing facilities and other places

The situation
Obviously, a lot of digital information is being stored and transferred. Some connections may be more secure than others, but the environment is a hacker's dream come true. HealthITSecurity contributor Greg Michaels acknowledged that while exchanging patient intelligence may enable physicians to deliver better care, health care organizations find they can't dedicate enough resources to sanctioning safe delivery.

Michaels advised medical industry participants heavily entrenched in EHR uses to work with a trusted, third-party IT security expert. In addition to communication surveillance, the outsourced entity should be capable of providing remote database management and monitoring as well. Michaels also recommended professionals abide by the following best practices:

  • Audit all partners to see which ones provide their customers with protected health information and identify which IT protection measures they're taking
  • Open communication with third-parties so data breaches affecting multiple organizations can be addressed in a united manner
  • Ensure all partners are compliant with standards outlined by the Health Insurance Portability and Accountability Act
  • Educate in-house personnel on how to take basic security measures

By seeking help from a database administration service and implementing basic protective measures, hospitals will be able to use EHR with limited risk of sustaining an IT disaster.

The post Don’t let database security woes outweigh EHR benefits appeared first on Remote DBA Experts.

Developing with JAX-RS 2.0 for WebLogic Server 12.1.3

Steve Button - Thu, 2014-07-31 00:47
In an earlier post on the topic of Using JAX-RS 2.0 with WebLogic Server 12.1.3, I described that we've utilized the shared-library model to distribute and enable it.

This approach exposes the JAX-RS 2.0 API and enlists the Jersey 2.x implementation on the target server, allowing applications to make use of it as when they are deployed through a library reference in a weblogic deployment descriptor.

The one resulting consideration here from a development perspective is that since this API is not part of the javaee-api-6.jar nor is it a default API of the server, it's not available in the usual development API libraries that WebLogic provides.

For instance the $ORACLE_HOME/wlserver/server/lib/api.jar doesn't contain a reference to the JAX-RS 2.0 API, nor do the set of maven artifacts we produce and push to a repository via the oracle-maven-sync plugin contain the library.

To develop an application using JAX-RS 2.0 to deploy to WebLogic Server 12.1.3, the needs to be sourced and added to the development classpath.

Using maven, this is very simple to do by adding an additional dependency for the artifact that is hosted in public maven repositories:


Note here that the scope is set to provided since the library will be realized at runtime through jax-rs-2.0.war shared-library that it deployed to the target server and referenced by the application. It doesn't need to be packaged with the application to deploy to WebLogic Server 12.1.3.

For other build systems using automated dependency management such as Gradle or Ant/Ivy, the same sort of approach can be used.

For Ant based build systems, the usual approach of obtaining the necessary API libraries and adding them to the development CLASSPATH will work. Be mindful that there is no need to bundle the in the application itself as it will be available from the server when correctly deployed and referenced in the weblogic deployment descriptor.