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

David Jencks Thu, 02 Aug 2001 23:12:21 -0700
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</attribute>
>     <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</attribute>
>     <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>&nbsp;&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;&nbsp;&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>&nbsp;&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
Re: [JBoss-user] jboss.jcml db entries

Reply via email to
