I am getting "Adapter deployment failed: A database error was detected." ERROR while deploying the HTTP adapter
Iam just trying to deploy this auto generated adapter code with auto generated project, but it gives above error message.
IBM worklight version 8.0.0 plugin Eclipse Mars 2 Win7
Whatever you're using, it's not MobileFirst Foundation 8.0, as the Studio plug-in for Eclipse in v8.0 does not have a UI to generate adapters.
You're using 7.1 and you may have also installed 8.0, but they do different things entirely.
As for the database error - you should have provided the server log as well as the full actual log; that single error line is unclear.
What you can do is delete your workspace in Eclipse in order to generate a new 7.1 server instance, and try again.