sql server 2008 - Mondrian Olap ClassNotFoundException: mondrian.olap4j.MondrianOlap4jDriver -


i have build schema file of mondrian , sql server.

now writing code in java database connection using olap4j.

code : 

    try {         class.forname("mondrian.olap4j.mondrianolap4jdriver");                     string connectionstring1 = "type=olap name=sales driver=mondrian.olap4j.mondrianolap4jdriver location=jdbc:mondrian:jdbc=jdbc:sqlserver://servername:1433;database=tempdatabase;catalog=c:/schema1.xml;jdbcdrivers=com.microsoft.sqlserver.jdbc.sqlserverdriver username=sa password=p@ssw0rd";                     connection jdbcconnection = drivermanager.getconnection(connectionstring1);                     olapconnection connection = ((olapwrapper)jdbcconnection).unwrap(olapconnection.class);   olapstatement olapstatement = connection.createstatement();      } catch (sqlexception e) {              e.printstacktrace();     }catch (classnotfoundexception e) {         e.printstacktrace();     }

but giving me error while running code : 

java.lang.classnotfoundexception: mondrian.olap4j.mondrianolap4jdriver     @ java.net.urlclassloader$1.run(unknown source)     @ java.security.accesscontroller.doprivileged(native method)     @ java.net.urlclassloader.findclass(unknown source)     @ java.lang.classloader.loadclass(unknown source)     @ sun.misc.launcher$appclassloader.loadclass(unknown source)     @ java.lang.classloader.loadclass(unknown source)     @ java.lang.class.forname0(native method)     @ java.lang.class.forname(unknown source)     @ com.tuto.test.main(test.java:16)

i using following jars : 

1.asm.jar 2.asm-commons.jar 3.asm-tree.jar 4.javacup.jar 5.olap4j-1.0.0.445.jar 6.olap4j-xmla-1.0.0.445.jar 7.retroweaver.jar 8.retroweaver-rt.jar 9.sqljdbc.jar 10.xercesimpl.jar 11.olap4j-tck-1.0.0.445.jar

please me why getting error?

thanks.

you trying use mondrian implementation of olap4j, mondrian isn't in class path. have download mondrian , dependencies.

also, can remove following libraries.

  • retroweaver*.jar
  • olap4j-tck
  • olap4j-xmla

the retroweaver runtime necessary if use jdk4 version of olap4j. olap4j-tck useful if implementing olap4j driver , wanted test it.

also note connection url pretty messed up. i'm pretty sure won't work. should check basic code examples provided here started.


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more