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

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ 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

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.0.19

Product Version

3.0.18

Product Build

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...

Steps To Reproduce

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.