Re: [Jython-users] jython cgi connect mysql

[Charlie G. <cha...@gm...>]

Hi Rachmat,

MySQLdb is the CPython MySQL library, so it won't work with Jython.
You'll want to use zxJDBC to connect to MySQL from Jython:
http://jython.org/Project/userguide.html#database-connectivity-in-jython
 You'll need to add the MySQL jdbc jar to your classpath and rework
the examples to use your connection settings for it to work.

Charlie

On Fri, Mar 7, 2008 at 10:24 AM,  <ra...@cs...> wrote:
> dear all,
>
>
>  i'm using jython cgi, and this script :
>
>  #!java -jar c:/jython-2.1/jython.jar
>
>  import sys
>  import MySQLdb
>
>  print "Content-type: text/html\n\n"
>  print "<title>CGI Text</title>\n"
>
>  try:
>     MySQLdb.connect(host="localhost",port=3307,user="root",passwd="adismg",db="progchall")
>     print "Connected<br/>"
>  except MySQLdb.Error, e:
>      print "Error %d: %s " % (e.args[0], e.args[1])
>      sys.exit (1)
>
>
>
>
>  and in page is found error :
>
>  Error 2004: Can't create TCP/IP socket (10106)
>
>
>  any solution ?
>
>  rachmat
>
>
>
>  -------------------------------------------------------------------------
>  This SF.net email is sponsored by: Microsoft
>  Defy all challenges. Microsoft(R) Visual Studio 2008.
>  http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>  _______________________________________________
>  Jython-users mailing list
>  Jyt...@li...
>  https://lists.sourceforge.net/lists/listinfo/jython-users
>