Re: [JBoss-user] DeploymentException when using oracle

[Guy Rouillier]

Here is the text of two messages I saved on this question:   go to  http://prdownloads.sourceforge.net/hsqldb/hsql_143.zip and download the zip file with hypersonic. unzip it, go to the demo folder and launch the org.hsql.util.DatabaseManager (look at the memorydbmanager.html source) and connect to the in memory db that is running when jBoss is running. (settings can be found in jboss.jcml) I've been using iSQLViewer (http://isql.sourceforge.net/index.html) to view the contents of both Hypersonic (including the one embedded in JBoss) and PostgreSQL databases. ----- Original Message ----- From: Alice Ad To: Guy Rouillier ; [EMAIL PROTECTED] Sent: Friday, December 21, 2001 1:06 PM Subject: Re: [JBoss-user] DeploymentException when using oracle Thanks for the help. A simple question: How do I access Hypersonic (DefaultDS) ? I mean how can I run "sqlplus" counterpart of Oracle? Thanks.   Guy Rouillier <[EMAIL PROTECTED]> wrote: Two things.  First, you are using opentools.minerva.   These classes have been superceded by jbosspool counterparts.  As long as you are just getting started, get a version of JBoss >= 2.4.3, and use the jbosspool variant.  Second, make sure your code and deployment descriptors refer to OracleDB and not DefaultDS.  Finally (did I say two?), you don't mention what your EJB does, but I think if it uses jaws or cmp (neither of which I use), the default target for these is DefaultDS.  You'll have to fix that.   ----- Original Message ----- From: Alice Ad To: [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 9:57 PM Subject: [JBoss-user] DeploymentException when using oracle Hello, I want to use Oracle instead of hypersonic/instantdb. This is what i did in jboss.jcml: 1. org.jboss.jdbc.JdbcProvider mbean contains ONLY oracle driver 2. org.jboss.jdbc.HypersonicDatabase mbean and org.jboss.jdbc.XADataSourceLoader mbeans for InstantDN and DefaultDS removed 3. org.jboss.jdbc.XADataSourceLoader mbean for oracle added:   <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB">     <attribute name="PoolName">OracleDB</attribute>     <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>     <attribute name="URL">jdbc:oracle:thin:@localhost:1521:oracle</attribute>     <attribute name="JDBCUser">scott</attribute>     <attribute name="Password">tiger</attribute>   </mbean> I get this error: Deploying CDBean oracle.jboss.ejb.DeploymentException: DefaultDS not bound When I use all drivers in org.jboss.jdbc.JdbcProvider mbean and keep all org.jboss.jdbc.XADataSourceLoader mbeans for defaults, I do not get any error but all the data gets loaded in Hypersonic instead of Oracle. Please help. Thanks very much. (I am using JBoss2.2_Tomcat3.2.2 with WIn2k)         Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your holiday gifts! Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your holiday gifts!