The problem was in my jboss.xml file.
<resource-managers>
<resource-manager>
<res-name>jdbc/odotref_datasource</res-name>
<res-jndi-name>SybasePool</res-jndi-name>
</resource-manager>
</resource-managers>
The <res-jndi-name> value must be prefixed with the "java:/".
<res-jndi-name>java:/SybasePool</res-jndi-name>
jim
----- Original Message -----
From: "James Cook" <[EMAIL PROTECTED]>
To: "JBoss-User" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 4:21 PM
Subject: Re: [jBoss-User] Creating a BMP
> 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]
>
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
