Mantis Bugtracker
  

Viewing Issue Simple Details Jump to Notes ] View Advanced ] 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  
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-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