The platform mainly based on Java Application Server is the highest level of JDBC is DataSource, other, JDO, WebCache, Hibernate, etc., so that the performance of the database application is mainly written. Utilization, so DataSource can be said to be the most important application for J2EE.
For mainstream databases, such as MySQL, MSSQLServer, Oracle, from their universal performance, I suggest applying Oracle and MySQL, MS's database on the Java platform, only reach the above two databases 60- 70%, the basis of the same hardware is to do the same operation, test the support of these three databases, Mysql is up to 430, Oracle is 400, and SQL Server is only 250.
If you have to use SQLServer as a database of Java platforms, then a suitable JDBC is the most important, MS own JDBC, does not really support Datasource so far, but the JDBC of Type4 MS SQLSERVER in BEA's WebLogic8 This is a JDBC that truly supports DataSource. If you have to use SQL Server, you can refute this JDBC from the BEA's WLS.
Another point, if your J2EE application is mainly concentrated in JSP / servlet, and the background database uses Oracle, then you have a blessing. You don't use other web containers, and the servlet engine is built in the release after Oracle8.17.
If you are based on this engine, you will get the performance that other applications can't match, because Oracle's Web container is working in the address space of the database, thinking about it, what does this mean?
This means that the access to the database is "local file access mode", although Oracle also provides a standard JDBC interface to make the caller call, but in fact, the Connection object is only equivalent to a file handle, while others The JDBC links are encapsulated Socket, communicating via Socket and database, if you don't understand the difference here, then I am playing a bit: I am like two people face-to-face talks and through international long-distance talks, how is this performance? A high word is getting.
MySQL has never been designed as "network database". It is not too important for data security. Its the biggest advantage is universal, high performance, fast speed, low security, and is not a confidential application, use mysql definitely no wrong.
MS SQLServer, in addition to performance performance on the Java platform, there is nothing to say, if it is on the WIN platform, it is a top preference, no database can be compared to it on the WIN platform.
Oracle, boss on the Java platform, remove cost factors, there is no reason not to choose it on the Java platform.
