Emiline,
If you are trying to use/create more than one connection at a time, then you
will probably want to write a connection pool object yourself, particularly
since you are using the ODBC-JDBC bridge. You will then need to pull a
connection from the pool, use it, then return it to the pool. This type of
functionality is available to you WITHOUT the headache of writing/testing
your own connection pool is you use a real database and a Type III/IV JDBC
driver.
I would strongly suggest that if you have no other database available to you
other than Access, that you download the free database MySQL. I have also
seen posts to this listserver of other free databases such as Interbase by
Borland. You can do a search of the archives of the
[EMAIL PROTECTED] discussion group to find more info on both of
these databases. Both database's come with JDBC drivers, and offer a much
more realistic learning experience than the JDBC-ODBC bridge. You will
NEVER use Access and the JDBC-ODBC bridge in a real development project, or
at least I hope you never try to. So I would not waste my time working with
the ODBC-JDBC bridge and Access if you are tying to learn Java and/or JPS's.
Celeste
-----Original Message-----
From: Emeline Barns [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 25, 2001 12:39 PM
To: JRun-Talk
Subject: RE: Access Database
Hi Dave,
If I am using under 20 simeltenious connectons is it OK to use JDBC_ODBC
bridge for Access when only using SELECT statements?
Elena
>From: "Dave Feltenberger" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: JRun-Talk <[EMAIL PROTECTED]>
>Subject: RE: Access Database
>Date: Thu, 23 Aug 2001 10:16:58 -0400
>
>SQL Server is even more expensive than 3rd party drivers... I'd stick with
>Access (if it's working OK for you) and use the JDBC/ODBC bridge. If
>reliability were an issue, and the application you're using were getting
>hit
>thousands of times per second, you wouldn't be using Access in the first
>place - so the JDBC/ODBC bridge should work perfectly fine. It's included
>with JRun.
>
> > -----Original Message-----
> > From: Bert [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 23, 2001 10:14 AM
> > To: JRun-Talk
> > Subject: Re: Access Database
> >
> >
> > third party drivers are expensive you may want to upgrade to
> > Sql Server
> > ----- Original Message -----
> > From: "Jackie Comeau" <[EMAIL PROTECTED]>
> > To: "JRun-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, August 23, 2001 9:55 AM
> > Subject: RE: Access Database
> >
> >
> > > I've tried the JDBC-ODBC bridge and it doesn't work all
> > that well. Your
> > > better off going with a third-party driver. They are hard
> > to find for
> > > Access, and never found a freebee for Access. I'm using
> > JDataConnect.
> > >
> > > Jackie
> > >
> > > On Thursday, August 23, 2001 8:03 AM, Vitaly Shorin
> > > [SMTP:[EMAIL PROTECTED]] wrote:
> > > > Hi Rich,
> > > > I think the only way to do this is to use JDBC-ODBC bridge.
> > > > I did not hear about any third-party drivers, and the people in
> > Microsoft
> > > > are not fans of Java. Really, they didn't implement ever
> > MS SQL drivers
> > > for
> > > > JDBC!
> > > >
> > > > Regards,
> > > > Vitaly.
> > > >
> > > > ----- Original Message -----
> > > > From: "Rich Tretola" <[EMAIL PROTECTED]>
> > > > To: "JRun-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Thursday, August 23, 2001 3:57 PM
> > > > Subject: Access Database
> > > >
> > > >
> > > > > How do I set up an Access database connection to JRun?
> > > > > Rich
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
