Home » Bugs » BUG 253 : NOT A BUG - Under the same number of JDBC and Ebean concurrent comparison
 Bug 253 : NOT A BUG - Under the same number of JDBC and Ebean concurrent comparison
Priority 
High
 Reported Version 
 
 Logged By 
zhoupeng
Status 
Fixed
 Fixed Version 
2.6.0
 Assigned To 
 
Product 
Ebean - core
 Duplicate Of 
 
 Created 
18/03/2010
Updated 
18/03/2010
 Type 
Bug
  
Attachments 
No attachments

>>>>>>>>>>>>>>Test Environment:

DataBase: Oracle 10.2(The default parameter settings)

JDK: 1.6.5

IDE: IntelliJ IDEA9.0

Test Case use in the JDBC, The Result is correct.

>>>>>>TestCase:

public class TestThread implements Runnable {

public TestThread(){
for(int i = 0;i<200;i++){
Thread th = new Thread(this);
th.start();
}
}
public void run() {

try{
long i = Thread.currentThread().getId();
new Gxpt2().checkUserAndIp();
}catch(Exception e){
System.out.println(e.toString());
}
}

public static void main(String[] args) {
new TestThread();

}
}

>>>>>>>>The class Gxpt2:

public class Gxpt2 {

private static final String url = "jdbc:oracle:thin:@127.0.0.1:1521:LOCALDB";
private static final String oracleusername = "animation";
private static final String oraclepassword = "animation";

static {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}


public boolean checkUserAndIp() {

Statement st = null;
ResultSet rs = null;
Connection con = null;
try {

con = DriverManager.getConnection(url, oracleusername,
oraclepassword);
String sql = "select * from wf_processdefinition";
st = con.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString("wf_pd_name"));

}
return false;
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
try {
rs.close();
st.close();
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}

}


Test Case use in the Ebean,Abnormal results, exception is as follows����?

>>>>>>>>>>>TestCase:

public class TestThread implements Runnable {

public TestThread(){
for(int i = 0;i<200;i++){
Thread th = new Thread(this);
th.start();
}
}
public void run() {

try{
long i = Thread.currentThread().getId();
Ebean.find(FlowData.class).where("wf_pd_name like '%%'").findList();
}catch(Exception e){
System.out.println(e.toString());
}
}

public static void main(String[] args) {
new TestThread();

}
}

>>>>>>>>>>>Exception:

��������?��: DataSourcePool [ora] grow pool; busy[126] size[126] max[1000]
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'

2010-3-18 17:42:22 com.avaje.ebean.server.lib.sql.DataSourcePool notifyDataSourceIsDown
��������??: FATAL: DataSourcePool [ora] is down!!!
2010-3-18 17:42:22 com.avaje.ebean.server.lib.sql.DataSourcePool reset
��������?��: Reseting DataSourcePool [ora]
2010-3-18 17:42:22 com.avaje.ebean.server.lib.sql.DataSourcePool reset
��������?��: Busy Connections:
name[ora.1] startTime[1268905334139] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.2] startTime[1268905334239] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.3] startTime[1268905334301] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.4] startTime[1268905334346] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.5] startTime[1268905334396] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.6] startTime[1268905334455] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.7] startTime[1268905334536] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.8] startTime[1268905334931] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.9] startTime[1268905334990] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.10] startTime[1268905335039] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.11] startTime[1268905335084] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.12] startTime[1268905335157] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.13] startTime[1268905335213] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.14] startTime[1268905335269] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.15] startTime[1268905335325] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.16] startTime[1268905335465] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.17] startTime[1268905335522] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.18] startTime[1268905335585] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.19] startTime[1268905335642] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.20] startTime[1268905335705] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.21] startTime[1268905335812] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.22] startTime[1268905335879] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.23] startTime[1268905335945] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.24] startTime[1268905335999] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.25] startTime[1268905336059] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.26] startTime[1268905336115] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.27] startTime[1268905336165] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.28] startTime[1268905336219] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.29] startTime[1268905336291] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.30] startTime[1268905336457] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.31] startTime[1268905336507] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.32] startTime[1268905336564] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.33] startTime[1268905336612] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.34] startTime[1268905336657] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.35] startTime[1268905336753] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.36] startTime[1268905336814] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.37] startTime[1268905336884] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.38] startTime[1268905336939] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.39] startTime[1268905337031] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.40] startTime[1268905337090] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.41] startTime[1268905337155] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.42] startTime[1268905337205] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.43] startTime[1268905337265] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.44] startTime[1268905337322] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.45] startTime[1268905337381] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.46] startTime[1268905337438] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.47] startTime[1268905337486] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.48] startTime[1268905337553] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.49] startTime[1268905337613] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.50] startTime[1268905337662] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.51] startTime[1268905337707] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.52] startTime[1268905337764] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.53] startTime[1268905337829] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.54] startTime[1268905338039] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.55] startTime[1268905338117] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.56] startTime[1268905338169] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.57] startTime[1268905338215] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.58] startTime[1268905338260] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.59] startTime[1268905338312] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.60] startTime[1268905338362] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.61] startTime[1268905338407] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.62] startTime[1268905338462] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.63] startTime[1268905338516] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.64] startTime[1268905338577] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.65] startTime[1268905338636] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.66] startTime[1268905338685] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.67] startTime[1268905338736] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.68] startTime[1268905338795] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.69] startTime[1268905338843] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.70] startTime[1268905338893] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.71] startTime[1268905338957] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.72] startTime[1268905339031] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.73] startTime[1268905339131] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.74] startTime[1268905339192] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.75] startTime[1268905339253] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.76] startTime[1268905339297] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.77] startTime[1268905339344] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.78] startTime[1268905339401] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.79] startTime[1268905339468] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.80] startTime[1268905339522] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.81] startTime[1268905339580] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.82] startTime[1268905339638] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.83] startTime[1268905339688] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.84] startTime[1268905339734] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.85] startTime[1268905339782] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.86] startTime[1268905339850] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.87] startTime[1268905339900] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.88] startTime[1268905339952] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.89] startTime[1268905340042] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.90] startTime[1268905340118] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.91] startTime[1268905340294] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.92] startTime[1268905340343] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.93] startTime[1268905340390] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.94] startTime[1268905340440] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.95] startTime[1268905340493] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.96] startTime[1268905340552] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.97] startTime[1268905340604] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.98] startTime[1268905340664] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.99] startTime[1268905340714] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.100] startTime[1268905340766] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.101] startTime[1268905340830] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.102] startTime[1268905340884] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.103] startTime[1268905340933] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.104] startTime[1268905340996] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.105] startTime[1268905341072] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.106] startTime[1268905341145] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.107] startTime[1268905341198] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.108] startTime[1268905341267] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.109] startTime[1268905341329] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.110] startTime[1268905341402] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.111] startTime[1268905341448] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.112] startTime[1268905341513] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.113] startTime[1268905341565] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.114] startTime[1268905341622] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.115] startTime[1268905341668] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.116] startTime[1268905341710] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.117] startTime[1268905341768] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.118] startTime[1268905341832] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.119] startTime[1268905341879] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.120] startTime[1268905341929] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.121] startTime[1268905341977] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.122] startTime[1268905342042] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.123] startTime[1268905342091] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.124] startTime[1268905342155] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.125] startTime[1268905342221] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.126] startTime[1268905342276] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]
name[ora.127] startTime[1268905342362] stmt[select f.WF_PD_ID c0, f.WF_PD_NAME c1, f.WF_PD_CONTENT c2, f.WF_PD_DESCRIPTION c3, f.WF_PD_MOUDLENAME c4, f.WF_PD_CREATER c5, f.WF_PD_CREATEDATE c6
from WF_PROCESSDEFINITION f
where wf_pd_name like '%%'] createdBy[null]

