Re: [JBoss-user] jboss.jcml db entries

G.L. Grobe Thu, 02 Aug 2001 22:16:15 -0700
yeah, my lookup() is of java:comp/env/jdbc/PostgresqlDB and my entities are
bmp. i also do some queries in session beans w/ the same lookup.

don't know what jndiview is, but i'll give the docs a search.

thnxs

----- Original Message -----
From: "David Jencks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 11:18 PM
Subject: Re: [JBoss-user] jboss.jcml db entries


> I recommend removing those parts of jboss.jcml you aren't using- otherwise
> things will work by accident, as you are experiencing.  I think your
> XADatasourceLoader setup is ok, since it is the same as DefaultDS which is
> apparently working.  Check jndiview to be sure it's there.  Therefore your
> problems come from configuring the jndi name you use in your ejb's or
> config files to map to your datasource. Not sure how to help here, sorry.
>
> Are you looking up java:PostgressqlDS? cmp or bmp?
>
> david jencks
>
> On 2001.08.02 21:17:24 -0400 G.L. Grobe wrote:
> > Should I be able to (or should I) delete the DefaultDS from jboss.jcml
> > and leave my PostgresqlDB mbean in jboss.jcml.
> >
> > If I do delete DefaultDS, my access to postgresql will no longer work
> > even though I've got an entry strictly for Postgresql (which tells me
> > I've got something wrong in the config).
> >
> > Any suggestions, ideas?
> >
> > ------------------- JDBC section of jboss.jcml --------------------
> >
> >  <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=DefaultDS">
> >     <attribute name="PoolName">DefaultDS</attribute>
> >     <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
> >     <attribute name="Properties"></attribute>
> >     <attribute
name="URL">jdbc:postgresql:acais:@localhost:5432</attribute>
> >     <attribute name="GCMinIdleTime">1200000</attribute>
> >     <attribute name="JDBCUser">xxx</attribute>
> >     <attribute name="MaxSize">10</attribute>
> >     <attribute name="Password">xxx</attribute>
> >     <attribute name="GCEnabled">false</attribute>
> >     <attribute name="InvalidateOnError">false</attribute>
> >     <attribute name="TimestampUsed">false</attribute>
> >     <attribute name="Blocking">true</attribute>
> >     <attribute name="GCInterval">120000</attribute>
> >     <attribute name="IdleTimeout">1800000</attribute>
> >     <attribute name="IdleTimeoutEnabled">false</attribute>
> >     <attribute name="LoggingEnabled">false</attribute>
> >     <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> >     <attribute name="MinSize">0</attribute>
> >   </mbean>
> >
> >   <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > name="DefaultDomain:service=XADataSource,name=PostgresqlDB">
> >     <attribute name="PoolName">PostgresqlDB</attribute>
> >     <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
ibute>
> >     <attribute name="Properties"></attribute>
> >     <attribute
name="URL">jdbc:postgresql:acais:@localhost:5432</attribute>
> >     <attribute name="GCMinIdleTime">1200000</attribute>
> >     <attribute name="JDBCUser">xxx</attribute>
> >     <attribute name="MaxSize">10</attribute>
> >     <attribute name="Password">xxx</attribute>
> >     <attribute name="GCEnabled">false</attribute>
> >     <attribute name="InvalidateOnError">false</attribute>
> >     <attribute name="TimestampUsed">false</attribute>
> >     <attribute name="Blocking">true</attribute>
> >     <attribute name="GCInterval">120000</attribute>
> >     <attribute name="IdleTimeout">1800000</attribute>
> >     <attribute name="IdleTimeoutEnabled">false</attribute>
> >     <attribute name="LoggingEnabled">false</attribute>
> >     <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> >     <attribute name="MinSize">0</attribute>
> >   </mbean>
> >
> >
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> > <META content="MSHTML 5.50.4616.200" name=GENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=#ffffff>
> > <DIV><FONT face=Arial size=2>Should I be able to&nbsp;(or should
> > I)&nbsp;delete
> > the DefaultDS from jboss.jcml and leave my PostgresqlDB mbean in
> > jboss.jcml.</FONT></DIV>
> > <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>If I do delete DefaultDS, my access to
> > postgresql
> > will no longer work even though I've got an entry strictly for
Postgresql
> > (which
> > tells me I've got something wrong in the config). </FONT></DIV>
> > <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>Any suggestions, ideas?</FONT></DIV>
> > <DIV><FONT face=Arial size=2></FONT><FONT face=Arial
> > size=2></FONT>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>------------------- JDBC section of
> > jboss.jcml
> > --------------------</FONT></DIV>
> > <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>&nbsp;&lt;mbean
> > code="org.jboss.jdbc.JdbcProvider"
> >
name="DefaultDomain:service=JdbcProvider"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="Drivers"&gt;org.postgresql.Driver&lt;/attribute&gt;<BR>&nbsp;
> > &lt;/mbean&gt;</FONT></DIV>
> > <DIV>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>&nbsp; &lt;mbean
> > code="org.jboss.jdbc.XADataSourceLoader"
> >
name="DefaultDomain:service=XADataSource,name=DefaultDS"&gt;<BR>&nbsp;&nbsp;
&nbsp;
> >
> > &lt;attribute
> > name="PoolName"&gt;DefaultDS&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="DataSourceClass"&gt;org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl&lt
;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="Properties"&gt;&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> >
name="URL"&gt;jdbc:postgresql:acais:@localhost:5432&lt;/attribute&gt;<BR>&nb
sp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="GCMinIdleTime"&gt;1200000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
name="JDBCUser"&gt;xxx&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="MaxSize"&gt;10&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="Password"&gt;xxx&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="GCEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> >
name="InvalidateOnError"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="TimestampUsed"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
name="Blocking"&gt;true&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="GCInterval"&gt;120000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> > name="IdleTimeout"&gt;1800000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="IdleTimeoutEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="LoggingEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="MaxIdleTimeoutPercent"&gt;1.0&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute name="MinSize"&gt;0&lt;/attribute&gt;<BR>&nbsp;
> > &lt;/mbean&gt;<BR><BR>&nbsp; &lt;mbean
> > code="org.jboss.jdbc.XADataSourceLoader"
> >
name="DefaultDomain:service=XADataSource,name=PostgresqlDB"&gt;<BR>&nbsp;&nb
sp;&nbsp;
> >
> > &lt;attribute
> > name="PoolName"&gt;PostgresqlDB&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="DataSourceClass"&gt;org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl&lt
;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="Properties"&gt;&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> >
name="URL"&gt;jdbc:postgresql:acais:@localhost:5432&lt;/attribute&gt;<BR>&nb
sp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="GCMinIdleTime"&gt;1200000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
name="JDBCUser"&gt;xxx&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="MaxSize"&gt;10&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="Password"&gt;xxx&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
name="GCEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> >
name="InvalidateOnError"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="TimestampUsed"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
name="Blocking"&gt;true&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="GCInterval"&gt;120000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> > name="IdleTimeout"&gt;1800000&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="IdleTimeoutEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute
> > name="LoggingEnabled"&gt;false&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> > &lt;attribute
> >
name="MaxIdleTimeoutPercent"&gt;1.0&lt;/attribute&gt;<BR>&nbsp;&nbsp;&nbsp;
> >
> > &lt;attribute name="MinSize"&gt;0&lt;/attribute&gt;<BR>&nbsp;
> > &lt;/mbean&gt;<BR></FONT></DIV></BODY></HTML>
> >
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] jboss.jcml db entries

Reply via email to
