Styjun

What is my breathable atmosphere composed of?

Do ibuprofen or paracetamol cause hearing loss?

Job offer without any details but asking me to withdraw other applications - is it normal?

Can I disable a battery powered device by reversing half of its batteries?

When was the earliest opportunity the Voyager crew had to return to the Alpha quadrant?

How to work with a technician hired with a grant who argues everything

Can a corpse possessed by a Dybbuk be turned via Turn Undead?

What jurisdiction do Scottish courts have over the Westminster parliament?

Were Roman public roads build by private companies?

Can I toggle Do Not Disturb on/off on my Mac as easily as I can on my iPhone?

How to say "quirky" in German without sounding derogatory?

Where can I find vomiting people?

How can I fix a framing mistake so I can drywall?

Are Democrats more likely to believe Astrology is a science?

How are chord ratios developed exactly?

What is a realistic time needed to get a properly trained army?

Are scroll bars dead in 2019?

Will replacing a fake visa with a different fake visa cause me problems when applying for a legal study permit?

Gas pipes - why does gas burn "outwards?"

What is this unknown executable on my boot volume? Is it Malicious?

Maintenance tips to prolong engine lifespan for short trips

Leaving out pronouns in informal conversation

How to help my 2.5-year-old daughter take her medicine when she refuses to?

What are uses of the byte after BRK instruction on 6502?

Unable to connect netezza DB with jaydebeapi in python

Calling an external command in PythonWhat are metaclasses in Python?Is there a way to run Python on Android?Finding the index of an item given a list containing it in PythonWhat is the difference between Python's list methods append and extend?How can I safely create a nested directory?Does Python have a ternary conditional operator?How to get the current time in PythonHow can I make a time delay in Python?Does Python have a string 'contains' substring method?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

@Team

Got below exception while connecting the netezza DB from python

Exception:

jpype._jexception.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class org.netezza.Driver not found

Anyone, please help me to sort out this issue.

 Code:
import jaydebeapi,sys
import os

dsn_database = "XXXXX"
dsn_hostname = "XXXXXl"
dsn_port = "5480"
dsn_uid = "XXX"
dsn_pwd = "XXXX"
jdbc_driver_name = "org.netezza.Driver"
jdbc_driver_loc = os.path.join(r'C:Testnetezza-3.2.2.jar')

sql_str = "select now()" 
connection_s`tring='jdbc:netezza://'+dsn_hostname+':'+dsn_port+'/'+dsn_database
 url = '0:user=1;password=2'.format(connection_string, dsn_uid, 
 dsn_pwd)
 print("Connection String: " + connection_string)
 conn = jaydebeapi.connect(jdbc_driver_name, connection_string, 'user': 
 dsn_uid, 'password': dsn_pwd,jars=jdbc_driver_loc)
 curs = conn.cursor()
 curs.execute(sql_str)
 result = curs.fetchall()
 print(result[0])

Thanks
SG

python netezza jaydebeapi

share|improve this question

edited Mar 28 at 22:46

Sumesh S.G

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

add a comment
 | 

0

@Team

Got below exception while connecting the netezza DB from python

Exception:

jpype._jexception.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class org.netezza.Driver not found

Anyone, please help me to sort out this issue.

 Code:
import jaydebeapi,sys
import os

dsn_database = "XXXXX"
dsn_hostname = "XXXXXl"
dsn_port = "5480"
dsn_uid = "XXX"
dsn_pwd = "XXXX"
jdbc_driver_name = "org.netezza.Driver"
jdbc_driver_loc = os.path.join(r'C:Testnetezza-3.2.2.jar')

sql_str = "select now()" 
connection_s`tring='jdbc:netezza://'+dsn_hostname+':'+dsn_port+'/'+dsn_database
 url = '0:user=1;password=2'.format(connection_string, dsn_uid, 
 dsn_pwd)
 print("Connection String: " + connection_string)
 conn = jaydebeapi.connect(jdbc_driver_name, connection_string, 'user': 
 dsn_uid, 'password': dsn_pwd,jars=jdbc_driver_loc)
 curs = conn.cursor()
 curs.execute(sql_str)
 result = curs.fetchall()
 print(result[0])

Thanks
SG

python netezza jaydebeapi

share|improve this question

edited Mar 28 at 22:46

Sumesh S.G

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

add a comment
 | 

@Team

Got below exception while connecting the netezza DB from python

Exception:

jpype._jexception.RuntimeExceptionPyRaisable: java.lang.RuntimeException: Class org.netezza.Driver not found

Anyone, please help me to sort out this issue.

 Code:
import jaydebeapi,sys
import os

dsn_database = "XXXXX"
dsn_hostname = "XXXXXl"
dsn_port = "5480"
dsn_uid = "XXX"
dsn_pwd = "XXXX"
jdbc_driver_name = "org.netezza.Driver"
jdbc_driver_loc = os.path.join(r'C:Testnetezza-3.2.2.jar')

sql_str = "select now()" 
connection_s`tring='jdbc:netezza://'+dsn_hostname+':'+dsn_port+'/'+dsn_database
 url = '0:user=1;password=2'.format(connection_string, dsn_uid, 
 dsn_pwd)
 print("Connection String: " + connection_string)
 conn = jaydebeapi.connect(jdbc_driver_name, connection_string, 'user': 
 dsn_uid, 'password': dsn_pwd,jars=jdbc_driver_loc)
 curs = conn.cursor()
 curs.execute(sql_str)
 result = curs.fetchall()
 print(result[0])

Thanks
SG

python netezza jaydebeapi

share|improve this question

edited Mar 28 at 22:46

Sumesh S.G

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

 Code:
import jaydebeapi,sys
import os

dsn_database = "XXXXX"
dsn_hostname = "XXXXXl"
dsn_port = "5480"
dsn_uid = "XXX"
dsn_pwd = "XXXX"
jdbc_driver_name = "org.netezza.Driver"
jdbc_driver_loc = os.path.join(r'C:Testnetezza-3.2.2.jar')

sql_str = "select now()" 
connection_s`tring='jdbc:netezza://'+dsn_hostname+':'+dsn_port+'/'+dsn_database
 url = '0:user=1;password=2'.format(connection_string, dsn_uid, 
 dsn_pwd)
 print("Connection String: " + connection_string)
 conn = jaydebeapi.connect(jdbc_driver_name, connection_string, 'user': 
 dsn_uid, 'password': dsn_pwd,jars=jdbc_driver_loc)
 curs = conn.cursor()
 curs.execute(sql_str)
 result = curs.fetchall()
 print(result[0])

share|improve this question

edited Mar 28 at 22:46

Sumesh S.G

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

share|improve this question

edited Mar 28 at 22:46

Sumesh S.G

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges

asked Mar 28 at 9:20

Sumesh S.GSumesh S.G

133 bronze badges