jon * <[EMAIL PROTECTED]> writes:
> Sybase/SQLServer (they are essentially the same) are two very f*cked up
> databases with bad JDBC drivers that don't fully implement the JDBC spec.
> :-(
What parts of the JDBC spec are not supported by which JDBC drivers ? I've
been happily using the JConnect for Sybase in two projects(around 300K
lines of code combined) and have only run into minor problems and bugs that
have been fixed promptly by the excellent support at Sybase.
>
> What do you expect?
>
> The solution here is to switch to a SQL database that actually supports the
> specifications that you require.
Not a solution for everybody. Not that I'm using Sybase at the moment, but
I may very well in the future and I'm sure others will need support for
these databases as well. As far as f*cked up goes - how was transaction and
MySQL again ? ;-) No I don't want another discussion on that, but my point
is that there are different requirements out there.
> Ug. No it doesn't make it any harder. You just simply need to use the
> IDBroker across all of those applications. If you are using another
> language, it is simple to re-implement the IDBroker in another language. You
> are making the query against a single database table and doing a lock on a
> table. It isn't anything overly complex.
I agree with the argument, but my conclusion is that is does make it harder
because you have to read some extra documentation of the data model to find
out how to generate ids.
>
> All you are doing is outputting an ID that is a long instead of an int. Even
> if that breaks some code, I think that it is worth it and we have been
> waiting for someone to submit this patch anyway. Again, your argument
> doesn't hold up. :-)
If we're only talking going to long, but I suggested going to BigDecimal or
BigInteger. But before I can patch anything I will have to get
JetSpeed and Turbine up and running, so far I've only been reading source
code and documentation. I hope to do this on Sunday.
regards,
Gunnar
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
