Here we are again releasing Oracle SQLcl. We released Oracle SQLDeveloper SQLcl 18.1.1 yesterday with only one significant change.

Why? Well, we haven't changed the SQLcl code in this release but we've made it easier for you to use the libraries we ship with it.  We've added a pom.xml into the lib directory.  On a day to day use of SQLcl, this will not affect your use of SQLcl, however, it will allow you to install the libraries we ship with SQLcl into your local maven repository.



How does that work?  Well, you need to have maven installed in order to run the install.  You can check you have it like this.


With confirmed you can run the install by invoking the command 'mvn validate' in the sqlcl/lib directory.
While a lot of these jars are available in maven.oracle.com and maven.org, there are several that aren't.  We're working on getting our production jars published externally.  The ones we dont have published publicly yet are:


if you want to add these to your project, take the following dependency management and prune it for your needs.

1:      <dependencyManagement>  
2:          <dependencies>  
3:              <dependency>  
4:                  <groupId>com.oracle.jdbc</groupId>  
5:                  <artifactId>ojdbc8</artifactId>  
6:                  <version>12.2.0.1</version>  
7:              </dependency>  
8:              <dependency>  
9:                  <groupId>oracle.soda</groupId>  
10:                  <artifactId>orajsoda</artifactId>  
11:                  <version>12.2.0.1.0</version>  
12:              </dependency>  
18:              <dependency>  
19:                  <groupId>com.oracle.jdbc</groupId>  
20:                  <artifactId>xdb6</artifactId>  
21:                  <version>12.2.0.1</version>  
22:              </dependency>  
23:              <dependency>  
24:                  <groupId>com.oracle.jdbc</groupId>  
25:                  <artifactId>xmlparserv2-sans-jaxp-services</artifactId>  
26:                  <version>12.2.0.1</version>  
27:              </dependency>  
28:              <dependency>  
49:                  <groupId>com.oracle.jdbc</groupId>  
50:                  <artifactId>orai18n</artifactId>  
51:                  <version>12.2.0.1</version>  
52:              </dependency>  
53:              <dependency>  
54:                  <groupId>com.oracle.jdbc</groupId>  
55:                  <artifactId>orai18n-collation</artifactId>  
56:                  <version>12.2.0.1</version>  
57:              </dependency>  
58:              <dependency>  
59:                  <groupId>com.oracle.jdbc</groupId>  
60:                  <artifactId>orai18n-mapping</artifactId>  
61:                  <version>12.2.0.1</version>  
62:              </dependency>  
68:              <dependency>  
69:                  <groupId>com.oracle.jdbc</groupId>  
70:                  <artifactId>orai18n-utility</artifactId>  
71:                  <version>12.2.0.1</version>  
72:              </dependency>  
710:              <dependency>  
111:                  <groupId>oracle.dbtools</groupId>  
112:                  <artifactId>dbtools-common</artifactId>  
113:                  <version>18.1.1</version>  
114:              </dependency>  
115:              <dependency>  
116:                  <groupId>oracle.dbtools</groupId>  
117:                  <artifactId>dbtools-http</artifactId>  
118:                  <version>18.1.1</version>  
119:              </dependency>  
120:              <dependency>  
121:                  <groupId>oracle.dbtools</groupId>  
122:                  <artifactId>dbtools-sqlcl</artifactId>  
123:                  <version>18.1.1</version>  
124:              </dependency>  
125:              <dependency>  
126:                  <groupId>oracle.dbtools</groupId>  
127:                  <artifactId>jdbcrest</artifactId>  
128:                  <version>18.1.1</version>  
129:              </dependency>  
130:              <dependency>  
131:                  <groupId>com.oracle.jdbc</groupId>  
132:                  <artifactId>osdt_cert</artifactId>  
133:                  <version>12.2.0.1</version>  
134:              </dependency>  
135:              <dependency>  
136:                  <groupId>com.oracle.jdbc</groupId>  
137:                  <artifactId>osdt_core</artifactId>  
138:                  <version>12.2.0.1</version>  
139:              </dependency>  
140:              <dependency>  
141:                  <groupId>com.oracle.jdbc</groupId>  
142:                  <artifactId>oraclepki</artifactId>  
143:                  <version>12.2.0.1</version>  
144:              </dependency>  
160:              <dependency>  
161:                  <groupId>oracle.cloudstorage</groupId>  
162:                  <artifactId>low-level-api</artifactId>  
163:                  <version>13.0.0</version>  
164:              </dependency>  
170:          </dependencies>  
171:      </dependencyManagement>  

Stay tuned, you'll have a project you can use this on soon!