ZEXPХдЛ((U OFS.FolderqUFolderqtqNt.}q(UidqUSQLBenchMarkqU__ac_local_roles__q}qUioanq ]q UOwnerqasU_objectsq(}q (U meta_typeqUJsp DocumentqUidqUms_create_table.jspqu}q(hhhUms_insert1000.jspqu}q(hUDTML MethodqhU ms_connectqu}q(U meta_typeqUDTML MethodqUidqUora_connectqu}q(U meta_typeqUJsp DocumentqUidqUsearch_oracle.jspq u}q!(U meta_typeq"UJsp Documentq#Uidq$U search_ms.jspq%u}q&(U meta_typeq'UJsp Documentq(Uidq)Ums_to_oracle_copy.jspq*u}q+(h'UDTML Methodq,h)U index_htmlq-u}q.(U meta_typeq/UJsp Documentq0Uidq1Uauto_ms_insert1000.jspq2u}q3(U meta_typeq4UJsp Documentq5Uidq6Uinfo_ms.jspq7u}q8(h4h5h6Uinfo_ora.jspq9u}q:(h4h5h6Ucontinue_ms_to_oracle_copy.jspq;uth2(U Вq<(U Products.ZopeJsp.ZopeJspDocumentq=UZopeJspDocumentq>ttQh(UХхq?(h=UZopeJspDocumentq@ttQh7(U ТqA(h=UZopeJspDocumentqBttQh%(UХмqC(h=UZopeJspDocumentqDttQh;(U ЫqE(h=UZopeJspDocumentqFttQh9(U ЬqG(h=UZopeJspDocumentqHttQU index_htmlqI(U УqJ(UOFS.DTMLMethodqKU DTMLMethodqLttQh (UХлqM(h=UZopeJspDocumentqNttQh(UХгqO(h=UZopeJspDocumentqPttQUtitleqQUh(UХиqR(hKU DTMLMethodqSttQh*(UХйqT(h=UZopeJspDocumentqUttQh(UХкqV(hKU DTMLMethodqWttQu. ВM((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUauto_ms_insert1000.jspqUglobalsq}qUown_pathqU

<%! String RndText(int n) { String Chars="0123456789qwertyuiopasdfghjklzxcvbnm"; String rnd=""; int lg=Chars.length(); for(int i=0;i"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; Statement stmt = null; ResultSet rs = null; //load driver try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} //select max try{ rs = stmt.executeQuery("SELECT max(id) as maxid FROM bench "); //Loop through results of query. long maxid=0; while(rs.next()) maxid = 1+rs.getLong("maxid"); for(int i=0;i<1000;i++) try { rs = stmt.executeQuery("INSERT into bench values("+(i+maxid)+",'"+RndText(20)+"');"); } catch(Exception ignored){} out.println((maxid+999)+" records so far!
"); } catch(Exception e){out.println(Error(e));} if(conn != null) { try {conn.close();} catch (Exception ignored) {} } %> qUweb_pathqU#SQLBenchMark/auto_ms_insert1000.jspqUcompiledqKUtitleqU&Insert 1000 records into MS and repeatqUupdatedqKU_varsq}qu.Хх((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUms_insert1000.jspqUglobalsq}qUown_pathqU7d:/Tom/webapps/ROOT/Zope/SQLBenchMark/ms_insert1000.jspqUrawqTt<%@ page import="java.sql.*" %>

<%! String RndText(int n) { String Chars="0123456789qwertyuiopasdfghjklzxcvbnm"; String rnd=""; int lg=Chars.length(); for(int i=0;i"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; Statement stmt = null; ResultSet rs = null; //load driver try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} //select max try{ rs = stmt.executeQuery("SELECT max(id) as maxid FROM bench "); //Loop through results of query. long maxid=0; while(rs.next()) maxid = 1+rs.getLong("maxid"); for(int i=0;i<1000;i++) try { rs = stmt.executeQuery("INSERT into bench values("+(i+maxid)+",'"+RndText(20)+"');"); } catch(Exception ignored){} out.println((maxid+999)+" records so far!
"); } catch(Exception e){out.println(Error(e));} if(conn != null) { try {conn.close();} catch (Exception ignored) {} } %> qUweb_pathqUSQLBenchMark/ms_insert1000.jspqUcompiledqKUtitleqUInsert 1000 records into MSqUupdatedqKU_varsq}qu. Т+((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUinfo_ms.jspqUglobalsq}qUown_pathqU1d:/Tom/webapps/ROOT/Zope/SQLBenchMark/info_ms.jspqUrawqT╠<%@ page import="java.sql.*" %>

<%! String RndText(int n) { String Chars="0123456789qwertyuiopasdfghjklzxcvbnm"; String rnd=""; int lg=Chars.length(); for(int i=0;i"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; Statement stmt = null; ResultSet rs = null; //load driver try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} //select max try{ rs = stmt.executeQuery("SELECT max(id) as cnt FROM bench "); //Loop through results of query. long cnt=0; while(rs.next()) cnt = rs.getLong("cnt"); out.println((cnt)+" records on MS!
"); } catch(Exception e){out.println(Error(e));} if(conn != null) { try {conn.close();} catch (Exception ignored) {} } %> qUweb_pathqUSQLBenchMark/info_ms.jspqUcompiledqKUtitleqUCount MS RecordsqUupdatedqKU_varsq}qu.Хме((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qU search_ms.jspqUglobalsq}qUown_pathqU3d:/Tom/webapps/ROOT/Zope/SQLBenchMark/search_ms.jspqUrawqTI<%@ page import="java.sql.*" %>

<%! String Error(Exception e) { String ret = e.getMessage() + "
"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% String search_expr=request.getParameter("s"); if (search_expr==null) { out.println(""); } else //do search { Connection conn = null; Statement stmt = null; out.println("Try to load drivers!
"); try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} ResultSet rs = null; out.println("Searching!
"); try { rs = stmt.executeQuery("SELECT id,name from bench where name like '%"+search_expr+"%'"); out.println(""); while(rs.next()) { long id = rs.getLong("id"); String name = rs.getString("name"); out.println(""); } out.println("

ID	NAME
"+id+"	"+name+"

"); } catch(Exception e){out.println(Error(e));} } %> qUweb_pathqUSQLBenchMark/search_ms.jspqUcompiledqKUtitleqUSearch on MSqUupdatedqKU_varsq}qu. ЫЙ((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUcontinue_ms_to_oracle_copy.jspqUglobalsq}qUown_pathqUDd:/Tom/webapps/ROOT/Zope/SQLBenchMark/continue_ms_to_oracle_copy.jspqUrawqT%<%@ page import="java.sql.*" %>

<%! String Error(Exception e) { String ret = e.getMessage() + "
"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; //Microsoft Connection conn1 = null; //Oracle Statement stmt = null; Statement stmt1 = null; out.println("Try to load drivers!
"); try { conn1=conn; stmt = conn.createStatement(); stmt1 = conn1.createStatement(); } catch(Exception e){out.println(Error(e));} ResultSet rs = null; ResultSet rs1 = null; long maxid=0; //select max try{ rs1 = stmt1.executeQuery("SELECT max(id) as maxid FROM bench "); //Loop through results of query. while(rs1.next()) maxid = rs1.getLong("maxid"); out.println("Insert from "+maxid+".
"); } catch(Exception e){out.println(Error(e));} out.println("try continue TRANSFER!
"); try { rs = stmt.executeQuery("SELECT id,name from bench where id>"+maxid); while(rs.next()) { long id = rs.getLong("id"); String name = rs.getString("name"); try { rs1 = stmt1.executeQuery("INSERT into bench(id,name) values("+id+",'"+name+"')"); } catch (Exception ignored){} } } catch(Exception e){out.println(Error(e));} %> qUweb_pathqU+SQLBenchMark/continue_ms_to_oracle_copy.jspqUcompiledqKUtitleqU"Continue Copy MS table into OracleqUupdatedqKU_varsq}qu. Ь7((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUinfo_ora.jspqUglobalsq}qUown_pathqU2d:/Tom/webapps/ROOT/Zope/SQLBenchMark/info_ora.jspqUrawqTІ<%@ page import="java.sql.*" %>

<%! String RndText(int n) { String Chars="0123456789qwertyuiopasdfghjklzxcvbnm"; String rnd=""; int lg=Chars.length(); for(int i=0;i"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; Statement stmt = null; ResultSet rs = null; //load driver try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} //select max try{ rs = stmt.executeQuery("SELECT max(id) as cnt FROM bench "); //Loop through results of query. long cnt=0; while(rs.next()) cnt = rs.getLong("cnt"); out.println((cnt)+" records on Oracle!
"); } catch(Exception e){out.println(Error(e));} if(conn != null) { try {conn.close();} catch (Exception ignored) {} } %> qUweb_pathqUSQLBenchMark/info_ora.jspqUcompiledqKUtitleqUCount Oracle RecordsqUupdatedqKU_varsq}qu. У│((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUioanq]qUOwnerq asU__name__q U index_htmlqUtitleqUUglobalsq }qUrawqUз

SQL BenchMark for Zope & JSP

qU_varsq}qu.Хлж((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUsearch_oracle.jspqUglobalsq}qUown_pathqU7d:/Tom/webapps/ROOT/Zope/SQLBenchMark/search_oracle.jspqUrawqTJ<%@ page import="java.sql.*" %>

ID	NAME
"+id+"	"+name+"

"); } catch(Exception e){out.println(Error(e));} } %> qUweb_pathqUSQLBenchMark/search_oracle.jspqUcompiledqKUtitleqUSearch on OracleqUupdatedqKU_varsq}qu.ХгЖ((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUms_create_table.jspqUglobalsq}qUown_pathqU9d:/Tom/webapps/ROOT/Zope/SQLBenchMark/ms_create_table.jspqUrawqTa<%@ page import="java.sql.*" %>

<%! String Error(Exception e) { String ret = e.getMessage() + "
"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; Statement stmt = null; ResultSet rs = null; out.println("Load driver!
"); try { stmt = conn.createStatement(); } catch(Exception e){out.println(Error(e));} out.println("DROP!
"); try { rs = stmt.executeQuery("DROP TABLE bench"); out.println("Table dropped!
"); } catch(Exception e){out.println(Error(e));} out.println("CREATE!
"); try { rs = stmt.executeQuery("create table bench(id integer,name varchar(200))"); out.println("Table created!
"); } catch(Exception e){out.println(Error(e));} if(conn != null) { try {conn.close();} catch (Exception ignored) {} } %> qUweb_pathqU SQLBenchMark/ms_create_table.jspqUcompiledqKUtitleqUCreate MS SQL TableqUupdatedqKU_varsq}qu.ХиЁ((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUioanq]qUOwnerq asU__name__q U ms_connectqUtitleqUedit this fileq Uglobalsq}qUrawqUЭ/* common JDBC connect statement for all jsp files */ Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://ioan:1433;DatabaseName=dataweb", "sa", ""); qU_varsq}qu.Хй#((U Products.ZopeJsp.ZopeJspDocumentqUZopeJspDocumentqtqNt.}q(UportqU8144qU__ac_local_roles__q}qUioanq ]q UOwnerqasUfolderqUZopeq U__name__qUms_to_oracle_copy.jspqUglobalsq}qUown_pathqU;d:/Tom/webapps/ROOT/Zope/SQLBenchMark/ms_to_oracle_copy.jspqUrawqT┌<%@ page import="java.sql.*" %>

<%! String Error(Exception e) { String ret = e.getMessage() + "
"; //while((e = e.getNextException()) != null) // ret=ret+e.getMessage() + "
"; return ret; } %> <% Connection conn = null; //Microsoft Connection conn1 = null; //Oracle Statement stmt = null; Statement stmt1 = null; out.println("Try to load drivers!
"); try { conn1=conn; stmt = conn.createStatement(); stmt1 = conn1.createStatement(); } catch(Exception e){out.println(Error(e));} ResultSet rs = null; ResultSet rs1 = null; out.println("execute DROP!
"); try { rs1 = stmt1.executeQuery("DROP TABLE bench"); out.println("Table dropped!
"); } catch(Exception e){out.println(Error(e));} out.println("execute CREATE!
"); try { rs1 = stmt1.executeQuery("CREATE TABLE bench(id integer,name varchar(200))"); out.println("Table created!
"); } catch(Exception e){out.println(Error(e));} out.println("try TRANSFER all!
"); try { rs = stmt.executeQuery("SELECT id,name from bench"); while(rs.next()) { long id = rs.getLong("id"); String name = rs.getString("name"); try { rs1 = stmt1.executeQuery("INSERT into bench(id,name) values("+id+",'"+name+"')"); } catch (Exception ignored){} } } catch(Exception e){out.println(Error(e));} %> qUweb_pathqU"SQLBenchMark/ms_to_oracle_copy.jspqUcompiledqKUtitleqUCopy MS table into OracleqUupdatedqKU_varsq}qu.Хк╣((UOFS.DTMLMethodqU DTMLMethodqtqNt.}q(U__ac_local_roles__q}qUioanq]qUOwnerq asU__name__q Uora_connectqUtitleqUedit this fileq Uglobalsq}qUrawqUЩ/* common JDBC connect statement for all jsp files */ Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection( "jdbc:oracle:thin:@ioan:1521:dataweb", "system", "manager"); qU_varsq}qu.ЪЪЪЪЪЪЪЪЪЪЪЪЪЪЪЪ