Hi all,
I've been trying to set up a postgreSQL service and have had no luck so
far. I have downloaded the postgres-service.xml file from CVS and
applied it to RC1. The postgres driver's jar is in jboss/lib and I have
made the necessary changes to the xml file to match my setting. It seems
like the datasource name never gets bound to JNDI. Below is the output
from the service's startup:
07:53:15,087 INFO [MainDeployer] Starting deployment of package:
file:/home/javier/dev/jboss-3.0RC1/server/default/deploy/postgres-service.xml
07:53:15,873 WARN [ServiceController]
jboss.jca:service=LocalTxDS,name=PostgresDS does not implement any
Service methods
07:53:15,875 INFO [JBossManagedConnectionPool] Creating
07:53:15,876 INFO [JBossManagedConnectionPool] Created
07:53:15,879 INFO [JBossManagedConnectionPool] Starting
07:53:15,880 INFO [JBossManagedConnectionPool] Started
07:53:15,881 INFO [MainDeployer] Successfully completed deployment of
package:
file:/home/javier/dev/jboss-3.0RC1/server/default/deploy/postgres-service.xml
I have also added a section to login-config.xml to match what is in the
service.xml file as described in the comments. I have attached my
postgres-service.xml file below. Any help is appreciated.
thanks,
-javier
<?xml version="1.0" encoding="UTF-8"?>
<!--
========================================================================================
-->
<!-- New ConnectionManager setup for default PostgreSQL dbs
-->
<!-- Build jmx-api (build/build.sh all) and view for config
documentation -->
<!-- To avoid class not found headaches, copy your postgres driver to
the jboss lib directory -->
<!--
========================================================================================
-->
<server>
<mbean
code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
name="jboss.jca:service=LocalTxCM,name=PostgresDS">
<!-- ======================================================= -->
<!-- You must include a login module configuration named
PostgresDbRealm
in your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "PostgresDbRealm">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag =
"required">
<module-option name =
"principal">yourprincipal</module-option>
<module-option name = "userName">yourusername</module-option>
<module-option name = "password">yourpassword</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=PostgresDS</module-option>
</login-module>
</authentication>
</application-policy>
NOTE: the application-policy name attribute must match
SecurityDomainJndiName, and the
module-option name = "managedConnectionFactoryName"
must match the object name of the ConnectionManager you are
configuring here.
-->
<!--
===================================================================== -->
<!--comment out this line if you want component managed security or
want
to use the default values in the ManagedConnectionFactoryProperties
<attribute name="SecurityDomainJndiName">PostgresDbRealm</attribute>
-->
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=PostgresDS">
<!-- ========== Set the JndiName ======================= -->
<attribute name="JndiName">PostgresDS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:postgresql://localhost:1522/spider</config-property>
<config-property name="DriverClass"
type="java.lang.String">org.postgresql.Driver</config-property>
<!--set these only if you want only default logins, not
through JAAS -->
<config-property name="UserName"
type="java.lang.String">javier</config-property>
<config-property name="Password"
type="java.lang.String"></config-property>
</properties>
</attribute>
<!--Below here are advanced properties -->
<!--hack-->
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss
LocalTransaction JDBC Wrapper</depends>
<!--real attributes-->
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=LocalTxPool,name=PostgresDS">
<attribute name="MinSize">10</attribute>
<attribute name="MaxSize">30</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<!--criteria indicates if Subject (from security domain) or app
supplied
parameters (such as from getConnection(user, pw)) are used
to distinguish
connections in the pool. Choices are
ByContainerAndApplication (use both),
ByContainer (use Subject),
ByApplication (use app supplied params only),
ByNothing (all connections are equivalent, usually if
adapter supports
reauthentication)-->
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
<!--
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager</depends>
-->
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
