AW: [opencms-dev] Setup problem

[Walter Weinmann]

Dear Alex,

yes I had the current drivers (classes12.jar - Oracle now delivers
additionaly a jar-file) in the oclib and the lib-directory. The user and the
tables are already created in the database - so I suppose it's not a problem
of JDBC drivers.

Best regards

Walter

-----Ursprüngliche Nachricht-----
Von: owner-opencms-dev at www.opencms.com
[mailto:owner-opencms-dev at www.opencms.com]Im Auftrag von Alexander
Kandzior
Gesendet: Mittwoch, 10. April 2002 13:49
An: opencms-dev at www.opencms.com
Betreff: RE: [opencms-dev] Setup problem


Hi Walter,

Do you have the Oracle native JDBC driver installed on your System? For
Oracle 8i it's a file called "classes12.zip" and it should be in
${TOMCAT_HOME}/webapps/opencms/WEB-INF/oclib where all the other OpenCms
.JAR files are.

This diriver does not come with the OpenCms disribution, because of
copyright restrictions from Oracle. If you don't have the file, you can
download it from the Oracle Technology Network http://otn.oracle.com/ on
this page
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html .

Best Regards,
Alex.

> -----Original Message-----
> From: owner-opencms-dev at www.opencms.com
> [mailto:owner-opencms-dev at www.opencms.com] On Behalf Of
> Walter Weinmann
> Sent: Tuesday, April 09, 2002 8:56 PM
> To: opencms-dev at www.opencms.com
> Subject: AW: [opencms-dev] Setup problem
>
>
> Dear Alex,
>
> in the meanwhile I've installed Oracle 9i - I've encountered,
> that the SQL-Procedures were based on Oracle 8i. I've also
> installed JDK 1.3.1_03. I tried to setup the system with
> Oracle OCI driver, but I got the following
> errors:
>
> 69:		at
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
> 68:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
> 67:		at com.opencms.boot.CmsMain.begin(CmsMain.java:159)
> 66:		at java.lang.reflect.Method.invoke(Native Method)
> 65:		at com.opencms.core.CmsShell.commands(CmsShell.java:168)
> 64:		at
> com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:65)
> 63:	java.lang.NullPointerException
> 62:
> 61:
> 60:	>	at
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
> 59:
> 58:	>	at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
> 57:
> 56:	>	at com.opencms.boot.CmsMain.begin(CmsMain.java:150)
> 55:
> 54:	>	at java.lang.Class.newInstance(Class.java:232)
> 53:
> 52:	>	at java.lang.Class.newInstance0(Native Method)
> 51:
> 50:	>	at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 49:
> 48:	>	at com.opencms.core.OpenCms.<init>(OpenCms.java:217)
> 47:
> 46:	>	at
> com.opencms.file.CmsRbManager.init(CmsRbManager.java:74)
> 45:
> 44:	>	at java.lang.Class.forName(Class.java:115)
> 43:
> 42:	>	at java.lang.Class.forName0(Native Method)
> 41:
> 40:	>	at
> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:310)
> 39:
> 38:	>	at java.lang.ClassLoader.loadClass(ClassLoader.java:250)
> 37:
> 36:	>	at
> com.opencms.boot.CmsClassLoader.loadClass(CmsClassLoader.java:571)
> 35:
> 34:	>java.lang.ClassNotFoundException:
> com.opencms.file.oracleplsql.CmsResourceBroker
> 33:		at
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
> 32:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
> 31:		at com.opencms.boot.CmsMain.begin(CmsMain.java:150)
> 30:		at java.lang.Class.newInstance(Class.java:232)
> 29:		at java.lang.Class.newInstance0(Native Method)
> 28:		at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 27:		at com.opencms.core.OpenCms.<init>(OpenCms.java:217)
> 26:		at
> com.opencms.file.CmsRbManager.init(CmsRbManager.java:98)
> 25:	[CmsException]: 33 Resourcebroker-init error. Detailed
> Error: Critical
> error while loading resourcebroker. . Caught Exception:
> >java.lang.ClassNotFoundException:
> com.opencms.file.oracleplsql.CmsResourceBroker<
> 24:	[OpenCms] Critical error while loading resourcebroker.
> 23:	[CmsRbManager] Critical error while loading resourcebroker.
> 22:	[CmsRbManager] ressourcebroker-classname:
> com.opencms.file.oracleplsql.CmsResourceBroker
> 21:	[CmsRbManager] ressourcebroker-name: oracleOci
> 20:	[OpenCms] initializing the main resource-broker
> 19:	[OpenCms] creating first cms-object
> 18:	[OpenCmsServlet] file.encoding: Cp1252
> 17:	[OpenCmsServlet] OS Info: Windows 2000 5.0 x86
> 16:	[OpenCmsServlet] JDK Info: Java HotSpot(TM) Client VM
> 1.3.1_03-b03 mixed
> mode Sun Microsystems Inc.
> 15:	[OpenCmsServlet] logging started
> 14:	%%% props: C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\config/opencms.properties
> 13:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\xerces-1_4_4.jar
> 12:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\Tidy.jar
> 11:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\opencms.jar
> 10:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\mm.mysql-2.0.4-bin.jar
> 9:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\mail.jar
> 8:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\jakarta-oro-2.0.4.jar
> 7:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\fesi.jar
> 6:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\classes12.jar
> 5:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib\activation.jar
> 4:	jarlist
> 3:	oclib folder: C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\oclib
> 2:	[CmsClassLoader] Adding repository C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\occlasses
> 1:	Collecting Repositories
> 0:	[CmsBase] Setting OpenCms home folder to
> C:\Programme\Apache Tomcat
> 4.0\webapps\opencms\WEB-INF\.
>
> Thanks for help
>
> Walter
>
> -----Ursprüngliche Nachricht-----
> Von: owner-opencms-dev at www.opencms.com
> [mailto:owner-opencms-dev at www.opencms.com]Im Auftrag von
> Alexander Kandzior
> Gesendet: Montag, 25. März 2002 12:47
> An: opencms-dev at www.opencms.com
> Betreff: RE: [opencms-dev] Setup problem
>
>
> Dear Walter,
>
> The "genericsql" driver will not work for Oracle because of
> issues relating to Date/Time data types. You have to choose
> "oracleOci" on the wizard interface. I currently have no
> Oracle DB available for testing, so I can not promise that
> setup with the wizard will work for Oracle at all. In case
> you are familiar with Oracle, you can try to setup the tables
> yourself. Have a look in
> {$TOMCAT-HOME}\webapps\opencms\WEB-INF\ocsetup\oracleplsql
> and check out the readme.txt there.
>
> Best Regards,
> Alex
>
> Alexander Kandzior
> OpenCms Group
>
> -----Original Message-----
> From: owner-opencms-dev at www.opencms.com
> [mailto:owner-opencms-dev at www.opencms.com] On Behalf Of
> Walter Weinmann
> Sent: Sunday, March 24, 2002 3:49 PM
> To: Opencms-Dev
> Subject: [opencms-dev] Setup problem
>
>
> Hello,
>
> I've downloaded opencms_4.6.0_major.zip, deployed the
> war-file to TOMCAT and added classes12.jar (JDBC Oracle
> Version 9.0.1) to WEB-INF\lib. If I try to setup openCMS
> (advanced, genericsql - database, tables, jdk and TOMCAT ok,
> no changes in parameters), I get the following error:
>
> 1225:	[CmsDbAccess] shutdown complete.
> 1224:	[com.opencms.dbpool.CmsPool] genericsqlonline: destroyed
> 1223:	[com.opencms.dbpool.CmsPool] genericsql: destroyed
> 1222:	[com.opencms.dbpool.CmsPool] genericsqlbackup: destroyed
> 1221:	{Admin at Online}> exit
> 1220:	{Admin at Online}> writeExportPath export/
> 1219:	Vector was null or empty
> 1218:	currentUser:[User]:Admin , Id=2 , flags=0 :the admin-user
> 1217:	PublishProject 2 CmsObject Time:Sun Mar 24 15:24:01 CET 2002
> 1216:	###################################
> 1215:	Vector of changed resources:
> 1214:
> 1213:		at
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
> 1212:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
> 1211:		at com.opencms.boot.CmsMain.begin(CmsMain.java:159)
> 1210:		at java.lang.reflect.Method.invoke(Native Method)
> 1209:		at com.opencms.core.CmsShell.commands(CmsShell.java:188)
> 1208:		at com.opencms.core.CmsShell.call(CmsShell.java:147)
> 1207:		at java.lang.reflect.Method.invoke(Native Method)
> 1206:		at
> com.opencms.core.CmsShellCommands.publishProject(CmsShellComma
> nds.java:2
> 090)
> 1205:		at
> com.opencms.file.CmsObject.publishProject(CmsObject.java:2318)
> 1204:		at
> com.opencms.file.genericSql.CmsResourceBroker.publishProject(C
> msResource
> Brok
> er.java:4464)
> 1203:		at
> com.opencms.file.genericSql.CmsDbAccess.publishProject(CmsDbAc
> cess.java:
> 5054
> )
> 1202:		at
> com.opencms.file.genericSql.CmsDbAccess.createFile(CmsDbAccess
> .java:934)
> 1201:		at
> com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.j
> ava:5868)
> 1200:	[CmsException]: 2 Not found. Detailed Error:
> [com.opencms.file.genericSql.CmsDbAccess]
> /default/vfs/system/workplace/administration/channels/EditBackoffice.
> 1199:	currentUser:[User]:Admin , Id=2 , flags=0 :the admin-user
> 1198:	PublishProject 2 CmsObject Time:Sun Mar 24 15:24:01 CET 2002
> 1197:	###################################
> 1196:	[CmsAccessFileMySql] Datengröße größer als max. Größe für diesen
> Typ:
> 9596
> 1195:	[CmsClassManager] clearing class instance cache.
> 1194:	{Admin at _setupProject}> publishProject 2
> 1193:	[CmsClassManager] clearing class instance cache.
> 1192:	Importing system/workplace/templates/js/opencms_timer.js OK
> 1191:	Importing system/workplace/templates/js/version.js OK
> 1190:	Importing system/workplace/templates/js/opencms_task.js OK
> 1189:	Importing system/workplace/templates/js/opencms_piclist.js OK
> 1188:	Importing system/workplace/templates/js/opencms_kontextmenu.js
> OK
> 1187:	Importing system/workplace/templates/js/opencms_edithtml.js OK
>
> What's wrong ?
>
> My configuration is:
> - Windows 2000 SP2
> - JDK 1.3.1_02
> - TOMCAT 4.0.3
> - Oracle 8.0.6
>
> Thanks for help
>
> Walter Weinmann
>
>
>
>
>