hi folks,

I have just installed the mondrian-embedded.war from
mondrian-3.2.1.13885-derby.zip into a apache-tomcat-7.0.8 the general
system seems to be working, because i can use the "mdxquery" servlet to
query the embedded database. i want to access the server remotely using
xml/a, to do this i use olap4j 0.9.8.343 and create a connection like
this:

Connection connection = DriverManager.getConnection(
"jdbc:xmla:Server=http://localhost:8080/mondrian-embedded/xmla;"
+ "Catalog=FoodMart");

originally this gave me errors, which i fixed by changing the
datasources.xml and replaced the original DataSourceInfo (which pointed
to some oracle db) with this:

<DataSourceInfo>Provider=mondrian;Jdbc='jdbc:derby:classpath:/foodmart';Catalog=/WEB-INF/queries/FoodMart.xml;JdbcDrivers=org.apache.derby.jdbc.EmbeddedDriver;JdbcUser=sa;JdbcPassword=sa;PoolNeeded=false;</DataSourceInfo>

this seems to have done the trick, as i now get a different error which
i was hoping one of you could help me with. the olap4j seems to do some
sort of metadata discovery before sending teh actual query, whcih fails
with an exception:

XMLA provider gave exception:
<SOAP-ENV:Fault>
<faultcode>
SOAP-ENV:Server.00HSBE02
</faultcode>
<faultstring>
XMLA Discover unparse results error
</faultstring>
<faultactor>
Mondrian
</faultactor>
<detail>
<XA:error xmlns:XA="http://mondrian.sourceforge.net">
<code>
00HSBE02
</code>
<desc>
The Mondrian XML: Container was opened in read-only
mode.
</desc>
</XA:error>
</detail>
</SOAP-ENV:Fault>

Request was:
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<RequestType>MDSCHEMA_DIMENSIONS</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>FoodMart</CATALOG_NAME><SCHEMA_NAME>FoodMart</SCHEMA_NAME><CUBE_NAME>Sales
Ragged</CUBE_NAME> </RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<DataSourceInfo>Provider=Mondrian;DataSource=MondrianFoodMart;</DataSourceInfo>
<Catalog>FoodMart</Catalog>
<Content>Data</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

the tomcat log gives some extra info:

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
error: while counting members of level '[Customers].[Name]; sql=[select
count(*) from (select distinct "customer"."fullname" from "customer" as
"customer") as "init"]

any ideas?

thanks robert

--
Robert Lemmen http://www.semistable.com

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk1vpRUACgkQS6AOchRbaWavGwCdEMZzCY4yBJnv8XPJe6LfGYUY
afoAmgNn6PFKCR0bBFXMUHBk/mVmL7vC
=MQX3
-----END PGP SIGNATURE-----