DB2的Mule数据库连接器URL格式不正确 [英] Mule database connector url format for DB2 not correct

问题描述

我正在尝试将Mule的数据库连接器连接到DB2数据库，但是我无法找出数据库URL的正确格式.我使用数据库URL创建了通用数据库配置全局元素

I am trying Mule's Database Connector to connect to a DB2 database but I couldn't figure out the correct format for the database URL. I created a Generic Database Configuration global element with Database URL

jdbc:db2://db01.dev.myserver.org:50000/mydb;User=test;Password=secret

和驱动程序

com.ibm.db2.jcc.DB2Driver

当我单击测试连接"时，它说

When I click Test Connection, it says

Test connection failed: Cannot get connection for URL
jdbc:db2://db01.dev.myserver.org:50000/mydb;User=test;Password=secret :
[ibm][db2][jcc][t4][10205][11234] Null userid is not supported. 

如何在URL中输入用户名和密码?

How shall I put the username and password in the URL?

谢谢！

推荐答案

JDBC属性(例如user和password)需要用冒号(:")与URL的其余部分分开，并且每个属性(包括最后一个属性)应以分号(;")终止.我怀疑属性名称可能也区分大小写.所以

JDBC properties, such as user and password need to be separated from the rest of the URL with a colon (":"), and each property, including the last one, should be terminated with a semicolon (";"). I suspect the property names may be also case-sensitive. So

jdbc:db2://db01.dev.myserver.org:50000/mydb:user=test;password=secret;

参考: 查看全文