Code: Select all
VAR TEST4 EXTERNAL JDBC "jdbc:jtds:sqlserver://localhost:1433;databaseName=JUDYDB1,**,********,TEST1";
Code: Select all
ERROR: Encountered "VAR" at line 12, column 1.
Was expecting one of:
"BEGIN" ...
"TCLOSE" ...
<TUPLE> ...
"WITH" ...
<TUPLE> ...
entering in the connection string and other information leads to a successful outcome.
Interestingly, the text for attribute Definition in sys.DefinitioinHistory after the above executes
is the same as the variable declaration except for the implied AUTOKEY at the end of the string.
It would be convenient if the var definition also worked.
Also I could never get the driver for sql server in Accessing External Data Sources, jdbc:sqlserver, to
work. Entering in the following connection string:
"jdbc:sqlserver://localhost:1433;databaseName=JUDYDB1" and the other information leads to the error:
Code: Select all
ERROR: RS0450: EXTERNAL relvar definition failed due to: org.reldb.rel.exceptions.ExceptionSemantic:
EX0016: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost:1433;databaseName=JUDYDB1.
Drivers available: oracle.jdbc.OracleDriver, org.postgresql.Driver, net.sourceforge.jtds.jdbc.Driver,
org.mariadb.jdbc.Driver
thanks