SK> But...What's the difference between : SK> 1- Adding those 2 lines in the 'defaults' section of SK> 'jbosscmp-jdbc.xml'
This sets up the default settings for all the beans in the jbosscmp-jdbc.xml SK> 2- Adding the 2 same lines for each 'entity' of 'enterprise-beans' SK> section This overrides the defaults. alex SK> I thought it should work in the same way, no ? SK> Sebastien SK> ----- Original Message ----- SK> From: "Saroj Kumar" <[EMAIL PROTECTED]> SK> To: <[EMAIL PROTECTED]> SK> Sent: Tuesday, August 20, 2002 9:13 AM SK> 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 SK> 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 SK> 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 = >> > >> SK> "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 SK> 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" >> > >> SK> type="java.lang.String">jdbc:oracle:thin:@orion:1521:viewcom</config-pro >> > pert >> > y> >> > <config-property name="DriverClass" >> > >> SK> 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 >> > >> SK> optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployme >> > nt,n >> > ame=JBoss LocalTransaction JDBC Wrapper</depends> >> > </mbean> >> > </depends> >> > >> > <depends optional-attribute-name="ManagedConnectionPool"> >> > <mbean >> > SK> 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 >> > >> SK> optional-attribute-name="CachedConnectionManager">jboss.jca:service=Cach >> > edCo >> > nnectionManager</depends> >> > >> > <depends >> > >> SK> 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: SK> can't >> > find >> > data source: java:/DefaultDS; - nested throwable: >> > (javax.naming.NameNotFoundException: DefaultDS not bound), SK> 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: SK> can't >> > find >> > data source: java:/DefaultDS; - nested throwable: >> > (javax.naming.NameNotFoundException: DefaultDS not bound), SK> 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 SK> pool >> > and >> > > modify jboss.xml >> > > to have the resource ref "foo" which was pointing at the SK> 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 >> SK> ------------------------------------------------------- SK> This sf.net email is sponsored by: OSDN - Tired of that same old SK> cell phone? Get a new here for FREE! SK> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 SK> _______________________________________________ SK> JBoss-user mailing list SK> [EMAIL PROTECTED] SK> https://lists.sourceforge.net/lists/listinfo/jboss-user SK> ------------------------------------------------------- SK> This sf.net email is sponsored by: OSDN - Tired of that same old SK> cell phone? Get a new here for FREE! SK> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 SK> _______________________________________________ SK> JBoss-user mailing list SK> [EMAIL PROTECTED] SK> https://lists.sourceforge.net/lists/listinfo/jboss-user -- Best regards, Alex Loubyansky ------------------------------------------------------- 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
