[opencms-dev] setup problems in oracle database

[Ming Fai]

I encounter some different problems in different tries when setting up
OpenCMS in the OpenCMS Setup Wizard.

1. Using oracleOci resource Broker

It says:
 Trying to drop database ... Ok
 Creating database ... Ok
 Creating tables ... Failed

java.sql.SQLException: ORA-00900: invalid SQL statement
-------------------------------------------
java.sql.SQLException: ORA-00900: invalid SQL statement
-------------------------------------------
java.sql.SQLException: ORA-00900: invalid SQL statement
-------------------------------------------
java.io.FileNotFoundException:
/development/jakarta-tomcat-4.0.4/webapps/opencms/WEB-INF/ocsetup//
  ./oracleplsql/package_usertypes.sql (No such file or directory)
-------------------------------------------
java.sql.SQLException: SQL statement to execute cannot be empty or null
-------------------------------------------

I've checked and the *.sql files are there. What could be wrong?


2. Using generic jdbc resource broker, with Oracle thin jdbc driver

database can be dropped, created, and tables can be created. However, in the
workspace import stage, some errors come out. It seems all of them are about
"Data size bigger than max size for this type"


does anybody have suggestions to solve the problems? I'm prepare to work out
the OCI problem.

regards,
mingfai



1256:	[CmsDbAccess] shutdown complete.
1255:	[com.opencms.dbpool.CmsPool] genericsqlonline: destroyed
1254:	[com.opencms.dbpool.CmsPool] genericsql: destroyed
1253:	[com.opencms.dbpool.CmsPool] genericsqlbackup: destroyed
1252:	{Admin at Online}> exit
1251:	{Admin at Online}> writeExportPath export/
1250:	Vector was null or empty
1249:	currentUser:[User]:Admin , Id=2 , flags=0 , type=0 :the admin-user
1248:	PublishProject 2 CmsObject Time:Mon Aug 12 01:04:50 HKT 2002
1247:	###################################
1246:	Vector of changed resources:
1245:
1244:		at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:81)
1243:		at com.opencms.boot.CmsMain.startSetup(CmsMain.java:117)
1242:		at com.opencms.boot.CmsMain.begin(CmsMain.java:162)
1241:		at java.lang.reflect.Method.invoke(Native Method)
1240:		at com.opencms.core.CmsShell.commands(CmsShell.java:188)
1239:		at com.opencms.core.CmsShell.call(CmsShell.java:147)
1238:		at java.lang.reflect.Method.invoke(Native Method)
1237:		at
com.opencms.core.CmsShellCommands.publishProject(CmsShellCommands.java:2090)
1236:		at com.opencms.file.CmsObject.publishProject(CmsObject.java:2280)
1235:		at
com.opencms.file.genericSql.CmsResourceBroker.publishProject(CmsResourceBrok
er.java:4479)
1234:		at
com.opencms.file.genericSql.CmsDbAccess.publishProject(CmsDbAccess.java:5054
)
1233:		at
com.opencms.file.genericSql.CmsDbAccess.createFile(CmsDbAccess.java:934)
1232:		at
com.opencms.file.genericSql.CmsDbAccess.readFile(CmsDbAccess.java:5868)
1231:	[CmsException]: 2 Not found. Detailed Error:
[com.opencms.file.genericSql.CmsDbAccess]
/default/vfs/system/workplace/administration/channels/EditBackoffice.
1230:	currentUser:[User]:Admin , Id=2 , flags=0 , type=0 :the admin-user
1229:	PublishProject 2 CmsObject Time:Mon Aug 12 01:04:50 HKT 2002
1228:	###################################
1227:	[CmsAccessFileMySql] Data size bigger than max size for this type:
9596
1226:	[CmsClassManager] clearing class instance cache.
1225:	{Admin at _setupProject}> publishProject 2
1224:	[CmsClassManager] clearing class instance cache.

1145:	Importing system/workplace/templates/extended_backoffice Error:
[CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.genericSql.CmsDbAccess] Data size bigger than max size for
this type: 71422. Caught Exception: >java.sql.SQLException: Data size bigger
than max size for this type: 71422<

812:	Importing system/workplace/config/language/de/core_de Error:
[CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.genericSql.CmsDbAccess] Data size bigger than max size for
this type: 67171. Caught Exception: >java.sql.SQLException: Data size bigger
than max size for this type: 67171<

807:	Importing
system/workplace/administration/user/users/administration_content_users
Error: [CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.genericSql.CmsDbAccess] Data size bigger than max size for
this type: 32242. Caught Exception: >java.sql.SQLException: Data size bigger
than max size for this type: 32242<

687:	Importing system/workplace/administration/channels/channel_backoffice
Error: [CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.genericSql.CmsDbAccess] Data size bigger than max size for
this type: 31171. Caught Exception: >java.sql.SQLException: Data size bigger
than max size for this type: 31171<

447:	Importing pics/system/colortable.gif Error: [CmsException]: 4 Sql
exception. Detailed Error: [com.opencms.file.genericSql.CmsDbAccess] Data
size bigger than max size for this type: 16526. Caught Exception:
>java.sql.SQLException: Data size bigger than max size for this type: 16526<