Posted November 24, 20222 yr comment_83640 ey, Does anyone know where I am going wrong with MySQL and getting the server to run. discord: Taco#3811 HikariConfig config = new HikariConfig(); // For some reason, we need to explicitly specify the timezone to prevent a stacktrace of "EDT" unrecognized. String url = "jdbc:sqlserver://" + properties.getProperty("host") + "/" + properties.getProperty("database") + ";serverTimezone=" + properties.getProperty("serverTimezone") + ";integratedSecurity=true"; log.info("Creating mysql database service [{}] with url: {}", name, url); config.setJdbcUrl(url); config.setDriverClassName("com.mysql.cj.jdbc.Driver"); //config.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); config.setAutoCommit(false); config.setRegisterMbeans(true); config.setPoolName(name); config.setMinimumIdle(Integer.parseInt(properties.getProperty("maximumConnections"))); config.setConnectionTimeout(30_000); config.setMaximumPoolSize(512); config.setLeakDetectionThreshold(60_000); //config.setUsername(properties.getProperty("username")); //config.setPassword(properties.getProperty("password")); config.validate(); return new HikariDataSource(config); } For some reason the server isn't reading the SQL in jdbc
November 27, 20222 yr Author comment_83747 On 11/25/2022 at 10:26 AM, Deathwish said: are your host/database/timezone correct not sure how to check this one out
Create an account or sign in to comment