Question

是否有办法从 org.h2.jdbc.Jdbconnection 获得 olap4j.OlapConnection ?

http://www.olap4j.org/olap4j_fs.html#Connections" rel="no follow"> there:

Class.forName("org.h2.Driver");
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
Connection conn = DriverManager.getConnection("jdbc:h2:~/test;", "sa", "");
OlapWrapper wrapper = (OlapWrapper) conn;
OlapConnection olapConn = wrapper.unwrap(OlapConnection.class);

但我得到一个

Exception in thread "main" java.lang.ClassCastException: org.h2.jdbc.JdbcConnection cannot be cast to org.olap4j.OlapWrapper at myprogram.main(Mondrian2H2Test.java:67)

:67 是 OlapWrapper 包装器= (OlapWrapper) conn;

<强 > EDIT: 我也尝试过这个: Class.forName("org.h2.Driver"); Class.forName("mondrian.olap4j.MondrianOlap4jDriver"); Connection conn = DriverManager.getConnection("jdbc:h2:~/test;", "sa", ""); OlapConnection olapConn = conn.unwrap(OlapConnection.class); 因此: Exception in thread "main" java.lang.AbstractMethodError: org.h2.jdbc.JdbcConnection.unwrap(Ljava/lang/Class;)Ljava/lang/Object; at myprogram.main(Mondrian2H2Test.java:46) :46 是 OlapConn = conn.unlop (OlapCunction. classle);

Answer 1

http://mondrian.pentaho.com/api/mondrian/olap4j/MondrianOlap4jDriver.html" rel=“nofollow” >MondrianOlap4jDriver javadocs ,在电子邮件列表上,该代码似乎是:

import java.sql.Connection;
import java.sql.DriverManager;
import org.olap4j.OlapConnection;

Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
Connection conn = DriverManager.getConnection(
    "jdbc:mondrian:" + 
    "Jdbc=jdbc:h2:~/test; " +
    "JdbcUser=sa; " +
    "JdbcPassword=; " +
    "Catalog=file:/mondrian/demo/FoodMart.xml; " +
    "JdbcDrivers=org.h2.Driver");
OlapConnection olapConn = conn.unwrap(OlapConnection.class);

友情链接