Cloud SQL 자바 Connector를 사용하여 연결 만들기
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
Cloud SQL 자바 커넥터를 사용하여 SQL 서버용 Cloud SQL에 대한 연결을 엽니다.
더 살펴보기
이 코드 샘플이 포함된 자세한 문서는 다음을 참조하세요.
코드 샘플
Java
SQL Server용 Cloud SQL에 인증하려면 애플리케이션 기본 사용자 인증 정보를 설정합니다.
자세한 내용은 로컬 개발 환경의 인증 설정을 참조하세요.
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 Oracle 계열사의 등록 상표입니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],[],[],[],null,["# Create a connection using the Cloud SQL Java Connector\n\nOpen a connection to Cloud SQL for SQL Server by using the Cloud SQL Java Connector.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Connect from App Engine flexible environment](/sql/docs/sqlserver/connect-app-engine-flexible)\n- [Connect from App Engine standard environment](/sql/docs/sqlserver/connect-app-engine-standard)\n- [Connect from Cloud Run](/sql/docs/sqlserver/connect-run)\n- [Connect from Cloud Run functions](/sql/docs/sqlserver/connect-functions)\n- [Connect using Cloud SQL Language Connectors](/sql/docs/sqlserver/connect-connectors)\n\nCode sample\n-----------\n\n### Java\n\n\nTo authenticate to Cloud SQL for SQL Server, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n\n import com.zaxxer.hikari.HikariConfig;\n import com.zaxxer.hikari.HikariDataSource;\n import javax.sql.DataSource;\n\n public class ConnectorConnectionPoolFactory extends ConnectionPoolFactory {\n\n // Note: Saving credentials in environment variables is convenient, but not\n // secure - consider a more secure solution such as\n // Cloud Secret Manager (https://cloud.google.com/secret-manager) to help\n // keep secrets safe.\n private static final String INSTANCE_CONNECTION_NAME =\n System.getenv(\"INSTANCE_CONNECTION_NAME\");\n private static final String DB_USER = System.getenv(\"DB_USER\");\n private static final String DB_PASS = System.getenv(\"DB_PASS\");\n private static final String DB_NAME = System.getenv(\"DB_NAME\");\n\n public static DataSource createConnectionPool() {\n // The configuration object specifies behaviors for the connection pool.\n HikariConfig config = new HikariConfig();\n\n // The following is equivalent to setting the config options below:\n // jdbc:sqlserver://;user=\u003cDB_USER\u003e;password=\u003cDB_PASS\u003e;databaseName=\u003cDB_NAME\u003e;\n // socketFactoryClass=com.google.cloud.sql.sqlserver.SocketFactory;\n // socketFactoryConstructorArg=\u003cINSTANCE_CONNECTION_NAME\u003e\n\n // See the link below for more info on building a JDBC URL for the Cloud SQL JDBC Socket Factory\n // https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory#creating-the-jdbc-url\n\n // Configure which instance and what database user to connect with.\n config\n .setDataSourceClassName(\"com.microsoft.sqlserver.jdbc.SQLServerDataSource\");\n config.setUsername(DB_USER); // e.g. \"root\", \"sqlserver\"\n config.setPassword(DB_PASS); // e.g. \"my-password\"\n config.addDataSourceProperty(\"databaseName\", DB_NAME);\n\n config.addDataSourceProperty(\"socketFactoryClass\",\n \"com.google.cloud.sql.sqlserver.SocketFactory\");\n config.addDataSourceProperty(\"socketFactoryConstructorArg\", INSTANCE_CONNECTION_NAME);\n\n // The Java Connector provides SSL encryption, so it should be disabled\n // at the driver level.\n config.addDataSourceProperty(\"encrypt\", \"false\");\n\n // cloudSqlRefreshStrategy set to \"lazy\" is used to perform a\n // refresh when needed, rather than on a scheduled interval.\n // This is recommended for serverless environments to\n // avoid background refreshes from throttling CPU.\n config.addDataSourceProperty(\"cloudSqlRefreshStrategy\", \"lazy\");\n\n // ... Specify additional connection properties here.\n // ...\n\n // Initialize the connection pool using the configuration object.\n return new HikariDataSource(config);\n }\n }\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_sqlserver)."]]