firebird-java - RE: [IB-Java] J2EE JDBC Driver for InterBase...

Subject	RE: [IB-Java] J2EE JDBC Driver for InterBase...
Author	sbremal@matavnet.hu
Post date	2001-12-26T14:17:09Z

Hi,

I used the InterClient 2.XX JDBC driver with WebLogic 5.1 / 6.0 / 6.1. After
playing a lot with the properties I managed to make it work very stable. If
you are interested in the details check the excerpt from config.xml below.

<JDBCTxDataSource EnableTwoPhaseCommit="true"
JNDIName="MyJdbcDataSource" Name="MyJDBC Tx Data Source"
PoolName="MyJDBC Connection Pool" Targets="myserver"/>

<JDBCConnectionPool DriverName="interbase.interclient.Driver"
InitialCapacity="10" MaxCapacity="10"
Name="MyJDBC Connection Pool"
Password="{3DES}XUn4tIlDDL/ssRWovIHrNg=="
Properties="user=SYSDBA;charSet=UTF8" RefreshMinutes="1"
ShrinkingEnabled="false" Targets="myserver"
TestConnectionsOnRelease="true" TestConnectionsOnReserve="true"
TestTableName="BASE"
URL="jdbc:interbase://localhost/F:/my_projects/database/Observer.gdb"/>

I haven't yet used J2EE 1.3 but I can provide some relevant snippets from my
J2EE 1.2.1 default.properties:

jdbc.datasources=jdbc/EstoreDB|jdbc:cloudscape:rmi:CloudscapeDB;create=true|
jdbc/InventoryDB|jdbc:cloudscape:rmi:CloudscapeDB;create=true|jdbc/Cloudscap
e|jdbc:cloudscape:rmi:CloudscapeDB;create=true|jdbc/database|jdbc:interbase:
//localhost/G:/My
Projects/Address-book/Database/ADDRESS_BOOK.GDB|jdbc/SeoDB|jdbc:cloudscape:r
mi:SeoDB;create=true

Hope it helps a little!

/SB

