ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Randall Svancara <rsvanc...@wsu.edu>
Subject Re: Problems with returning a result set.
Date Tue, 22 Jan 2008 23:18:37 GMT
Stephen,

Thanks for the reply.  The table is in only one schema.

I have confirmed this by doing a:

SELECT table_name, owner from all_tables where table_name='BLAST_PROG' 

as the sysdba user.

Thanks

-  
Randall Svancara
Systems Administrator


On Tue, 2008-01-22 at 18:14 -0500, Stephen Boyd wrote:
> Do you have the same table in multiple schemas?  If so, make sure
> ibatis is reading from the correct schema.
> 
> On Jan 22, 2008 4:37 PM, Randall Svancara <rsvancara@wsu.edu> wrote:
>         I have used Ibatis for numerous projects and never had a
>         problems with 
>         returning back a result set.  I have other files configured in
>         a similar
>         manner and they seem to work just fine.
>         
>         First of all, i have this sql configuration file:
>         
>         Contents of Blast_Program.xml
>         ************************************* 
>         <?xml version="1.0" encoding="UTF-8"?>
>         <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
>         "http://www.ibatis.com/dtd/sql-map-2.dtd">
>         <sqlMap namespace="BlastProgram">
>         
>         
>            <typeAlias alias="BlastProgram"
>         type="edu.wsu.bioinfo.webblast.domain.BlastProgram " />
>            <typeAlias alias="QtypeDtypeParamClass"
>         type="edu.wsu.bioinfo.webblast.persistance.paramclasses.QtypeDtypeParamClass"
/>
>         
>            <resultMap id="blastProgramResultMap"
>         class="BlastProgram"> 
>             <result property="programid" column="program_id" />
>             <result property="programname" column="program_name" />
>             <result property="environment" column="environment" /> 
>             <result property="programpath" column="program_path" />
>             <result property="dtype" column="db" />
>             <result property="qtype" column="seq" /> 
>            </resultMap>
>         
>            <parameterMap id="blastparams"
>         class="QtypeDtypeParamClass">
>                <parameter property="qtype" jdbcType="VARCHAR"
>         nullValue="n"/> 
>                <parameter property="dtype" jdbcType="VARCHAR"
>         nullValue="n"/>
>            </parameterMap>
>            <!--
>         edu.wsu.bioinfo.webblast.persistance.paramclasses.QtypeDtypeParamClass 
>         -->
>            <select id="getAllBlastProgramsQT"
>         resultMap="blastProgramResultMap">
>                SELECT program_id, program_name, environment,
>         program_path, seq,
>         db from blast_prog where seq='n' and db='n' 
>            </select>
>         
>         
>         </sqlMap>
>         *********************************************************************
>         
>         
>         Here is the table stored in an Oracle Database:
>         
>         ********************************************************************* 
>         PROGRAM_ID
>         NOT NULL NUMBER(8)
>          PROGRAM_NAME
>         VARCHAR2(100)
>          ENVIRONMENT
>         VARCHAR2(2000)
>          PROGRAM_PATH
>         VARCHAR2(1000)
>          SEQ
>         CHAR(1)
>          DB
>         CHAR(1)
>         
>         ********************************************************************* 
>         
>         The above SQL located in Blast_Program.sql works just fine on
>         this table
>         and returns results when  put into SQL Plus.
>         
>         
>         Below is the debugging output from IBATIS:
>         ********************************************************************* 
>         2008-01-22 13:28:39,216 DEBUG
>         (edu.wsu.bioinfo.webblast.persistance.BlastProgramSQLMapDao:176) -
>         Opened SqlMapSession
>         [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@6481eb] for
>         iBATIS
>         operation
>         2008-01-22 13:28:39,218 DEBUG 
>         (org.springframework.jdbc.datasource.DataSourceUtils:112) -
>         Fetching
>         JDBC Connection from DataSource
>         2008-01-22 13:28:39,218 DEBUG
>         (org.springframework.jdbc.datasource.DataSourceUtils:112) -
>         Fetching
>         JDBC Connection from DataSource 
>         2008-01-22 13:28:39,220 DEBUG (java.sql.Connection:27) -
>         {conn-100006}
>         Connection
>         2008-01-22 13:28:39,221 DEBUG
>         (edu.wsu.bioinfo.webblast.persistance.BlastProgramSQLMapDao:185) -
>         Obtained JDBC Connection
>         [jdbc:oracle:thin:@mldb3.bioinfo.wsu.edu:1521:maindev,
>         UserName=RANDALLS, Oracle JDBC driver] for iBATIS operation
>         2008-01-22 13:28:39,222 DEBUG ( java.sql.Connection:27) -
>         {conn-100006}
>         Preparing Statement:          SELECT program_id, program_name,
>         environment, program_path, seq, db from blast_prog where
>         seq='n' and
>         db='n'
>         2008-01-22 13:28:39,223 DEBUG ( java.sql.PreparedStatement:27)
>         -
>         {pstm-100007} Executing Statement:          SELECT program_id,
>         program_name, environment, program_path, seq, db from
>         blast_prog where
>         seq='n' and db='n'
>         2008-01-22 13:28:39,224 DEBUG ( java.sql.PreparedStatement:27)
>         -
>         {pstm-100007} Parameters: []
>         2008-01-22 13:28:39,225 DEBUG (java.sql.PreparedStatement:27)
>         -
>         {pstm-100007} Types: []
>         2008-01-22 13:28:39,229 DEBUG (java.sql.ResultSet:27) -
>         {rset-100008} 
>         ResultSet
>         2008-01-22 13:28:39,230 DEBUG
>         (org.springframework.jdbc.datasource.DataSourceUtils:312) -
>         Returning
>         JDBC Connection to DataSource
>         2008-01-22 13:28:39,231 DEBUG
>         (org.springframework.jdbc.datasource.DataSourceUtils :312) -
>         Returning
>         JDBC Connection to DataSource
>         *****************************************************************************
>         
>         I have tried changing the names of the columns in the table in
>         the
>         database, creating resultMaps in various incarnations.  I am
>         using 
>         Struts2, Spring and IBATIS.
>         
>         If anyone has a chance, and can offer me any advice or
>         assistance I
>         would appreciate it.
>         
>         Thanks,
>         
>         Randall
>         
>         
>         
>         
> 

Mime
View raw message