Yes, those are the only two I changed, actually just "DefaultDS". I just tried java:/DefaultDS, but that gave me problems (tried to map java:java:/DefaultDS) I'm still grepping around for something I may have missed.
> -----Original Message----- > From: Dan Christopherson [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 12:27 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] Postgres users > > > You did change the postgres config so that it's JNDI name is > java:/DefaultDS, right? > > LaBanca, Rick wrote: > > 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: Battle your brains against the best in the Thawte Crypto Challenge. Be the first to crack the code - register now: http://www.gothawte.com/rd521.html _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
