Duh, it sure does. I've been looking at this stack trace for an hour and
completely looked over the org.hsql.* statements. Thanks.
Is there any example of setting up the deployment descriptors properly for BMP
datasources? I couldn't find any. I list the settings that I am using at the
bottom of this message...
jim
----- Original Message -----
From: "Dan Christopherson" <[EMAIL PROTECTED]>
To: "JBoss-User" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 2:49 PM
Subject: Re: [jBoss-User] Creating a BMP
> Your bean looks to be grabbing the hypersonic DB datasource rather then
> your Sybase connection. Are you sure you have the right names in
> ejb-jar.xml, et.al.?
>
> For what it's worth, the first thing I do after building JBoss is get rid
> of the default database pool settings (and the MBeans that launch
> Hypersonic and the other embedded DB) and replace the DefaultDS settings
> with what I really want.
>
> On Wed, 7 Mar 2001, James Cook wrote:
>
> > I am converting a CMP bean to a BMP. I am using Sybase as the database, and
the
> > CMP version works fine.
> >
> > I must have a configuration error however, since my BMP code gives me the
> > following exception when I try to execute a query:
> >
> > TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:
> > javax.ejb.EJBException
> > java.sql.SQLException: Table not found: COUNTY in statement [insert into
county
> > (COUNTY_NBR, COUNTY_NME, COUNTY_ABREV3_CD, COUNTY_ABREV4_CD) values
(1,'North
> > Pole','NPL','NOPL')]
> > at org.hsql.Trace.getError(Trace.java:124)
> > at org.hsql.Result.<init>(Result.java:70)
> > at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644)
> > at org.hsql.jdbcConnection.execute(jdbcConnection.java:540)
> > at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
> > at org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52)
> > at
> > org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:114)
> > at
> >
org.jboss.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementIn
> > Pool.java:81)
> > at
> >
us.oh.state.dot.common.ejb.reference.ejb.bean.CountyBeanBMP.ejbCreate(CountyBean
> > BMP.java:51)
> >
> > Borland AppServer does a very nice job of declaring datasources. jBoss
appears
> > to me to require a couple additional files to achieve what BAS accomplishes
with
> > the single ejb-inprise.xml descriptor. Here are the settings in the relevant
> > jBoss files:
> >
> > jboss.conf
> > ========
> > <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
> > CODEBASE="../lib/ext/">
> > <ARG TYPE="java.lang.String" VALUE="SybaseDB">
> > <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> > </MLET>
> >
> > jboss.jcml
> > =======
> > <mbean name="DefaultDomain:service=XADataSource,name=SybasePool">
> > <attribute
name="URL">jdbc:sybase:Tds:SOCDB004:25000/testdb</attribute>
> > <attribute name="JDBCUser">user</attribute>
> > <attribute name="Password">pass</attribute>
> > </mbean>
> >
> > jboss.xml
> > =======
> > ....
> > <entity>
> > <ejb-name>CountyBeanBMP</ejb-name>
> > <jndi-name>odotref/county_bmp</jndi-name>
> > <resource-ref>
> > <res-ref-name>jdbc/odotref_link</res-ref-name>
> > <resource-name>jdbc/odotref_datasource</resource-name>
> > </resource-ref>
> > </entity>
> > ....
> > <resource-managers>
> > <resource-manager>
> > <res-name>jdbc/odotref_datasource</res-name>
> > <res-jndi-name>SybasePool</res-jndi-name>
> > </resource-manager>
> > </resource-managers>
> > ....
> >
> > MyBean
> > =======
> > I look up the database connection using:
> > Context ctx = (Context) new InitialContext();
> > DataSource ds =
(DataSource)ctx.lookup(java:comp/env/jdbc/odotref_link");
> > Connection conn = ds.getConnection();
> >
> > The exception occurs when I execute a query using this connection. Also, the
> > DatabaseMetaData for the connection does not seem to be knowledgable of any
of
> > the database information.
> >
> > thanks,
> > jim
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> >
>
> --
> Dan Christopherson (danch)
> nVisia Technical Architect (www.nvisia.com)
>
> Opinions expressed are mine and do not neccessarily reflect any
> position or opinion of nVISIA.
>
> ---------------------------------------------------------------------------
> If you're a capitalist and you have the best goods and they're
> free, you don't have to proselytize, you just have to wait.
> -Eben Moglen
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
