Weblog for the AMIS Technology corner
Archive for August, 2007
Package java classes (WSIF calls) in BPEL suitcase
Aug 15th
Introduction
Is it possible to package java classes which are invoked through WSIF along with the BPEL Suitcase generated by bpelc?
I’ve noticed that when generating and deploying the suitcase using JDeveloper (10.1.3.x) – the class files are compiled to the output directory and packaged in the suitcase, but when I run the same build.xml via Ant (ant deploy-process), the class files are missing in the output directory and thus missing in the suitcase
Read the rest of this entry »
Implementation Restricted Relaxed in Oracle 11g
Aug 13th
If you are a regular user of the FORALL
statement, you are probably also familiar with this message:
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
While I was playing around on our Oracle 11g database, I found that this restriction was lifted. How cool is that?
Maven JMeter plugin and report generation (the last steps to get it working)
Aug 8th
JMeter (http://jakarta.apache.org/jmeter/)is a powerful tool for functional and performance testing web applications. JMeter, opposed to selenium, also works perfectly on generated applications (like Oracle ADF ). One of the key strengths of JMeter is the automation. The same test can be repeated after each (minor) release. This is a great help in executing time consuming regression testing.
We use Maven 2 (http://maven.apache.org/) in combination with Continuum (http://maven.apache.org/continuum/) as the basis of our AMIS-SoftwareStudio. With the build schema in Continuum we are able to execute both performance and functional regression testing every night (or even each hour if you like) on the most recent version of the application from our source repository.
The documentation on the JMeter wiki (http://wiki.apache.org/jakarta-jmeter/JMeterMavenPlugin) is to limited to get the JMeter plugin working at once. It does not handle the generation of reports and installing the plugin into your company repository. Most of the samples on the internet (use the Google to find Maven 2+JMeter) are based on extensive Ant scripts. The sample below shows how to get the Maven-JMeter-Plugin working in Maven2 with a minimum of extra code in your projects pom.xml.
New in Oracle 11g: Read Only Tables
Aug 7th
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made read only to other users, by granting only the select privilege to these users. But the owner of the table was always able to do updates and inserts. With the new statement: alter table <table name> read only the table is really read only. And you can reverse it again with: alter table <table name> read write. A small example: Read the rest of this entry »
New in Oracle 11g: wait added to lock table syntax
Aug 2nd
In Oracle 11g you can add a wait clause to the lock table command in which you can specify how many seconds you want to wait to get the lock on the table.
SQL> lock table t in exclusive mode wait 10; lock table t in exclusive mode wait 10 *ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired Elapsed: 00:00:09.95 SQL>
Getting started with JPA mapping – How IntelliJ can map your data with a few clicks
Aug 1st
With JPA, there finally is an ORM standard and every major IDE has support for it. Today I will show you how to map your data with IntelliJ IDEA. I also use the brand new TopLink 11g preview (a JPA implementation), but you can try this at home with every JPA-implementation.
