Shulou(Shulou.com)06/02 Report--

This article analyzes "MySQL driverClassName and URL usage" with you. The content is detailed and easy to understand. Friends interested in "MySQL driverClassName and url usage" can read it slowly and deeply along with Xiaobian's ideas. I hope it can help everyone after reading. Let's learn more about MySQL driverClassName and URL usage together with Xiaobian.

driverClassName with url driverClassNamedriverClassName: com.mysql.jdbc.Driver #mysql-connector-driverClassName: com. mysql. cj. jdbc. Driver #mysql-connector-url in java 6.x and later

user: database username (used to connect to the database)

password: user password (used to connect to database)

useUnicode: whether to use Unicode character set

characterEncoding: Specify the character encoding

autoReconnect: whether to reconnect automatically when the database connection is abnormally interrupted

autoReconnectForPools: whether to use a reconnect policy for database connection pools

failOverReadOnly: whether the connection is set to read-only after automatic reconnection is successful

maxReconnect: Number of times connections are retried when autoReconnect is set to true

initialTimeout: When autoReconnect is set to true, the time interval between reconnections, in seconds

connectTimeout: Timeout in milliseconds for establishing a socket connection with the database server. 0 means never timeout for JDK

socketTimeout: timeout for socket operations (read/write) in milliseconds. 0 means never timeout

useSSL: whether to make SSL connection

serverTimezone: database time zone setting, mysql8.x jdbc upgraded, added time zone (serverTimezone) attribute, and not allowed to be empty.

#Kaven is the specific database name you want to connect to url: jdbc: mysql://localhost: 3306/Kaven #Use Unicode character set and specify UTF-8 character encoding url: jdbc: mysql://localhost: 3306/Kaven? useUnicode = true & characterEncoding = UTF-8#Automatic reconnect url: jdbc: mysql://localhost: 3306/Kaven? autoReconnect = true #Do not make SSL connections url: jdbc: mysql://localhost: 3306/Kaven? useSSL = false #Do not make SSL connections and set the database time zone to Asia Shanghai url: jdbc: mysql://localhost: 3306/Kaven? useSSL = false & serverTimezone = Asia/Shanghai Common Database driverClassname and url #Properties file with JDBC-related settings.########### HSQLDB ############jdbc.driverClassName=org.hsqldb.jdbcDriver#jdbc.url=jdbc:hsqldb:hsql://localhost:9001/bookstore#jdbc.username=sa#jdbc.password=############ MySQL 5 ############jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test? useUnicode=true&characterEncoding=GBKjdbc.username=rootjdbc.password=root###############PostgreSQL ################jdbc.driverClassName= www.example.com Oracle ############jdbc.driverClassName=oracle.jdbc.driver.OracleDriver#jdbc.url=jdbc:oracle:thin:@192.168.1.250:1521:devdb#jdbc.username=HFOSPSP#jdbc.password=HFOSPSP##############################MS SQL Server 2000 (JTDS)###############################jdbc.driverClassName= www.example.com MS SQL Server 2000 org.postgresql.Driver#jdbc.url=jdbc:postgresql://localhost/bookstore#jdbc.username=#jdbc.password=############jdbc. username = sa #jdbc. password = ahtec #####ODBC ########jdbc. driverClassName = sun. jdbc. odbc. JdbcOdbcDriver #jdbc. url = jdbc: odbc: bookstore #jdbc. username =#jdbc. password = MySQL driverClassName and url usage is what to share here, I hope the above content can make everyone improve. If you want to learn more, please pay more attention to the updates of Xiaobian. Thank you for your attention to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.