deeman1337 1 Posted November 24, 2022 Report Share Posted November 24, 2022 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 Link to comment Share on other sites More sharing options...
AllGeniusHost 286 Posted November 25, 2022 Report Share Posted November 25, 2022 are your host/database/timezone correct 1 Link to comment Share on other sites More sharing options...
deeman1337 1 Posted November 27, 2022 Author Report Share Posted November 27, 2022 On 11/25/2022 at 10:26 AM, Deathwish said: are your host/database/timezone correct not sure how to check this one out Link to comment Share on other sites More sharing options...
insomnia 0 Posted December 17, 2022 Report Share Posted December 17, 2022 pooooooosts Link to comment Share on other sites More sharing options...
AlienBoi 0 Posted January 4, 2023 Report Share Posted January 4, 2023 sorry I do not know the answer just trying to get posts up Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now