Problem with primitive parameters
---------------------------------
Key: IBATIS-114
URL: http://issues.apache.org/jira/browse/IBATIS-114
Project: iBatis for Java
Type: Bug
Components: SQL Maps
Environment: Using Eclipse 3.1.0 M5 under Linux
Reporter: Tom Cassimon
Hi,
i'm currently working on a web application that uses iBATIS in Java (
JDK 1.5 ), but i ran into a problem and tried to fix it in a little
test application, but no succes.
The first problem is that the attribute parameter, to use primitive
parameters ( according to the developer guide ), is not included in
the dtd ( http://www.ibatis.com/dtd/sql-map-2.dtd ). So i surfed the
internet and found examples where they used primitive parameters and
they didn't use any of the parameter attributes. But that doesn't work
either. I've also tried parameterClass="string" with no succes.
I've also played with the database types, first it were VARCHAR2's now
it are CHAR's, the db is an Oracle 9.2.0.4 btw. Now i have an sql
query with a where clause that compares a string as you can see in
User.xml but i also tried with the user_id and then the sql query
returns an result. If i use the Name in het where clause like it is
now, it returns null. Does anybody has any idea why ?
Db Table:
Create table Users (
User_id numeric[10] primary key,
Name Char[100] unique,
Password Char[100] );
My sqlMapConfig.xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd";>
<sqlMapConfig>
<settings
cacheModelsEnabled="false"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:oracle:thin:@localhost:1521:virodb"/>
<property name="JDBC.Username"
value="vbapp"/>
<property name="JDBC.Password"
value="vbapp"/>
<property name="JDBC.DefaultAutoCommit"
value="yes"/>
<property name="Pool.MaximumActiveConnections"
value="10"/>
<property name="Pool.MaximumIdleConnections"
value="5"/>
</dataSource>
</transactionManager>
<sqlMap resource="db/sql/sqlmap/User.xml"/>
<sqlMap resource="db/sql/sqlmap/Message.xml"/>
</sqlMapConfig>
My User.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="User">
<resultMap id="User" class="db.bean.User">
<result property="id" column="USER_ID"
javaType="int" jdbcType="NUMERIC[11]"/>
<result property="user"
column="NAME" javaType="string"
jdbcType="CHAR[100]"/>
<result property="password" column="PASSWORD"
javaType="string" jdbcType="CHAR[100]"/>
</resultMap>
<select id="getUserbyName" resultMap="User" resultClass="db.bean.User">
SELECT * FROM users WHERE name = #value#
</select>
</sqlMap>
My Java file:
reader =
Resources.getResourceAsReader("db/sql/sqlmap/SqlMapConfig.xml");
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
user = (User) sqlMap.queryForObject("getUserbyName",username);
if ( password != user.getPassword() ) <-- NullpointerException (
so
the previous line returns null )
{
throw new Exception();
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
