How to install the DB2 JDBC driver with Jython

[Liliana]

Hi all,

I am using DB2 Universal Database that is JDBC Drivers Program has been proved to be a powerful, and get IBM to support the technology.I heard that Jython is the Python programming language, that is 100% pure Java Achieved. I want to now that how to install the DB2 JDBC driver with Jython. Thanks in advance.

[Modifier]

you need to install Jython 2.1 and JVM. If you add the Jython installation path to the platform on the PATH environment variable, the installation will be very easy. Enable DB2 UDB V8 in the SAMPLE database. Running with the DB2 with the release of db2sampl program to create the SAMPLE database, also available from the DB2 install the Tools menu FirstSteps to create. In addition, you must create DB2 ID / password. Check and reply.

[MindSpace]

Jython need to import each of a Java package, including the java.lang. Jython string you can use single quotes, you can also use double quotation marks. Jython's type is dynamic, so no need to con the type of declaration of java.sql.Connection. Simply use this code:

from java.lang import *
from java.sql import *
Class.forName ( "com.ibm.db2.jcc.DB2Driver"). NewInstance ()
con123 = DriverManage123r.getConnection ( 'jdbc: db2: / / db2host: 50000/sample', 'username', 'password')

[opaper]

The following example in the Windows 2000 using the SAMPLE database and type 2 CLI JDBC driver. You can use Lambda function. Check the code:

toStr = lambda e: e [ 'username']+','+ e [' password']+',$'+ str (e [ 'dateof birth'])
f = open ( 'salaries123.txt', 'w')
f.writelines ([toStr (e) + '\ n' for e in employeeList])
finally:
f.close ()

[Reegan]

Jython benefited from a huge database, as well as Java, such as IBM DB2 JDBC DriversPrograms such as API, seamless integration. Based on its linguistic features, Jython is very suitable for automated testing and load testing tasks that require rapid application development. Jython is a very convenient supplement for rapid inspection and construct prototypes, testing, and to deal with those more suitable for the use of its method of coding task is useful. Best of luck.