Changeset - 5dbb8a045bb1
[Not reviewed]
0 1 0
Hannes Muehleisen - 9 years ago 2016-08-02 14:48:19
hannes@muehleisen.org
jdbc fixes
1 file changed with 2 insertions and 1 deletions:
0 comments (0 inline, 0 general)
vldb-protocols.py
Show inline comments
 
@@ -182,30 +182,31 @@ for r in range(nruns):
 
					querycmd = 'cat %s | %s nc 127.0.0.1 %d' % (filename, compress_cmd, netcat_port)
 
					jdbcflags = None
 
					odbccmd = None
 
					odbcdriver = None
 
				else:
 
					exit("unknown db %s" % system['db'])
 

	
 
				qfile = open("query", "w")
 
				qfile.write(query)
 
				qfile.write("\n")
 
				qfile.close()
 

	
 
				jdbccmd = 'java -Xmx10G -Djava.security.egd=file:/dev/./urandom -cp /home/user/java/pmjc.jar:/home/user/java/db2jcc4.jar:/home/user/java/monetdb-jdbc-2.23.jar:/home/user/java/mariadb-java-client-1.4.6.jar:/home/user/java/ojdbc6_g.jar:/home/user/java/postgresql-9.4.1209.jar:/home/user/java/hive-jdbc-2.1.0-standalone.jar:/home/user/java/hadoop-common-2.6.4.jar %s "%s" 1000' % (jdbcflags, query)
 
				jdbccmd = 'java -Xmx10G -Djava.security.egd=file:/dev/./urandom -cp /home/user/java/pmjc.jar:/home/user/java/db2jcc4.jar:/home/user/java/monetdb-jdbc-2.23.jar:/home/user/java/mariadb-java-client-1.4.6.jar:/home/user/java/ojdbc6_g.jar:/home/user/java/postgresql-9.4.1209.jar:/home/user/java/hive-jdbc-2.1.0-standalone.jar:/home/user/java/hadoop-common-2.6.4.jar nl.cwi.da.pmjc.Pmjc %s "%s" 1000 > /dev/null 2>/dev/null' % (jdbcflags, query)
 
				
 
				# special case for hive
 
				if querycmd is None:
 
					querycmd = jdbccmd
 
					jdbccmd = None
 
					jdbcflags = None
 

	
 
				# getting caches hot
 
				benchmark_command(querycmd, system, 'native', network, tuple, r, True)
 

	
 
				# native client
 
				benchmark_command(querycmd, system, 'native', network, tuple, r, False)
 
				if 'compress' not in system:
 
					# odbc
 
					if odbccmd is not None:
 
						benchmark_command(odbccmd, system, 'odbc', network, tuple, r, False)
 
					# jdbc
 
					if jdbcflags is not None:
0 comments (0 inline, 0 general)