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.

Labels:

Comments

Post a Comment

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...
42 comments
Read more

Configuring Google Cardboard to work with Ant VR Headset for Lenovo Vibe K4 Note

Let me make it short. Open the Google Cardboard app from your Lenovo Vibe K4 Note. Go to Switch Viewer option and scan the following QR code. This makes Google Cardboard app to work perfectly with Ant VR Headset. Thanks to this Quora thread . Note : Dont use the inbuilt VR mode and Google Cardboard together. VR mode tries to make the whole android experience viewable through VR headset whereas Google Cardboard only produces VR experience for selective apps with Cardboard compatibility. So they dont work at the same time. Nothing goes wrong even if you activate them together, you only see VRception. Dont use default Ant VR app As mentioned in the Quora thread, dont use Ant VR app. It looks fishy and amateurish. May be its even a spying venture of PLA. who knows. Difference between 360 and 3D videos? If you open 360 videos from Google Cardboard you can watch selected 360 videos (like this one ), where you can rotate your head and look everywhere within t...
2 comments
Read more

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, ...
11 comments
Read more