ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barnett <brian.barn...@whitesandsolutions.com>
Subject Re: Oracle + iBATIS: more details
Date Wed, 16 Mar 2005 16:37:26 GMT
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 <krisajenkins@yahoo.co.uk>:

> 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:  kris@jenkster.com
> Blog:   http://cafe.jenkster.com/
> Wiki:   http://wiki.jenkster.com/
>
>
>
>



Mime
View raw message