Skip to main content

How to test your application connectivity with a MySQL database in a remote server

That’s a pretty long blog title. Anyway that’s a beacon for those of you tired of testing your client application with MySQL database running locally in localhost:3306. I played all sort of querying and updating tricks between my local database and the application that I developed. But still felt incomplete without connecting my application to a MySQL server running remotely.

I searched the web for such a service and found out that it is possible through Amazon Web Services. You need to create an account with a one year free tier plan for that. But further steps sounded too complicated. Somehow in my Java journey I found out an easiest way to do it. Let me introduce you the Cloudbees.com . But one limitation is that your database size should not exceed 5MB.

  1. Go to http://www.cloudbees.com/ and signup for a free account. You will be asked to provide custom domain name, which will be used to

    Cloudbees Home Page
  2. Sign in to your new Cloudbees account. In Home page click on Services tab. You will be shown a list of services that you can subscribe to.

    Connecting to Remote SQL Server
  3. Browse for the service Database and click on Learn More.
  4. You will be directed to the subscription page, where you can subscribe to 5MB free package.
  5. Click on the Database to access the management tools for your database. You can also access this through Services dropdown in homepage.
  6. Once you are in to Database management page, click on Create Database.

    Setting up remote database
  7. You will be asked for Database Name, Database Username and Password. Fill them accordingly.

    Setting Root Username and Password
  8. Once you are done, you will be provided with server URL for your database and the port number as well. From now on you are on your own to explore the site and do wonders.

I have used this service for hosting my JSP and JSF applications remotely. If interested you may checkout my stone age primitive JSF application here http://proserver.greenxgene.cloudbees.net/

Please feed your comments and suggestions.

Comments

Popular posts from this blog

How to use JCalendar date picker in your Java Swing Applications with NetBeans

If you are one of those JAVA beginners like me who wants to implement a datepicker module in your experimental/business critical application developed with NetBeans IDE , then this for you. Let me share how I figured out to do so in simple steps with a sample code. Assuming that you have your Java Swing application ready, you will need to download the JCalendar package from here http://www.toedter.com/en/jcalendar/index.html . The page lists out various modules available with descriptions like JDateChooser, JCalendar, JYearChooser, JMonthChooser, JDayChooser, JSpinField and JLocaleChooser. The one I chose for my app was JDateChooser. After downloading and opening the ZIP file, you can see a whole set of files in it. The one we need is in the folder ‘lib’ with the name jcalendar-1.4.jar (this is the latest version while I was writing this). extract that file to your folder of comfort. The jar file you just extracted contains everything you need to implement the date picker in y...

Honda CB Twister India : A Quick Review

I came across a dozen reviews of Honda CB Twister on web and finally decided to buy it. I owned it on last March, 2012. It costed around ₹63,000 with disc brakes, alloy wheels, road tax and stuffs. The reason why I have included ‘India’ in title is because Twister is also available as Honda CB110 in other countries. Here is my short account on my experience with Twister. Mileage Mileage is a very essential part of my riding experience. I travel around 200 Kms every week, so fuel expenses shouldn't make me bankrupt. Twister’s 60 – 65 KmpL mileage is one of the factors that influenced my choice while buying. Anyway in advertisements its claimed to be 70KmpL.   Engine Nowadays its a increasing trend to see Indians going for high end bikes, but in my case I am good with medium performance engines. Twister’s 110CC engine makes riding smooth up to 55Kmph speed, beyond that Honda Twister turns in to a Honda Vibrator. Considering the fact that I’m not an adrenalized rider, ...

How to open a PDF file using ICEpdf Viewer from your Java Application?

Few weeks back I designed an application, where I wanted to display Help content through a PDF file rather than through a textbox in a JPanel, because the help content had complex formula stuffs. So I thought of embedding the PDF file with my swing application itself. But it was too tricky to learn in a short span of time. So I figured out two options to display the help content. By opening the PDF file using a native PDF Reader in the system, on click of the Help Button in my Java Swing application. By opening the PDF file using a PDF reader integrated with my application jar package, on click of the Help Button in my Java Swing application. I dont want to discourage the readers, but to be frank the above two methods didnt work for one bad reason. You need the absolute path of the PDF file to be used in the source code. One solution would be to load a PDF file from a Web link. Another solution would be to use an installation wizard (See here ) for your Java application to plac...