Hi,
We are using FDMEE 11.1.2.3 . We have installed JDBC 4.0 driver on server and tried to connect to SQL Server 2008 using Jython Script .. Below is the script :
import java.sql as sql
coding='UTF-8'
sql.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
connectionUrl = "jdbc:sqlserver://as-sg-essdev;" +"databaseName=FCRS_STG;user=FCRS;password=Password;";
sourceConn = sql.DriverManager.getConnection(connectionUrl);
insertStmt = """INSERT [FCRS_STG].[dbo].[fdm_sales_adjust] (USER_ID,app,ENTITY,CUSTOMER,[SELLING_BUSINESS_LINE],[SELLING_PRODUCT],[BUYING_BUSINESS_LINE],[BUYING_PRODUCT],[GST/VAT],[SALES_LCY],[SALES_FCY],[QTY_NORMAL],[QTY_INV]) Values ('CJTEST','SG','ENTITY1','CUSTOMER1','SB1','SP1','BB1','BP1',100,200,300,50,75)"""
stmt = sourceConn.prepareStatement(insertStmt)
stmt.executeQuery()
stmt.close()
stmt.close()
sourceConn.close()
We are getting below error when we execute this script :
FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
File "<string>", line 464, in executeJythonScript
File "E:\FDMEE\FCRSSG/data/scripts/custom/TestJy.py", line 3, in <module>
sourceConn = sql.DriverManager.getConnection("jdbc:sqlserver://as-sg-essdev", "FCRS", "Password");
SQLException: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://as-sg-essdev
we tried different connection options given in Admin guide and on oracle forums ..