Guest User

Untitled

a guest
Apr 19th, 2018
241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.09 KB | None | 0 0
  1. HOST="jdbc:JethroData://UATSERVERHOST:9111/UATINSTANCE"
  2.  
  3. USER= "USERNAME"
  4.  
  5. PASS= "PassWord"
  6.  
  7. public Connection getConnection(String HOST, String USER, String PASS) throws IOException
  8. {
  9. Connection connection = null;
  10. try {
  11. Class.forName("com.jethrodata.JethroDriver");
  12. //STEP 3: Open a connection
  13. connection = DriverManager.getConnection(HOST, USER, PASS);
  14. return connection;
  15. }
  16. catch(Exception e) {
  17. TestAutomationOutput.outputLog("There is an exception in connecting to the jethro database rn"+e);
  18. e.printStackTrace();
  19. }
  20. return null;
  21. }
  22.  
  23. <dependency>
  24. <groupId>com.jethro</groupId>
  25. <artifactId>jethrojdbc</artifactId>
  26. <version>3.8</version>
  27. </dependency>
  28.  
  29. <build>
  30. <sourceDirectory>src</sourceDirectory>
  31. <resources>
  32. <resource>
  33. <directory>src</directory>
  34. <excludes>
  35. <exclude>**/*.java</exclude>
  36. </excludes>
  37. </resource>
  38. </resources>
  39. <plugins>
  40. <plugin>
  41. <artifactId>maven-compiler-plugin</artifactId>
  42. <version>3.7.0</version>
  43. <configuration>
  44. <source>1.8</source>
  45. <target>1.8</target>
  46. </configuration>
  47. </plugin>
  48. <plugin>
  49. <groupId>org.apache.maven.plugins</groupId>
  50. <artifactId>maven-dependency-plugin</artifactId>
  51. <executions>
  52. <execution>
  53. <id>copy</id>
  54. <phase>package</phase>
  55. <goals>
  56. <goal>copy-dependencies</goal>
  57. </goals>
  58. <configuration>
  59. <outputDirectory>
  60. ${project.build.directory}/lib
  61. </outputDirectory>
  62. </configuration>
  63. </execution>
  64. </executions>
  65. </plugin>
  66. <plugin>
  67. <groupId>org.apache.maven.plugins</groupId>
  68. <artifactId>maven-jar-plugin</artifactId>
  69. <version>3.0.2</version>
  70. <configuration>
  71. <archive>
  72. <manifest>
  73. <addClasspath>true</addClasspath>
  74. <classpathPrefix>lib/</classpathPrefix>
  75. <mainClass>rdltestmodule.RDLAutomationFrame</mainClass>
  76. </manifest>
  77. </archive>
  78. </configuration>
  79. </plugin>
  80. <plugin>
  81. <groupId>org.apache.maven.plugins</groupId>
  82. <artifactId>maven-assembly-plugin</artifactId>
  83. <version>2.2-beta-5</version>
  84. <executions>
  85. <execution>
  86. <phase>package</phase>
  87. <goals>
  88. <goal>single</goal>
  89. </goals>
  90. <configuration>
  91. <archive>
  92. <manifest>
  93. <mainClass>rdltestmodule.RDLAutomationFrame</mainClass>
  94. </manifest>
  95. </archive>
  96. <descriptorRefs>
  97. <descriptorRef>jar-with-dependencies</descriptorRef>
  98. </descriptorRefs>
  99. </configuration>
  100. </execution>
  101. </executions>
  102. </plugin>
  103. </plugins>
  104. </build>
  105.  
  106. java.sql.SQLException: java.lang.NullPointerException
  107. at com.jethrodata.JethroDriver.connect(JethroDriver.java:115)
  108. at com.jethrodata.JethroDriver.connect(JethroDriver.java:16)
  109. at java.sql.DriverManager.getConnection(Unknown Source)
  110. at java.sql.DriverManager.getConnection(Unknown Source)
  111. at rdltestmodule.JethroConnection.getConnection(JethroConnection.java:36)
  112. at rdltestmodule.TestManager.MasterTest(TestManager.java:39)
  113. at rdltestmodule.RDLAutomationFrame$2.actionPerformed(RDLAutomationFrame.java:253)
  114. at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
  115. at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
  116. at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
  117. at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
  118. at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
  119. at java.awt.Component.processMouseEvent(Unknown Source)
  120. at javax.swing.JComponent.processMouseEvent(Unknown Source)
  121. at java.awt.Component.processEvent(Unknown Source)
  122. at java.awt.Container.processEvent(Unknown Source)
  123. at java.awt.Component.dispatchEventImpl(Unknown Source)
  124. at java.awt.Container.dispatchEventImpl(Unknown Source)
  125. at java.awt.Component.dispatchEvent(Unknown Source)
  126. at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
  127. at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
  128. at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
  129. at java.awt.Container.dispatchEventImpl(Unknown Source)
  130. at java.awt.Window.dispatchEventImpl(Unknown Source)
  131. at java.awt.Component.dispatchEvent(Unknown Source)
  132. at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
  133. at java.awt.EventQueue.access$500(Unknown Source)
  134. at java.awt.EventQueue$3.run(Unknown Source)
  135. at java.awt.EventQueue$3.run(Unknown Source)
  136. at java.security.AccessController.doPrivileged(Native Method)
  137. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  138. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  139. at java.awt.EventQueue$4.run(Unknown Source)
  140. at java.awt.EventQueue$4.run(Unknown Source)
  141. at java.security.AccessController.doPrivileged(Native Method)
  142. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  143. at java.awt.EventQueue.dispatchEvent(Unknown Source)
  144. at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
  145. at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
  146. at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
  147. at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  148. at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  149. at java.awt.EventDispatchThread.run(Unknown Source)
  150.  
  151. <dependency>
  152. <groupId>com.jethrodata</groupId>
  153. <artifactId>jethro-jdbc</artifactId>
  154. <version>3.8</version>
  155. <systemPath>${basedir}srcmainresourceslibjethro-jdbc-3.8.jar</systemPath>
  156. <scope>system</scope>
  157. </dependency>
  158.  
  159. JethroConnection connection = null;
  160. try {
  161. Class.forName("com.jethrodata.JethroDriver");
  162. } catch (ClassNotFoundException e) {
  163. e.printStackTrace();
  164. }
  165. try {
  166. connection = ((JethroConnection) DriverManager
  167. .getConnection(url, username, password));
  168. } catch (SQLException e) {
  169. // TODO Auto-generated catch block
  170. e.printStackTrace();
  171. }
  172. JethroStatement stmt = null;
  173. JethroResultSet rs = null;
  174. stmt = (JethroStatement) connection.createStatement();
Add Comment
Please, Sign In to add comment