Not sure if this right forum but I have a problem that I have been
working on for almost a week, I am new to Ibatis and am just trying to
hook up to my database and am getting the following error (in red).....
I know that I am close but just cant seem to see it, I ask that you
please take a look at this, if this is the wrong way to get my questions
answered please just let me know what I need to do to properly submit my
questions... thank you in advance for any advice you can provide, I have
included my xml document and where I read from too. .
[5/5/05 17:26:29:641 MDT] 6b6bd603 SystemOut O =DEBUG
[Servlet.Engine.Transports : 1] May/05 17:26:29 |
(BSController.class:195) Map =
{providerAction=gov.utah.dhs.dsamh.bs.actions.ProviderAction,
serverAction=gov.utah.dhs.dsamh.bs.actions.ServerAction,
trainerAction=gov.utah.dhs.dsamh.bs.actions.TrainerAction}
=DEBUG [Servlet.Engine.Transports : 1] May/05 17:26:29 |
(BSController.class:64) Inside of controller do process
=DEBUG [Servlet.Engine.Transports : 1] May/05 17:26:29 |
(BSController.class:80) Inside of key if serverAction
inside of the bss mapper
[5/5/05 17:26:30:062 MDT] 6b6bd603 ConnectionFac I J2CA0122I: Resource
reference jdbc/bss could not be located, so default values of the
following are used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]
isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)
[5/5/05 17:26:30:219 MDT] 6b6bd603 SystemOut O ServerAction -
inside of the process request
[5/5/05 17:26:30:219 MDT] 6b6bd603 SystemOut O Action received:
First Name = Joe
[5/5/05 17:26:30:219 MDT] 6b6bd603 SystemOut O Action received:
Last Name = Buckwheat
[5/5/05 17:26:30:219 MDT] 6b6bd603 SystemOut O Action received:
Middle Name = Dee
[5/5/05 17:26:30:219 MDT] 6b6bd603 SystemOut O Action received: SSN
= 1234
[5/5/05 17:26:30:250 MDT] 6b6bd603 SystemErr R
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in gov/utah/dhs/dsamh/bs/dao/Server.xml.
--- The error occurred while applying a parameter map.
--- Check the getServer-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131:
Syntax error near 'id' on line 1
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -131:
Syntax error near 'id' on line 1
[5/5/05 17:26:30:250 MDT] 6b6bd603 SystemErr R at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:181)
[5/5/05 17:26:30:250 MDT] 6b6bd603 SystemErr R at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:100)
[5/5/05 17:26:30:250 MDT] 6b6bd603 SystemErr R at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
[5/5/05 17:26:30:250 MDT] 6b6bd603 SystemErr R at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
my xml document looks like the following
<?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="Server">
<select id="getServer"
resultClass="gov.utah.dhs.dsamh.bs.beans.ServerBean"
parameterClass="int">
SELECT *
id as id,
first_name as firstName,
middle_name as middleName,
last_name as lastName,
ssn_four as ssn,
SYSTEM_USER_ID as systemUser,
FROM dba.tbl_server
WHERE id = #value#
</select>
<insert id="insertServer"
parameterClass="gov.utah.dhs.dsamh.bs.beans.ServerBean">
INSERT INTO
server (id, first_name, middle_name,
last_name, ssn_four, system_user_id)
VALUES (#id#, #firstName#, #middleName#, #lastName#,
#ssn#, #systemUser#, )
</insert>
<update id="updateServer"
parameterClass="gov.utah.dhs.dsamh.bs.beans.ServerBean">
UPDATE server
SET first_name = #firstName#,
middle_name = #middleName#,
last_name = #lastName#,
ssn_four = #ssn#,
WHERE id = #id#
</update>
<delete id="deleteServer"
parameterClass="gov.utah.dhs.dsamh.bs.beans.ServerBean">
DELETE server
WHERE id = #id#
</delete>
</sqlMap>
and where I read the objects from the database looks like the
following
private ServerBean setParameters()
{
// SqlMapClient sqlMap =
BSSqlMapConfig.getSqlMapInstance();
Integer id=new Integer(1);
ServerBean sb = null;
try {
sb = (ServerBean)
sqlMap.queryForObject("getServer", id);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return sb;
/* sb.server1 =
(Server)sqlMap.queryForObject("getServer",id);
return sb;
ServerBean sb = new ServerBean();
sb.setCreateDate("2005-01-01");
sb.setSystemUser("dsgallow");
sb.setFirstName("John");
sb.setLastName("Lennon");
sb.setMiddleName("L");
sb.setSsn("1234");
return sb;
*/
}
}
Dwight S. Galloway
(801) 538-4234
[EMAIL PROTECTED]
Office of Technology
Department of Human Services
MAKE IT A GREAT DAY!
