I am building a website which will have a rigorous database access. It should also have a good exception handling mechanism and be fast. To avoid DB access, I want to load some of the values in RAM using Java.
- Inorder to handle MySQL DB handles issue, I am creating a pool of DB handles and accessing them using threads in Java.
- The Java shall provide interfaces to access the values present in RAM as well as provide user management and some other interfaces.
- I need detailed error handling and exception handling is great in Java as compared to PHP.
Now my problem is:
- Accessing Java objects in PHP is an issue because it does not have a great system to store values in PHP.
- Also, PHP access to Java is required through PHP bridge.
So, Should I use JSP? But JSP is not available on all servers, so thats a dilemma for me.
Is PHP -> Java bridge a good solution? Is it scalable and has good performance as compared to JSP->Java combination