javax.persistence.PersistenceException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
127.0.0.1:1521:LOCALDB

javax.persistence.PersistenceException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
127.0.0.1:1521:LOCALDB

............................
............................
 
Rob 18 Mar 20:24
I don't understand

Sorry, I do not understand what the problem is.

Can you explicitly state what you think the issue is.

Thanks, Rob.

zhoupeng 19 Mar 01:18
Description

The same test cases and the operating environment, Ebean run better than JDBC worse, while Ebean will appear before the said exception

Rob 19 Mar 03:15
Sorry...

Sorry, I still do not understand.

Is this a performance issue?

Is this an issue related to the ORA-12519, TNS:no appropriate service handler found error?

Can you further explain what you think the problem / defect / bug is.

Thanks, Rob.

Rob 19 Mar 08:20
Hmmm...

Ok, I had another quick look at this code. The ORA-12519 occured and Ebean's connection pool could not grow (it had reached 126 connections).

So you have to find out if your Oracle instance can support 200 odd concurrent connections and try to determine the cause of the ORA-12519.

I don't think this is an Ebean issue.

zhoupeng 19 Mar 12:45
Please test as I use case

My question is, the same environment, why JDBC is not an error, but does not meet the demand is wrong Ebean

zhoupeng 19 Mar 17:01
I felt, the connection did not immediately closed

I felt, the connection did not immediately closed

Rob 20 Mar 08:31
You have to discover the cause of the ORA-12519 to progress

> why JDBC is not an error

Ebean got an ORA-12519 so you have to find out why that occured. Then you may or many not know why it worked in the JDBC case.

> I felt, the connection did not immediately closed

With Ebean you are using a connection pool, so the connections do not close they go back into the pool.

zhoupeng 22 Mar 03:38
I feel this is a problem

orale configuration as I know, in the same database environment, JDBC no errors, Ebean wrong! I feel this is a problem, please follow the test cases to test in detail.

zhoupeng 22 Mar 03:40
Ebean very powerful, and hope that more and more powerful

Ebean very powerful, and hope that more and more powerful

Rob 22 Mar 08:06
Your JDBC code...

Your JDBC code is not doing the same thing though. It is closing the connections fully after the query has finished. This means the JDBC code is not going to have as many connections open to the database (assuming that is the cause of the ORA 12519 which you are not sure of).

You need to reproduce the ORA-12519 using JDBC code ... perhaps by leaving the connections open. If the error occured that would tell you the max connections your oracle server was allowing ... and that assumes that is the cause of the ORA 12519.

Rob 31 Mar 03:51
Have you given up?

I'll close this as not a bug unless you can provide more information wrt the ORA 12519.

Thanks, Rob.

Rob 06 Apr 10:02
Ok, closing as NOT A BUG

Ok, closing as NOT A BUG.

woResponse

Upload a file