Keep in mind that "DefaultDS" can be mapped to any back-end you like.
For example, we map it to PostgreSQL in the "jboss.jcml" file and use this
with MVCSoft, and we do not even configure Hypersonic or InstantDB:
<mbean
code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.postgresql.Driver</attribute>
</mbean>
<mbean
code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=PostgresDB">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="PoolName">DefaultDS</attribute>
<attribute name="URL">jdbc:postgresql://127.0.0.1/dbname</attribute>
<attribute name="JDBCUser">username</attribute>
<attribute name="Password">password</attribute>
</mbean>
<mbean
code="com.mvcsoft.persistence.jboss.spi.PersistenceSPIService"
name=":service=PersistenceSPI" />
Jim Archer, who answered your question originally and whose post you
quoted below, is obviously far more knowledgeable about MVCSoft than I am,
but the above excerpts from my working "jboss.jcml" file should give you a
clear idea of how easy it is to point MVCSoft at any arbitrary back-end.
-- Mike
On 2001-06-22 at 10:21 -0600, Da-Ming Duan wrote:
> Thanks Jim. It realy helps. I think there should be someway to specify
> different datasources with MVC PM, otherwise it is useless for any
> enterprise application that has its own database.
>
> Da-Ming
>
> Message: 9
>
> > Date: Thu, 21 Jun 2001 20:22:46 -0400
> > From: Jim Archer <[EMAIL PROTECTED]>
> > To: Da-Ming Duan <[EMAIL PROTECTED]>
> > cc: [EMAIL PROTECTED]
> > Subject: [JBoss-user] Re: MVCSoft Persistence Manager and JBoss
> > Reply-To: [EMAIL PROTECTED]
> >
> > Hello...
> >
> > Let me take a shot at these...
> >
> > --On Thursday, June 21, 2001 4:43 PM -0600 Da-Ming Duan
> > <[EMAIL PROTECTED]> wrote:
> >
> > > How and where to specify a datasource in a EJB2.0 jar with MVCSoft
> > > Persistence Manager? Can I incude jaws.xml in an EJB2.0 jar to specify a
> > > datasource with <jaws><datasource>MyOracleDBPool</datasource></jwas>?
> >
> > The code generated by the MVC PM uses DefaultDS. I'm noit sure if this can
> > be easily changed, as I have never tried. You won;t need Jaws with the MVC
> > PM, as it generates BMP code for you.
> >
> > > 2. There are 4 elements for MVCSoft Code Generator: EJB2.0 input jar,
> > > EJB1.1 output jar, a temperory directory and the file with the DDL
> > > output for the tables. What is this file and what are these tables?
> > > Where to put this file when archiving the beans?
> >
> > The "DDL" file is actually just a bunch of SQL create statements you can
> > use to create your tables in your database. You don't put this file
> > anywhere. Since your now using BMP, jBoss won;t create the tables for you,
> > so you'll have to use this file to do that yourself.
> >
> > Using a mapping.xml file, you can control the names and schemas of each
> > table you'll need.
> >
> > > 3. Can jboss.xml still be put in the directory META-INF for an EJB2.0
> > > jar?
> >
> > Yes, and depending upon what your doing you may still need it.
> >
> > > 4. Are mapping.xml and default_mapping.xml used to replace JBoss'
> > > jaws.xml and standardjaws.xml? If yeas, the mapping.xml-->jaws.mxl is OK
> >
> > No, not at all. These files tell the code generator what table an field
> > names and field types and sizes to use for the database tables. Nothing
> > more.
> >
> > > By the way, is there any user email list for MVCSoft Persistence
> > > Manager?
> >
> > Yes, they have a mail list on Yahoo Groups called ejb20-persistence. Its a
> > very low volume and helpfull list.
> >
> > Good luck!
> >
> > Jim
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
