If you haven’t already registered for MySQL Connect, now is the time to do it.

Looking for the right reason to attend? Here are the TOP THREE REASONS…

• You’ll get the chance to hear directly from users including PayPal, Verizon, Twitter, Facebook, Ticketmaster, Ning, Mozilla, CERN, Yahoo! and more, about best practices for deploying MySQL based solutions.
• Don’t miss this unique opportunity to meet the engineers developing and supporting the MySQL products, all in a single location. You’ll be able to ask them all your questions and provide them feedback.
• Acquire detailed knowledge about the latest innovations in InnoDB, the MySQL Optimizer, high availability strategies, performance and scalability, security improvements and numerous other topics. You’ll hear it straight “from the horse’s mouth” and from other MySQL experts in the ecosystem.

Early bird registration rate offering a saving of $500 ends this friday, July 27. Don’t miss out…Register Now.

The proliferation of mobile devices and competitive reasons are compelling enterprises to offer access to commonly used business applications for customers and employees using personal mobile devices. But many applications don’t have visibility into the security posture of the device making it challenging to enforce audit, compliance, and privacy requirements.  

As part of Oracle Identity Management 11gR2, Oracle is now offering a mobile and social sign on solution as part of its Access Management solution stack.With the innovative Mobile and Social Access Management capability, organizations can extend SSO to mobile applications and secure applications and data regardless of which device is being used. Also organizations can consume identities from popular social networks (Facebook, Google, Yahoo, Twitter, and LinkedIn) for signing on users to consumer-facing and other low risk applications, providing a seamless user experience for users without the burden of forcing additional registration and logins.

The solution also comes with an SDK with REST APIs that developers can leverage to integrate custom mobile applications with commonly used identity management functions like authentication, credential management, secondary authentication, device fingerprinting, and session management. The SDK supports OAuth and OpenID, two of the most commonly used user-centric identity frameworks in the industry. So developers can use the SDK to enable applications to consume social identities.

This offers several compelling benefits to organizations:

• Tighter Security for Mobile Enterprise: Organizations can now secure applications and data regardless of which device is being used to access those applications.

• Easier Identity Integration for Mobile Apps: This provides a programmatic and flexible way to integrate native mobile apps and web apps with identity services offered by enterprises such as authentication and SSO.

• Sign On from Social Networks: Organizations can consume internet identities for signing on users to low value applications like blogs, community forums, etc. This capability can also be leveraged by consumer facing applications to provide a seamless user experience for users without the burden of forcing additional registration and logins.

You can get more information about our new Mobile and Social Access Management solution here. 

NetBeans 7.2 was today published. You can download it here. You could read about the PHP features added to the NetBeans 7.2 release here on the blog, but the main features added or improved are:

• Support for PHP 5.4
• PHP editing: Fix Uses action, annotations support, editing of Neon and Apache Config files and more
• Support for Symfony2, Doctrine2 and ApiGen frameworks
• FTP remote synchronization
• Support for running PHP projects on Hudson

NetBeans 7.2 was today published. You can download it here. You could read about the PHP features added to the NetBeans 7.2 release here on the blog, but the main features added or improved are:

• Support for PHP 5.4
• PHP editing: Fix Uses action, annotations support, editing of Neon and Apache Config files and more
• Support for Symfony2, Doctrine2 and ApiGen frameworks
• FTP remote synchronization
• Support for running PHP projects on Hudson

Start spreading the news! NetBeans IDE 7.2 is out with, as always, its clean and neat user interface:

Here’s the top 10 features you’ll find in this release:

• Static code analysis support, in particular, FindBugs integration.
• Smoother startup and faster project scanning.
• New, better, and faster tools throughout the Java Editor.
• Enhancements for Java EE developers, such as JPA code completion and PrimeFaces 3.2.
• Better JavaFX tools, in particular, JavaFX Scene Builder integration.
• Even more NetBeans love for Maven.
  
• Tools and templates for TestNG.
• New PHP frameworks integrated, together with more editor tools.
  
• Groovy & Grails faster and more tools.
• NetBeans C++ powered up and yet more support than before.

Go get it while the buzz is buzzing!

This feature is sure to define your placement into one of the following camps:

1. I love it when my IDE helps me with my code
2. I hate it when my IDE inserts code I didn’t explicitly type

And the feature is -

Autogenerate Group By clause

Autogenerate Group By clause

The help defines this preference/feature as:

Automatically generates a GROUP BY clause if you manually enter (not copy/paste) a SELECT statement containing a COUNT function, and then edit the SELECT query.

I think that’s mostly correct. It’s not just for COUNT, but for any AGGREGATE function. I tested SUM, AVG, and COUNT for good measure.

So what does this mean exactly?

If I type:

Select avg(Salary)
From Hr.Employees;

This will ‘work.’ You’re asking for an average salary of everyone in the Employees table.

But if I ask for this:

Select avg(Salary), Department_Id
From Hr.Employees;

Oracle will give me a

ORA-00937: not a single-group group function
00937. 00000 -  "not a single-group group function"
*Cause:    
*Action:
Error at Line: 2 Column: 20

This isn’t a math tutorial, but the SQL can’t read our mind and know that we want average salaries broken down by departments. To achieve that we implement the GROUP BY clause.

Now some of you might be thinking, wouldn’t it be nice if SQL Developer could see that I was doing a aggregate and automatically add for me the required GROUP BY.

For that crowd, you’ll want to enable the autogenerate preference. Here’s how it looks:

SQL Developer auto-inserts and updates your GROUP BY clause as you change the SELECT list following an aggregate function call.

So what camp do I belong to?

I fall somewhere in the middle. I like the code insight features, but I disable the automatic bits and just call it on demand with ctrl+spacebar. I didn’t have this auto-Group by feature enabled, and I’ll probably leave it off. But that’s just me. What do you think?