[opencms-dev] Setup problem

[Alexander Kandzior]

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(CmsShellCommands.java:2
090)
1205:		at
com.opencms.file.CmsObject.publishProject(CmsObject.java:2318)
1204:		at
com.opencms.file.genericSql.CmsResourceBroker.publishProject(CmsResource
Brok
er.java:4464)
1203:		at
com.opencms.file.genericSql.CmsDbAccess.publishProject(CmsDbAccess.java:
5054
)
1202:		at
com.opencms.file.genericSql.CmsDbAccess.createFile(CmsDbAccess.java:934)
1201:		at
com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.java: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