• <legend id='O0rfW'><style id='O0rfW'><dir id='O0rfW'><q id='O0rfW'></q></dir></style></legend>

      1. <small id='O0rfW'></small><noframes id='O0rfW'>

          <bdo id='O0rfW'></bdo><ul id='O0rfW'></ul>

      2. <tfoot id='O0rfW'></tfoot>
        <i id='O0rfW'><tr id='O0rfW'><dt id='O0rfW'><q id='O0rfW'><span id='O0rfW'><b id='O0rfW'><form id='O0rfW'><ins id='O0rfW'></ins><ul id='O0rfW'></ul><sub id='O0rfW'></sub></form><legend id='O0rfW'></legend><bdo id='O0rfW'><pre id='O0rfW'><center id='O0rfW'></center></pre></bdo></b><th id='O0rfW'></th></span></q></dt></tr></i><div id='O0rfW'><tfoot id='O0rfW'></tfoot><dl id='O0rfW'><fieldset id='O0rfW'></fieldset></dl></div>

        通过 JDBC 连接到 DB2 时的用户名和密码

        时间:2023-09-30

        1. <tfoot id='A9otD'></tfoot>
                <bdo id='A9otD'></bdo><ul id='A9otD'></ul>
                <legend id='A9otD'><style id='A9otD'><dir id='A9otD'><q id='A9otD'></q></dir></style></legend>
                <i id='A9otD'><tr id='A9otD'><dt id='A9otD'><q id='A9otD'><span id='A9otD'><b id='A9otD'><form id='A9otD'><ins id='A9otD'></ins><ul id='A9otD'></ul><sub id='A9otD'></sub></form><legend id='A9otD'></legend><bdo id='A9otD'><pre id='A9otD'><center id='A9otD'></center></pre></bdo></b><th id='A9otD'></th></span></q></dt></tr></i><div id='A9otD'><tfoot id='A9otD'></tfoot><dl id='A9otD'><fieldset id='A9otD'></fieldset></dl></div>

                <small id='A9otD'></small><noframes id='A9otD'>

                  <tbody id='A9otD'></tbody>
                  本文介绍了通过 JDBC 连接到 DB2 时的用户名和密码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

                  问题描述

                  我正在尝试连接到本地 DB2 10.5 Express-C 服务器.这是一个测试环境,所以我不关心安全性.

                  I am trying to connect to a local DB2 10.5 Express-C server. This is a testing environment so I don't care about security.

                  我能够连接到命令行处理器(在 Windows 上运行),并且我更改了 AUTHENTICATION=CLIENTTRUST_ALLCLNTS=YES 的配置设置.那时我希望能够在不进行身份验证的情况下进行连接(我重新启动了 DB2 服务),但仍然出现错误.

                  I am able to connect to the Command Line Processor (running on Windows), and I changed the configuration settings for AUTHENTICATION=CLIENT and TRUST_ALLCLNTS=YES. I expected to be able to connect without authentication at that point (I restarted the DB2 service), but I still get an error.

                  当我尝试在没有用户名/密码的情况下进行连接时

                  When I try to connect without username/password

                  jdbc:db2://localhost:50000/test
                  

                  我收到错误:com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][4.14.146] Null userid is not supported.ERRORCODE=-4461,SQLSTATE=42815

                  I get the error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][4.14.146] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815

                  当我尝试添加虚假"用户/密码时(因为我不知道如何设置或重置凭据),例如

                  And when I try to add "bogus" user/password (because I can't figure out how to set or reset credentials), e.g.

                  jdbc:db2://localhost:50000/test:user=userid;password=password;
                  

                  我收到错误:com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][4.14.146] 发生连接授权失败.原因:不支持安全机制.ERRORCODE=-4214,SQLSTATE=28000

                  I get the error: com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][201][11237][4.14.146] Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000

                  如何使用 JDBC 进行连接?

                  How can I connect using JDBC?

                  DB2 配置如下:

                  db2 get dbm cfg
                  
                  
                            Database Manager Configuration     Node type = Database Server with local and remote clients Database manager configuration release level            = 0x1000 CPU speed (millisec/instruction)             (CPUSPEED) = 1.023413e-007 Max number of concurrently active databases     (NUMDB) = 32
                   Federated Database System Support           (FEDERATED) = NO
                   Transaction processor monitor name        (TP_MON_NAME) = 
                   Default charge-back account           (DFT_ACCOUNT_STR) = 
                   Java Development Kit installation path       (JDK_PATH) = C:PROGRA~1IBMSQLLIBjavajdk Diagnostic error capture level              (DIAGLEVEL) = 3
                   Notify Level                              (NOTIFYLEVEL) = 3
                   Diagnostic data directory path               (DIAGPATH) = E:DataDB2\IBMDB2DB2COPY1DB2
                   Current member resolved DIAGPATH                        = E:DataDB2\IBMDB2DB2COPY1DB2
                   Alternate diagnostic data directory path (ALT_DIAGPATH) = 
                   Current member resolved ALT_DIAGPATH                    = 
                   Size of rotating db2diag & notify logs (MB)  (DIAGSIZE) = 0 Default database monitor switches
                     Buffer pool                         (DFT_MON_BUFPOOL) = OFF
                     Lock                                   (DFT_MON_LOCK) = OFF
                     Sort                                   (DFT_MON_SORT) = OFF
                     Statement                              (DFT_MON_STMT) = OFF
                     Table                                 (DFT_MON_TABLE) = OFF
                     Timestamp                         (DFT_MON_TIMESTAMP) = ON
                     Unit of work                            (DFT_MON_UOW) = OFF
                   Monitor health of instance and databases   (HEALTH_MON) = OFF SYSADM group name                        (SYSADM_GROUP) = 
                   SYSCTRL group name                      (SYSCTRL_GROUP) = 
                   SYSMAINT group name                    (SYSMAINT_GROUP) = 
                   SYSMON group name                        (SYSMON_GROUP) = 
                   Client Userid-Password Plugin          (CLNT_PW_PLUGIN) = 
                   Client Kerberos Plugin                (CLNT_KRB_PLUGIN) = IBMkrb5
                   Group Plugin                             (GROUP_PLUGIN) = 
                   GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) = 
                   Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
                   Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) = 
                   Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) = 
                   Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
                   Cluster manager                                         = 
                   Database manager authentication        (AUTHENTICATION) = CLIENT
                   Alternate authentication           (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
                   Cataloging allowed without authority   (CATALOG_NOAUTH) = YES
                   Trust all clients                      (TRUST_ALLCLNTS) = YES
                   Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
                   Bypass federated authentication            (FED_NOAUTH) = YES Default database path                       (DFTDBPATH) = C: Database monitor heap size (4KB)          (MON_HEAP_SZ) = AUTOMATIC(66)
                   Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 2048
                   Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0
                   Global instance memory (4KB)          (INSTANCE_MEMORY) = AUTOMATIC(3592673)
                   Member instance memory (4KB)                            = GLOBAL
                   Agent stack size                       (AGENT_STACK_SZ) = 16
                   Sort heap threshold (4KB)                  (SHEAPTHRES) = 0 Directory cache support                     (DIR_CACHE) = YES Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
                   Max requester I/O block size (bytes)         (RQRIOBLK) = 65535
                   Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10 Priority of agents                           (AGENTPRI) = SYSTEM
                   Agent pool size                        (NUM_POOLAGENTS) = AUTOMATIC(100)
                   Initial number of agents in pool       (NUM_INITAGENTS) = 0
                   Max number of coordinating agents     (MAX_COORDAGENTS) = AUTOMATIC(200)
                   Max number of client connections      (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAGENTS) Keep fenced process                        (KEEPFENCED) = YES
                   Number of pooled fenced processes         (FENCED_POOL) = AUTOMATIC(MAX_COORDAGENTS)
                   Initial number of fenced processes     (NUM_INITFENCED) = 0 Index re-creation time and redo index build  (INDEXREC) = RESTART Transaction manager database name         (TM_DATABASE) = 1ST_CONN
                   Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180 SPM name                                     (SPM_NAME) = WORKS12
                   SPM log size                          (SPM_LOG_FILE_SZ) = 256
                   SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
                   SPM log path                             (SPM_LOG_PATH) = 
                   TCP/IP Service name                          (SVCENAME) = db2c_DB2
                   Discovery mode                               (DISCOVER) = SEARCH
                   Discover server instance                (DISCOVER_INST) = ENABLE SSL server keydb file                   (SSL_SVR_KEYDB) = 
                   SSL server stash file                   (SSL_SVR_STASH) = 
                   SSL server certificate label            (SSL_SVR_LABEL) = 
                   SSL service name                         (SSL_SVCENAME) = 
                   SSL cipher specs                      (SSL_CIPHERSPECS) = 
                   SSL versions                             (SSL_VERSIONS) = 
                   SSL client keydb file                  (SSL_CLNT_KEYDB) = 
                   SSL client stash file                  (SSL_CLNT_STASH) = 
                   Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
                   Enable intra-partition parallelism     (INTRA_PARALLEL) = NO No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
                   No. of int. communication channels   (FCM_NUM_CHANNELS) = AUTOMATIC(512)
                   db2start/db2stop timeout (min)        (START_STOP_TIME) = 10 WLM dispatcher enabled                 (WLM_DISPATCHER) = NO WLM dispatcher concurrency            (WLM_DISP_CONCUR) = COMPUTED WLM dispatcher CPU shares enabled (WLM_DISP_CPU_SHARES) = NO WLM dispatcher min. utilization (%) (WLM_DISP_MIN_UTIL) = 5 Communication buffer exit library list (COMM_EXIT_LIST) = 
                   Current effective arch level         (CUR_EFF_ARCH_LVL) = V:10 R:5 M:0 F:5 I:0 SB:0
                   Current effective code level         (CUR_EFF_CODE_LVL) = V:10 R:5 M:0 F:5 I:0 SB:0 Keystore type                           (KEYSTORE_TYPE) = NONE
                   Keystore location                   (KEYSTORE_LOCATION) = 
                  

                  推荐答案

                  您需要使用 JDBC Type 2 URL (jdbc:db2:test) 而不是您正在使用的 Type 4 URL.您可以使用空的用户名/密码.

                  You need to use a JDBC Type 2 URL (jdbc:db2:test) Instead of the Type 4 URL you are using. You can use an empty username/password.

                  由于您的应用程序与数据库服务器在同一台机器上运行,您甚至不需要设置 AUTHENTICATION = CLIENTTRUST_ALLCLNTS = YES.

                  Since your application is running on the same machine as the database server, you don't even need to set AUTHENTICATION = CLIENT or TRUST_ALLCLNTS = YES.

                  这篇关于通过 JDBC 连接到 DB2 时的用户名和密码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持html5模板网!

                  上一篇:使用 Java 为 DB2 和 Oracle 插入 BLOB 下一篇:DB2 java 存储过程调用返回错误 SQLCODE=-440, SQLSTAT

                  相关文章

                  最新文章

                      <small id='c398N'></small><noframes id='c398N'>

                      • <bdo id='c398N'></bdo><ul id='c398N'></ul>
                    1. <legend id='c398N'><style id='c398N'><dir id='c398N'><q id='c398N'></q></dir></style></legend>

                      <tfoot id='c398N'></tfoot>
                    2. <i id='c398N'><tr id='c398N'><dt id='c398N'><q id='c398N'><span id='c398N'><b id='c398N'><form id='c398N'><ins id='c398N'></ins><ul id='c398N'></ul><sub id='c398N'></sub></form><legend id='c398N'></legend><bdo id='c398N'><pre id='c398N'><center id='c398N'></center></pre></bdo></b><th id='c398N'></th></span></q></dt></tr></i><div id='c398N'><tfoot id='c398N'></tfoot><dl id='c398N'><fieldset id='c398N'></fieldset></dl></div>