-
1. Re: Please help with SQL Server 2000 Mapping
alex_koshterek Dec 13, 2001 3:33 AM (in response to matthicksj)This driver have bug in working with BIG_INT8.
Check nntp server msnews.microsoft.com
There exists group about this driver -
2. Re: Please help with SQL Server 2000 Mapping
matthicksj Dec 13, 2001 11:04 AM (in response to matthicksj)On the newsgroup they suggested the use of 'long' to handle the BIGINT values. However, the mapping already looks like this. I am not sure if this attempts to do what they suggested on the newsgroup:
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</sql-type>
Also, how do we change the defaults for the CMP fields? For instance, how could I change the default value of BIGINT(8) to INT or something when the tables are created? Thanks -
3. Re: Please help with SQL Server 2000 Mapping
alexnet Dec 13, 2001 4:48 PM (in response to matthicksj)Hi,
there is a bug in MS drivers. If you change your type of your column to nullable, everything should be fine. Errors occurs only if column has type 'Long' and declare as 'NOT NULL'.
Alex. -
4. Re: Please help with SQL Server 2000 Mapping
matthicksj Dec 13, 2001 6:30 PM (in response to matthicksj)Great - thank you very much for your replies. I was able to change the code to have the primary key's use int's as opposed to Long's. One thought I had though, would it work just to map the Long datatype to the FLOAT JDBC type as opposed to the BIGINT type - they are both 8 byte values.
Thanks