A common database JDBC URL format 1 sqlite driver package Name: Sqlitejdbc-v056.jar Driver class Name: Org.sqlite.JDBCJDBC url:jdbc:sqlite:c:\*.db default Port No & NBSP;2 Microsoft SQL Servermicrosoft SQL Server JDBC Driver (typically used to connect to SQL Server) driver package name: Msbase.jar Mssqlserver.ja R Msutil.jar Driver class name: Com.microsoft.jdbc.sqlserver.SQLServerDriverJDBC url:jdbc:microsoft:sqlserver://<server_ Name>:<port> default port 1433, port can omit the Microsoft SQL Server 2005 JDBC driver if the server uses the default port Driver package Name: Sqljdbc.jar Driver class name: Com.microsoft.sqlserver.jdbc.SQLServerDriverJDBC url:jdbc:sqlserver://<server_name >:<port> default port 1433, port can omit 3 oracleoracle Thin JDBC driver Driver package name if the server uses the default port: Ojdbc14.jar Driver Class Name: Oracle.jdbc.driver.OracleDriverJDBC Url:jdbc:oracle:thin:@//
Note: You need to manipulate records in order to avoid garbled characters should be added attribute Useunicode=true&characterencoding=utf8, such as
Jdbc:mysql://192.168.177.129:3306/report?useunicode=true&characterencoding=utf8
Dialect of database in two Hibernate 1 Oracle dialect
Org.hibernate.dialect.OracleDialect
2 MySQL dialect
Org.hibernate.dialect.MySQLDialect
3 SQL Server dialect
Org.hibernate.dialect.SQLServerDialect
Common database JDBC URL format
