|
Mantis - Resin
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 1028 | block | always | 03-30-06 12:33 | 03-01-06 10:03 | |
|
|
|||||
| Reporter: | peden | Platform: | |||
| Assigned To: | ferg | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | closed | Product Version: | 3.0.18 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 3.0.19 | ||
|
|
|||||
| 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 |
||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||