Mike Blamires

It's fairly simple to install but you do need to get the NetBeans IDE as the package in the repository is just an installer, to do this use the following:


sudo wget http://us2-mirror.netbeans.info/download/5_5/mlfcs/200612070100/netbeans-5_5.tar.gz /tmp
sudo apt-get install netbeans5.5 sun-java6-jdk glassfish


This should install all the new Java goodies for you.

To login to the application server admin console at http://localhost:4848/, the default username/password is admin/adminadmin respectively.

To test your application server you can go to http://localhost:8080/

Note: you may want to use an alternative mirror or source for netbeans. Its still needs to go into the /tmp folder.Make sure multiverse is enabled in your /etc/apt/sources.list and that netbeans-5_5.tar.gz is owned by root, downloading to /tmp with sudo permissions should do this if not then you need to use sudo chown root:root netbeans-5_5.tar.gz.

Update: I fired up netbeans briefly tonight, although I have the sun-java6-jdk which is one of the dependencies of netbeans (either that or sun-java5-jdk) it moaned about not having the JPDA Debugger installed.Once I had installed sun-java5-jdk it was fine. See the netbeans package here: http://packages.ubuntu.com/feisty/devel/netbeans5.5

I have always found NetBeans to be an excellent IDE for Java development so I am very pleased to see the Ubuntu are officially supporting it with Ubuntu 7.04.
So far it has officially supported Eclipse which is very suitable for Java development but, for me personally, I have always peferred NetBeans finding it much more intuitive with more comprehensive 'out of the box' features.
It is great to see this support from Ubuntu, I will certainly be grabbing any using this when I upgrade to 7.04.

More information can be found here http://www.ubuntu.com/news/java-stack-included-in-ubuntu

April 19^th marks the release of Ubuntu 7.04 (Feisty Fawn), I won't be upgrading straight away but only because my legacy video card always plays merry hell, however, the betas I used before Christmas were encouraging and really did give credit to Ubuntu.

For those wishing to upgrade and with brevity in mind, the quick script below will guide you through (of course replacing 'edgy' with your current version):


sudo cp /etc/apt/sources.list /etc/apt/sources.list.edgy
sudo sed 's/edgy/feisty/g' -i /etc/apt/sources.list
sudo apt-get update
sudo apt-get dist-upgrade


Further checks can of course be made in case you see any errors output or problems occur:


sudo apt-get -f install
sudo dpkg --configure -a


There isn't a function in T-SQL which will round dates for you, here is a function which does just that - specifically I needed a function which would round up or down to the hour (up if > 30 minutes into the hour, down if < 30 minutes).


CREATE FUNCTION dbo.RoundDate ( @toRound as DateTime )
RETURNS DateTime AS
BEGIN

Declare @roundedDateTime DateTime
if (datepart(minute, @toRound) < 30)
begin
set @roundedDateTime = DATEADD(Hour, DATEDIFF(Hour, 0, @toRound), 0)
end
else
begin
set @roundedDateTime = DATEADD(Hour, DATEDIFF(Hour, 1, @toRound), 0)
end

return @roundedDateTime

END


The key to this working is that in the dateadd function the number variable is rounded up. So if you supply 1.75 the fractional part is discarded and it's rounded up to 2.

Taking an example with real values (simplified for the example):

Dateadd(Hour, datediff (Hour, '1900-01-01 01:00:00.000', '2007-04-16 16:10:00.000'), '1900-01-01 00:00:00.000')


• When a date value is instantiated with 1 in the above example it means 1 hour from the SQL base time (the SQL epoch if you will).
• The nested datediff function return the following, 940474.80 (approx!), in hours
• The .80 is dropped and the time is then rounded up to 940475
• The whole function now looks like this datediff(hour, 940475, 0) (remember our 0 means the 'SQL epoch')
• This then adds 94075 hours to 0 (or '1900-01-01 01:00:00.000') which leaves us with ... '2007-04-16 17:00:00.000' our time rounded up.

I think it's pretty safe to say that there are a number of ways to do this particular task, I would like to hear them.

Jext has for a very long time always been my preferred text editor and development environment for modifying legacy ASP (shudder) applications etc. It's sheer simplicity, intuitive interface, extensive range of plugins mean that even though development has frozen over time, with the original author moving on to other projects, it still remains head and shoulders above the rest

It is nice to see that Romain Guy (lead dev and creator of jext) is continuing to do well even doing an internship with the Swing UI team!

I would urge you to check out http://www.jext.org/ & http://www.curious-creature.org/