Thank you Saroj and Dain Sundstrom for his contribution under "Re: [JBossCMP] CMP 2.x 1-to-n in JBoss 2.x alpha" . Following the search in the archives I understand the use of the jbosscmp-jdbc file. Previously, I had changed the jndi-name in postgres-service.xml to 'DefaultDS'. My application is now using postgreSQL 7.2 for persistance and I am not getting any column type errors like mapping to colomn type 'object' in place of 'BYTEA'.
my jbosscmp-jdbc now reads as follows. <jbosscmp-jdbc> <defaults> <datasource>java:/PostgresDS</datasource> <datasource-mapping>PostgreSQL 7.2</datasource-mapping> <create-table>true</create-table> <remove-table>false</remove-table> <read-only>false</read-only> <time-out>300</time-out> <pk-constraint>true</pk-constraint> <fk-constraint>false</fk-constraint> <row-locking>false</row-locking> <preferred-relation-mapping>foreign-key</preferred-relation-mapping> <read-ahead> <strategy>on-load</strategy> <page-size>1000</page-size> <eager-load-group>*</eager-load-group> </read-ahead> <list-cache-max>1000</list-cache-max> </defaults> </jbosscmp-jdbc> Allan Kamau. --- Saroj Kumar <[EMAIL PROTECTED]> wrote: > In <jbosscmp-jdbc> file , > > Do it like (For ORACLE): > > <datasource>java:/OracleDS</datasource> > > <datasource-mapping>Oracle8</datasource-mapping> > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On > Behalf Of Allan Kamau > Sent: Monday, August 12, 2002 1:11 PM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] JBoss 3.0.x and PostgresDS > > > I have successfully configured and deployed the > PostgresDS on JBoss-3.0.0 now I seem to be stuck in > getting JBoss use PostgresDS as CMP of my EJBs in > place of the DefaultDS. > What additional configurations are required (is > jboss.xml used in JBoss-3.0.x for the same?) > > Allan. > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com ------------------------------------------------------- This sf.net email is sponsored by: Dice - The leading online job board for high-tech professionals. Search and apply for tech jobs today! http://seeker.dice.com/seeker.epl?rel_code=31 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user