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

Reply via email to