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 Wed, 30 Dec 2009 09:18:45 GMT

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