Hi all,
When I am trying to execute a stored procedure in Sybase Database, it is
failing, if the entry is not present in the DB table. If the entry is
present, it works fine. We have the same code in the Weblogic and is working
fine. But seems like in tomcat, some more configuration needs to be made.
I have provided the code details.
Java Code
========
Map<String, String> parmMap = new HashMap<String, String>();
parmMap.put("configParmName", configParmName);
try
{
startTxn(sqlMap); // Just a wrapper for startTransaction
sqlMap.flushDataCache();
List resultList = sqlMap.queryForList("getConfigParmData",
parmMap);
String status = (String) parmMap.get("statusString");
if (status.indexOf("Error:") > 0)
if (status.indexOf("Return code 906") <= 0)
throw new SQLException(status);
commitTxn(sqlMap); // Just a wrapper for commitTransaction
return resultList;
} catch (SQLException sqlE) {
throw wrapSqlException(sqlE);
} finally {
endTxn(sqlMap); // Just a wrapper for endTransaction
}
Stored Proc (Sybase)
=========
CREATE PROCEDURE get_ConfigParm
@config_parm_name udt_short_name,
@statusString varchar( 1024 ) = NULL
OUTPUT
AS
DECLARE
@error int,
@rowcount int,
@statusInfo varchar( 1024 ),
@ret_code int,
@create_date udt_datetime,
@valid char(1),
@procname varchar(35),
@error_code varchar(5),
@num_rows varchar(5)
SELECT @procname = OBJECT_NAME( @@procid )
SELECT
@statusInfo = ISNULL( @@servername, 'UNKNOWN' ) + '.'
+ DB_NAME() + '.' + @procname
,
@statusString = ' Successful'
SELECT
config_parm_name,
parm_datatype,
config_parm_desc,
create_date,
create_user_id,
modify_date,
modify_user_id
FROM
ConfigParm
WHERE
config_parm_name = @config_parm_name
-- Status check
SELECT
@error = @@error,
@rowcount = @@rowcount
-- Check for error
If( @error != 0 )
BEGIN
select @ret_code = 904,
@error_code = CONVERT( varchar(5), @error )
SELECT @statusString = @statusInfo + ' Error: ['
+ convert( varchar(5), @error ) + '] selecting config_parm_name [' +
+ @config_parm_name + '] from ConfigParm table- Return code '
+ CONVERT( varchar(5), @ret_code)
RAISERROR 25012, 'GET', 'ConfigParm' , @error_code
RETURN 904
END
-- Check for no rows
IF( @rowcount = 0 )
BEGIN
select @ret_code = 906
SELECT @statusString = @statusInfo + ' Error: config_parm_name [' +
+ @config_parm_name + '] does not exist in ConfigParm table- Return
code '
+ CONVERT( varchar(5), @ret_code)
RAISERROR 25014, "config_parm_name",
@config_parm_name,"ConfigParm",'GET'
RETURN 906
END
-- Check for multiple rows
IF( @rowcount > 1 )
BEGIN
SELECT @statusString = @statusInfo + ' Warning: Select affected ['
+ convert( varchar(5), @rowcount ) + '] ConfigParms'
END
RETURN 0
XML Data
=======
<parameterMap id="getConfigParmDataMap" class="map" >
<parameter property="returnCd"
jdbcType="INTEGER" javaType="java.lang.Integer" mode="OUT"/>
<parameter property="configParmName"
jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="statusString"
jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
</parameterMap>
<procedure id="getConfigParmData"
parameterMap="getConfigParmDataMap"
resultClass="java.util.HashMap"
cacheModel="siteConfigCache" >
{? = call get_ConfigParm(?, ?) }
</procedure>
Error
====
Caused by: com.sybase.jdbc3.jdbc.SybSQLException: ** config_parm_name
DEV_WRPSYSCONFIG_1 does not exist in ConfigParm table- GET operation can not
be completed ***
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
Can anyone, let me know how to fix this issue??
Regards
Prabhu
--
View this message in context:
http://www.nabble.com/Ibatis-queryForList-in-Sybase-Database-tp18123663p18123663.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
