Hi,
I use OJB with MySQL since 6 month without any real pb.
When I try to configure my app to work with SQL Server 7, a lot of pb occure :
1 - Can't find free working JDBC driver or not able to configure it fine :
- try MS JDBC Driver .. only for SQL 2000 (? nobody can tell me where to find
previous version ?)
- try freetds_jdbc(com.internetcds.jdbc.tds.driver) and jtds-0.5.1(sourceforge)
but have classCast Exception when insert or update element (under query generation I
think, not sur ..)
- Finaly use JSQLConnect but I have to use ConnectionFactoryNotPooled if I wan't
to use it free ...
Any other way to use OJB with SQL Server 7 ? using JDBC/ODBC ? how to configure
repository_data and what's the good driver ?
2 - autoincrement : SQL Server can be configured to auto increment column with 2 ways
: "counter" and "rowguid".
counter is not a real autoincrement I think (or MySQL have a particular comportement
with autoincrement columns), because you can't insert it as null (try to set id column
readonly, no way).
And rowguid can't be set after insert data in the table (so I can't use it, I have to
insert existing datas with there references).
=> I finaly let sequenceManager increment ids, working fine (with
SequenceManagerHighLowImpl, is it the good way ?)
Is anybody work with MS SQL Server 7 ?
How do you configure your connection ?
What's your strategie to insert rows ?
Any suggestions are welcome !
thxs.
