I had changed my standardjbosscmp-jdbc.xml to:
<defaults>
<datasource>java:/DefaultDS</datasource>
<datasource-mapping>PostgreSQL 7.2</datasource-mapping>
...
Is that the file you meant? I don't see one named exactly
jbosscmp-jdbc.xml...
> -----Original Message-----
> From: Stephen Coy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 19, 2002 11:42 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Postgres users
>
>
> The jetty jbosscmp-jdbc.xml file contains the following:
>
> <defaults>
> <datasource>java:/DefaultDS</datasource>
> <datasource-mapping>Hypersonic SQL</datasource-mapping>
> </defaults>
>
> which I believe is a wart.
>
> So if you have set your DefaultDS to be postgres, then jetty is still
> trying to use
> hsqldb mappings with it.
>
> Steve
>
> On Wednesday, November 20, 2002, at 02:31 PM, Rick LaBanca wrote:
>
> > I thought along the same lines as you. I'm not doing
> anything myself,
> > whatever the jetty cmp is doing triggers this, and the site isn't
> > running
> > yet, this is initialization. I am pretty sure it's using
> the postgres
> > map,
> > but it sure seems likely that I have something wrong in
> this area if it
> > works for others. All I changed was the jboss-servicecmp
> (or whatever
> > it is
> > in conf, not at work to look right now) to point to postgres at the
> > top, and
> > put in my postgres.xml (and remove hsqldb).
> > Postgres actually isn't necessary, I may just punt and try
> to figure
> > out how
> > to get an hsqldb running and just go with the flow!
> >
> >> Are you by any chance mixing up the JDBC type mappings with the SQL
> >> type mappings?
> >> 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)?
> >>
>
>
>
> -------------------------------------------------------
> 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
>
-------------------------------------------------------
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
