Hi,all,
when i run 'build.sh junit' against a MSSQL server, I got the following
message:
[torque-insert-sql] Executing file:
/home/kongan/workpf/main/pecunia/Java/OJB/finis/target/src/sql/ojbtest-schem
a.sql
[torque-insert-sql] Failed to execute: /*
---------------------------------------------------------------------- */
[torque-insert-sql] /* SM_KEY
*/ /* ----------------------------------------------------------------------
*/ IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'SM_KEY')
BEGIN DECLARE @reftable_59 nvarchar(60), @constraintname_59 nvarchar(60)
DECLARE refcursor CURSOR FOR select reftables.name tablename, cons.name
constraintname from sysobjects tables, sysobjects reftables, sysobjects
cons, sysreferences ref where tables.id = ref.rkeyid and cons.id =
ref.constid and reftables.id = ref.fkeyid and tables.name = 'SM_KEY' OPEN
refcursor FETCH NEXT from refcursor into @reftable_59, @constraintname_59
while @@FETCH_STATUS = 0 BEGIN exec ('alter table '+@reftable_59+' drop
constraint '+@constraintname_59) FETCH NEXT from refcursor into
@reftable_59, @constraintname_59 END CLOSE refcursor DEALLOCATE refcursor
DROP TABLE SM_KEY END CREATE TABLE SM_KEY ( INT_KEY INT NOT NULL, NAME
VARCHAR (250) NULL, STRING_KEY VARCHAR (250) NOT NULL, LONG_KEY BIGINT NOT
NULL, INTEGER_KEY INT NOT NULL, CONSTRAINT SM_KEY_PK PRIMARY KEY(INT_KEY))
[torque-insert-sql] java.sql.SQLException: [Microsoft][SQLServer JDBC
Driver][SQLServer]Column or parameter #4: Cannot find data type bigint.
The reason is that the target SQL server is 'standard edition' and does not
support the type 'bigint'. The type is supported in the Enterprice edition
though.
So, questions:
1) How should I solve this problem? Will I break anything if I change the
schema for testing purpose?
2) How to make the junit test be aware of this difference in MSSQL ? Has
similar situation happened in other platform and, if so, how it is fixed?
Regards,
Anthony
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
