我目前正在使用17连接到Oracle数据库实例,然后提取一些数据并将其插入我拥有的Server表中。DROP TABLE IF EXISTS [jerry].[dbo].[purchases] FROM OPENQUERY(OLAP, '
然而,SQL代码大约有9500个字符,因此OPENQUERY失败,这是所支持的[purchases]然而,我仍然得到一个Invalid Syntax near
我会得到一个异常:
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mondrian:Jdbc=jdbc:mysql://localhost:3306/foodmart?$Olap4jPoolingConnectionFactory.getConnection(
我安装了Oracle12c企业版,但当我连接到实例时,我看到消息"With the Partitioning,OLAP,Advanced Analytics and Real Application Testingsqlplus / as sysdba
连接到: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -具有分区、OLAP、Advanced