Package org.hsqldb.cmdline

Examples of org.hsqldb.cmdline.SqlFile$BadSpecial

127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
        sqlVarMap.put("invoker", getClass().getName());
        // This variable is pretty useless, but this should show you how to
        // set variables which you can access inside of scripts like *{this}.

        File file;
        SqlFile sqlFile;
        for (String fileString : fileStrings) {
            file = new File(fileString);
            if (!file.isFile())
                throw new IOException("SQL file not present: "
                        + file.getAbsolutePath());
            sqlFile = new SqlFile(file);
            sqlFile.setConnection(conn);
            sqlFile.addUserVars(sqlVarMap);
            sqlFile.execute();

            // The only reason for the following two statements is so that
            // changes made by one .sql file will effect the future SQL files.
            // Has no effect if you only execute one SQL file.
            conn = sqlFile.getConnection();
            sqlVarMap = sqlFile.getUserVars();
        }
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
128
    {
        Connection conn = null;
        try
        {
            conn = getConnection();
            SqlFile userDbSetup = new SqlFile( new File( file ) );
            userDbSetup.setConnection(conn);
            userDbSetup.execute();
        }
        catch( Exception e )
        {
            LOG.error( e.getMessage(), e );
        }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
        sqlVarMap.put("invoker", getClass().getName());
        // This variable is pretty useless, but this should show you how to
        // set variables which you can access inside of scripts like *{this}.

        File file;
        SqlFile sqlFile;
        for (String fileString : fileStrings) {
            file = new File(fileString);
            if (!file.isFile())
                throw new IOException("SQL file not present: "
                        + file.getAbsolutePath());
            sqlFile = new SqlFile(file);
            sqlFile.setConnection(conn);
            sqlFile.addUserVars(sqlVarMap);
            sqlFile.execute();

            // The only reason for the following two statements is so that
            // changes made by one .sql file will effect the future SQL files.
            // Has no effect if you only execute one SQL file.
            conn = sqlFile.getConnection();
            sqlVarMap = sqlFile.getUserVars();
        }
    }
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
     */
    public void load(final Logger logger,
                     final Database database,
                     final Source source) {
        try {
            final SqlFile sqlFile = new SqlFile(
                    getReader(source),
                    source.getSourceFile(),
                    System.out,
                    null,
                    false,
                    null);
            final DataSource dataSource = ((SQLDatabase)database).getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {
            final String message = MessageUtil.getMessage(CANNOT_READ_SOURCE_FILE, source.getSourceFile());
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
        assert database != null;
        assert logger != null;
        assert source != null;

        try {
            final SqlFile sqlFile = new SqlFile(source);
            final DataSource dataSource = database.getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
                connection.commit();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    assert database != null;
    assert logger != null;
    assert source != null;

    try {
      final SqlFile sqlFile = new SqlFile(source);
      final DataSource dataSource = database.getDataSource();
      final Connection connection = dataSource.getConnection();
      try {
        sqlFile.setConnection(connection);
        sqlFile.execute();
        connection.commit();
      } finally {
        connection.close();
      }
    } catch (final IOException exception) {
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
     */
    public void load(final Logger logger,
                     final Database database,
                     final Source source) {
        try {
            final SqlFile sqlFile = new SqlFile(
                    getReader(source),
                    source.getSourceFile(),
                    System.out,
                    null,
                    false,
                    null);
            final DataSource dataSource = ((SQLDatabase)database).getDataSource();
            final Connection connection = dataSource.getConnection();
            try {
                sqlFile.setConnection(connection);
                sqlFile.execute();
            } finally {
                connection.close();
            }
        } catch (final IOException exception) {
            final String message = MessageUtil.getMessage(CANNOT_READ_SOURCE_FILE, source.getSourceFile());
View Full Code Here
TOP

Related Classes of org.hsqldb.cmdline.SqlFile$BadSpecial

  • com.btmatthews.maven.plugins.inmemdb.ldr.SQLLoader
  • com.btmatthews.maven.plugins.inmemdb.ldr.sqltool.SQLLoader
  • org.apache.wiki.HsqlDbUtils
  • org.hsqldb.cmdline.sqltool.Calculator
  • org.hsqldb.cmdline.sqltool.FileRecordReader
  • org.hsqldb.cmdline.sqltool.SqlFileScanner
  • org.hsqldb.cmdline.sqltool.Token
  • org.hsqldb.cmdline.sqltool.TokenList
  • org.hsqldb.lib.RCData
  • org.hsqldb.sample.SqlFileEmbedder
    • 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.