My wife has had a Samsung Galaxy S1 Android phone for over a year now and its been great. Recently though, she’d been having terrible battery performance and had noticed that after charging the phone overnight, it was only at 50% in the morning. My first thought was to buy a new battery, but then I figured I’d try updating the firmware first.

Thats when I discovered that windows couldn’t recognise the device!! This was a big issue – how could I get all of her photos off the phone?

Solutions:

1. Quite by accident, she plugged her phone into an iCoustic USB charger that we got with an iPod accessory pack – this fully charged the battery and now there are no battery issues. She’d been using my iPad USB charger previously and for some reason, this makes a difference.
2. I realized that when syncing the phone with Kies I wasn’t using the original USB cable that came with the phone. We’d been using a third party cable we’d bought after losing the original one. Since we’d found the original cable I tried that and there were no problems – Windows found the drivers, installed them and recognised the phone. Kies worked fine after that.

So, all is good now – the phone works fine, running Android 2.3 (Gingerbread).

I’ve just started using Grooveshark.com for listening to music. Running in the browser, its a great cross platform solution – no installs necessary. I’m just running the browser on my MythTV media center, with the sound via the TV. The quality seems great, even though I’ve got it on the lower quality, and I’m hoping its just what I need to find some new and interesting music.

I’ve finally fixed sound via the browser on my Ubuntu 11.04 MythTV media center. MythTV was working fine, but the browsers never even tried to play sound (the sound settings would show NO applications using sound, when Chrome or Firefox should have been).

The information I needed was here and I had no /etc/asound.conf so I had to put the following in ~/.asoundrc -

pcm.pulse { type pulse }
ctl.pulse { type pulse }
pcm.!default { type pulse }
ctl.!default { type pulse }

I recently mapped a JPA entity to a view, and encountered this error while using hibernate to update the database schema:

ORA-01702: a view is not appropriate here

[SchemaUpdate.execute] could not complete schema update

I was using the Oracle JDBC drivers 10.1.3.3 – luckily, the solution was to upgrade the drivers – when using 11.2.0.2.0 it works fine.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

ojdbc6.jar (2,152,051 bytes) – Classes for use with JDK 1.6. It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.

I went to a Agile Sydney meetup recently – “Automated web tests as a team communication tool” – by John Smart of Wakaleo Consulting. It was great stuff, and the presentation is now online.

There is a nice story here in that the project feature set is documented via
easily readable and executable tests, and the reporting shows which features are
implemented and which aren’t.

More information on the the Thucydides tool he references can be found at:

• https://github.com/thucydides-webtests/thucydides/wiki

While reading that presentation online, I found more gold here in some of his other presentations:

• JUnit Kung Fu: Getting More Out of Your Unit Tests
• Introduction to Domain Driven Design

They are a great read and are great pointers in the right direction to improve your software development.

(If you haven’t seen them before, check out Wakaleo’s training courses. I haven’t been on them, but based on the course content, they look to be the most relevant courses I’ve come across)

The last couple of projects I’ve been on I’ve been frustrated by a few things about the code base that I couldn’t quite put my finger on, and the DDD presentation hit a nerve.

I searched around for more about DDD and found some more excellent resources:

• Domain driven design quickly
• DDD sample application
• Time and Money

I still have to absorb all of this material and try it out but I can instantly recognise that it addresses some if not most of the code problems that have frustrated me.

So, exciting times are ahead. Its always refreshing to find new tricks and efficient ways of improving software development!

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 = new ReportClientDocument();
reportClientDoc.open("My crystal report.rpt", 0);
ByteArrayInputStream byteArrayInputStream = (ByteArrayInputStream)reportClientDoc.getPrintOutputController().export(ReportExportFormat.PDF);
reportClientDoc.close();

The report I dealt with was developed by another team, and expected a data source called ‘TESTDB’ to be available. Without that data source present, I would get the following error:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Error finding JNDI name (TESTDB)---- Error code:-2147467259 Error code name:failed

Setting a data source up in Tomcat is trivial, just by adding a resource to context.xml:

<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>

    <Resource name="jdbc/TESTDB" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="user" password="passwd" driverClassName="oracle.jdbc.OracleDriver"
               url="jdbc:oracle:thin:@dbserver:1521:db1"/>
</Context>

Now the data source is set up, there’s another problem – the report expects a parameter and we get this error:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException: InternalFormatterException---- Error code:-2147217394 Error code name:missingParameterValueError

Adding the report parameter is simple once you know how:

ParameterFieldController paramController = reportClientDoc.getDataDefController().getParameterFieldController();
paramController.setCurrentValue("","MyParamName","MyParamValue");

There’s probably a lot of subtle information and detail missing here, but it works – I can generate the PDF via java code so its now at a stage where it can be integrated into our application.

So, the final spike test code looks like:

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<%//Crystal Java Reporting Component (JRC) imports.%>
<%@page import="com.crystaldecisions.reports.sdk.*" %>
<%@page import="com.crystaldecisions.sdk.occa.report.lib.*" %>
<%@page import="com.crystaldecisions.sdk.occa.report.exportoptions.*" %>

<%//Java imports. %>
<%@page import="java.io.*" %>

<%

try {

	//Open report.
	ReportClientDocument reportClientDoc = new ReportClientDocument();
	reportClientDoc.open("MyReport.rpt", 0);
	ParameterFieldController paramController = reportClientDoc.getDataDefController().getParameterFieldController();
	paramController.setCurrentValue("","MyParamName","MyParamValue");
	ByteArrayInputStream byteArrayInputStream = (ByteArrayInputStream)reportClientDoc.getPrintOutputController().export(ReportExportFormat.PDF);
	reportClientDoc.close();

	writeToBrowser(byteArrayInputStream, response, "application/pdf");

} catch(Exception ex) {
	out.println(ex);
}
%>

