Package com.microsoft.jdbcx.sqlserver

Examples of com.microsoft.jdbcx.sqlserver.SQLServerDataSource

38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
  }

  public boolean bindDataSource(String bindName) {
    boolean isRegistered = false;
    try {
      SQLServerDataSource mds = new SQLServerDataSource();
      mds.setDescription("MS SQLServerDataSource");
      mds.setServerName("sqlserver");
      mds.setPortNumber(1433);
      mds.setDatabaseName("pubs");
      mds.setSelectMethod("cursor");
      ctx.rebind(bindName, mds);
      System.out.println("Bind success");
      isRegistered = true;
    } catch (Exception e) {
      System.out.println("Error Occured in JNDISetup:     " + e.getMessage());
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
    }

    public void init(int branchId) throws XAException {
        try {
            // Initialize the Datasource
            SQLServerDataSource sqlServerDataSource = new SQLServerDataSource();

            // "jdbc:microsoft:sqlserver://bleujin:1433;DatabaseName=pubs;"
            String jdbcUrl = ( (MSSQLDBManager) dbm).getJdbcURL().trim() + ";";
            String serverInfo = StringUtils.substring(jdbcUrl, "jdbc:microsoft:sqlserver://".length());

            String serverName = StringUtils.substringBefore(serverInfo, ":");
            int portNum = Integer.parseInt(StringUtils.substringBetween(serverInfo, ":", ";"));
            String dbName = StringUtils.substringBetween(serverInfo, ";DatabaseName=", ";");

            sqlServerDataSource.setServerName(serverName);
            sqlServerDataSource.setDatabaseName(dbName);
            sqlServerDataSource.setPortNumber(portNum);

            sqlServerDataSource.setUser( ( (MSSQLDBManager) dbm).getUserId());
            sqlServerDataSource.setPassword( ( (MSSQLDBManager) dbm).getUserPwd());
            sqlServerDataSource.setSelectMethod("cursor");

            xaDataSource = sqlServerDataSource;
            xaConnection = xaDataSource.getXAConnection();

            xaResource = xaConnection.getXAResource();
View Full Code Here
TOP

Related Classes of com.microsoft.jdbcx.sqlserver.SQLServerDataSource

  • com.bleujin.framework.db.manager.JNDISetup
  • com.bleujin.framework.db.procedure.MSSQL2000TxTransaction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.