SQLCL 18.1.1 Release installing jars to local maven repository
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.
which will take each jar and install it into your local maven repository. By default, this will be ~/.m2
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:
low-level-api.jar ojdbc8.jar
dbtools-common.jar oraclepki.jar
dbtools-http.jar orai18n-mapping.jar
dbtools-net.jar orai18n-utility.jar
dbtools-sqlcl.jar orai18n.jar
orajsoda.jar httpcore.jar
osdt_cert.jar osdt_core.jar
ucp.jar. jdbcrest.jar
xdb6.jar xmlparserv2-sans-jaxp-services.jar
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!