select count(weblogentry.categoryid) as “Number of Entries”, weblogcategory.name as “category”,
count(weblogentry.id) as “Total”
from weblogentry JOIN weblogcategory
on weblogentry.categoryid = weblogcategory.id
group by weblogcategory.name

Just installed Opensolaris 2008.12 on a spare box. As part of any computer build I end up putting JDeveloper on it. Download it and double click on the jar to start the installer. One problem with the install is it can’t create the directories so when it goes to start installing you get a error. "/home/XXXXX/Oracle/Middleware has insufficient space", the fix is to create that directory before you start installing.

ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.
Action: – Wait a moment and try to connect a second time.- Check which services are currently known by the listener by executing: lsnrctl services – Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.- Check for an event in the listener.log file.

One thing to try if using Oracle 10g XE in the database field use “HOST”/”SERVICE_NAME”

I beat myself for 2 weeks trying to sort that out after a upgrade from 9i

The format of the data to be entered in the Username fields on the Credentials pages is “DomainUsername”. This setting is only accepted when the user has the “Log on as a batch job” right assigned.
Select the “Administrative Tools” control panel. Then “Local Security Policy”. Expand “Local Policies”, select “User Rights Assignment”. Finally add the User to “Logon as a Batch Job” local security setting.
With thanks to Rachel from Oracle Support.

Out of Time is a believable time travel space opera. I always worry
when I read about people who time travel, there seems to be only a
couple of ways to do it. Pat has found a believable third way. He
captures the emotions of 3 people caught in a fate they could never
imagine, but they can understand due to of the timeless of human nature.

The pace is set very nicely at the beginning of the story but feels
a little rushed towards the end. I feel that it could have had several
more chapters, I felt disappointed when it ended. But, I am looking
forward to more.

I had a error FRM-40740 when I added a alert to a form I was working on. The alert was called UPDATE_RECORD and was set to the update_record button. After changing the alert and program procedure to UPDATE_STUDENT the error went away.