Tuesday, July 26, 2005

Course Collision!

The Desert Southwest Software Symposium changed the presentation schedule. Two sessions I am most interested in, "Herding Racehorses and Racing Sheep" by Dave Thomas and "Advanced Object-Relational Mapping with Hibernate", are running side by side.

Now, that is a real bummer.

How to start isqlplus

To start isqlplus, a web version of sqlplus, issue

isqlplusctl start
Thereafter, the isqlplus is accessible from http://localhost:5560/isqlplus.

Technorati Tags:

Saturday, July 23, 2005

How to run native SQL from Hibernate?

Hibernate 2 provides createSQLQuery() method on the Session for native SQL. However, this method must return a persistent class and can be costly at times.

When raw power is needed, get a JDBC connection by calling connection() method on the Session.

Technorati Tags:

What to do when dbca does not start?

Yank the network cable.

Yeah, you heard me alright. If On OSX, if the dbca just sits there, no GUI, no message, no nothing, yank the network cable. This is what I learnt after having tried to reinstall Oracle - twice.

Technorati Tags: ,

Monday, July 18, 2005

How do you develop Oracle PL/SQL on OSX

Let me take back my words. JDeveloper on OSX is useless for PL/SQL programming. Attempt to compile a simple procedure will crash the JDeveloper. Now I am back to using SQLPlus. Is there any tool, preferably free, that works well on OSX for PL/SQL?

After posting, I remembered that I am using Apple's JDK 1.5. Maybe JDeveloper doesn't work so well with 1.5, I thought. So I switched to JDK 1.4.2_08 from Apple and sure enough, it crashes no more.

Now if you excuse me, I have got some triggers to write.

Technorati Tags: ,

Wednesday, July 13, 2005

Collections.sublist() returns a non-serializable list

This gotcha me today. The Collections.sublist() method returns an instance of java.util.RandomAccessSubList, which is obviously not serializable. Solution is easy - just add all contents to an serialziable list implemenation such as ArrayList.

Technorati Tags:

Prevent .DS_Store creation on network volumes

Note to myself: Execute following command in a terminal

defaults write com.apple.desktopservices DSDontWriteNetworkStores true

Technorati Tags:

First LAJUG night with Si Chen

Went to my first LAJUG meeting tonight. Si Chen @ Open Source Strategies, Inc presented Open For Business In A Nutshell. I have to confess that I almost passed the meeting for mistaken it as some talk on open source business model. Turns out it is about ofbiz open source project and I am glad that I didn't miss the presentation.

Si is not only a commiter on the ofbiz project but also build his own online shopping site using ofbiz. The fact that he eats his own dog food makes him much creditable to me.

I briefly checked out ofbiz workflow about two years ago. My major reservation at the time was its map based API. I was worried about the loss of compile time check, refactoring support in IDE etc. When I raised the question tonight at the meeting, Si responded that he does not find this to be a problem in his experience. In fact he actually finds the map based API is easy to work with than traditional type based API. I didn't get a chance to ask him what kind of team he had to work with. My current take on the issue is that such a approach may be more suitable for a small and competent team, but probably not in a large team consists of programmers with various experience level.

Technorati Tags:

Thursday, July 07, 2005

Why there is no GUI tool to configure JBoss?

I have long been wondering why there is no such tool to ease JBoss configuration. Given the popularity of the JBoss server, I would thought somebody must have written such a tool already. Please leave me a comment if you know such a tool.