my code stock.com

Deepak Kumar

How to create connection string to Mysql from Java
by Deepak Kumar

This requires commons-dbcp.jar file to connect to mysql database using java

Snippet options

Download: Download snippet as how-to-create-connection-string-to-mysql-from-java.java.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

public static Connection getConnection(String connectionString) throws SQLException {
		ResourceBundle bundle = ResourceBundle.getBundle("com.accenture.sourcereader.dbAccess");
		String dbName = bundle.getString("db.name");
		String userName = bundle.getString("db.user");
		String password = bundle.getString("db.passwd");
		String host = bundle.getString("db.host");
		BasicDataSource connectionPool;

        if (dataSources.containsKey(connectionString)) {
        	connectionPool = dataSources.get(connectionString);
        } else {
        	connectionPool = new BasicDataSource();
    		connectionPool.setUsername(userName);
    		connectionPool.setPassword(password);
    		connectionPool.setDriverClassName("com.mysql.jdbc.Driver");
    		connectionPool.setUrl("jdbc:mysql://" + host + ":3306/" + dbName);
    		//connectionPool.setInitialSize(20);
    		connectionPool.setMinIdle(5);
    		connectionPool.setMaxIdle(20);
    		connectionPool.setMaxOpenPreparedStatements(180);
            dataSources.put(dbName, connectionPool);
        }

        return connectionPool.getConnection();
    }

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.