I have never tried the second option. No Idea..
-Saroj -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sebastien CHAUSSON Sent: Tuesday, August 20, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Default database Thanks again, But...What's the difference between : 1- Adding those 2 lines in the 'defaults' section of 'jbosscmp-jdbc.xml' 2- Adding the 2 same lines for each 'entity' of 'enterprise-beans' section I thought it should work in the same way, no ? Sebastien ----- Original Message ----- From: "Saroj Kumar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 9:13 AM Subject: RE: [JBoss-user] Default database > 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 > ------------------------------------------------------- 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
