Advertisement
Guest User

Untitled

a guest
Mar 16th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. private static HikariDataSource Hikari;
  2. public static String ID_Usuario;
  3.  
  4. public void connectToDatabase() {
  5.  
  6. Hikari = new HikariDataSource();
  7. Hikari.setDriverClassName("com.mysql.jdbc.Driver");
  8. Hikari.setJdbcUrl("jdbc:mysql://localhost:3306/bank");
  9. Hikari.setUsername("root");
  10. Hikari.setPassword("");
  11. Hikari.setMaximumPoolSize(5);
  12. Hikari.setConnectionTimeout(300000);
  13. Hikari.addDataSourceProperty("cachePrepStmts", "true");
  14. Hikari.addDataSourceProperty("prepStmtCacheSize", "250");
  15. Hikari.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
  16. Hikari.setConnectionTestQuery("SELECT 1");
  17. }
  18.  
  19. public HikariDataSource getHikari(){
  20. return Hikari;
  21. }
  22.  
  23. Pool HikariPool;
  24. HikariDataSource Hikari;
  25. Connection connection;
  26.  
  27. public SQL() {
  28. initComponents();
  29. }
  30.  
  31. public void initComponents(){
  32. HikariPool= new Pool();
  33. HikariPool.connectToDatabase();
  34.  
  35. Hikari=HikariPool.getHikari();
  36.  
  37. try{
  38. connection= Hikari.getConnection();
  39. }catch(SQLException e){
  40. e.printStackTrace();
  41. }
  42. }
  43.  
  44. public int validateLogin(String nip){
  45. int validation=0;
  46. String SQL="SELECT * FROM bank.account WHERE No_Account='"+account+"'
  47. AND NIP='"+nip+"'";
  48. try{
  49. Statement stm=Conexion.createStatement();
  50. ResultSet rs= stm.executeQuery(SQL);
  51. ...
  52.  
  53. [AWT-EventQueue-0] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-0
  54. - is starting.
  55. java.sql.SQLException: Connection is closed at
  56. com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection$1.invoke
  57. (ProxyConnection.java:468)
  58. at com.sun.proxy.$Proxy0.createStatement(Unknown Source)...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement