At 01:13 23/04/2002 -0400, you wrote:
>Yes, I am using postgres, and I am probably not using the most recent
>postgresql.jar.  If you do get a chance, I would appreciate the .jar.  I
>assume I'd need to use CVS to grab the version you're using from postgres
>mirrors?

Have sent this offlist...

>Also, what changes do I need to make to db.props to include the BYTEA
>support?  I've just changed the VARBINARY line to say "VARBINARY = bytea".
>Is that sufficient?

Theres some good stuff about this in the archive, Michael ;-). Here is a 
db.props for postgres from:
http://www.mail-archive.com/[email protected]/msg06357.html

---------------------------------------------------------------
# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to PostgreSQL mappings.

BIT =
TINYINT = int2
SMALLINT = int2
INTEGER = integer
BIGINT = int8
FLOAT = float
REAL = float
BOOLEANCHAR = boolean

DOUBLE =
NUMERIC =
DECIMAL =
CHAR = varchar
VARCHAR = varchar
LONGVARCHAR = bytea
DATE = date
TIME = time
TIMESTAMP = timestamp
BINARY = bytea
VARBINARY = bytea
LONGVARBINARY = bytea
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB =
CLOB = text
REF =
---------------------------------------------------------------

Good luck and let us know how you get on...

c


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to