On Sat, 6 Nov 1999, John N. Alegre wrote:
> Peter,
>
> I have no problem on my end. I have 4 years expeience with Server Side
> Java. I want the most advanced JDBC driver/db combination. The question I am
> rasing is which JDBC drier is more robust and closer to the JDBC 2.0 speck.
> Once I have a solid driver, there is no problem writing code to use it here!
I'm not certain about mySQL, but one item that is in PostgreSQL is
transactions, which I believe mySQL doesn't have. Also the PostgreSQL JDBC
driver is thread safe. That is more than one thread can use the same
connection at the same time.
As for the 2.0 spec, only parts of it is implemented so far. As I said
earlier, BLOB and Array support is first on the list, then the other
methods. Now that 6.5.3 is out, I'm about to start on this ready for 7.0
(which is the next release).
> Do you know of any independent comparisons of the JDBC drivers for PostgresSQL
> and mySQL? I just got back from the Colorado Software Summit and feedback
> there was mixed.
Not that I'm aware of, but I would be interested in reading them if there
are any.
What type of feedback did you get?
Peter
> john
>
> On 26-Oct-99 Peter Mount wrote:
> > On Mon, 25 Oct 1999, John N. Alegre wrote:
> >
> >> Has anyone else had this experience. I have been reluctant to move to
> >> PostgrSQL for reasons of complexity and speed.
> >
> > Although I don't touch applets anymore, the problems with placing either
> > all of the classes into a single jar file, or extracting the classes so
> > they are downloaded individually are old, but tips I still give out when
> > people ask me about problems with browsers.
> >
> >> Is the JDBC support that much more advanced in PostgrSQL?
> >
> > I should hope so, as it takes up a lot of my time :-)
> >
> > For the next release I'm hoping to have most of the JDBC2 spec complete,
> > but mainly the BLOB and Array support.
> >
> >> All comments welcome.
> >>
> >> john
> >>
> >> On 24-Oct-99 Eric vanberkel wrote:
> >> > I've been thru this.
> >> >
> >> > You go to check you have the 1.2.2 driver and not the
> >> > 1.2.1, which did not work on my prev2 JDK + latest mysql
> >> >
> >> > Also for apps:
> >> > java -cp .:$CLASSPATH proggie
> >> > with a correct classpath set
> >> >
> >> > in applets $CLASSPATH won't work.
> >> > You'll want to put into your html:
> >> >
> >> > <applet>
> >> > ..
> >> > ..
> >> > <archive=".....">
> >> >
> >> > put the mm jarfile in this tag and in the applet home dir.
> >> > If there is no jar, copy the mm.mysql level into the applet
> >> > home dir. I know it's a shame, butt...
> >> >
> >> > If you haven't got a jar you use the jar tools to pack the
> >> > mm.mysql classes into a jar file.
> >> >
> >> > This knowledge cost me a lotta sweat. I hope it pays off
> >> > for you brother...
> >> >
> >> > Oh,
> >> > I managed to step over the line to PostgrSQL. Support for
> >> > JDBC is much better. This might be a hint. They also
> >> > upgraded to JDBC2 faster then mysql usually does....
> >> >
> >> > Good luck,
> >> > gr. Eric
> >> >
> >> > --- Jalaluddin Riaz <[EMAIL PROTECTED]> wrote:
> >> >> hi,
> >> >> I am a newbie to JDBC programming and am having some
> >> >> problems. I am
> >> >> using mysql rdbms and mm.mysql.jdbc-1.2 driver and have
> >> >> jdk1.2preV2
> >> >> installed. the problem is everytime i try to run a prog.
> >> >> i get class not
> >> >> found exception. the prog is not able to find the driver
> >> >> class files. i have
> >> >> tried different CLASSPATH settings, still does no works..
> >> >> any ideas.
> >> >>
> >> >> thanks.
> >> >>
> >> >> ______________________________________________________
> >> >> Get Your Private, Free Email at http://www.hotmail.com
> >> >>
> >> >>
> >> >>
> >> > ----------------------------------------------------------------------
> >> >> To UNSUBSCRIBE, email to
> >> >> [EMAIL PROTECTED]
> >> >> with a subject of "unsubscribe". Trouble? Contact
> >> >> [EMAIL PROTECTED]
> >> >>
> >> >>
> >> >
> >> > __________________________________________________
> >> > Do You Yahoo!?
> >> > Bid and sell for free at http://auctions.yahoo.com
> >> >
> >> >
> >> > ----------------------------------------------------------------------
> >> > To UNSUBSCRIBE, email to [EMAIL PROTECTED]
> >> > with a subject of "unsubscribe". Trouble? Contact
> >> > [EMAIL PROTECTED]
> >>
> >> ----------------------------------
> >> E-Mail: John N. Alegre <[EMAIL PROTECTED]>
> >> Date: 25-Oct-99
> >> Time: 13:02:49
> >>
> >> This message was sent by XFMail
> >> ----------------------------------
> >>
> >>
> >> ----------------------------------------------------------------------
> >> To UNSUBSCRIBE, email to [EMAIL PROTECTED]
> >> with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
> >>
> >
> > --
> > Peter T Mount [EMAIL PROTECTED]
> > Main Homepage: http://www.retep.org.uk
> > PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> > Java PDF Generator: http://www.retep.org.uk/pdf
> >
> >
> > ----------------------------------------------------------------------
> > To UNSUBSCRIBE, email to [EMAIL PROTECTED]
> > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
>
> ----------------------------------
> E-Mail: John N. Alegre <[EMAIL PROTECTED]>
> Date: 06-Nov-99
> Time: 18:04:59
>
> This message was sent by XFMail
> ----------------------------------
>
--
Peter T Mount [EMAIL PROTECTED]
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
