Welcome Sebastian.
You can specify it in this way..
<defaults>
<datasource>java:/OracleDS</datasource>
<datasource-mapping>Oracle8</datasource-mapping>
<create-table>true</create-table>
<remove-table>true</remove-table>
</defaults>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Sebastien
CHAUSSON
Sent: Tuesday, August 20, 2002 12:05 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Default database
Thank you Saroj, It seems to be OK, although it doesn't create
tables during deployment :-(
----- Original Message -----
From: "Saroj Kumar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 6:23 PM
Subject: RE: [JBoss-user] Default database
>
> Hi Sebastian,
>
> No Need to remove "hsqldb-service.xml" from default/deploy directory.
>
> Just add oracle service xml in deploy directory and add following to
> your
>
> <defaults>
>
> <datasource>java:/OracleDS</datasource>
> <datasource-mapping>Oracle8</datasource-mapping>
>
> </defaults>
>
> To jbosscmp-jdbc.xml at top before <enterprise-beans> tag.
>
> This should work.
> Saroj
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of Sebastien
> CHAUSSON
> Sent: Monday, August 19, 2002 8:42 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] Default database
>
>
> 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-pro
> pert
> 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=RARDeployme
> nt,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=Cach
> edCo
> nnectionManager</depends>
>
> <depends
>
optional-attribute-name="JaasSecurityManagerService">jboss.security:serv
> ice=
> 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
>
>
>
> -------------------------------------------------------
> 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
