PDA

View Full Version : help,can i connect to oracle8.0.6?



px7444
03-10-2003, 03:56 PM
i am using oracle8.0.6,i use the the following configuration,but it doesn't work.
jdbcDriver="oracle.jdbc.driver.OracleDriver"
jdbcUrl="jdbc:oracle:oci8:foodmart/foodmart@odas" catalogUri="/WEB-INF/queries/FoodMart.xml
browser report
Results: Error: /space/oracle/lib/liboci806jdbc.so: ld.so.1: /usr/j2se/bin/java: fatal: relocation error: file /space/oracle/lib/liboci806jdbc.so: symbol makeJavaString: referenced symbol not found
any one can help me?
by the way ,can i connect to oracle8.0.6 using jdbc thin mode?if i can ,where i put username and password?
thanks

jhyde
03-10-2003, 04:12 PM
Looks like you're not picking up a library, or finding the wrong version of one. Check your LD_LIBRARY_PATH variable.
Also make sure that your JDBC driver is certified with your JDK version (1.4, I presume).
I don't know what "thin mode" is. But note that mondrian connect strings can contain "JdbcUser" and "JdbcPassword" keywords, so this may help.

px7444
03-10-2003, 05:14 PM
thank you for your help ;
i say thin mode is like such "jdbc:oracle:thin:@192.168.0.213:1521:odas",i used this before.but i don't know where to put username or password.

jhyde
03-10-2003, 05:19 PM
At
http://www.experts-exchange.com/Programming/Programming_Languages/Java/Q_20234015.html,
I found an example of an oracle thin connect string containing username and password:
jdbc:oracle:thin:scott/tiger@localhost:1521:orcl8
But Mondrian's JdbcUser and JdbcPassword keywords should work OK too.

px7444
03-10-2003, 05:22 PM
thank you for your help ;
i say thin mode is like such "jdbc:oracle:thin:@192.168.0.213:1521:odas",i used this before.but i don't know where to put username or password.

px7444
03-10-2003, 05:45 PM
my configuration is
1.jdk1.4.0
2.oracle 8.0.6
3.for jdbc i tried classes111,zip get from oracle8.0.6's jdbc directory,and classes111,zip from oralce8i,classes12.zip from oracle8i,but none works
4.mondrian 0.5.
my LD_LIBRARY_PATH include the directory in which there is /space/oracle/lib/liboci806jdbc.so,
i hope i can use oci and thin to connect oracle8.0.6
i got such a error
Results: Error: Internal error: while creating RolapSchema (Provider=mondrian; Jdbc=thin:foodmart/
foodmart@192.168.0.213
:1521:odas; Catalog=jndi:/localhost/mondrian-0.5/WEB-INF/FoodMart.xml; JdbcDrivers=oracle.jdbc.driver.OracleDriver)
a day full of failure an sorrow:(