<%!
   /*
	* Utility method that demonstrates how to write an input stream to the server's local file system.
	*/
	private void writeToBrowser(ByteArrayInputStream byteArrayInputStream, HttpServletResponse response, String mimetype) throws Exception {

		//Create a byte[] the same size as the exported ByteArrayInputStream.
		byte[] buffer = new byte[byteArrayInputStream.available()];
		int bytesRead = 0;

		//Set response headers to indicate mime type and inline file.
		response.reset();
		response.setHeader("Content-disposition", "inline;filename=report.pdf");
		response.setContentType(mimetype);

		//Stream the byte array to the client.
		while((bytesRead = byteArrayInputStream.read(buffer)) != -1) {
			response.getOutputStream().write(buffer, 0, bytesRead);
		}

		//Flush and close the output stream.
		response.getOutputStream().flush();
		response.getOutputStream().close();

	}
%>

Note, implementing this in a JSP was just a simple and quick shortcut to investigate the API.

I put a simple CRConfig.xml in WEB-INF/classes:

<?xml version="1.0" encoding="utf-8"?>
<CrystalReportEngine-configuration>
    <reportlocation>..</reportlocation>
    <timeout>0</timeout>
    <ExternalFunctionLibraryClassNames>
    	<classname></classname>
    </ExternalFunctionLibraryClassNames>
</CrystalReportEngine-configuration>

Note that this specified a report location of .. which meant I had to put MyReport.rpt in the WEB-INF directory of my application (i.e. [web-root]/WEB-INF/classes/.. = [web-root]/WEB-INF) – contents of the WEB-INF directory should not be available for download.

If the rpt file cannot be found, you’ll see an error like:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Report file /[path-to-webapps]/webapps/cr/WEB-INF/MyReport.rpt not found---- Error code:-2147215356 Error code name:fileNotOpened

Back in the day it used to be a bit more difficult than it is now to dynamically generate your java application classpath – you’d have to write a script to loop over all the jar files in a directory, appending them to your classpath variable – like this.

Since Java 6 though, its been a lot easier – you can use wildcards to specify all jars in a directory. See the “Understanding class path wildcards” in the Java SE 6 documentation.

Now its as simple as:

java -cp /my/lib/dir/* MyClass

Simple! As it should be!

I’ve been developing a simple little command line application and one of the libraries I’m using seems to log debug information to the console. To clean up the console output, I had to turn off the JDK by using:

        LogManager.getLogManager().reset();

This seemed to do the trick for me, but it sounds like in some cases you may need to go a bit further and turn off logging at the global logger level:

        LogManager.getLogManager().reset();
        Logger globalLogger = Logger.getLogger(java.util.logging.Logger.GLOBAL_LOGGER_NAME);
        globalLogger.setLevel(java.util.logging.Level.OFF);

I’ve been writing JUnit Parameterized tests (a nice intro here – also see Theories) to do some data driven API testing. Now, when introducing Spring into the mix there are a couple of extra things to do. I came unstuck though because I was trying to do Transactional tests – since I’m now using @RunWith(Parameterized.class) and setting up my Spring TestContextManager manually the @Transaction annotations caused an exception:

java.lang.IllegalArgumentException: Superclass has no null constructors but no arguments were given

I couldn’t find any built in solution, so I’ve gone with manual transaction management in my test, using doInTransaction:

@RunWith(Parameterized.class)
@ContextConfiguration(locations = "classpath*:/testContext.xml")
public class MyTest {

    @Autowired
    PlatformTransactionManager transactionManager;

    private TestContextManager testContextManager;

    public MyTest (... parameters for test) {
        // store parameters in instance variables
    }

    @Before
    public void setUpSpringContext() throws Exception {
        testContextManager = new TestContextManager(getClass());
        testContextManager.prepareTestInstance(this);
    }

    @Parameterized.Parameters
    public static Collection generateData() throws Exception {
        ArrayList list = new ArrayList();
        // add data for each test here
        return list;
    }

    @Test
    public void validDataShouldLoadFully() throws Exception {
        new TransactionTemplate(transactionManager).execute(new TransactionCallback() {
            public Object doInTransaction(TransactionStatus status) {
                status.setRollbackOnly();
                try {
                    ... do cool stuff here

                } catch (Exception e) {
                    throw new RuntimeException(e);
                }
                return null;
            }
        });

    }

I’ve occasionally been frustrated by the output of ‘ps -ef’ not showing the full command line for the processes. Well, it turns out that the solution is as simple as piping the output to a file – i.e. ‘ps -ef > ps.txt’ – now I can easily see the FULL command line for my java processes.

I bought a new WIFI router this week. My old one was getting flaky, and for some reason I’ve always had trouble with some of the url shorteners such as bit.ly and t.co – they just couldn’t be resolved. So I bought a basic Netgear WNR1000 which satisfied all of my criteria. One of the things I like most is that it has a switch to turn off the wireless when I don’t need it. This helps with security as well as saving power.

I’ve almost finished porting my latest application to AppEngine (Python). Lucky its a small application! I’m constantly being reminded that its useful to have skills in a lightweight technology to bootstrap and test ideas quickly. If that idea takes off, then there is always the option to re-write in a more heavy weight enterprise way. Using different languages and technologies can also be refreshing and stimulating, but it does take time.