You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by nt...@apache.org on 2018/04/18 09:59:06 UTC
[02/19] cayenne git commit: Fixed the script for selecting all
Sequences from the database
Fixed the script for selecting all Sequences from the database
Project: http://git-wip-us.apache.org/repos/asf/cayenne/repo
Commit: http://git-wip-us.apache.org/repos/asf/cayenne/commit/265636c8
Tree: http://git-wip-us.apache.org/repos/asf/cayenne/tree/265636c8
Diff: http://git-wip-us.apache.org/repos/asf/cayenne/diff/265636c8
Branch: refs/heads/master
Commit: 265636c8c9843c3f62f97cb4e2219e32e9f2ec16
Parents: b18329b
Author: Aleksey Pleshkanev <pr...@hotmail.com>
Authored: Sun Mar 4 16:37:55 2018 +0300
Committer: Aleksey Pleshkanev <pr...@hotmail.com>
Committed: Sun Mar 4 16:37:55 2018 +0300
----------------------------------------------------------------------
.../org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cayenne/blob/265636c8/cayenne-server/src/main/java/org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java
----------------------------------------------------------------------
diff --git a/cayenne-server/src/main/java/org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java b/cayenne-server/src/main/java/org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java
index 820b8a4..2f2f054 100644
--- a/cayenne-server/src/main/java/org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java
+++ b/cayenne-server/src/main/java/org/apache/cayenne/dba/sqlserver/SQLServerPkGenerator.java
@@ -93,7 +93,7 @@ public class SQLServerPkGenerator extends OraclePkGenerator {
@Override
protected String selectAllSequencesQuery() {
- return "SELECT sch.name + '.' + seq.name"
+ return "SELECT seq.name"
+ " FROM sys.sequences AS seq"
+ " JOIN sys.schemas AS sch"
+ " ON seq.schema_id = sch.schema_id";