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