ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vishalj <Vish...@ivycomptech.com>
Subject Re: New to iBatis facing problem to get started
Date Mon, 04 Jan 2010 10:02:28 GMT

Hi,
does my configuration looks incorrect somewhere 


Clinton Begin wrote:
> 
> Well... I don't know what to tell you.  iBATIS isn't reporting an error,
> and
> doesn't often fail silently (if ever).  You can try turning on logging and
> replace your main method with a unit test that has assertions like
> assertNotNull(userProfile);, which is cleaner than letting an NPE occur.
> 
> Clinton
> 
> On Wed, Dec 30, 2009 at 2:18 AM, vishalj <VishalJ@ivycomptech.com> wrote:
> 
>>
>> tha db table contains a row with id vakue of '1' which i am trying to
>> query
>> .And also the same select statement is working fine
>>
>> Clinton Begin wrote:
>> >
>> > The NPE is coming from your main method (profile.getName()).  It's not
>> > finding the profile record. It looks like iBATIS is working, but
>> there's
>> > simply no data to be found, or the parameter is incorrect.
>> >
>> > Clinton
>> >
>> > On Tue, Dec 29, 2009 at 10:28 PM, vishalj <VishalJ@ivycomptech.com>
>> wrote:
>> >
>> >>
>> >> Hi,
>> >> I am using iBatis for the first time ,but no success yet.This is how
>> my
>> >> setup looks like
>> >>
>> >> DB SCHEMA:
>> >>  CREATE TABLE TEST_USERPROFILE
>> >>   (    NAME VARCHAR2(20),
>> >>        ID NUMBER
>> >>   ) ;
>> >>
>> >> iBatis configuration.xml
>> >> <configuration>
>> >>        <properties
>> >> resource="com/pg/ibatis/config/config.properties"></properties>
>> >>        <typeAliases>
>> >>                <typeAlias type="com.pg.beans.UserProfile"
>> >> alias="UserProfile"/>
>> >>        </typeAliases>
>> >>        <environments default="development">
>> >>                <environment id="development">
>> >>                        <transactionManager type="JDBC" />
>> >>                        <dataSource type="POOLED">
>> >>                                <property name="driver"
>> value="${driver}"
>> >> />
>> >>                                <property name="url" value="${url}" />
>> >>                                <property name="username"
>> >> value="${username}" />
>> >>                                <property name="password"
>> >> value="${password}" />
>> >>                        </dataSource>
>> >>                </environment>
>> >>        </environments>
>> >>        <mappers>
>> >>                        <mapper
>> >> resource="com/pg/ibatis/config/UserProfileMapper.xml" />
>> >>        </mappers>
>> >> </configuration>
>> >>
>> >> UserProfileMapper.xml
>> >> <mapper namespace="com.pg.mappers.UserProfileMapper">
>> >>        <select id="selectUserProfile" parameterType="int"
>> >> resultType="UserProfile">
>> >>                SELECT * FROM TEST_USERPROFILE WHERE id=#{id}
>> >> </select>
>> >> </mapper>
>> >>
>> >> UserProfileMapper.java
>> >> public interface UserProfileMapper {
>> >>        UserProfile selectUserProfile(int id);
>> >> }
>> >>
>> >> UserProfile.java
>> >> public class UserProfile {
>> >>        String name;
>> >>        int id;
>> >>        public int getId() {
>> >>                return id;
>> >>        }
>> >>        public void setId(int id) {
>> >>                this.id = id;
>> >>        }
>> >>        public String getName() {
>> >>                return name;
>> >>        }
>> >>        public void setName(String name) {
>> >>                this.name = name;
>> >>        }
>> >>
>> >> }
>> >>
>> >> Main method
>> >> String resource = "com/pg/ibatis/config/Configuration.xml";
>> >>                Reader reader =
>> Resources.getResourceAsReader(resource);
>> >>                SqlSessionFactory factory = new
>> SqlSessionFactoryBuilder()
>> >>                                .build(reader);
>> >>                SqlSession session = factory.openSession();
>> >>                try {
>> >>                        UserProfileMapper mapper =
>> >> session.getMapper(UserProfileMapper.class);
>> >>                        UserProfile profile =
>> mapper.selectUserProfile(1);
>> >>                        System.out.println("PROFILE " + profile);
>> >>                        System.out.println(profile.getName());
>> >>                } finally {
>> >>                        session.close();
>> >>                }
>> >>
>> >> But i am getting NPE
>> >> PROFILE null
>> >> Exception in thread "main" java.lang.NullPointerException
>> >>        at Main.main(Main.java:23)
>> >> --
>> >> View this message in context:
>> >>
>> http://old.nabble.com/New-to-iBatis-facing-problem-to-get-started-tp26964254p26964254.html
>> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://old.nabble.com/New-to-iBatis-facing-problem-to-get-started-tp26964254p26965432.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
> 
> 

-- 
View this message in context: http://old.nabble.com/New-to-iBatis-facing-problem-to-get-started-tp26964254p27010870.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message