如何使用 MySQL 配置 Glassfish 4 · JavaTutorialNetwork 中文系列教程

# 如何使用 MySQL 配置 Glassfish 4 > 原文： [https://javatutorial.net/configure-glassfish-mysql](https://javatutorial.net/configure-glassfish-mysql) 本文介紹了如何使用 Glassfish 應用服務器設置和配置 MySQL 數據庫 ![](https://img.kancloud.cn/44/c7/44c7a6142d9ac9460a0e11b6bb025061_620x320.jpg) 如今，MySQL 已在生產和開發環境中廣泛使用。 Glassfish 4（及先前版本）具有易于管理數據庫連接的界面。您可以使用 Glassfish 的管理控制臺來設置和配置 MySQL 數據庫，或者，如果您愿意，可以編輯包含數據庫首選項的配置文件。我將在本教程中向您展示這兩種方法。核心部分本教程也適用于 Payara。 ## 要求 MySQL Server 安裝在本地或遠程計算機上。另外，您將需要一個現有用戶（帶有密碼）和一個對該用戶具有讀/寫權限的數據庫 Glassfish（或 Payara）4 應用程序服務器 ## 在 Glassfish 上安裝 MySQL Java Connector MySQL 的官方 JDBC（Java 數據庫連接）驅動程序稱為 MySQL Connector/J。您可以在 [https://dev.mysql.com/downloads/connector/j/](https://dev.mysql.com/downloads/connector/j/) 找到下載頁面。 1. 下載 TAR 或 ZIP 歸檔文件 - 無論您喜歡使用什么文件。解壓縮檔案后，您會發現一個名為`mysql-connector-java-X.X.XX-bin.jar`的 JAR 文件（其中`X.X.XX`是版本號）。 2. 將 JAR 文件粘貼到您的`GLASSFISH_HOME/glassfish/bin`目錄中 3. 重新啟動 Glassfish，以使更改生效 ## 創建 Glassfish JDBC 連接池在本地主機上打開 Glassfish 管理控制臺：4848 展開 JDBC，然后單擊“JDBC 連接池” 單擊“新建…”按鈕以創建新的連接池 ![Glassfish create new JDBC pool](https://img.kancloud.cn/6a/2c/6a2c5b206226a8c00898002cb667fc5f_749x561.jpg) Glassfish 創建新的 JDBC 連接池在“池名稱”中輸入連接池的名稱選擇`javax.sql.DataSource`作為“資源類型” 選擇 MySql 作為“數據庫驅動程序供應商” 點擊“下一步”按鈕進行下一步 ![Create JDBC connection pool](https://img.kancloud.cn/db/68/db68d29be33f342172dcb654e75b75e4_948x501.jpg) 創建 JDBC 連接池在屏幕 #2 上，檢查“數據源類名”，應將其設置為`com.mysql.jdbc.jdbc2.optional.MysqlDataSource` 啟用“Ping” ![Create JDBC connection pool step 2](https://img.kancloud.cn/fa/61/fa61b325c575df9a477c0a9a6fa695ee_1024x720.jpg) 創建 JDBC 連接池的步驟 2 現在在同一屏幕上向下滾動。填寫以下必填字段： * `User ` – 輸入數據庫用戶名 * `DatabaseName` –輸入數據庫的名稱 * `Password` – 是您在第一個字段中輸入的用戶密碼 * `URL`和`Url` – 在`jdbc:mysql://:3306/`之后添加數據庫的名稱，因此它成為`jdbc:mysql://:3306/tutorials` ![](https://img.kancloud.cn/84/f7/84f7f9fedb2d052aa33f8838ea5ce393_953x85.jpg) ![](https://img.kancloud.cn/c3/63/c363998f64c7e92491de82aef3e6ea83_997x531.jpg) ![](https://img.kancloud.cn/b9/39/b93909784058c5bd3c71df8576610e1c_974x131.jpg) 您可能要根據項目的偏好填寫其他一些字段，這完全取決于您！單擊“完成”按鈕以保存您的配置。發送到數據庫的`ping`命令以檢查連接。如果一切正常，您將看到以下消息： ![](https://img.kancloud.cn/eb/a4/eba466f6db427ff104009a724cb80e3e_274x74.jpg) 如果看到錯誤消息，請單擊“編輯”，然后檢查輸入的數據是否正確。 ## 在 Glassfish 中創建 JDBC 資源創建 JDBC 資源不一定是 MySQL 配置教程的一部分，但是您將需要使用它來將項目連接到數據庫，因此在這里進行介紹：選擇“JDBC 資源”，然后單擊“新建...”按鈕 ![Glassfish JDBC-resources](https://img.kancloud.cn/b1/4e/b14e0fb6413c1476a6643d221ab3617e_800x501.jpg) Glassfish JDBC 資源在“JNDI 名稱”下，輸入`jdbc/`，然后輸入您要為此資源指定的名稱。例如`jdbc/tutorialsDS` 在“池名稱”下，選擇您在上一步中剛剛創建的連接池的名稱保存新創建的 JDBC 資源 ![Glassfish create new JDBC resource](https://img.kancloud.cn/d2/f7/d2f72a0d05af96a6e97ade7dcc4d61f1_740x553.jpg) Glassfish 創建新的 JDBC 資源好的！現在，您可以將 MySQL 數據庫與在 Glassfish 服務器上部署的應用程序一起使用了。 ## 替代配置方法如果您希望通過編輯配置文件來創建連接池和 JDBC 資源，則可以通過在`<resources>...</resources>`標記之間的以下行中為選定域的`GLASSFISH_HOME/glassfish/domains/domain1/config/domain.xml`插入 Glassfish 的配置文件中來輕松完成此操作 ```java <jdbc-connection-pool ping="true" datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" name="MySQLPool" res-type="javax.sql.DataSource"> <property name="SelfDestructOnPingSecondsLifetime" value="0"></property> <property name="UseUsageAdvisor" value="false"></property> <property name="AllowSlaveDownConnections" value="false"></property> <property name="LoadBalanceBlacklistTimeout" value="0"></property> <property name="QueryTimeoutKillsConnection" value="false"></property> <property name="CacheServerConfiguration" value="false"></property> <property name="RoundRobinLoadBalance" value="false"></property> <property name="UseCursorFetch" value="false"></property> <property name="JdbcCompliantTruncation" value="true"></property> <property name="UseOnlyServerErrorMessages" value="true"></property> <property name="AllowPublicKeyRetrieval" value="false"></property> <property name="DefaultAuthenticationPlugin" value="com.mysql.jdbc.authentication.MysqlNativePasswordPlugin"></property> <property name="DontTrackOpenResources" value="false"></property> <property name="UseInformationSchema" value="false"></property> <property name="UseNanosForElapsedTime" value="false"></property> <property name="UseCompression" value="false"></property> <property name="EnableEscapeProcessing" value="true"></property> <property name="PasswordCharacterEncoding" value="UTF-8"></property> <property name="AutoDeserialize" value="false"></property> <property name="TcpRcvBuf" value="0"></property> <property name="CallableStatementCacheSize" value="100"></property> <property name="AutoSlowLog" value="true"></property> <property name="IgnoreNonTxTables" value="false"></property> <property name="UseJDBCCompliantTimezoneShift" value="false"></property> <property name="AllowNanAndInf" value="false"></property> <property name="TcpSndBuf" value="0"></property> <property name="ContinueBatchOnError" value="true"></property> <property name="Logger" value="com.mysql.jdbc.log.StandardLogger"></property> <property name="MaxAllowedPacket" value="-1"></property> <property name="PrepStmtCacheSqlLimit" value="256"></property> <property name="AllowMultiQueries" value="false"></property> <property name="StrictFloatingPoint" value="false"></property> <property name="PreparedStatementCacheSqlLimit" value="256"></property> <property name="CachePreparedStatements" value="false"></property> <property name="InitialTimeout" value="2"></property> <property name="UseUnicode" value="true"></property> <property name="AutoClosePStmtStreams" value="false"></property> <property name="UseServerPrepStmts" value="false"></property> <property name="IncludeThreadNamesAsStatementComment" value="false"></property> <property name="PreparedStatementCacheSize" value="25"></property> <property name="CreateDatabaseIfNotExist" value="false"></property> <property name="RollbackOnPooledClose" value="true"></property> <property name="SocketFactoryClassName" value="com.mysql.jdbc.StandardSocketFactory"></property> <property name="LoadBalanceValidateConnectionOnSwapServer" value="false"></property> <property name="CompensateOnDuplicateKeyUpdateCounts" value="false"></property> <property name="EnablePacketDebug" value="false"></property> <property name="JdbcCompliantTruncationForReads" value="true"></property> <property name="PadCharsWithSpace" value="false"></property> <property name="NoAccessToProcedureBodies" value="false"></property> <property name="UseTimezone" value="false"></property> <property name="ClientCertificateKeyStoreType" value="JKS"></property> <property name="Port" value="3306"></property> <property name="ClientInfoProvider" value="com.mysql.jdbc.JDBC4CommentClientInfoProvider"></property> <property name="IsInteractiveClient" value="false"></property> <property name="CachePrepStmts" value="false"></property> <property name="ProfileSQL" value="false"></property> <property name="ProfileSql" value="false"></property> <property name="MaxQuerySizeToLog" value="2048"></property> <property name="LoadBalanceHostRemovalGracePeriod" value="15000"></property> <property name="TreatUtilDateAsTimestamp" value="true"></property> <property name="DynamicCalendars" value="false"></property> <property name="DatabaseName" value="tutorials"></property> <property name="UseSSL" value="false"></property> <property name="DisconnectOnExpiredPasswords" value="true"></property> <property name="DontCheckOnDuplicateKeyUpdateInSQL" value="false"></property> <property name="TrustCertificateKeyStoreType" value="JKS"></property> <property name="MaxRows" value="-1"></property> <property name="SlowQueryThresholdMillis" value="2000"></property> <property name="ResultSetSizeThreshold" value="100"></property> <property name="UseBlobToStoreUTF8OutsideBMP" value="false"></property> <property name="TransformedBitIsBoolean" value="false"></property> <property name="Pedantic" value="false"></property> <property name="SocksProxyPort" value="1080"></property> <property name="UseUltraDevWorkAround" value="false"></property> <property name="EnableQueryTimeouts" value="true"></property> <property name="LogXaCommands" value="false"></property> <property name="PrepStmtCacheSize" value="25"></property> <property name="Password" value="YOUR_DB_PASSWORD_HERE"></property> <property name="SelfDestructOnPingMaxOperations" value="0"></property> <property name="ZeroDateTimeBehavior" value="exception"></property> <property name="CallableStmtCacheSize" value="100"></property> <property name="SecondsBeforeRetryMaster" value="30"></property> <property name="EmulateLocators" value="false"></property> <property name="LoginTimeout" value="0"></property> <property name="GatherPerfMetrics" value="false"></property> <property name="RetriesAllDown" value="120"></property> <property name="DetectCustomCollations" value="false"></property> <property name="NoDatetimeStringSync" value="false"></property> <property name="LoadBalanceStrategy" value="random"></property> <property name="UseOldUTF8Behavior" value="false"></property> <property name="LoadBalanceAutoCommitStatementThreshold" value="0"></property> <property name="UltraDevHack" value="false"></property> <property name="UseFastIntParsing" value="true"></property> <property name="StrictUpdates" value="true"></property> <property name="EmptyStringsConvertToZero" value="true"></property> <property name="UseLocalSessionState" value="false"></property> <property name="LoggerClassName" value="com.mysql.jdbc.log.StandardLogger"></property> <property name="NullNamePatternMatchesAll" value="true"></property> <property name="PopulateInsertRowWithDefaultValues" value="false"></property> <property name="ProfilerEventHandler" value="com.mysql.jdbc.profiler.LoggingProfilerEventHandler"></property> <property name="UseStreamLengthsInPrepStmts" value="true"></property> <property name="RunningCTS13" value="false"></property> <property name="UseOldAliasMetadataBehavior" value="false"></property> <property name="ReadOnlyPropagatesToServer" value="true"></property> <property name="SocketFactory" value="com.mysql.jdbc.StandardSocketFactory"></property> <property name="MaxReconnects" value="3"></property> <property name="ReportMetricsIntervalMillis" value="30000"></property> <property name="BlobsAreStrings" value="false"></property> <property name="SendFractionalSeconds" value="true"></property> <property name="CacheResultSetMetadata" value="false"></property> <property name="Paranoid" value="false"></property> <property name="AllowUrlInLocalInfile" value="false"></property> <property name="NoTimezoneConversionForTimeType" value="false"></property> <property name="EmulateUnsupportedPstmts" value="true"></property> <property name="ReconnectAtTxEnd" value="false"></property> <property name="RequireSSL" value="false"></property> <property name="UseHostsInPrivileges" value="true"></property> <property name="UseSSPSCompatibleTimezoneShift" value="false"></property> <property name="UseReadAheadInput" value="true"></property> <property name="ParseInfoCacheFactory" value="com.mysql.jdbc.PerConnectionLRUFactory"></property> <property name="DefaultFetchSize" value="0"></property> <property name="URL" value="jdbc:mysql://localhost:3306/tutorials"></property> <property name="Url" value="jdbc:mysql://localhost:3306/tutorials"></property> <property name="AllowMasterDownConnections" value="false"></property> <property name="CacheDefaultTimezone" value="true"></property> <property name="QueriesBeforeRetryMaster" value="50"></property> <property name="FunctionsNeverReturnBlobs" value="false"></property> <property name="DumpQueriesOnException" value="false"></property> <property name="LoadBalanceExceptionChecker" value="com.mysql.jdbc.StandardLoadBalanceExceptionChecker"></property> <property name="VerifyServerCertificate" value="true"></property> <property name="NetTimeoutForStreamingResults" value="600"></property> <property name="ProcessEscapeCodesForPrepStmts" value="true"></property> <property name="UseAffectedRows" value="false"></property> <property name="GatherPerformanceMetrics" value="false"></property> <property name="TinyInt1isBit" value="true"></property> <property name="MetadataCacheSize" value="50"></property> <property name="RewriteBatchedStatements" value="false"></property> <property name="CacheCallableStatements" value="false"></property> <property name="ServerName" value="localhost"></property> <property name="GetProceduresReturnsFunctions" value="true"></property> <property name="UseGmtMillisForDatetimes" value="false"></property> <property name="CapitalizeTypeNames" value="true"></property> <property name="ServerConfigCacheFactory" value="com.mysql.jdbc.PerVmServerConfigCacheFactory"></property> <property name="NoTimezoneConversionForDateType" value="true"></property> <property name="TcpTrafficClass" value="0"></property> <property name="AutoGenerateTestcaseScript" value="false"></property> <property name="CacheCallableStmts" value="false"></property> <property name="FailOverReadOnly" value="true"></property> <property name="LoadBalancePingTimeout" value="0"></property> <property name="LocatorFetchBufferSize" value="1048576"></property> <property name="RelaxAutoCommit" value="false"></property> <property name="UseFastDateParsing" value="true"></property> <property name="LoadBalanceEnableJMX" value="false"></property> <property name="OverrideSupportsIntegrityEnhancementFacility" value="false"></property> <property name="HoldResultsOpenOverStatementClose" value="false"></property> <property name="InteractiveClient" value="false"></property> <property name="UseJvmCharsetConverters" value="false"></property> <property name="PortNumber" value="3306"></property> <property name="UseDynamicCharsetInfo" value="true"></property> <property name="LogSlowQueries" value="false"></property> <property name="IncludeThreadDumpInDeadlockExceptions" value="false"></property> <property name="ReplicationEnableJMX" value="false"></property> <property name="SlowQueryThresholdNanos" value="0"></property> <property name="UseDirectRowUnpack" value="true"></property> <property name="UseSqlStateCodes" value="true"></property> <property name="IncludeInnodbStatusInDeadlockExceptions" value="false"></property> <property name="MaintainTimeStats" value="true"></property> <property name="PinGlobalTxToPhysicalConnection" value="false"></property> <property name="TcpNoDelay" value="true"></property> <property name="TraceProtocol" value="false"></property> <property name="AlwaysSendSetIsolation" value="true"></property> <property name="NullCatalogMeansCurrent" value="true"></property> <property name="YearIsDateType" value="true"></property> <property name="SocketTimeout" value="0"></property> <property name="UseServerPreparedStmts" value="false"></property> <property name="UseLocalTransactionState" value="false"></property> <property name="GenerateSimpleParameterMetadata" value="false"></property> <property name="ExplainSlowQueries" value="false"></property> <property name="UseColumnNamesInFindColumn" value="false"></property> <property name="ConnectTimeout" value="0"></property> <property name="ElideSetAutoCommits" value="false"></property> <property name="PacketDebugBufferSize" value="20"></property> <property name="RetainStatementAfterResultSetClose" value="false"></property> <property name="DumpMetadataOnColumnNotFound" value="false"></property> <property name="BlobSendChunkSize" value="1048576"></property> <property name="UseLegacyDatetimeCode" value="true"></property> <property name="UseUnbufferedInput" value="true"></property> <property name="AllowLoadLocalInfile" value="true"></property> <property name="ReadFromMasterWhenNoSlaves" value="false"></property> <property name="AutoReconnectForPools" value="false"></property> <property name="TcpKeepAlive" value="true"></property> <property name="ClobberStreamingResults" value="false"></property> <property name="User" value="root"></property> </jdbc-connection-pool> <jdbc-resource pool-name="MySQLPool" jndi-name="jdbc/tutorialsDS"></jdbc-resource> ``` 還要在`<server>...</server>`標簽中添加以下行 ```java <resource-ref ref="jdbc/tutorialsDS"></resource-ref> ``` 謝謝閱讀。如果您對許多配置屬性有任何疑問或建議，請使用下面的注釋部分。