Jump to content
Existing user? Sign In

Sign In



Sign Up
Search In
  • More options...
Find results that contain...
Find results in...

Help with LOCAL SQL


deeman1337
 Share

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.

Contact

Jack.#7022

RSPS Partners

RedemptionRSPS

What is a RSPS?

A RSPS, also known as RuneScape private server, is an online game based on RuneScape, and controlled by independent individuals.

Popular RSPS Servers

Runewild Alora RSPS RedemptionRSPS

Disclaimer

Runesuite is not affiliated with runescape, jagex, rune-server and runelocus in any way & exists solely for educational purposes.

×
×
  • Create New...