[empire-db] branch master updated: EMPIREDB-362 Bugfix Postgres

[derjan]

This is an automated email from the ASF dual-hosted git repository.

derjan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/empire-db.git


The following commit(s) were added to refs/heads/master by this push:
     new 7fdf9fe  EMPIREDB-362 Bugfix Postgres
7fdf9fe is described below

commit 7fdf9fecebd63bd8d13c56f046576ac7018ab430
Author: Jan Glaubitz <j...@glaubitz.org>
AuthorDate: Tue Mar 1 09:49:59 2022 +0100

    EMPIREDB-362 Bugfix Postgres
---
 .../org/apache/empire/samples/db/advanced/db/CarSalesDB.java     | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git 
a/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/db/CarSalesDB.java
 
b/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/db/CarSalesDB.java
index 1244e0d..a378dc3 100644
--- 
a/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/db/CarSalesDB.java
+++ 
b/empire-db-examples/empire-db-example-advanced/src/main/java/org/apache/empire/samples/db/advanced/db/CarSalesDB.java
@@ -28,6 +28,7 @@ import org.apache.empire.db.generic.TDatabase;
 import org.apache.empire.db.generic.TTable;
 import org.apache.empire.db.validation.DBModelChecker;
 import org.apache.empire.db.validation.DBModelErrorLogger;
+import org.apache.empire.dbms.DBMSHandler;
 import org.apache.empire.dbms.postgresql.DBMSHandlerPostgreSQL;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
@@ -291,13 +292,15 @@ public class CarSalesDB extends TDatabase<CarSalesDB>
             checkDataModel(context);
         } 
         else
-        {   // PostgreSQL does not support DDL in transaction
-            if(getDbms() instanceof DBMSHandlerPostgreSQL)
+        {   
+               DBMSHandler dbms = context.getDbms();
+               // PostgreSQL does not support DDL in transaction
+            if(dbms instanceof DBMSHandlerPostgreSQL)
                 setAutoCommit(context, true);
             // create the database
             createDatabase(context);
             // PostgreSQL does not support DDL in transaction
-            if(getDbms() instanceof DBMSHandlerPostgreSQL)
+            if(dbms instanceof DBMSHandlerPostgreSQL)
                 setAutoCommit(context, false);
             // attach to driver
             super.open(context);