Connect to database using wlst script

from com.ziclix.python.sql import zxJDBC

# Connection variables
db_user='Dev_SOAINFRA'
db_password='Welcome1'
host='localhost'
port='1521'
db_name='SOADEV'
jdbc_url = 'jdbc:oracle:thin:@'+host+':'+port+'/'+db_name
db_driver = 'oracle.jdbc.xa.client.OracleXADataSource'

# Query to perform
sql_query="SELECT 'Connected as '||USER||' to database '||SYS_CONTEXT ('USERENV', 'DB_NAME')||'(instance:'||SYS_CONTEXT ('USERENV', 'INSTANCE_NAME')||') on host '||
SYS_CONTEXT ('USERENV', 'SERVER_HOST') from dual"

# Test Database connection
conn = zxJDBC.connect(jdbc_url, db_user, db_password, db_driver)
cursor = conn.cursor(1)
cursor.execute(sql_query)

if cursor.rowcount == 0:
   print "Successfully connected to database..."
   for row in cursor.fetchall():
      print(row)
   cursor.close()
   ####
  
   conn.close()
else:
   print "Failed to connect to database..."
   dumpStack()