I haven't tried it with access, honestly.
We use oracle and I did have to tweak it a little to use that.
[EMAIL PROTECTED] (512)-236-6244
---
The first thing was, I learned to forgive myself. Then, I told myself, "Go
ahead and do whatever you want, it's okay by me." -- Deep Thoughts by Jack
Handey
-----Original Message-----
From: Haseltine, Celeste [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 12:04 PM
To: JRun-Talk
Subject: RE: Access Database
Does PoolMan support Access? My memory seems to think that PoolMan
did not
work well with Access, but Imay be remember something package other
than
PoolMan.
Celeste
-----Original Message-----
From: McKenzie, Ben [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 11:51 AM
To: JRun-Talk
Subject: RE: Access Database
I have started using the PoolMan jdbc pool manager
(http://www.codestudio.com/), and I like it pretty well. It had
some
features that we needed that the jrun connection pools did not (like
maximum
connections)
[EMAIL PROTECTED] (512)-236-6244
---
The first thing was, I learned to forgive myself. Then, I told
myself, "Go
ahead and do whatever you want, it's okay by me." -- Deep Thoughts
by Jack
Handey
-----Original Message-----
From: Haseltine, Celeste [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 11:19 AM
To: JRun-Talk
Subject: RE: Access Database
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
