Jonathan Ackerman wrote:
> 
> My entity bean is using Bean Managed persistence so I should not have to do
> this (I believe).

Why not? I don't quite follow this.

> My ejb-jar.xml has a section as follows in it:
> 
> <resource-ref>
>   <description>This is the JDBC datasource that the bean uses.</description>
>   <res-ref-name>jdbc/booklist</res-ref-name>
>   <res-type>javax.sql.DataSource</res-type>
>   <res-auth>Container</res-auth>
> </resource-ref>

That's good.

> And my jboss.xml file has the following in it:
> 
> <resource-ref>
>   <res-ref-name>jdbc/booklist</res-ref-name>
>   <resource-name>java:/BookListDS</resource-name>
> </resource-ref>

Aha! Read the DTD at http://www.jboss.org/documentation/jboss.dtd and
you will see that this is not quite right. The <resource-name> is a
symbolic reference to a <resource-manager> defined elsewhere in the
file.

Toby.

> My code gets hold of the Datasource by doing:
> 
> dataSource = (DataSource) new
> InitialContext().lookup("java:comp/env/jdbc/booklist");
> 
> This all seems to work fine, I don't get any errors, until I try to execute
> a query in my ejbLoad() method !
> 
> Jonathan
> 
> -----Original Message-----
> From: Toby Allsopp [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 15 January 2001 6:00 p.m.
> To: jBoss
> Subject: Re: [jBoss-User] JBoss and Interbase
> 
> Have you set your bean to use that datasource? By default it will
> DefaultDS. You can set the default in standardjboss.xml or per-bean with
> META-INF/jboss.xml.
> 
> Toby.
> 
> Jonathan Ackerman wrote:
> 
> > Yep,
> >
> > Set it up as per the manual, I can see the JDBC driver been loaded and my
> > datasource being created. Checked this by setting the wrong password in
> > jboss.jcml and saw my datasource create fail.
> >
> > Jonathan
> >
> >
> >
> >> Have you set your datasource up in jboss.conf and jboss.jcml?
> >
> >
> >> Sorry to be patronising if you have ;-)
> >
> >
> >> Tim.
> >
> >
> >>> Has anyone been able to get JBoss and Interbase to work together ?
> >>>
> >>> I'm trying to write a BMP entity bean. Whenever my ejbLoad() method is
> >>> called I get a "java.sql.SQLException: Table not found: xxxx" exception
> >>> message.
> >>>
> >>
> >> Now I've double checked the table and it is there. I also wrote a small
> >
> > Java
> >
> >>> app running the same query to test it and the query works fine from the
> >>
> > app.


--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
List Help?:          [EMAIL PROTECTED]

Reply via email to