> -----Original Message-----
> From: Perumal [mailto:perumal_v@...]
> Sent: Wednesday, December 26, 2001 5:56 AM
> To: IB-Java@yahoogroups.com
> Subject: Re: [IB-Java] J2EE JDBC Driver for InterBase...
>
>
> Hi,
>
> Please tell me where can I get answer for this question.
>
> Perumal.
>
>
> ----- Original Message -----
> From: "David Jencks" <davidjencks@...>
> To: <IB-Java@yahoogroups.com>
> Sent: Wednesday, December 26, 2001 9:55 AM
> Subject: Re: [IB-Java] J2EE JDBC Driver for InterBase...
>
>
> > If you mean Sun's J2ee RI, I have no idea how to do
> anything with it,
> > sorry.
> >
> > david jencks
> >
> > On 2001.12.25 23:22:44 -0500 Perumal wrote:
> > > Hi David,
> > >
> > > Thanx for your reply, I am using just J2EE not any other
> > > Application
> > > server, I would like to know the JDBC Driver settings in J2EE
> > > configuration
> > > file for InterBase Database through InterClient.
> > >
> > > InterBase is connecting succesfully when using
> Jakarta-tomcat for
> JSP
> > > file but I could't do with J2EE.
> > >
> > > Perumal.
> > > ----------------------------------------------------
> > >
> > >
> > > ----- Original Message -----
> > > From: "David Jencks" <davidjencks@...>
> > > To: <IB-Java@yahoogroups.com>
> > > Sent: Monday, December 24, 2001 7:27 PM
> > > Subject: Re: [IB-Java] J2EE JDBC Driver for InterBase...
> > >
> > >
> > > > AFAIK, the form of this configuration is specific to
> the app server
> you
> > > are
> > > > using, and you should consult the app server documentation. For
> > > example,
> > > > for JBoss 3, one way is documented in the online manual.
> > > >
> > > > david jencks
> > > >
> > > > On 2001.12.24 04:56:23 -0500 Perumal wrote:
> > > > > Hi,
> > > > >
> > > > > Could you please give me an idea about how to
> make connection
> > > > > between J2EE and InterBase DB and what is the Driver setting.
> > > > >
> > > > > I could work with Interbase perfectly when I use JSP. But I
> could't
> > > > > when I use EJB bean. So please clear my doubt.
> > > > >
> > > > > Perumal.
> > > > >
> > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > > > > <HTML><HEAD>
> > > > > <META http-equiv=Content-Type content="text/html;
> > > charset=iso-8859-1">
> > > > > <META content="MSHTML 6.00.2462.0" name=GENERATOR>
> > > > > <STYLE></STYLE>
> > > > > </HEAD>
> > > > > <BODY bgColor=#ffffff>
> > > > >
> > > > >
> > > > > <DIV><FONT face=Arial size=2>
> > > > > <DIV>
> > > > > <DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
> > > > > <DIV><FONT face=Arial size=2></FONT> </DIV>
> > > > > <DIV><FONT face=Arial size=2>
> Could you
> > > please
> > > > > give me
> > > > > an idea about how to make connection between
> J2EE and InterBase
> > > DB
> > > > > and what
> > > > > is the Driver setting. </FONT></DIV>
> > > > > <DIV><FONT face=Arial size=2></FONT> </DIV>
> > > > > <DIV><FONT face=Arial size=2> I could work
> with Interbase
> > > > > perfectly when I use JSP. But I
> could'</FONT><FONT face=Arial
> > > > > size=2>t
> > > > > when I use EJB bean. So please clear my
> doubt.</FONT></DIV>
> > > > > <DIV><FONT face=Arial size=2></FONT> </DIV>
> > > > > <DIV><FONT face=Arial
> > > > > size=2>Perumal.</FONT></DIV></DIV></FONT></DIV>
> > > > > <br>
> > > > >
> > > > > 
> > > > >
> > > > > <table border=0 cellspacing=0 cellpadding=2>
> > > > > <tr bgcolor=#FFFFCC>
> > > > > <td align=center><font size="-1"
> color=#003399><b>Yahoo! Groups
> > > > > Sponsor</b></font></td>
> > > > > </tr>
> > > > > <tr bgcolor=#FFFFFF>
> > > > > <td align=center width=470><a
> > >
> href="http://rd.yahoo.com/M=215839.1778785.3296727.1261774/D=e
> groupweb/S=170
> > >
> 5006764:HM/A=868540/R=0/*http://zappos.zappos.com/bin/zapposse
> t?ref=yahoogro
> > > ups2"><img
> > > > >
> > >
> src="http://us.a1.yimg.com/us.yimg.com/a/za/zappos/zap_468x60w
> interboots.gif
> > > "
> > > > > height=60 width=468></a></td>
> > > > > </tr>
> > > > > <tr><td><img alt="" width=1 height=1
> > > > >
> > >
> src="http://us.adserver.yahoo.com/l?M=215839.1778785.3296727.1
> 261774/D=egrou
> > > pmail/S=1705006764:HM/A=868540/rand=188152343"></td></tr>
> > > > > </table>
> > > > >
> > > > > 
> > > > >
> > > > >
> > > > > <br>
> > > > > <tt>
> > > > > To unsubscribe from this group, send an email to:<BR>
> > > > > IB-Java-unsubscribe@egroups.com<BR>
> > > > > <BR>
> > > > > </tt>
> > > > > <br>
> > > > >
> > > > > <br>
> > > > > <tt>Your use of Yahoo! Groups is subject to the <a
> > > > > href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of
> > > > > Service</a>.</tt>
> > > > > </br>
> > > > >
> > > > > </BODY></HTML>
> > > > >
> > > >
> > > >
> > > > 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/
> > > >
> > >
> > >
> > >
> > > 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/
> > >
> > >
> > >
> > >
> > >
> >
> >
> > 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/
> >
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> PC to PC calling with 3-way conferencing. Only
> $11.95/yr at CrystalVoice! Free trial. Click Here!
> http://us.click.yahoo.com/4SQRwC/RYfDAA/ySSFAA/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/
>
>
>