Hi,
it's continuing my last question,
when I run my script on pure python, its works well and no error appeared.
but, when I tried to run it from java (using jython) it shows ImportError: No module named pymysql in case it's works on python.
daftar_po.java
Quote:String ram = "0005/07/2017";
String dat[] = {ram};
PythonInterpreter.initialize(System.getProperties(), System.getProperties(), dat);
org.python.util.PythonInterpreter py = new org.python.util.PythonInterpreter();
StringWriter out = new StringWriter();
String sln = "python/process.py";
py.execfile(sln);
String strOut = out.toString();
System.out.println(strOut);
import sys
sys.path.append("D:\AvosLab\digital_scale\python")
from key import db, base
db = db
base = base
def aFunc(arg1):
base.execute("select num from tbl_a where KodeForm=%s",(arg1))
hsl = base.fetchall()
words = [row[0] for row in hsl]
num_text = ','.join(words)
max_val = max([int(x) for x in num_text.split(',')])
print(max_val)
aFunc(sys.argv[0])key.py
import sys
sys.path.append("D:\AvosLab\digital_scale\python")
import pymysql
db = pymysql.connect(host="192.1.1", user="user", passwd="pass123", db="tbl_a")
base = db.cursor()Error:
Exception in thread "AWT-EventQueue-0" Traceback (most recent call last):
File "python/process.py", line 3, in <module>
from key import db, base
File "D:\AvosLab\digital_scale\python\key.py", line 3, in <module>
import pymysql
ImportError: No module named pymysql
tell me if I am not allowed to post another programming language here, but I am very satisfied to this forum that answer my questions correctly.
As your script runs in python, this is not a python error.
Hoever running in jyphon the module not found error is described in section 4.1 of the jyphon FAQ:
http://www.jython.org/archive/22/userfaq...-supported
You may be unlucky here and have picked a python module that is not in the jyphon library.
Unless someone has an another idea you may have to contact the jyphon team
(Jul-20-2017, 08:04 PM)cygnus_X1 Wrote: [ -> ]As your script runs in python, this is not a python error.
Hoever running in jyphon the module not found error is described in section 4.1 of the jyphon FAQ:
http://www.jython.org/archive/22/userfaq...-supported
You may be unlucky here and have picked a python module that is not in the jyphon library.
Unless someone has an another idea you may have to contact the jyphon team
so the problem is I am just unlucky? hahahah...
I think I'll go to the fortune teller next time..
haha
(Jul-20-2017, 08:47 PM)Larz60+ Wrote: [ -> ]is there a pip equivalent in jpython? if so perhaps you can install: https://pypi.python.org/pypi/PyMySQL/0.7.11
I've installed it,
and, the same error appeared
Can you tell me,
what should I use to connect into mysql except using pymysql?
if pymysql is not possible..
Quote:I will try it one by one.
You don't need to do that. Open each up in pypi and read it's capibilities.
choose one that has a high weight (based on update activity and number if downloads).
It's not a bad guide.
If you find one that seems to fit, then give it a go.
Also if it's been around for a while, look in
nullege.com for some working examples and see how it's used.
Perhaps even go to the github location and take a look at what's available, as there may be more information available there
(Jul-24-2017, 10:57 AM)Larz60+ Wrote: [ -> ]Quote:I will try it one by one.
You don't need to do that. Open each up in pypi and read it's capibilities.
choose one that has a high weight (based on update activity and number if downloads).
It's not a bad guide.
If you find one that seems to fit, then give it a go.
Also if it's been around for a while, look in http://nullege.com for some working examples and see how it's used.
Perhaps even go to the github location and take a look at what's available, as there may be more information available there
OK, thanks... I am still look for that