On Wednesday, November 20, 2002, at 07:28 AM, LaBanca, Rick wrote:
Are you by any chance mixing up the JDBC type mappings with the SQL type mappings?
Jboss 3.0.4, fooling with the cmp flavor of jetty session persistence. I get
this upon initializing:
Unable to locate type name 'varbinary' in catalog
I checked the mappings in the jboss cmp config, looks correct. It looks like
Objects are mapped to BYTEA for statements, and VARBINARY for prepared
statements, if I understand the cmp docs. I'm thinking the jdbc driver just
isn't translating varbinary into something postgres can accept (bytea I
would think).
Anyone get this working?
VARBINARY is a JDBC type, and BYTEA is an SQL type. JBoss needs the SQL type so
that it can create the table. After that is uses the JDBC type as far as I know.
The message suggests that you're trying to use VARBINARY as an SQL type.
Coincidentally, VARBINARY is an hsqldb SQL type. Maybe you're somehow using a postgres
datasource with hsqldb mappings (which are the default)?
Steve
-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
