My Adventures in Coding

January 11, 2015

Java to Sql Server – Cannot create PoolableConnectionFactory

Filed under: Java,SQL Server,Uncategorized — Brian @ 11:14 pm
Tags: , ,

If you are connecting a Java application to a SQL Server database, which is up and running, but your connection fails with the following error:

Could not acquire a connection from DataSource – Cannot create PoolableConnectionFactory

The error is most likely that the windows service “SQL Server Browser” is disabled.

To fix the problem:

  • Start -> Control Panel -> Systems & Security -> Administrative tools -> Services
  • SQL Server Browser -> right click -> properties

image2014-10-30 19-17-34

  • Set Startup type to “Automatic”
  • Apply -> Start

image2014-10-30 19-19-16

Now you should be able to connect to SQL Server from your Java application!

October 9, 2010

Ubuntu – Increasing the maximum number of open files

Filed under: Uncategorized — Brian @ 12:26 am

Recently a co-worker and I were stress testing an application in a Ubuntu Linux virtual machine when we ran into the open file limit which is 1024 files. Initially we tried to use the command ulimit to solve this problem, however every time we tried to increase the open file limit it would still end up being 1024. Then we realized that in order for a user to use ulimit to increase the open file limit, the limits needed to first be increased in the limits.conf file. Here is what solved the problem for us:

  • Open the file in a text editor: sudo vi /etc/security/limits.conf
  • Add two lines to increase the soft limit and hard limit for the user “myuser” before the #end tag
    • myuser hard nofile 1800
    • myuser soft nofile 1600
  • You will need to reboot to make this change take effect

Now you should have a good sized file limit!

June 6, 2010

Prairie Dev Con 2010!

Filed under: Conferences,Uncategorized — Brian @ 3:20 pm

Chris Presenting at PRDC10

Chris from P2 Presenting at PRDC10

This last week I had the great opportunity to attend Prairie Dev Con 2010 in Regina. This is the first time a good sized software conference has been organized here in the prairies. I travelled to Regina with some co-workers and really enjoyed the experience. I was extremely impressed at how well organized the conference was, as well as the number of talks lined up (50 talks over 2 days).

Since this was the first time a big software conference had been hosted in Saskatchewan, the organizer, who works primarily with Microsoft technologies, used many of his contacts from within that community to put together a good list of speakers. Now that the conference has been run once and had a good attendance, the hope is for next years conference that we can attract speakers on a more wide range of technologies such as as Python, Django, Scala, and document style databases such as MongoDB.

Since Point2 has been doing a lot of interesting work with new technologies, I hope for next year we will be able to put on a number of talks to offer a more well rounded list of topics for next year.

Overall, I was really impressed with PRDC10 and I am looking forward to seeing it happen again next year!

February 27, 2010

Remote Desktop to Windows XP from Ubuntu

Filed under: Uncategorized — Brian @ 6:54 pm
Tags: , ,

This weekend I decided to reformat my laptop with the Ubuntu 9.10 Netbook Remix. So far I have been very happy with the switch, it is a great distro! Now, I still need to be able to remote into my computer at work which is Windows XP Pro. Fortunately there is a great free tool called rdesktop that does the trick.

To install rdesktop just run the following command:

        sudo aptitude install rdesktop

To start a remote desktop session:

        /usr/bin/rdesktop -f myworkmachine.company.com

Note: the -f option opens the remote desktop session in full screen mode.

To exit full screen mode:

        Ctrl+Alt+Enter

Create a free website or blog at WordPress.com.