Zero Downtime with MS SQL Server
When you think you have it all planned out for high availability, having 2 SQL server in active-passive clustering and expecting 0 downtime? You are so wrong, for obvious reasons there are “few minutes” of downtime when there is a switch from one server to another.
Want a real zero downtime solution? That depends on whether you would spend the extra $ to invest in Oracle DB. It offer RAC (Real Application Cluster), multiple DB server can access the some DATA files and through a functionality they call cache fusion, it is able to maintain the data integrity between multiple servers.
So if I suddenly unplug one of the DB server from the network, I’m still able to access the DB normally as long as 1 server is still alive. Since there is no “transition” period to it there is zero downtime. Truly achieving a high available system.
SQL Server Error: 1222 Lock request time out period exceeded
You were executing some transaction (I was creating partition) that take too long to complete and somehow It lock that whole Database. Under the right conditions you should go look for the process id and kill it or kill -9.
Under particular reason and if you know that no one using the DB instance you can also
ALTER DATABASE SET OFFLINE ROLLBACK IMMEDIATE;
ALTER DATABASE SET ONLINE
It will force all uncompleted transaction to rollback
E/adb: Failed to get the adb version: Cannot run program “adb”: CreateProcess error=2, The system cannot find the file specified.
After Upgrading ADK receive error
E/adb: Failed to get the adb version: Cannot run program “adb”: CreateProcess error=2, The system cannot find the file specified.
when attempting to run ddms for debugging.
This is cause by a change of the path to the adb.
Add the path to the Environment Variable %PATH%
Right click computer > properties > advance system setting > Environment Variables button
Add not replace!!!
Integration Facebook with Andriod
While I update my Eclipse with the latest ADT(2.3), I decided to take the time to do some read up on the integration with Facebook.
Below is a link where you can get the facebook android sdk. I’ve haven’t tried it though, will blog about it if I get started on this part.
I anticipate that there will be issues with generating the Android Hash Key since Eclipse automatically signs the application for us.
keytool -exportcert -alias [alias] -keystore [keystore] | openssl sha1 -binary | openssl base64
[keystore] is the Location(Complete path in double quotes) of the keystore that you use when you export your application
[alias] is the Alias that you use for the key creation when you export your application
Example:
keytool -exportcert -alias mydebugkey -keystore "D:\Workspace\Keystore" | openssl sha1 -binary | openssl base64
Make sure that the key used is the same as the application you are using (or already on the Market) else Facebook will not be able to authenticate the application as a trusted application.
Facebook-Andriod-SDK : https://github.com/facebook/facebook-android-sdk
Unable to open class file R.java
R.java is a automatically generated file by Android, it will be created in the /gen/ folder the first time you build your project.
It is an index to all the resource that the project uses.
Anyway If you are using Eclipse and having errors building your project regarding a missing R.java, you can try to “clean” (Project > Clean) .
If the R.java file is there and somehow Eclipse doesn’t recognise it, try removing it. Eclipse should generate a new R.java automatically.
If all else fails try to restart Eclipse.
.class compatibility set to 5.0
After I copy the whole project folder to friend’s PC, he had this error
“Android requires .class compatibility set to 5.0. Please fix project properties.”
Resolution will be check the API used by the build.
Go to Project > Properties > Java Build Path > Order and Export
Check the API you are going to use. Clean your Build
Setup Dev Environment
Guide to setup the Development environment can be found at below link.
http://developer.android.com/sdk/installing.html
I’m using eclipse for the development, makes my life easier with the Android Development Toolkit(ADT)
Installing step for ADT is found at http://developer.android.com/sdk/eclipse-adt.html
I suggest you read the latest guide at the above websites first before going and downloading the stuff.
Signing up as Android Developer
Yesterday after work I went home to browse on how to upload you android application to the market.
Hence I registered an account under my gmail account, paid USD$25 and got the account setup to upload my application. If you need to be paid for our applications you will need to setup a Merchant Account which it liked to google checkout. Don’t worry if you don’t have the account yet, you will be directed to open an account on google checkout.
You will also see your previous payment of USD$25 under Purchase History, also just follow the step to verify your bank account and you will have your account setup…
Everything just comes naturally…
As a registered developer, you are also entitled to purchase unlocked android “developement” phone namely Nexus One (USD$529) and Android Dev Phone 2 (USD$399). Enjoy~
My First Post using Word Press
From first look I think that this a pretty decent piece of development work. All the navigation are responsive and give user good feedback to know where they are. The look and feels are also impressive. Next will be to explore on more of it’s features.
Anyway the main purpose of this blog is not to ogle at the wordpress, I wanted to keep a blog on my thoughts for bringing about a new startup for android development. And so it is I’ll start to blog on my adventures with Andriod.