Guest User

Untitled

a guest
Dec 14th, 2018
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. package dbcontract.db;
  2.  
  3. public interface DbContract {
  4.  
  5. public static final String HOST = "jdbc:postgresql://localhost:5432/";
  6. public static final String DB_NAME = "db_notespesa";
  7. public static final String USERNAME = "postgres";
  8. public static final String PASSWORD = "";
  9. }
  10.  
  11. package dbcontract;
  12. import java.sql.Connection;
  13. import java.sql.DriverManager;
  14. import java.sql.SQLException;
  15.  
  16. import dbcontract.db.DbContract;
  17.  
  18. public class TestConnection {
  19.  
  20. public static void main(String[] args) {
  21. try {
  22. Class.forName("org.postgresql.Driver");
  23. Connection conn = DriverManager.getConnection(
  24. DbContract.HOST+DbContract.DB_NAME,
  25. DbContract.USERNAME,
  26. DbContract.PASSWORD);
  27. System.out.println("DB connected");
  28.  
  29. } catch (ClassNotFoundException | SQLException e) {
  30. e.printStackTrace();
  31. }
  32. }
  33. }
  34.  
  35. java.lang.ClassNotFoundException: org.postgresql.Driver
  36. at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:583)
  37. at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
  38. at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:521)
  39. at java.base/java.lang.Class.forName0(Native Method)
  40. at java.base/java.lang.Class.forName(Class.java:315)
  41. at TestConnection.main(TestConnection.java:13)
  42.  
  43. <`<!-- https://mvnrepository.com/artifact/org.postgresql/postgresql -->
  44. <dependency>
  45. <groupId>org.postgresql</groupId>
  46. <artifactId>postgresql</artifactId>
  47. <version>42.2.5</version>
  48. </dependency>
Add Comment
Please, Sign In to add comment