0001028: JMS Text message example does not work with PostgreSQL Database Server 8.1.2

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001028

[Resin]

block

always

03-30-06 12:33

03-01-06 10:03

Reporter

peden

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Status

closed

Product Version

3.0.18

Summary

0001028: JMS Text message example does not work with PostgreSQL Database Server 8.1.2

Description

The text jms message example fails with the follwing error message when used with a Postgres 8.1.2 data source:

com.caucho.services.message.MessageServiceException: com.caucho.jms.JMSExceptionWrapper:
ERROR: column "header" is of type bytea but expression is of type character
varying
    at com.caucho.jms.resource.MessageSenderResource.send(MessageSenderResource.java:149)
    at example.MessageServlet.service(MessageServlet.java:46)
    at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
    at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
    at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
    at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
    at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
    at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
    at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
    at java.lang.Thread.run(Thread.java:595)

The failure is apparently caused by the following line (line 0000275 in the resin 3.0.18 source) in the file JdbcMessage (in the package com.caucho.jms.jdbc)"

        pstmt.setNull(i++, Types.VARCHAR);

The intent of this line is to set the header parameter to null. Unfortunately, the actual data type of a these small "blobs" in Postgres is Types.BINARY.

This type was determined by the call to JdbcManager.getBlob() when the table is created in the init() method.

Perhaps there should be a method in the JdbcManager to get the Types.XXXX constant of the blob type...

Additional Information

OS: Windows XP Service Pack 2
Database: PostgreSQL Database Server 8.1.2

Attached Files

Relationships

Notes
(0000984) ferg 03-01-06 10:03	ejb/679b

Issue History
Date Modified	Username	Field	Change
03-30-06 12:33	peden	New Issue
03-30-06 13:02	peden	Issue Monitored: peden
03-01-06 10:03	ferg	Note Added: 0000984
03-01-06 10:03	ferg	Assigned To	=> ferg
03-01-06 10:03	ferg	Status	new => closed
03-01-06 10:03	ferg	Resolution	open => fixed
03-01-06 10:03	ferg	Fixed in Version	=> 3.0.19

Mantis 1.0.0rc3[^]

31 total queries executed.
27 unique queries executed.