I was looking for some tutorial about configuring Squirrel SQL (http://squirrel-sql.sourceforge.net/) to connect to firebird database and unfortunately i couldn’t find one . So when i finally managed to connect, i thought of publishing the steps in my log so that it could be useful to some one else.
Configuring Squirrel Sql to connect to firebird was much easier than i thought. You need to go to firebird website and look for JCA-JDBC Driver downloads. At the time of writing this blog, the latest release was 2.1.6 (http://prdownloads.sourceforge.net/firebird/Jaybird-2.1.6JDK_1.6.zip?download). Download it and unzip it. There will be a jar file called Jaybird-2.1.6-full.jar. Copy this file and save it in your Squirrel lib directory (It will be something like C:/Program Files/Squirrel SQL/ lib).
Now start Squirrel and you will see the jaybird driver listed in the drivers window (with a tick sign). Now click on the menu and click add. In the Database driver section put Jaybird Driver and provide the database url in the format jdbc:firebirdsql:localhost/3050:/firebird/test.gdb Now give your username and password . Hooray !!! you are finally connected to firebird database…
Finally after an adventurous coach journey (yes i accept that i was stupid and hence took a coach), i finally arrived in Antwerp to attend the famous Devoxx conference in Antwerp (Antwerepen…. in Belgium way). It surely lived up to its hype and made me think how much i still don’t know about the new technologies..
Devoxx is the same Javapolis conference, but had to change the name due to objections from Sun. It is strange that they had to change the name, knowing the fact that Sun is also sponsoring the event. Maybe sun wants to pre-empt any attempt to use the name ‘Java’ by any group and hence this carrot and stick approach.
On day two, I attended the talk ActiveMQ and ServiceMix by Bruce Snyder. Bruce is an active proponent of open source solutions and one of the founding members of Apache Geronimo propject. These days he is busy talking in conferences about ActiveMQ and co-authoring a book on it which is supposed to come out in early part of next year (quoting him from conference). He started off the talk with basic features of ActiveMQ, its benefits and how to configure it. ActiveMQ is an open source message broker with support of JMS and Enterprise Integration patterns. Although it is open source, it is used by a lot of companies and seems to be an ideal choice to replace the age-old JMS systems.
I couldn’t imagine that the configuration of ActiveMQ is so simple (or maybe a delusion in my head) and with Spring 2.5 it has become much easier. ActiveMQ is something which has been in my mind for some time, since at my workplace they decided of changing their old JbossMQ system which was totally unreliable. I was thinking of proposing ActiveMQ as a suitable candidate as it seems to perfectly fit our needs.
Some cool features of ActiveMQ
- Support for Java, C, C++, C#, Ruby, Perl, Python, PHP
- Support for EIP (Enterprise Integration Patterns)
- Support for JMS 1.1 and J2EE 1.4 with support for transient, persistent, transactional and XA messaging
- Supports TCP, SSL, NIO, UDP, multicast, JGroups and JXTA transports
- Master Slave Configurability and Clustering support
http://www.devoxx.com/
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
This normally happens when we are using the user-generated-certificates instead of the certificate generated by Certification Authorities. So to avoid this download and run this little java program
http://blogs.sun.com/andreas/resource/InstallCert.java
java InstallCert myserver.xyz.com . Here myserver.xyz.com is your server hostname
It downloads the certificate and asks whether to add it to the keystore
Enter certificate to add to trusted keystore or ‘q’ to quit: [1]
press Enter
this will generate the file jssecacerts in the current directory . Copy it to $JAVA_HOME/jre/lib/security . Hooray … no more exception
For detailed information see the blog of andreas http://blogs.sun.com/andreas/entry/no_more_unable_to_find
Related Links
http://java.sun.com/j2se/1.4.2/docs/tooldocs/windows/keytool.html
How many times have you been left wondering all those weird codes in db2 means? Every time you had to open the db2 command prompt to find out what the code means.. In IBM website, there is a page explaining the sql error codes..
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0sttmsg.htm
