Oracle - granting priveleges to v$ views such as v$transaction

Link: http://coskan.wordpress.com/2007/03/07/how-to-grant-to-v-views/

Salesforce.com Integrating Products and Pricebooks

I've been working on a Oracle BPEL integration lately to upload Product2, PriceBook2, and PriceBookEntry objects into Salesforce. I didn't realize how complicated upserting a PriceBookEntry would be, however.

When upserting a PriceBookEntry, there are no external ids. So, before doing the upsert, you have to log-in to Salesforce and query the PriceBookEntry objects for a list of Ids according to the PriceBook2Id and the Product2Id. Ok simple enough.

Now what about a batch statement with up to 200 PriceBookEntry records at one time? Oy!

So, I took the existing XSLT transformation for a single Id lookup, and converted it to lookup 200 Ids. The query is a little nuts, and I'm hoping that it will come back in time, as SOQL has a strict time limit on returning queries. The query resembles the following:

Select Id,PriceBook2Id,Product2Id From PriceBookEntry where (PriceBook2Id = 'Id1' and Product2='Id2') or (PriceBook2Id = 'Id2' and Product2='Id2') .. etc, up to 200 times.

Now once you get the Id's back, you have to transform them into a Salesforce upsert request. The transform matches the Ids to the PriceBook2 and Product2 Ids and the values passed in through the integration. That part was equally as tricky, and involved some XSLT for-each statements and some recursive xslt-template calls.

Next, I got an error stating something similar to 'Cannot insert Product2 Pricebook without a Standard Price'. Having not dealt with PriceBooks before, I scratched my head on this one. Turns out, the Product2 object needs to be added to the Standard PriceBook before it can be added any other PriceBooks, via the PriceBook entry lookup object.

Here's a nifty little trigger to add a Product2 to the standard PriceBook2 object:

trigger InsertProductIntoStandardPB on Product2 (after insert) {
//Insert the product(s) into the standard price book as a pricebookentry
sObject s = [select ID from Pricebook2 where IsStandard = TRUE];
List entries = new List();
for (Product2 product : Trigger.new) {
entries.add(
new PricebookEntry(
Pricebook2Id=s.ID,
Product2Id=product.ID,
UnitPrice=0.00,
IsActive=product.IsActive,
UseStandardPrice=FALSE)
);
}
insert entries;
}

Note: It's best practice, in Salesforce, to put your objects into a list before performing DML operations. It reduces the amount of SOQL calls drastically, especially, such as in this case, if 200 Products are inserted as part of a batch operation.

Displaying compile-time warnings for triggers in Oracle

I'm keeping this hear mostly for my future reference.

The following code snippet is for displaying compile time warnings when a trigger compiles, but shows warnings.  For instance, if I compile a trigger in SQL Developer, sometimes it will compile, but then the trigger is invalidated when I try to run it.  I go to check for any errors, but SQL Developer only shows 'Compiled with warnings'.

select line, position, text from dba_errors where owner='SCHEMANAME' and
name='TRIGGERNAME' and type='TRIGGER'
order by sequence, line, position;

This query can also be used for package and package body compilation errors/warnings. Instead of type='TRIGGER' use (type='PACKAGE' or type='PACKAGE BODY')

Note, the user you're running the query as, needs to have select priveleges to dba_errors, such as the SYS user.

In-file property expansion in Eclipse

This defect in Eclipse and Rational Application Developer is driving me nuts at the moment..

https://bugs.eclipse.org/bugs/show_bug.cgi?id=206362


However, according to my good friend Google, Netbeans also struggles with In-file property expansion.

ANT and file permissions

When using the JAR or WAR tasks in ANT, permissions are not inherited in a non-Windows environment. This is due to security issues in the JVM. Instead, the permissions are set to 0644 by default.

There are a few ways to get around this.

When using the JAR task, use the chmod task directly afterwards to set the permissions. The chmod task does does not work correctly in Windows, but will work correctly in UNIX.. go figure.

<!-- Jars all class files in parent directory and then sets the jar file to rwxr-xr-x permissions -->
<jar destfile="myjar.jar">
   <fileset dir="./" includes="**/*.class" />
</jar>

<chmod file="myjar.jar" perm="755">

When using the WAR task, the same is true. However, I am using a zipfileset below, which extends the fileset element, but allows the user to set permissions on the files within the fileset. In this case, I had to set all jars to 755 in order for them to be executable for an applet. First, I had to exclude all jars from the war element. Next, include them in the zipfileset, setting the filemode, or file permissions, to 755, or rwxr-xr-x. Example:

<war destfile="mywar.war" manifest="manifest.mf" basedir="./" excludes="**/*.jar">
   <zipfileset dir="." includes="**/*.jar" filemod="755"/>
</war>

One more thing to note: I've read in other blogs that the chmod element tends to work erratically in Windows due to security flaws. You may want to envelope the chmod in an ant target that depends on the OS like in the example below:

<!-- Calls chmod if the OS is NOT a Windows Operating System -->
<condition value="isWindows">
   <os family="windows"/>
</condition>

<target name="chmodFile" unless="isWindows">
   <chmod file="myjar.jar" perm="755" />
</target>

<antcall target="chmodFile" />