Advertisement
Guest User

Untitled

a guest
Dec 19th, 2016
278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.49 KB | None | 0 0
  1. ### Error opening session. Cause: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.19.49] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
  2.  
  3. public class Test {
  4. public static void main(String[] args){
  5. Reader reader = null;
  6. SqlSessionFactory sqlSessionFactory = null;
  7. SqlSession session = null;
  8.  
  9. try {
  10. reader = Resources.getResourceAsReader("mybatis-config.xml");
  11. } catch (IOException e) {
  12. System.out.println("MyBatis config not found!");
  13. e.printStackTrace();
  14. }
  15.  
  16. sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  17. session = sqlSessionFactory.openSession();
  18.  
  19. User user = new User();
  20. user.setName("second");
  21. user.setNumber(2);
  22. session.insert("User.addNew", user);
  23.  
  24. int num = session.selectOne("User.getNumber", "second");
  25. System.out.println(num);
  26.  
  27. session.close();
  28. }
  29. }
  30.  
  31. <mapper namespace="User">
  32. <resultMap type="int" id="resultNumber">
  33. <result property="number" column="NUMBER" />
  34. </resultMap>
  35. <resultMap type="User" id="resultUser">
  36. <result property="name" column="NAME" />
  37. <result property="number" column="NUMBER" />
  38. </resultMap>
  39. <select id="getNumber" parameterType="String" resultMap="resultNumber">
  40. SELECT number
  41. FROM mp.mybatis
  42. WHERE name = #{name}
  43. </select>
  44. <select id="getUser" parameterType="String" resultMap="resultUser">
  45. SELECT *
  46. FROM mp.mybatis
  47. WHERE name = #{name}
  48. </select>
  49. <insert id="addNew" parameterType="User">
  50. INSERT INTO mp.mybatis (name, number)
  51. VALUES (#{name}, #{number})
  52. </insert>
  53. <update id="updateUser" parameterType="map">
  54. UPDATE mp.mybatis
  55. SET name = #{new.name}, number = #{new.number}
  56. WHERE name = #{old.name} AND number = #{old.number}
  57. </update>
  58. <delete id="deleteUser" parameterType="String">
  59. DELETE FROM mp.mybatis
  60. WHERE name = #{name}
  61. </delete>
  62. </mapper>
  63.  
  64. <?xml version='1.0' encoding='UTF-8' ?>
  65. <!DOCTYPE configuration
  66. PUBLIC '-//mybatis.org//DTD Config 3.0//EN'
  67. 'http://mybatis.org/dtd/mybatis-3-config.dtd'>
  68. <configuration>
  69. <properties resource='jdbc.properties' />
  70. <typeAliases>
  71. <typeAlias type='com.MyBatisMP.POJO.User' alias='User'></typeAlias>
  72. </typeAliases>
  73. <environments default='development'>
  74. <environment id='development'>
  75. <transactionManager type='JDBC' />
  76. <dataSource type='POOLED'>
  77. <property name='driver' value='${jdbc.driverClassName}' />
  78. <property name='url' value='${jdbc.url}' />
  79. <property name='username' value='${jdbc.username}' />
  80. <property name='password' value='${jdbc.password}' />
  81. </dataSource>
  82. </environment>
  83. </environments>
  84. <mappers>
  85. <mapper resource='com/MyBatisMP/Mapper/UserMapper.xml' />
  86. </mappers>
  87. </configuration>
  88.  
  89. jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
  90. jdbc.url=jdbc:db2://localhost:50000/mp
  91. jdbc.username=XXX
  92. jdbc.password=XXX
  93.  
  94. Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
  95. ### Error opening session. Cause: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.19.49] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
  96. ### Cause: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.19.49] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
  97. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
  98. at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:81)
  99. at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSession(DefaultSqlSessionFactory.java:32)
  100. at com.MyBatisMP.Test.Test.main(Test.java:27)
  101. Caused by: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.19.49] Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
  102. at com.ibm.db2.jcc.am.kd.a(Unknown Source)
  103. at com.ibm.db2.jcc.am.kd.a(Unknown Source)
  104. at com.ibm.db2.jcc.t4.ac.a(Unknown Source)
  105. at com.ibm.db2.jcc.t4.ac.<init>(Unknown Source)
  106. at com.ibm.db2.jcc.t4.a.b(Unknown Source)
  107. at com.ibm.db2.jcc.t4.b.newAgent_(Unknown Source)
  108. at com.ibm.db2.jcc.am.Connection.initConnection(Unknown Source)
  109. at com.ibm.db2.jcc.am.Connection.<init>(Unknown Source)
  110. at com.ibm.db2.jcc.t4.b.<init>(Unknown Source)
  111. at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(Unknown Source)
  112. at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(Unknown Source)
  113. at com.ibm.db2.jcc.DB2Driver.connect(Unknown Source)
  114. at com.ibm.db2.jcc.DB2Driver.connect(Unknown Source)
  115. at java.sql.DriverManager.getConnection(Unknown Source)
  116. at java.sql.DriverManager.getConnection(Unknown Source)
  117. at org.apache.ibatis.datasource.unpooled.UnpooledDataSource.getConnection(UnpooledDataSource.java:64)
  118. at org.apache.ibatis.datasource.pooled.PooledDataSource.popConnection(PooledDataSource.java:349)
  119. at org.apache.ibatis.datasource.pooled.PooledDataSource.getConnection(PooledDataSource.java:55)
  120. at org.apache.ibatis.session.defaults.DefaultSqlSessionFactory.openSessionFromDataSource(DefaultSqlSessionFactory.java:72)
  121. ... 2 more
  122. Caused by: java.net.ConnectException: Connection refused: connect
  123. at java.net.DualStackPlainSocketImpl.connect0(Native Method)
  124. at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
  125. at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
  126. at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
  127. at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
  128. at java.net.PlainSocketImpl.connect(Unknown Source)
  129. at java.net.SocksSocketImpl.connect(Unknown Source)
  130. at java.net.Socket.connect(Unknown Source)
  131. at com.ibm.db2.jcc.t4.w.run(Unknown Source)
  132. at java.security.AccessController.doPrivileged(Native Method)
  133. ... 19 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement