Do lnow why I used the word type.
On the download page it just say jdbc3 jdk1.4
I used the postgresql type bytea for the message_body column.
<sql name="createTable" db="postgresql">
CREATE TABLE ${table} (
message_name varchar (200) NOT NULL,
repository_name varchar (255) NOT NULL,
message_state varchar (30) NOT NULL ,
error_message varchar (200) NULL ,
sender varchar (255) NULL ,
recipients text NOT NULL ,
remote_host varchar (255) NOT NULL ,
remote_addr varchar (20) NOT NULL ,
message_body bytea NOT NULL ,
last_updated timestamp NOT NULL,
PRIMARY KEY (message_name, repository_name)
)
</sql>
and the length function.
<sql name="retrieveMessageBodySizeSQL" db="postgresql">SELECT length(message_body) FROM ${table} WHERE message_name = ? AND repository_name = ?</sql>
What is the best method of getting these changes into csv?
I think the bytea type has only been around for the last couple of major release.
I store nulls as \000 and \ as \\ etc.. in the database.
Thanks.
Regards,
Simon
Noel J. Bergman wrote:
Simon,
I am using the current stable jdbc driver for jdk1.4 type 3 with james
and all is ok.
pg73jdbc3.jar from http://jdbc.postgresql.org/download.htmlThank you for your report. :-)
Do you mean a type 4 driver for JDBC v3? I would not expect a type 3
driver.
What changes, if any, did you have to make from the stock sqlResources.xml
as distributed by the project?
--- Noel
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
