You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by al...@apache.org on 2020/08/13 00:39:45 UTC

[juddi] 02/02: JUDDI-1015 reduces sql identifiers for better support for both mssql and for oracledb. JUDDI-1101 related. also resolves sql query issues for discoery url due to varchar to clob change

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 4d7bc5a3bf37e7d5341286432c129f8fb1a4b203
Author: Alex O'Ree <al...@apache.org>
AuthorDate: Wed Aug 12 20:39:39 2020 -0400

    JUDDI-1015 reduces sql identifiers for better support for both mssql and for oracledb.
    JUDDI-1101 related. also resolves sql query issues for discoery url due to varchar to clob change
---
 .../src/main/java/org/apache/juddi/model/PublisherAssertion.java   | 2 +-
 .../main/java/org/apache/juddi/model/ReplicationConfiguration.java | 7 +++++--
 .../java/org/apache/juddi/model/ReplicationConfigurationNode.java  | 2 +-
 juddi-core/src/main/java/org/apache/juddi/model/Signature.java     | 2 +-
 .../org/apache/juddi/query/FindBusinessByDiscoveryURLQuery.java    | 4 ++--
 .../src/main/java/org/apache/juddi/ddl/generator/App.java          | 1 -
 6 files changed, 10 insertions(+), 8 deletions(-)

diff --git a/juddi-core/src/main/java/org/apache/juddi/model/PublisherAssertion.java b/juddi-core/src/main/java/org/apache/juddi/model/PublisherAssertion.java
index 2d5ec2f..d2dac96 100644
--- a/juddi-core/src/main/java/org/apache/juddi/model/PublisherAssertion.java
+++ b/juddi-core/src/main/java/org/apache/juddi/model/PublisherAssertion.java
@@ -37,7 +37,7 @@ import javax.persistence.TemporalType;
  * @author <a href="mailto:kurt@apache.org">Kurt T Stam</a>
  */
 @Entity
-@Table(name = "j3_publisher_assertion")
+@Table(name = "j3_pubassrt")
 public class PublisherAssertion implements java.io.Serializable {
 
         private static final long serialVersionUID = -5285434317957104272L;
diff --git a/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfiguration.java b/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfiguration.java
index 93d0f73..1e3de5c 100644
--- a/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfiguration.java
+++ b/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfiguration.java
@@ -73,7 +73,7 @@ public class ReplicationConfiguration implements Serializable {
          * Gets the value of the serialNumber property.
          *
          */
-        @Column(name = "serialnumb")
+        @Column(name = "serno")
         @OrderBy(value = "SerialNumber DESC")
         @Id
         public Long getSerialNumber() {
@@ -206,7 +206,10 @@ public class ReplicationConfiguration implements Serializable {
         }
 
         // @OneToMany( fetch = FetchType.LAZY,targetEntity = Edge.class, mappedBy = "Edge")
-        @OneToMany(targetEntity = Edge.class, fetch = FetchType.LAZY, cascade = CascadeType.ALL)
+        @OneToMany(targetEntity = Edge.class, 
+                fetch = FetchType.LAZY, cascade = CascadeType.ALL
+                //mappedBy = "j3_edge"
+                )
         public List<Edge> getEdge() {
                 return this.edge;
         }
diff --git a/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfigurationNode.java b/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfigurationNode.java
index e146375..7b03ffc 100644
--- a/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfigurationNode.java
+++ b/juddi-core/src/main/java/org/apache/juddi/model/ReplicationConfigurationNode.java
@@ -37,7 +37,7 @@ public class ReplicationConfigurationNode implements Serializable {
         private static final long serialVersionUID = 1L;
         private Long id;
         private ReplicationConfiguration parent;
-        String rx;
+        private String rx;
 
         @Id
         @GeneratedValue(strategy = GenerationType.AUTO)
diff --git a/juddi-core/src/main/java/org/apache/juddi/model/Signature.java b/juddi-core/src/main/java/org/apache/juddi/model/Signature.java
index 856014a..886092d 100644
--- a/juddi-core/src/main/java/org/apache/juddi/model/Signature.java
+++ b/juddi-core/src/main/java/org/apache/juddi/model/Signature.java
@@ -33,7 +33,7 @@ import javax.persistence.Table;
  *
  */
 @Entity
-@Table(name = "j3_signature")
+@Table(name = "j3_sig")
 public class Signature implements java.io.Serializable {
     private static final long serialVersionUID = -3233157941119408718L;
     
diff --git a/juddi-core/src/main/java/org/apache/juddi/query/FindBusinessByDiscoveryURLQuery.java b/juddi-core/src/main/java/org/apache/juddi/query/FindBusinessByDiscoveryURLQuery.java
index b606ad4..ac85264 100644
--- a/juddi-core/src/main/java/org/apache/juddi/query/FindBusinessByDiscoveryURLQuery.java
+++ b/juddi-core/src/main/java/org/apache/juddi/query/FindBusinessByDiscoveryURLQuery.java
@@ -91,10 +91,10 @@ public class FindBusinessByDiscoveryURLQuery extends BusinessEntityQuery {
 			String urlValue = discURL.getValue();
 			
 			if (discURL.getUseType() == null || discURL.getUseType().length() == 0 ) {
-				qry.appendGroupedAnd(new DynamicQuery.Parameter(urlTerm, urlValue, DynamicQuery.PREDICATE_EQUALS));
+				qry.appendGroupedAnd(new DynamicQuery.Parameter(urlTerm, urlValue, DynamicQuery.PREDICATE_LIKE));
 			}
 			else {
-				qry.appendGroupedAnd(new DynamicQuery.Parameter(urlTerm, urlValue, DynamicQuery.PREDICATE_EQUALS), 
+				qry.appendGroupedAnd(new DynamicQuery.Parameter(urlTerm, urlValue, DynamicQuery.PREDICATE_LIKE), 
 									 new DynamicQuery.Parameter(entityAliasChild + ".useType", discURL.getUseType(), DynamicQuery.PREDICATE_EQUALS));
 			}
 			
diff --git a/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java b/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
index d226c30..4f5a7f6 100644
--- a/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
+++ b/juddi-ddl-generator/src/main/java/org/apache/juddi/ddl/generator/App.java
@@ -255,7 +255,6 @@ public class App {
          */
         private static enum Dialect {
 
-                ORACLE("org.hibernate.dialect.Oracle10gDialect"),
                 MYSQL("org.hibernate.dialect.MySQLDialect"),
                 HSQL("org.hibernate.dialect.HSQLDialect"),
                 POSTGRES("org.hibernate.dialect.PostgreSQLDialect"),


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@juddi.apache.org
For additional commands, e-mail: commits-help@juddi.apache.org