Tuesday, November 22, 2005

Oracle 10g: Oracle Open World Top 10 presentations

You can find online the top 10 presentations of Oracle Open World 2005:

1. Optimizing the Optimizer: Essential SQL Tuning Tips and Techniques
2. 10 Things We Like About Oracle Database 10g Release 2
3. PeopleSoft Enterprise, JD Edwards, and Oracle E-Business Suite Integration with Oracle Fusion Middleware
4. The Future of Database and Information Technology
5. Understanding Shared Pool Memory Structures: Tips on How to Optimize Usage and Avoid Errors
6. Take the Guesswork Out of Database I/O Tuning
7. Tuning Oracle SQL in the Real World
8. What They Didn't Print in the Doc: High-Availability Best Practices from Oracle Maximum Availability
9. Performance Diagnostics Demystified: Best Practices for Oracle Database 10g
10. Best Practices for Oracle Database 10g Backup and Recovery

Friday, November 11, 2005

Using Eclipse WTP and OracleAS/OC4J

You have probably heard about Web Tools Platform (WTP), this project extends Eclipse with various tools for developping J2EE applications. It contains editors for HTML, JSP, XML and so more... In addition to various wizards to create Web Services, EJB, Connector and more... WTP allows developers to package the application using J2EE standard packagind: EAR,WAR,RAR,JAR and deploy and run the application from the IDE.

The challenge here is not how you build J2EE components using an IDE, but more how do you package, deploy and run your application easily from the IDE. Eclipse WTP allows you like Oracle JDeveloper does, to package the various J2EE components in standard archives (JAR, WAR, EAR, RAR, ...) and deploy them to a J2EE container. WTP project has a very nice list of containers you can deploy to: Oracle, IBM, BEA, JBoss, Tomcat, ...

Supported Server
click to enlarge

With the latest build of Eclipse WTP (Release 1.0M8), Oracle Application Server 10g is now part of the default server list. So if your are an OracleAS user you can now use WTP and start to run and debut your application running in OracleAS from Eclipse.

What do you need to start using WTP and OracleAS:
  1. Download and install Eclipse WTP 1.0M8 from Eclipse site.
  2. Download and install OracleAS 10g (OC4J 10.1.3 Developer Preview 4) from OTN
  3. You must set a administrator password for OC4J using the start command
  4. Done! You can now use OC4J and Eclipse. I have a viewlet that shows the basic steps to create and run your first Web application.

OC4J configuration
Update (Nov,18) : I forgot to mention the Oracle Application Server Adapter tutorial from the Web Tools project.