Below is my sql-map-config.xml file. JVM memory settings are -Xms512m
-Xmx512m. Pretty sure Toad does not use JDBC to connect, since it requires an
install of the Oracle client tools.
Thank you all for responding.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
useStatementNamespaces="false"
maxSessions="128"
maxTransactions="32"
maxRequests="512"/>
<transactionManager type="JDBC">
<dataSource type="JNDI">
<property name="DataSource"
value="java:comp/env/bppool"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/scholar/model/map/PrivilegesSQL.xml"/>
<sqlMap resource="com/scholar/model/map/EntitySQL.xml"/>
<sqlMap resource="com/scholar/model/map/GenericSQL.xml"/>
<sqlMap resource="com/scholar/model/map/SchoolYearsSQL.xml"/>
<sqlMap resource="com/scholar/model/map/DemographicSQL.xml"/>
<sqlMap resource="com/scholar/model/map/TeacherSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ClassroomSQL.xml"/>
<sqlMap resource="com/scholar/model/map/SchoolSQL.xml"/>
<sqlMap resource="com/scholar/model/map/UsersSQL.xml"/>
<sqlMap resource="com/scholar/model/map/RolesSQL.xml"/>
<sqlMap resource="com/scholar/model/map/UserGroupsSQL.xml"/>
<sqlMap resource="com/scholar/model/map/SchoolClassificationSQL.xml"/>
<sqlMap resource="com/scholar/model/map/AssessmentSQL.xml"/>
<sqlMap resource="com/scholar/model/map/AssessmentGroupSQL.xml"/>
<sqlMap resource="com/scholar/model/map/AssessedReportCatSQL.xml"/>
<sqlMap resource="com/scholar/model/map/StudentSQL.xml"/>
<sqlMap resource="com/scholar/model/map/TestSQL.xml"/>
<sqlMap resource="com/scholar/model/map/AnalysisSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ScoreMethodSQL.xml"/>
<sqlMap resource="com/scholar/model/map/SubjectSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ReportCategorySQL.xml"/>
<sqlMap resource="com/scholar/model/map/ProficiencyProfileSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ProficiencyRubricSQL.xml"/>
<sqlMap resource="com/scholar/model/map/GradeLevelSQL.xml"/>
<sqlMap resource="com/scholar/model/map/TestSessionSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ConceptSQL.xml"/>
<sqlMap resource="com/scholar/model/map/DefaultDailyViewSQL.xml"/>
<sqlMap resource="com/scholar/model/map/InterventionSQL.xml"/>
<sqlMap resource="com/scholar/model/map/ReportGroupSQL.xml"/>
<sqlMap resource="com/scholar/model/map/SavedGraphSQL.xml"/>
<sqlMap resource="com/scholar/model/map/MaintenanceSQL.xml"/>
<sqlMap resource="com/scholar/model/map/TestScoreEntrySQL.xml"/>
<sqlMap
resource="com/scholar/model/map/ProficiencyProfileLevelSQL.xml"/>
<sqlMap resource="com/scholar/model/map/TestCourseSQL.xml"/>
<sqlMap resource="com/scholar/model/map/QuestionSQL.xml"/>
<sqlMap resource="com/scholar/model/map/CohortSQL.xml"/>
<sqlMap resource="com/scholar/model/map/StudentsTestedSQL.xml"/>
<sqlMap resource="com/scholar/model/map/StudentProfileSQL.xml"/>
<sqlMap
resource="com/scholar/model/map/ProficiencyRubricAssessmentSQL.xml"/>
<sqlMap resource="com/scholar/model/map/CIDTQueueSQL.xml"/>
<sqlMap resource="com/scholar/model/map/DataTransferProfileSQL.xml"/>
<sqlMap resource="com/scholar/model/map/DataTransferSQL.xml"/>
<sqlMap resource="com/scholar/model/map/FormatSQL.xml"/>
<sqlMap resource="com/scholar/model/map/OracleSpecificSQL.xml"/>
</sqlMapConfig>
Quoting Kris Jenkins <[EMAIL PROTECTED]>:
Hi Brian,
I'm using a very similar setup - tomcat 5.0.28, iBatis 2.0.9, Oracle
8i and the ojdbc14.jar - and I don't get this problem. Perhaps I can
help you track it down?
We execute a query through the web app that takes 55 seconds to complete.
While this query is executing, we execute another query against the same
table in a different browser. It normally takes a few seconds, but it will
not complete until the first one does.
First things first - one query at running at a time sounds like a
number of (sessions|transactions|requests|connections) problem. Can
we see your sql-map-config.xml and any properties files it uses?
Cheers,
Kris
--
Kris Jenkins
Email: [EMAIL PROTECTED]
Blog: http://cafe.jenkster.com/
Wiki: http://wiki.jenkster.com/
