Thank you Eric, but I didn't manage to make it work :
I removed "hsqldb-service.xml" from default/deploy directory to
be sure to use my oracle db.
I added following snippet to the conf/login-config.xml :
<application-policy name = "OracleDbRealm">
<authentication>
<login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule" flag =
"required">
<module-option name = "principal">viewcomdba</module-option>
<module-option name = "userName">viewcomdba</module-option>
<module-option name = "password">viewcomdba</module-option>
<module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=OracleDS</mo
dule-option>
</login-module>
</authentication>
</application-policy>
My oracle-service.xml :
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean
code="org.jboss.resource.connectionmanager.LocalTxConnectionManager"
name="jboss.jca:service=LocalTxCM,name=OracleDS">
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
<mbean code="org.jboss.resource.connectionmanager.RARDeployment"
name="jboss.jca:service=LocalTxDS,name=OracleDS">
<attribute name="JndiName">OracleDS</attribute>
<attribute name="ManagedConnectionFactoryProperties">
<properties>
<config-property name="ConnectionURL"
type="java.lang.String">jdbc:oracle:thin:@orion:1521:viewcom</config-propert
y>
<config-property name="DriverClass"
type="java.lang.String">oracle.jdbc.driver.OracleDriver</config-property>
<!--set these only if you want only default logins, not through
JAAS -->
<config-property name="UserName"
type="java.lang.String">viewcomdba</config-property>
<config-property name="Password"
type="java.lang.String">viewcomdba</config-property>
</properties>
</attribute>
<depends
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,n
ame=JBoss LocalTransaction JDBC Wrapper</depends>
</mbean>
</depends>
<depends optional-attribute-name="ManagedConnectionPool">
<mbean
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
name="jboss.jca:service=LocalTxPool,name=OracleDS">
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">50</attribute>
<attribute name="BlockingTimeoutMillis">5000</attribute>
<attribute name="IdleTimeoutMinutes">15</attribute>
<attribute name="Criteria">ByContainer</attribute>
</mbean>
</depends>
<depends
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedCo
nnectionManager</depends>
<depends
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=
JaasSecurityManager</depends>
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
<!--make the rar deploy! hack till better deployment-->
<depends>jboss.jca:service=RARDeployer</depends>
</mbean>
</server>
Now, when I start Jboss, I get following error message :
.....
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error: can't find
data source: java:/DefaultDS; - nested throwable:
(javax.naming.NameNotFoundException: DefaultDS not bound), ObjectName: jbo
ss.j2ee:service=EJB,jndiName=com.viewcom.model.telco.Region
state: FAILED
I Depend On:
Depends On Me: org.jboss.deployment.DeploymentException: Error: can't find
data source: java:/DefaultDS; - nested throwable:
(javax.naming.NameNotFoundException: DefaultDS not bound), ObjectName: jbo
ss.j2ee:service=EJB,jndiName=com.viewcom.model.telco.Site
state: FAILED
I Depend On:
.....
Any idea ?
TIA,
Sebastien
----- Original Message -----
From: "Eric Kaplan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 2:56 PM
Subject: RE: [JBoss-user] Default database
> I think that as long as you declare a name for your new oracle pool and
> modify jboss.xml
> to have the resource ref "foo" which was pointing at the hypersonic pool
to
> point at
> this new oracle pool you'll be set.
>
> Eric
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Sebastien
> CHAUSSON
> Sent: Monday, August 19, 2002 8:36 AM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] Default database
>
>
> Hi,
>
> I'm really newbie with jboss, and for the moment, I only
> used default database Hypersonic during developpement.
>
> Now, I'd like to replace this datasource by an oracle
> instance, and I don't know how to tell jboss to use
> oracle instead of hypersonic (I already wrote an
> oracle-service.xml file and put it in default/deploy directory) ?
>
> TIA,
>
> Sebastien CHAUSSON
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone? Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone? Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
