SQLJ connection to SQLServer

From: <jacobelias_at_gmail.com>
Date: 31 Jul 2006 02:04:23 -0700
Message-ID: <1154336663.285480.117430@m73g2000cwd.googlegroups.com>

Hello,

Is it possible using SQLJ to connect to sqlserver? When I try, I am getting error:
java.lang.IllegalArgumentException: SQLJ programs translated with the option -codegen=oracle must be run under Oracle JDBC 9.0.0 or higher. If the Oracle JDBC driver is wrapped, then the wrapper must implement all of the oracle.jdbc.OracleXxxx interfaces. Alternatively, you can translate SQLJ programs either with -codegen=iso or with -codegen=jdbc.

Code

Oracle.connect(LM_SQLJ.class,"connect.properties",true); Oracle.connect("jdbc:microsoft:sqlserver://10.10.10.10:1433;DatabaseName=zzz;User=123;Password=1234",true);
#sql iterator SeatCursor1(Timestamp CLOSE_DATE, String
TERMINAL_PRODUCT_NUMBER,String NAME,String TANK_CODE,int OPENING_PHYSICAL_GROSS_QTY,int CLOSING_PHYSICAL_GROSS_QTY); SeatCursor1 sc;
#sql sc = { select CLOSE_DATE

,TERMINAL_PRODUCT_NUMBER,NAME,TANK_CODE,OPENING_PHYSICAL_GROSS_QTY,CLOSING_PHYSICAL_GROSS_QTY from cbv by CLOSE_DATE desc}; Received on Mon Jul 31 2006 - 04:04:23 CDT