ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: New to iBatis facing problem to get started
Date Wed, 30 Dec 2009 13:51:45 GMT
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
>
>

Mime
View raw message