This is an automated email from the ASF dual-hosted git repository.
alexoree pushed a commit to branch bug/JUDDI-1015
in repository https://gitbox.apache.org/repos/asf/juddi.git
commit c6e69a48bfe61dde00a8ff8873bb8f946e06e4ea
Author: Alex O'Ree <alexo...@apache.org>
AuthorDate: Thu Jul 16 21:37:15 2020 -0400
JUDDI-1015 adds oracle and mssql drivers to the mix along with an example
for oracle db
---
juddi-tomcat/build.xml | 2 ++
juddi-tomcat/context.xml | 15 ++++++++++++---
juddi-tomcat/pom.xml | 15 +++++++++++++++
3 files changed, 29 insertions(+), 3 deletions(-)
diff --git a/juddi-tomcat/build.xml b/juddi-tomcat/build.xml
index d912823..be5e480 100644
--- a/juddi-tomcat/build.xml
+++ b/juddi-tomcat/build.xml
@@ -56,6 +56,8 @@
<copy file="${dependency.mysql.jar}" todir="${lib.dir}"/>
<copy file="${dependency.postgres.jar}" todir="${lib.dir}"/>
+ <copy file="${dependency.mssql.jar}" todir="${lib.dir}"/>
+ <copy file="${dependency.oracle.jar}" todir="${lib.dir}"/>
<copy file="${dependency.log4j.jar}" todir="${lib.dir}"/>
<copy file="${dependency.derby.jar}" todir="${lib.dir}"/>
<copy file="${dependency.commons-discovery.jar}"
todir="${lib.dir}"/>
diff --git a/juddi-tomcat/context.xml b/juddi-tomcat/context.xml
index 28ff8b5..fef1eb6 100644
--- a/juddi-tomcat/context.xml
+++ b/juddi-tomcat/context.xml
@@ -18,14 +18,14 @@
-->
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
- <!-- -->
+ <!-- apache derby embedded -->
<Resource name="jdbc/JuddiDS" auth="Container"
type="javax.sql.DataSource" username="" password=""
driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
url="jdbc:derby:target/juddi-derby-test-db;create=true"
maxTotal="8"
/>
-
+
<!-- mysql
<Resource name="jdbc/JuddiDS" auth="Container"
type="javax.sql.DataSource" username="root" password=""
@@ -36,11 +36,20 @@
-->
<!-- postgresql
<Resource name="jdbc/JuddiDS" auth="Container"
- type="javax.sql.DataSource" username="juddi" password="juddi"
+ type="javax.sql.DataSource" username="juddi" password=""
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/juddi"
maxActive="8"
/>
-->
+
+ <!-- oracle
+ <Resource name="jdbc/JuddiDS" auth="Container"
+ type="javax.sql.DataSource" username="juddi" password=""
+ driverClassName="oracle.jdbc.driver.OracleDriver"
+ url="jdbc:juddi:thin:@localhost:1521:xe"
+ maxActive="8"
+ />
+ -->
</Context>
diff --git a/juddi-tomcat/pom.xml b/juddi-tomcat/pom.xml
index f4820cd..14b063a 100644
--- a/juddi-tomcat/pom.xml
+++ b/juddi-tomcat/pom.xml
@@ -84,6 +84,18 @@
<groupId>org.json</groupId>
<artifactId>json</artifactId>
</dependency>
+ <dependency>
+ <groupId>com.microsoft.sqlserver</groupId>
+ <artifactId>mssql-jdbc</artifactId>
+ <version>8.2.2.jre8</version>
+ </dependency>
+ <dependency>
+ <groupId>com.oracle.database.jdbc</groupId>
+ <artifactId>ojdbc8</artifactId>
+ <version>19.7.0.0</version>
+ </dependency>
+
+
</dependencies>
<build>
@@ -134,6 +146,9 @@
<property name="dependency.log4j.jar"
value="${maven.dependency.log4j.log4j.jar.path}" />
<property name="dependency.mysql.jar"
value="${maven.dependency.mysql.mysql-connector-java.jar.path}" />
<property name="dependency.postgres.jar"
value="${maven.dependency.org.postgresql.postgresql.jar.path}" />
+ <property name="dependency.mssql.jar"
value="${maven.dependency.com.microsoft.sqlserver.mssql-jdbc.jar.path}" />
+ <property name="dependency.oracle.jar"
value="${maven.dependency.com.oracle.database.jdbc.ojdbc8.jar.path}" />
+
<property
name="dependency.commons-discovery.jar"
value="${maven.dependency.commons-discovery.commons-discovery.jar.path}" />
<property name="dependency.derby.jar"
value="${maven.dependency.org.apache.derby.derby.jar.path}" />
<property name="dependency.tomcat.zip"
value="${maven.dependency.org.apache.tomcat.tomcat.zip.path}" />
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@juddi.apache.org
For additional commands, e-mail: commits-h...@juddi.apache.org
