Thanks

I am loading the FBDriver class is this just jdbc 1.0 - no blob support?   I get the following exception when I try to run it with win2K and using localhost as the server:

**** Exception possible com.alteon.nms.persist.PdException: InterBaseIf.dbQuery(
): SQL exception java.sql.SQLException: ResourceException: javax.resource.Resour
ceException: couldn't start local transaction: javax.transaction.xa.XAException
com.alteon.nms.persist.PdException: InterBaseIf.dbQuery(): SQL exception java.sq
l.SQLException: ResourceException: javax.resource.ResourceException: couldn't st
art local transaction: javax.transaction.xa.XAException

I am using the following connection URL
jdbc:firebirdsql:localhost/3050:/c:/Program Files/Alteon/PcdNms/PCDNMS.GDB

Thanks for all your help

Jeff Seaman

-----Original Message-----
From: David Jencks [mailto:davidjencks@...]
Sent: Tuesday, February 12, 2002 2:39 PM
To: IB-Java@yahoogroups.com
Subject: Re: [IB-Java] jca-jdbc driver without jboss

On 2002.02.12 14:05:23 -0500 Jeffrey Seaman wrote:
>
> Hello,
>
> Is it possible to use the jca-jdbc driver outside of the JBOSS
> environment
> as a standalone driver connecting to firebird. I am having trouble
> getting
> any xactions to work which is why I guess JBOSS is needed.
>
> Thanks,
>
> Jeff Seaman

Yes. Use the FBDriver class if you like jdbc 1 or FBWrappingDataSource if
you would like a datasource with pooling built in.  Consult the tests for
examples of how to use these.

If you want xa transactions you will have to supply a ConnectionManager
class to work with your transaction manager.  You might be able to adapt
one of the jboss ones.

The driver should actually work in any app server supporting jca, such as
some versions of weblogic and websphere, and Pramati server, however I
haven't tested it anywhere else.

If you really need xa, I suggest using an app server such as jboss.  You
can prune jboss to a small size and it will simplify many aspects of
coding.

david jencks

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
When building an e-commerce site, you want to start with a
secure foundation. Learn how with VeriSign's FREE Guide.
http://us.click.yahoo.com/oCuuSA/XdiDAA/yigFAA/saFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
IB-Java-unsubscribe@egroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/