Java tutorial
//package com.java2s; /* * JBoss, Home of Professional Open Source. * Copyright 2011, Red Hat Middleware LLC, and individual contributors * as indicated by the @author tags. See the copyright.txt file in the * distribution for a full listing of individual contributors. * * This is free software; you can redistribute it and/or modify it * under the terms of the GNU Lesser General Public License as * published by the Free Software Foundation; either version 2.1 of * the License, or (at your option) any later version. * * This software is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this software; if not, write to the Free * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA * 02110-1301 USA, or see the FSF site: http://www.fsf.org. */ import java.util.Properties; public class Main { /** * Returns properties for non XA datasource * @param jndiName */ public static Properties nonXaDsProperties(String jndiName) { Properties params = commonDsProperties(jndiName); //attributes params.put("jta", "false"); //common params.put("driver-class", "org.hsqldb.jdbcDriver"); params.put("datasource-class", "org.jboss.as.connector.subsystems.datasources.ModifiableDataSource"); params.put("connection-url", "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"); return params; } /** * Returns common properties for both XA and Non-XA datasource * @param indiName */ public static Properties commonDsProperties(String jndiName) { Properties params = new Properties(); //attributes params.put("use-java-context", "true"); params.put("spy", "false"); params.put("use-ccm", "true"); params.put("jndi-name", jndiName); //common elements params.put("driver-name", "h2"); params.put("new-connection-sql", "select 1"); params.put("transaction-isolation", "TRANSACTION_READ_COMMITTED"); params.put("url-delimiter", ":"); params.put("url-selector-strategy-class-name", "someClass"); //pool params.put("min-pool-size", "1"); params.put("max-pool-size", "5"); params.put("pool-prefill", "true"); params.put("pool-use-strict-min", "true"); params.put("flush-strategy", "EntirePool"); //security params.put("user-name", "sa"); params.put("password", "sa"); params.put("security-domain", "HsqlDbRealm"); params.put("reauth-plugin-class-name", "someClass1"); //validation params.put("valid-connection-checker-class-name", "someClass2"); params.put("check-valid-connection-sql", "select 1"); params.put("validate-on-match", "true"); params.put("background-validation", "true"); params.put("background-validation-millis", "2000"); params.put("use-fast-fail", "true"); params.put("stale-connection-checker-class-name", "someClass3"); params.put("exception-sorter-class-name", "someClass4"); //time-out params.put("blocking-timeout-wait-millis", "20000"); params.put("idle-timeout-minutes", "4"); params.put("set-tx-query-timeout", "true"); params.put("query-timeout", "120"); params.put("use-try-lock", "100"); params.put("allocation-retry", "2"); params.put("allocation-retry-wait-millis", "3000"); //statement params.put("track-statements", "nowarn"); params.put("prepared-statements-cache-size", "30"); params.put("share-prepared-statements", "true"); return params; } }