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