Re: DB2 OpenJMS: Peristence exception

Here's the exact error..
==================
18:20:58.037 ERROR [server-9] - Failed to make message persistent
org.exolab.jms.persistence.PersistenceException:
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -301, SQLSTATE: 07006, SQLERRMC: 7

Error details from DB2:
db2 => ? sql-301
SQL0301N The value of input host variable or parameter number
          "<number>" cannot be used because of its data type.

Explanation:
A host variable or parameter in position "<number>" could not be
used as specified in the statement because its data type is incompatible with the intended use of its value. This error can occur as a result of specifying an incorrect host variable or an incorrect SQLTYPE value in a SQLDA on an EXECUTE or OPEN statement.  In the case of a user-defined structured type, the associated built-in type of the host variable or SQLTYPE
might not be compatible with the parameter of the TO SQL transform function defined in the transform group for the statement. In the case of performing an implicit or explicit cast
between character and graphic data types, this error indicates that such a cast was attempted with a non-Unicode character or graphic string. The statement cannot be processed.
==========================================================

Regards,
Hemant


On Sat, 31 Mar 2007 Hemant Gaur wrote :
>I am using ActiveMQ-JMETER for the OpenJMS/DB2 performance. I have done the test with many other databases but for the DB2 (latest version 9), i can see lot of persistence exceptions reported at the start time. The message throughput is high and comparable with other DB's but unlike them this exception apprears in the logs (rite at the start).
>
>Dont have the setup ready now but error is some thing like
>org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -301(?), SQLSTATE: ?, SQLERRMC: DB2USER.SYSTEM_DATA
>AND
>org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2USER.SYSTEM_DATA
>
>The first SQL error I looked into DB2 meant that the table column data type is not consistent with the value being inserted. (though many messages are pub/sub). I have created the data base using the DB tool.
>What is the side effect of these persistence errors? Are the messages lost ?
>Anything we need to do specially fro DB2?
>
>Thanks,
>Hemant
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys-and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>openjms-user mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/openjms-user

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
openjms-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openjms-user