How to Deploy JBoss Application Server on NetBeans

-
First of all, you need to download the JBoss Application Server from JBoss Downloads Website: http://www.jboss.org/jbossas/downloads/. Unzip the .zip file into a location on your hard drive. For instance, c:\jboss-4.0.4.GA\. Now do the following:
  • Open NetBeans and go to Services on the left Pane of the IDE.
  • Right click on drivers, and select 'New Driver'.
  • A window titled 'New JDBC Driver' will appear, Click on 'Add' Button.
  • Browse to ...\jboss-4.0.4.GA\server\default\lib and select 'hsqldb.jar'.
  • The Driver class should be "org.hsqldb.jdbcDriver" and choose a name for the Driver.
Before making a connection to the Database, you have to make some configurations:

Environment Variables:
  • Create a variable named "JBOSS_HOME" and set the value pointing to the JBoss Installation Directory, i.e. ..\jboss-4.0.4.GA
  • Add or append "...\jboss-4.0.4.GA\server\default\lib\hsqldb.jar" to the CLASSPATH variable.
These environment variable reduce the effort of modifying the XML configuration file of the JBoss Server. Now, get back to NetBeans again, go to the Databases->Drivers and right click on the driver you created and select connect using:
  • A window titled "New Database Connection" should appear.
  • Enter "sa" as username and "" empty password. These are the default username/password for JBoss Server.
  • To get the JDBC URL, open the XML file, "...\jboss-4.0.4.GA\server\default\deploy\hsqldb-ds.xml".
  • Look for the tag:
    <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDBconnection-url>
  • The parameter "jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDB" is the JDBC URL, copy it and paste into the "New Database Connection" window in NetBeans.
The reason for setting the JBOSS_HOME variable is that you can easily access the JBoss classes by referring them like given above. After you've entered the username, password and JDBC URL, press OK, and the DataBase should be connected and should show up in the Tree Heirarchy of Databases in NetBeans. It should be something like:
"jdbc:hsqldb:... /jboss-4.0.4.GA/server/default/data/hypersonic/localDB[sa on Public]".

I hope, it helps.

Comments

Post a Comment

Popular posts from this blog

Type casting problem while unmarshalling XML objects using JAXB

-
While using JAXB to unmarshall objects from a given XML, a very common problem might occur which is the type casting of the unmarshalled object. For instance, for the following code: JAXBContext jaxbContext = JAXBContext.newInstance("user.jaxb"); Unmarshaller unmarshaller = jaxbContext.createUnmarshaller(); user.jaxb.Type myType = (user.jaxb.Type) unmarshaller.unmarshal(new File("myXML.xml")); For the above code, the error: Exception in thread "main" java.lang.ClassCastException: javax.xml.bind.JAXBElement cannot be cast to user.jaxb.Type might occur. The type of the object returned by the unmarshaller is JAXBElement and trying to typecast it to your resepective type directly causes the classcastexecption, whereas, if you get the value of the returned JAXBElement object by calling the .getValue( ) method, and then do the type casting on this object to your respective type, the problem is solved,  as follows: user.jaxb.Type myType = (user.jaxb.Type)...
Read more

Second Interview at Seattle, Microsoft HQ (Part I)

-
Alright, I didn't have a very good feeling after the initial phone interview. So, I'd thought I didn't make it. The reason being, I was feeling that I didn't give correct and complete answers to all of the questions as I wrote in my other blog post regarding the first interview.  What was interesting though, was that the interviewer was never looking for the correct answer, because there wasn't one.  What he was looking for was to see my thinking process progress, and how do I respond at problems, which I believe, I did well in during the initial interview.  So, three days later I got an email from the Microsoft recruiter, stating "Congratulations, Microsoft wants you to fly out to Seattle for an in person interview". I was definitely excited seeing that email, because I hadn't been expecting it, but this definitely gave me an idea of how to prepare for the interview and what would be going through the minds of the interviewers at the Microsoft Headq...
Read more

My J2EE/Component Based Software Design Projects

-
I have tried to summarize a bunch of J2EE Projects which I completed in my graduate level course  Component Based Software Design . You can view the detailed report by clicking  J2EE/Component Based Software Design Projects . This document contains detail description of five projects implemented in the Component Based Software Design Graduate level course at George Mason University. Each project is the implementation of an Airline Reservation System but with some new functionality and new design decisions. The following J2EE projects were developed for an Airline Reservation System with different technologies to support  travel agent  and  airline HQ  functionalities i.e. adding an airline, searching for reservation, reserving a seat etc.  JBoss Application server  and  Oracle10g  Database were used.   A Java  Swing  application developed using  RMI  and  JavaBeans  to provide the above fun...
Read more