blocks|key|83557|text|在这个回答中，我忽略了加载失败消息，并回答了与jdbc+Type2JDBC连接功能相关的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|83558|从db2-LUWv11.1IBM+deprecated+"db2jcc.jar“开始，这意味着它将不会获得任何新特性，尽管修补程序将继续提供。|offset|length|83559|IBM驱动程序的当前支持版本同时支持类型2连接和类型4连接，包括两种类型的并发，正如Db2指定的：|83560|IBM+Data+Server+Driver+for+JDBC+and+|83561|是一个单独的驱动程序，它包括JDBC+type2和JDBC+type4行为。当应用程序加载用于JDBC和SQLJ的IBM+Data+Server+Driver时，将为类型2和类型4实现加载单个驱动程序实例。应用程序可以使用这个单一的驱动程序实例建立类型2和类型4连接。类型2和类型4的连接可以同时进行。IBM+Data+Server+Driver+for+JDBC+and+SQLJ+type2驱动程序行为称为IBM+Data+Server+Driver+for+JDBC+and+SQLJ+type2连接。IBM+Data+Server+Driver+for+JDBC+and+SQLJ+Type4驱动程序行为称为IBM+Data+Server+Driver+for+JDBC+and+SQLJ+Type4+connectivity。“|blockquote|83562|83563|83564|因此，当我通过DriverManager接口对无密码的本地连接使用Type2URL+format+(jdbc:db2:mydbname)时，当db2jcc4.jar位于CLASSPATH的开头并且db2jcc.jar不在CLASSPATH上时，它会成功连接。|style|CODE|83565|它还允许jdbc调用SQL存储过程，该存储过程返回输出参数(已正确检索)以及结果集等。|83566|因此，除了URL之外，如果您使用的是db2jcc4.jar的当前版本，我不知道您还需要更改什么-通常需要进行仔细的测试。|83567|entityMap|0|LINK|mutability|MUTABLE|url|https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_cjvintro.html^0|0|H|A|0|0|0|0|0|0|0|1E|H|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1B|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@$D|1F|E|1G|Q|R]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1I|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

In this answer I ignore the load-failure message and respond to the questions relating to Db2 Type-2 jdbc connectivity capabilities.

Starting from Db2-LUW V11.1 IBM <a href="https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_cjvintro.html" rel="nofollow noreferrer">deprecated</a> "db2jcc.jar" which means it won't get any new features although fixes will continue to be delivered.

The currently supported versions of the Db2 jdbc driver support both Type-2 connections and Type-4 connections including both types concurrentl, as IBM specifies:
:

<blockquote>
 "The IBM Data Server Driver for JDBC and SQLJ is a single driver that
 includes JDBC type 2 and JDBC type 4 behavior. When an application
 loads the IBM Data Server Driver for JDBC and SQLJ, a single driver
 instance is loaded for type 2 and type 4 implementations. The
 application can make type 2 and type 4 connections using this single
 driver instance. The type 2 and type 4 connections can be made
 concurrently. IBM Data Server Driver for JDBC and SQLJ type 2 driver
 behavior is referred to as IBM Data Server Driver for JDBC and SQLJ
 type 2 connectivity. IBM Data Server Driver for JDBC and SQLJ type 4
 driver behavior is referred to as IBM Data Server Driver for JDBC and
 SQLJ type 4 connectivity."
</blockquote>

So when I use the Type-2 URL format (<code>jdbc:db2:mydbname</code>) for passwordless local connections via the DriverManager interface, it connects successfully when db2jcc4.jar is at the start of the CLASSPATH and db2jcc.jar is not on the CLASSPATH.

It also lets jdbc call an SQL PL stored-procedure that returns an output parameter (which is correctly retrieved) along with result-set etc.

So apart from the URL, I don't know what else you need to change if you are using a current version of db2jcc4.jar - subject to careful testing as usual.

My Java app is getting called form withing a shell script and Java app is then calling a Stored procedure. It was working all fine till the time I was using Type 4 Drivers but not working when tried to use Type 2 drivers . We must not use password to connect to Database through java which resulted in going for Type 2 drivers. 
I am getting below error when trying with type 2 :

<blockquote>
 com.ibm.db2.jcc.am.SqlException: [jcc][10389][12245][3.61.86] Failure
 in loading native library db2jcct2, java.lang.UnsatisfiedLinkError:
 db2jcct2 (Not found in java.library.path): ERRORCODE=-4472,
 SQLSTATE=null
</blockquote>

Tried setting path of the native library as well for 64 bits as the database is 64 bit , using :

<pre><code>export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/prods/db2/USH25D/sqllib/lib64 
</code></pre>

Nothing seems to be working . But the question is does TYPE2 Drivers support Stored Procedure calls for the SPs which return values ?
 If this is not supported then the efforts to make it working will go invain

Can I use Type 2 JDBC Driver to call a SP from within java without passing username and password?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我的Java应用程序使用shell脚本调用表单，然后Java应用程序调用存储过程。在我使用Type4驱动程序之前，它工作得很好，但当我尝试使用Type2驱动程序时，它就不能工作了。我们不能使用密码通过java连接到数据库，这会导致使用Type2驱动程序。尝试使用类型2时出现以下错误： com.ibm.db2.jcc.a...

我是否可以使用Type2 JDBC驱动程序从java内部调用SP，而无需传递用户名和密码？-腾讯云开发者社区-腾讯云

问我是否可以使用Type2 JDBC驱动程序从java内部调用SP，而无需传递用户名和密码？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我是否可以使用Type2 JDBC驱动程序从java内部调用SP，而无需传递用户名和密码？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我是否可以使用Type2 JDBC驱动程序从java内部调用SP，而无需传递用户名和密码？
EN