|
Hi all, I am confronted to a
weird problem. My configureAndWatch is
not able to load a class from an assembly that is sitting in the same
directory. Have you an idea of what
could be my problem? “…Exception
non gérée: IBatisNet.Common.Exceptions.ConfigurationException: DaoManager could
not configure SqlMapDaoSessionHandler.Cause: Could not load type: cmacgm.Wimb.Domain.Lara.Data.JobHeaders
at IBatisNet.DataAccess.DaoSessionHandlers.SqlMapDaoSessionHandler.Configure(Hashtable
properties) …” Thanks in advance for
your help, Regards Jean-Guillaume |
laraSqlMap.config
Description: Binary data
wimbv2Dao.config
Description: Binary data
<?xml version="1.0" encoding="UTF-8" ?> <sqlMap namespace="JobHeaders" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="SqlMap.xsd">
<alias>
<typeAlias alias="JobHeaders" assembly="wimbv2.Domain.dll" type="cmacgm.Wimb.Domain.Lara.Data.JobHeaders" />
<typeAlias alias="IDictionary" assembly="Mscorlib.dll" type="System.Collections.IDictionary" />
</alias>
<resultMaps>
<resultMap id="JobHeadersResult" class="JobHeaders">
<result property="Id" column="JOB_REFERENCE"/>
<result property="JobStatus" column="JOB_STATUS"/>
<result property="AvailDate" column="AVAILABLE_DATE"/>
<result property="DateStamp" column="DATE_STAMP"/>
<result property="TimeStamp" column="TIME_STAMP"/>
<result property="PointFrom" column="POINT_FROM"/>
<result property="PointLoad" column="POINT_LOAD"/>
<result property="PointDisch" column="POINT_DISCH"/>
<result property="PointTo" column="POINT_TO"/>
<result property="AlternExp" column="ALTERNATE_POINT_EXPORT"/>
<result property="AlternImp" column="ALTERNATE_POINT_IMPORT"/>
<result property="VoyRef" column="VOYAGE_REFERENCE"/>
<result property="NumUnits" column="NUM_UNITS"/>
<result property="ExternJobRef" column="EXTERNAL_JOB_REFERENCE"/>
<result property="PointTrans" column="POINT_TRANS"/>
<result property="BkgPtyName" column="BKG_PTY_CODE"/>
<result property="BolNum" column="BOL_NUMBER"/>
<result property="PointFromLabel" column="POINTFROMLABEL"/>
<result property="PointLoadLabel" column="POINTLOADLABEL"/>
<result property="PointToLabel" column="POINTTOLABEL"/>
<result property="PointDischLabel" column="POINTDISCHLABEL"/>
</resultMap>
</resultMaps>
<!-- =============================================
MAPPED STATEMENTS
=============================================
-->
<statements>
<select id="findJobHeadersById" resultMap="JobHeadersResult" parameterClass="string">
select
JOB_REFERENCE,
JOB_STATUS,
AVAILABLE_DATE,
DATE_STAMP,
TIME_STAMP,
POINT_FROM,
POINT_LOAD,
POINT_DISCH,
POINT_TO,
ALTERNATE_POINT_EXPORT,
ALTERNATE_POINT_IMPORT,
VOYAGE_REFERENCE,
NUM_UNITS,
EXTERNAL_JOB_REFERENCE,
POINT_TRANS,
BKG_PTY_CODE,
BOL_NUMBER,
PFROM.FULL_NAME POINTFROMLABEL,
PLOAD.FULL_NAME POINTLOADLABEL,
PDISCH.FULL_NAME POINTDISCHLABEL,
PTO.FULL_NAME POINTTOLABEL
from
JOB_HEADERS,
PORTS PFROM,
PORTS PLOAD,
PORTS PDISCH,
PORTS PTO
where
JOB_HEADERS.POINT_FROM = PFROM.POINT_CODE(+) AND
JOB_HEADERS.POINT_LOAD = PLOAD.POINT_CODE(+) AND
JOB_HEADERS.POINT_DISCH = PDISCH.POINT_CODE(+) AND
JOB_HEADERS.POINT_TO = PTO.POINT_CODE(+) AND
BOL_NUMBER = #value# AND
AVAILABLE_DATE between current_date-100 and current_date
</select>
<select id="findJobHeadersByXOF" resultMap="JobHeadersResult" parameterClass="IDictionary">
select
header.JOB_REFERENCE,
header.JOB_STATUS,
header.AVAILABLE_DATE,
header.DATE_STAMP,
header.TIME_STAMP,
header.POINT_FROM,
header.POINT_LOAD,
header.POINT_DISCH,
header.POINT_TO,
header.ALTERNATE_POINT_EXPORT,
header.ALTERNATE_POINT_IMPORT,
header.VOYAGE_REFERENCE,
header.NUM_UNITS,
header.EXTERNAL_JOB_REFERENCE,
header.POINT_TRANS,
header.BKG_PTY_CODE,
header.BOL_NUMBER,
PFROM.FULL_NAME POINTFROMLABEL,
PLOAD.FULL_NAME POINTLOADLABEL,
PDISCH.FULL_NAME POINTDISCHLABEL,
PTO.FULL_NAME POINTTOLABEL
from
JOB_HEADERS header,
JOB_EQUIPMENT equipment,
JOURNEY journey,
POOL_LOCATIONS pool,
PORTS PFROM,
PORTS PLOAD,
PORTS PDISCH,
PORTS PTO
WHERE
header.POINT_FROM = PFROM.POINT_CODE(+) AND
header.POINT_LOAD = PLOAD.POINT_CODE(+) AND
header.POINT_DISCH = PDISCH.POINT_CODE(+) AND
header.POINT_TO = PTO.POINT_CODE(+) AND
header.JOB_REFERENCE = equipment.JOB_REFERENCE
AND
equipment.JOB_REFERENCE = journey.JOB_REFERENCE
AND
header.JOB_STATUS not in ('0', '9')
AND
journey.JOURNEY_TYPE in ('T', 'F')
AND
equipment.CONTAINER_NUMBER = #conId#
AND
(journey.COLL_DATE BETWEEN (TO_DATE(#date1#,'MM-DD-YYYY') - #offset1# ) AND (TO_DATE(#date2#,'MM-DD-YYYY') + #offset2# )
OR
(journey.COLL_DATE IS NULL AND header.AVAILABLE_DATE BETWEEN (TO_DATE(#date3#,'MM-DD-YYYY') - #offset3# ) AND (TO_DATE(#date4#,'MM-DD-YYYY') + #offset4# )))
AND
header.JOB_STATUS NOT IN ('0', '1', '9')
AND
pool.POOL_LOCATION=#pointCode#
AND
journey.POINT_FROM = pool.POINT_CODE
</select>
<select id="findJobHeadersByXRX" resultMap="JobHeadersResult" parameterClass="IDictionary">
select
header.JOB_REFERENCE,
header.JOB_STATUS,
header.AVAILABLE_DATE,
header.DATE_STAMP,
header.TIME_STAMP,
header.POINT_FROM,
header.POINT_LOAD,
header.POINT_DISCH,
header.POINT_TO,
header.ALTERNATE_POINT_EXPORT,
header.ALTERNATE_POINT_IMPORT,
header.VOYAGE_REFERENCE,
header.NUM_UNITS,
header.EXTERNAL_JOB_REFERENCE,
header.POINT_TRANS,
header.BKG_PTY_CODE,
header.BOL_NUMBER,
PFROM.FULL_NAME POINTFROMLABEL,
PLOAD.FULL_NAME POINTLOADLABEL,
PDISCH.FULL_NAME POINTDISCHLABEL,
PTO.FULL_NAME POINTTOLABEL
from
JOB_HEADERS header,
JOB_EQUIPMENT equipment,
JOURNEY journey,
POOL_LOCATIONS pool,
PORTS PFROM,
PORTS PLOAD,
PORTS PDISCH,
PORTS PTO
WHERE
header.POINT_FROM = PFROM.POINT_CODE(+) AND
header.POINT_LOAD = PLOAD.POINT_CODE(+) AND
header.POINT_DISCH = PDISCH.POINT_CODE(+) AND
header.POINT_TO = PTO.POINT_CODE(+) AND
header.JOB_REFERENCE = equipment.JOB_REFERENCE
AND
equipment.JOB_REFERENCE = journey.JOB_REFERENCE
AND
header.JOB_STATUS not in ('0', '9')
AND
journey.JOURNEY_TYPE in ('T', 'F')
AND
equipment.CONTAINER_NUMBER = #conId#
AND
(journey.COLL_DATE BETWEEN (TO_DATE(#date1#,'MM-DD-YYYY') - #offset1# ) AND (TO_DATE(#date2#,'MM-DD-YYYY') + #offset2# )
OR
(journey.COLL_DATE IS NULL AND header.AVAILABLE_DATE BETWEEN (TO_DATE(#date3#,'MM-DD-YYYY') - #offset3# ) AND (TO_DATE(#date4#,'MM-DD-YYYY') + #offset4# )))
AND
header.JOB_STATUS NOT IN ('0', '1', '9')
AND
pool.POOL_LOCATION=#pointCode#
AND
journey.POINT_FROM = pool.POINT_CODE
</select>
</statements>
</sqlMap>
