Displaying dates and times with Oracle

I use SQLDeveloper when interacting with Oracle. When viewing tables with date columns it can be frustrating that the default display does not show time (just day, month and year).

To change this behaviour, you can set the date format for your current session:
alter session set NLS_DATE_FORMAT='DD-Mon-YYYY HH24:MI:SS'
Now, when you view tables or resultsets, you'll have a more precise view of the data:
04-Sep-2008 09:07:51

Popular posts from this blog

Using the Crystal Reports Java API to generate PDF

I recently had to investigate how to generate a PDF from a Crystal Report created by another team. Without knowing anything about Crystal Reports, I had to google around for information and piece it all together. It turns out to be really simple once you know how.

We were using Business Objects 4.0, and probably the most important thing was to get the Java library - download 'SAP Crystal Reports for Java runtime components - Java Reporting Component (JRC)' from
http://www.businessobjects.com/campaigns/forms/downloads/crystal/eclipse/datasave.asp

There are a lot of samples on the web to look at - you might find something to help here:
http://wiki.sdn.sap.com/wiki/display/BOBJ/Java+Reporting+Component++SDK+Samples

A good example to start with is “JRC EXPORT REPORT”:
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40d580ce-bd66-2b10-95b0-cc4d3f2dcaef

If you have an RPT file, the java to generate the report is relatively simple - :

ReportClientDocument reportClientDoc =…
Read more

No Scope registered for scope request

Recently I was working with some code which defined beans as request scope. Junit tests failed with the following exception while trying to initialize the application context:


Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: ...; nested exception is java.lang.IllegalStateException: No Scope registered for scope 'request'


I found the solution by searching around (unfortunately I didn't record the sources). Basically, you can register the required scopes as shown below:

[sourcecode language='java']
import org.springframework.mock.web.MockHttpServletRequest;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.RequestScope;
import org.springframework.web.context.request.ServletRequestAttributes;
import org.springframework.web.context.request.SessionScope;

public class SampleTest extends AbstractDependencyInjectionSpringContextTests {

@Override
protected void prepar…
Read more

Using Selenium WebDriver to select JSF/PrimeFaces selectOneMenu options

I'm using JBehave with Selenium WebDriver to test my PrimeFaces (JSF2) application. Selecting an option from a SelectOne option list isn't standard though because of the HTML markup generated by the JSF component.


The facelets code to place the selectOneMenu uses the ID 'state':


This generates HTML div blocks with id's prefixed with this components id:


To select an option, I use a method which manipulates the appropriate divs - this can be used as illustrated below:


To reuse this type of utility method, I put it in a base Page Object class:



Read more