Mantis Bugtracker
  

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0001028 [Resin] block always 03-30-06 12:33 03-31-06 10:03
Reporter peden View Status public  
Assigned To ferg
Priority normal Resolution fixed Platform
Status closed   OS
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-31-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-31-06 10:03 ferg Note Added: 0000984
03-31-06 10:03 ferg Assigned To  => ferg
03-31-06 10:03 ferg Status new => closed
03-31-06 10:03 ferg Resolution open => fixed
03-31-06 10:03 ferg Fixed in Version  => 3.0.19


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
31 total queries executed.
27 unique queries executed.
Powered by Mantis Bugtracker