Tweets as of 2010-08-29

  • "I don't want to be a product of my environment. I want my environment to be a product of me." – Frank Costigan, The Departed #
  • Actually said 'Good Morning' to his Mac when it it announced 'It's 8 o'clock'. Taking it to a whole new level… #
  • @auxbuss have found mockflow more helpful lately, partly as it's integrated with google apps. balsamiq has a more aesthetic UI though ;o) #

Tags:

Author: Andrew Eells    Sunday, August 29th, 2010 Uncategorized No Comments

Tweets as of 2010-08-29

  • "I don't want to be a product of my environment. I want my environment to be a product of me." – Frank Costigan, The Departed #
  • Actually said 'Good Morning' to his Mac when it it announced 'It's 8 o'clock'. Taking it to a whole new level… #
  • @auxbuss have found mockflow more helpful lately, partly as it's integrated with google apps. balsamiq has a more aesthetic UI though ;o) #

Tags:

Author: Andrew Eells    Sunday, August 29th, 2010 Uncategorized No Comments

Tweets as of 2010-08-22

  • is reading up on #NoSQL and how best to store several '000 small read-only data tables. answers on a postcard please ;o) #

Tags:

Author: Andrew Eells    Sunday, August 22nd, 2010 Uncategorized No Comments

Tweets as of 2010-07-18

  • has broken the @Oracle database. that's a first ;o) #

Tags:

Author: Andrew Eells    Sunday, July 18th, 2010 Uncategorized No Comments

RESTful system design

A useful resource (see what I did there?) showing starting point and evolving maturity when designing RESTful systems, courtesy of the ubiquitous Martin Fowler.

Author: Andrew Eells    Tuesday, July 13th, 2010 Architecture, Development, Internet, REST No Comments

Oracle 11g UCP with Tomcat

Download Instant Client Package – Basic and SQL*Plus from Oracle.
Unzip packages to /Applications/oracle/instantclient_10_2.
Add the following to ~/.bash_profile:

export DYLD_LIBRARY_PATH=/Applications/oracle/instantclient_10_2
export TNS_ADMIN=/Applications/oracle/instantclient_10_2
export PATH=$PATH:$DYLD_LIBRARY_PATH

Ensure you have the below tnsnames.ora file in TNS_ADMIN so as to connect to the server from client using connect string: sqlplus <username>@xyz


xyz =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(PORT = <port>)
(HOST = <server_name>)
)
(CONNECT_DATA = (SID = <SID>))
)
Add the following to your tomcat/conf/server.xml file:

<GlobalNamingResources>

<Resource
name="jdbc/<pool_jndi_name>"
auth="Container"
url="jdbc:oracle:thin:@<server_name>:<port>:<SID>"
user="<username>"
password="<password>"
factory="oracle.ucp.jdbc.PoolDataSourceImpl"
type="oracle.ucp.jdbc.PoolDataSource"
connectionFactoryClassName="oracle.jdbc.pool.OracleDataSource"
connectionPoolName="<pool_name>"
connectionWaitTimeout="30"
minPoolSize="5"
maxPoolSize="25"
inactiveConnectionTimeout="20"
timeoutCheckInterval="60"
validateConnectionOnBorrow="true"
sqlForValidateConnection="SELECT 1 FROM DUAL" />

...
and add the ucp.jar to tomcat/libs directory.

Author: Andrew Eells    Wednesday, July 7th, 2010 Code, Database, Development, Oracle, Tomcat No Comments

Dozer examples

Best place to find Dozer example mapping files is in the source bundle under test/resources. Most other examples out there are pretty basic and won’t help you if you want to do something more complex…

Author: Andrew Eells    Monday, July 5th, 2010 Code No Comments

Tweets as of 2010-06-27

Tags:

Author: Andrew Eells    Sunday, June 27th, 2010 Uncategorized No Comments

Tweets as of 2010-06-20

Tags:

Author: Andrew Eells    Sunday, June 20th, 2010 Uncategorized No Comments

Google Apps observations

After experimenting and persevering with Google Apps in a corporate environment I would say the following are the headline issues we have experienced:

Positives:

  • Fantastic cost/effort reduction over homegrown or outsourced alternatives
  • Simple setup and good online documentation and usability

Negatives:

  • Lack of full product features in Google Docs versus MS Office
  • Security features not entirely sufficient for a corporate environment

In general, for the cost, speed and effort with which you can set up a functioning environment I would say it’s definitely worth at least making sure you positively rule out Google Apps as an option for your corporate IT infrastructure.

The major issues we have found that might count against Google would be the inability to restrict usage to a certain IP range (i.e. the office) and poor Docs interoperability with MS Office. Until these are resolved corporate users will be slow on the uptake.

I think it’s a reasonable assumption that the products will improve rapidly – but I have found a lot of people with similar observations and no indication from Google that the security issues at least are being tackled!

Author: Andrew Eells    Tuesday, March 16th, 2010 Code No Comments

Tech Startup