The Oracle Lite Blog

The Rekounas Blog about Oracle's Mobile Enterprise Application Platform

The Oracle Lite Blog header image 2

My last 2 years with Oracle Lite and Webtogo

April 26th, 2007 · No Comments

So, in the last 2 years of working with Webtogo in a international, web farmed environment; here are all the issues I encountered:

  • Oracle Lite did not work with UTF8… but does now
  • The customized workspace likes the use of absolute paths… even though it’s suppose to be your customized workspace! The servlets are hard coded in many cases to refer to files in directory /userinfo
  • Your Struts application can take a long time to load and take up a lot of your system resources on the client… read metalink note 412098.1
  • In a international environment, you need to ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=BYTE before running the repwizard. Don’t forget to do this when you are (re)publishing your application too.
  • If SQLCOMPATIBILITY is set to SQL92, your TO_NUMBER function doesn’t seem to work properly. You have to cast it cast(to_number('1210.73') as number(6,2))
  • When a client hasn’t sync’d in a long time or a lot of data is being deleted from their client database, you might need to set MaxSharedMemSize = 256 in the polite.ini file in the section [All Databases]
  • Consperf doesn’t display the correct cost in the explain plans. Oracle support is still looking at this.

In the last 2 years, I have opened 46 metalink support issues. 5 issues are still open.

Share

Tags: Oracle Lite · Webtogo

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment

*