set parallel threads python script error

Gang Yan <[email protected]> Fri, 28 Nov 2014 06:00:53 -0800 (PST)
Newsgroups gmane.comp.java.grinder.user
Message-ID <be434c10-0111-447c-817a-68f1267badad@default>
Hi all:

I set parallel threads python script, run script error: Follow is python script:

test1 = Test(1, "Database insert")

test2 = Test(2, "Database query")

# Load the Oracle JDBC driver.
DriverManager.registerDriver(OracleDriver())

def getConnection():
    return DriverManager.getConnection(
        "jdbc:oracle:thin:@uapgv4102.us.oracle.com:1521:XE", "grinder", "grinder")

def ensureClosed(object):
    try: object.close()
    except: pass

# One time initialisation that cleans out old data.
connection = getConnection()
statement = connection.createStatement()

try: statement.execute("drop table grinder_test1126")
except: pass

statement.execute("create table grinder_test1126(thread number, run number)")

ensureClosed(statement)
ensureClosed(connection)

class TestRunner:
  def __init__(self):
        tid = grinder.threadNumber

        if (grinder.threadNumber % 2 == 0):
             Even threadNumber
             Do insertStatement
        else:
             Odd threadNumber
             Do queryStatement

#   def __call__(self):
#       self.testRunner()

        endTime = datetime.now() + duration
        notDone = True
        while notDone:
         connection = None
         insertStatement = None
         queryStatement = None
         notDone = datetime.now() < endTime

        try:
            connection = getConnection()
            insertStatement = connection.createStatement()
            queryStatement = connection.createStatement()

            test1.record(insertStatement)
            insertStatement.execute("insert into grinder_test1126 values(%d, %d)" %
                                    (grinder.threadNumber, grinder.runNumber))

            test2.record(queryStatement)
            queryStatement.execute("select * from grinder_test1126 where thread=%d" %
                                   grinder.threadNumber)

        finally:
            ensureClosed(insertStatement)
            ensureClosed(queryStatement)
            ensureClosed(connection)


run script error info:
2014-11-27 02:47:34,448 INFO  agent: Worker process command line: java '-javaagent:/u03/JavaOsTesting/grinder-3.11/lib/grinder-dcr-agent-3.11.jar' '-Xms2g' '-Xmx2g' '-XX:+HeapDumpOnOutOfMemoryError' -classpath '/u03/JavaOsTesting:/u03/JavaOsTesting/lib:/u06/app/oracle/product/11.2.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u03/JavaOsTesting/grinder-3.11/lib/grinder.jar' net.grinder.engine.process.WorkerProcessEntryPoint
2014-11-27 02:47:34,490 INFO  agent: worker..com-0 started
2014-11-27 02:47:36,280 ERROR uapgv4102.us.oracle.com-0: aborting process - Jython exception, <type 'exceptions.SyntaxError'>: ("mismatched input 'threadNumber' expecting NEWLINE", ('./test_jdbc.py', 90, 18, 'Even threadNumber\n')) [initialising test script]
net.grinder.scriptengine.jython.JythonScriptExecutionException: <type 'exceptions.SyntaxError'>: ("mismatched input 'threadNumber' expecting NEWLINE", ('./test_jdbc.py', 90, 18, 'Even threadNumber\n'))


------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk