Hi,
I'm new to MMBase. And I think I can use some help with this issue :)
Is MMBase 1.5.1 (bin) (9 Jul 2002) Oracle 8.1.6 compliant?
I tried to let the server connect to a remote empty Oracle database but I get several errors of different kind (db user unknown mostly).
Before that I modified the jdbc.xml accordingly (I think).
These are the settings that I've tried, just for test purpose, but don't work:
<classfile>org.mmbase.module.database.JDBC</classfile>
<property name="url">jdbc:oracle:thin:@$HOST:$PORT:$DBM</property>
<property name="user">system</property>
<property name="password">manager</property>
<property name="supportclass">org.mmbase.module.database.DatabaseSupportShim</property>
<property name="database">mmbase</property>
<property name="connections">20</property>
<property name="driver">oracle.jdbc.driver.OracleDriver</property>
<property name="host">dbServer1</property>
<property name="port">1521</property>
<property name="querys">256</property>
- I created the database before I tried to connect to it.
- When using a db client such as Toad, connecting to the db etc with the same userid goes fine.
- I've added the classes12.jar to the mmbase classpath. The driver get's correctly loaded.
- but what about the "supportclass" property? which class do I have to define for OracleSupport?(MMOracle gives a classcast exception).
- when I use the above configuration and just change the username to "sa" and password to "", then the application connects to a local hsqldb server. So it seems that my db configuration seems to be ignored.
All help is more than welcome and will be appreciated!
Regards, Corry.
