<br><font size=2 face="sans-serif">Hi all,</font>
<br>
<br><font size=2 face="sans-serif">I found a mistake in the URLs. Now they look like</font>
<br><font size=2 face="sans-serif">jdbc:oracle:oci8:@sid</font><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="sans-serif">But this leads to another error. OpenCms logs the following:</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Java VM in use : Java HotSpot(TM) Server VM 1.4.1_01-b01 mixed mode Sun Microsystems Inc. </font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Operating sytem : Windows 2000 5.0 x86 </font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Resource broker used : oracleOci</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Resource broker class: com.opencms.file.oraclesql.CmsResourceBroker</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Resource broker init : phase 1 ok - starting</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Resource broker init : phase 2 ok - initializing database</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Resource broker init : phase 3 ok - creating db access module</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Database access init : ok</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Database offline pool: jdbc:opencmspool:oracleOci</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Database online pool : jdbc:opencmspool:oracleOcionline</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Database backup pool : jdbc:opencmspool:oracleOcibackup</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Digest configured : MD5</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Digest file encoding : UTF-8</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:44] <opencms_init> . Using digest encoding: MD5 from SUN version 1.2</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Initializing registry: starting</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.0_start_und_meta</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.1_aktuelles_und_trends</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.2_leistungen_und_profil</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.3_werbemittel_und_formulare</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.4_vertrieb_und_kooperation</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.5_kurse_und_maerkte</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.6_vorstandslounge</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Loading module : de.sbroker.kompakt.reportings</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Initializing registry: finished</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Resource broker init : phase 4 ok - finished</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Found mime types : 127 entrys</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Legacy HTTP streaming: disabled</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_critical> . Critical init error/5: com.opencms.core.CmsException: [com.opencms.file.oraclesql.CmsDbAccess]Ungültiger Spaltentyp</font>
<br><font size=2 face="sans-serif">[21.08.2003 16:02:47] <opencms_init> . Session storage : initialized<br>
</font>
<br><font size=2 face="sans-serif">What has happened?</font>
<br><font size=2 face="sans-serif">Using just the JDBC Thin Driver there is no such error.</font>
<br><font size=2 face="sans-serif"><br>
Mit freundlichen Grüßen<br>
<br>
Thomas Breder<br>
<br>
____________________________________________________<br>
<br>
S Broker AG<br>
Information Technology<br>
<br>
Tel.: +49 (0)203/289-2120 (Duisburg)<br>
Tel.: +49 (0)611/2044-2120 (Wiesbaden)<br>
Fax: +49 (0)203/289-2099 (Duisburg)<br>
thomas.breder@sbroker.de<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Thomas.Breder@sbroker.de</b></font>
<br><font size=1 face="sans-serif">Gesendet von: opencms-dev-admin@opencms.org</font>
<p><font size=1 face="sans-serif">21.08.2003 12:44</font>
<br><font size=1 face="sans-serif">Bitte antworten an opencms-dev</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> An: opencms-dev@opencms.org</font>
<br><font size=1 face="sans-serif"> Kopie: </font>
<br><font size=1 face="sans-serif"> Thema: [opencms-dev] Oracle Problem</font></table>
<br>
<br>
<br><font size=2 face="sans-serif"><br>
Hi List,</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
we have a lot of trouble using the Oracle JDBC Thin Driver with OpenCms.</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
So, I switched the configuration to a JDBC OCI8 Driver. Oracle Client is installed an properly configured.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
I use the following URLs:</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
pool.oracleOci.url=jdbc:oracle:oci8:@my.db.host:port:sid</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
pool.oracleOcionline.url=jdbc:oracle:oci8:@my.db.host:port:sid<br>
pool.oracleOcibackup.url=jdbc:oracle:oci8:@my.db.host:port:sid</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
The first Access to OpenCms leads to the following exception</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
javax.servlet.ServletException: OpenCms initialization error!<br>
<br>
Could not connect to the database. Is the database up and running?</font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="sans-serif"><br>
...</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
>>>Root cause:<br>
>>>java.sql.SQLException: ORA-06401: NETCMN: ungültiger Treiberbezeichner<br>
>>> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)<br>
>>> at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)<br>
>>> at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:477)</font><font size=3 face="Times New Roman"><br>
</font><font size=2 face="sans-serif"><br>
Database is up and running.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="sans-serif"><br>
Any ideas??</font><font size=3 face="Times New Roman"> </font><font size=2 face="sans-serif"><br>
<br>
Mit freundlichen Grüßen<br>
<br>
Thomas Breder<br>
<br>
____________________________________________________<br>
<br>
S Broker AG<br>
Information Technology<br>
<br>
Tel.: +49 (0)203/289-2120 (Duisburg)<br>
Tel.: +49 (0)611/2044-2120 (Wiesbaden)<br>
Fax: +49 (0)203/289-2099 (Duisburg)<br>
thomas.breder@sbroker.de</font><font size=3 face="Times New Roman"><br>
<br>
<br>
<br>
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *<br>
S Broker AG * Beekstraße 38-42 * 47051 Duisburg<br>
service@sbroker.de * www.sbroker.de<br>
<br>
Sitz Wiesbaden * Amtsgericht Wiesbaden * HRB 20591 * BLZ 300 301 00<br>
<br>
Vorstand:<br>
Klaus Schöniger (Sprecher)<br>
Dr. Raoul G. Wild<br>
Karl-Martin im Brahm<br>
<br>
Vorsitzender des Aufsichtsrats:<br>
Dr. Harald Quensen<br>
<br>
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte <br>
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese </font>
<br><font size=3 face="Times New Roman">E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den <br>
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren <br>
sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.</font>
<br>
<br>
<font face="Helv" size=3 color=#000000 > </font><br>
<font face="Helv" size=3 color=#000000 ><br><br></font><font face="Helv" size=3 color=#000000 >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *<br>S Broker AG * Beekstraße 38-42 * 47051 Duisburg<br>service@sbroker.de * www.sbroker.de<br><br>Sitz Wiesbaden * Amtsgericht Wiesbaden * HRB 20591 * BLZ 300 301 00<br><br>Vorstand:<br>Klaus Schöniger (Sprecher)<br>Dr. Raoul G. Wild<br>Karl-Martin im Brahm<br><br>Vorsitzender des Aufsichtsrats:<br>Dr. Harald Quensen<br><br>Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte <br>Informationen. Wenn Sie nicht der richtige Adressat sind oder diese <br>E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den <br>Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren <br>sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.</font>