The Oracle Lite Blog

If you plan on attending Oracle OpenWorld 2008 in San Francisco this year, I will be at the Oracle Lite booth in the Oracle DEMOgrounds. More details as they become available. **Update: Location Information Venue: Moscone Center Exhibition Hall – Database Demo Grounds Station ID: L05 DEMOground Floor Plan

[Read more →]

I have posted a suggestion at Oracle Mix for an Oracle Lite session on sizing and performance tuning. If you plan on going to Oracle OpenWorld San Francisco 2008 and are interested in this topic, go to Performance Tuning and Sizing Oracle Lite for a Global Enterprise Application and cast your vote. I am waiting […]

[Read more →]

As the mobility market is increasing in popularity more companies are recognizing the value of pushing the current boundaries of enterprise applications to extend the reach into mobile computing. With the extension of the enterprise to mobile devices the strategy and technology used to support them has met the growing demand but offered some interesting […]

[Read more →]

Performance is often overlooked on a mobile database. Users are generally only dealing with thousands of rows instead of millions of rows, so not a lot of thought is spent on tuning a client database. I will show you a scenario where querying a table with 3600 hundred records can cause a fair amount of […]

[Read more →]

The last couple of weeks, for my own benefit, I have been looking at what products other then Oracle Lite do data synchronization between mobile devices and an enterprise database.  These products are: Sybase MobiLink IBM DB2 Everyplace Microsoft SQL Server Compact Edition (CE) From those 3, MobiLink and Everyplace are capable of syncing with […]

[Read more →]

I recently upgraded my WordPress and while I was at it, I decided to update my blog theme as well.  I change the images to be images from Oracle OpenWorld 2007 in San Francisco.  They were all pictures that I took. Let me know what you think of the new look.

[Read more →]

When you start designing an Oracle Lite solution, the very first thing you should think about after you determine that Oracle Lite is the path for your company, start thinking about performance. You are probably thinking, performance? This is Oracle Lite. I shouldn’t have to worry about performance tuning. Well, the truth of the matter […]

[Read more →]

Starting upgrading Webtogo to OC4J and here are my likes and dislikes so far:Likes: Full J2EE compliance Easier to develop and debug application code I can specify different JVM from the one that is installed last. Dislikes: Customized workspace is not supported (Although, I think I can get around that) WTGJDBCDriver is doing some really, […]

[Read more →]

Here is an example of how you deploy an application. I will follow it up with examples of how to add publication items to the application and adding users to the application as well. The following command should be all on one line: java -classpath .:$ORACLE_HOME/mobile/classes/consolidator.jar: $ORACLE_HOME/mobile/server/bin/devmgr.jar: $ORACLE_HOME/mobile/server/bin/webtogo.jar: $ORACLE_HOME/jdbc/lib/ojdbc14.jar Deploy MOBILEADMIN MOBILEPWD localhost 1521 XE […]

[Read more →]

Let me start by saying that this is not supported or will be supported by Oracle. If you are doing some R&D work and want to see how Oracle Lite will work, it will install on Oracle XE. And just in case you were still thinking of using this in your production system, get that […]

[Read more →]

The mobile system that I designed 2 1/2 years ago has been in production now for almost 6 months and as any new system that goes into production, changes are inevitable. When we designed the system, we had to come up with two applications that would be implemented both on a WebLogic/Sun ONE container and […]

[Read more →]

I was at Think NB a couple of weeks ago. Here is a picture of the OAO booth.

[Read more →]

Greg Rekounas, OAOT Oracle Solutions Architect and Oracle Lite Technology Leader, featured at Oracle OpenWorld 2007 GREENBELT, MD – November 13, 2007 – OAO Technology Solutions, Inc.(OAOT) announced that its Oracle Practice Area, part of the Strategic Business Solutions line of business, was featured at Oracle’s OpenWorld 2007 in San Francisco, CA. Greg Rekounas, an […]

[Read more →]

Finally! Got my Oracle OpenWorld Connect Card today.

[Read more →]

I have been invited to speak at Oracle Open World this year about Oracle Lite. My presentation information and schedule are as follows: Session ID: S291373 Session Title: Globalizing a Mobile Application with Oracle Database Lite (Featuring J2EE Technology) Track: INDUSTRIES; TECHNOLOGY; ORACLE DEVELOP; Automotive; Database; Java and Java Enterprise Edition; Database Application Development Room: […]

[Read more →]

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 […]

[Read more →]

Install either the Mobile Client or Mobile Development Kit. Launch JDev. Open the Connections Tab. Right-click on Database and click New Database Connection. Select Third Party JDBC Driver and click Next. Enter your username and password. If it is a replicated database, username is SYSTEM. For your url enter jdbc:polite:DSN. You will also have to […]

[Read more →]

I found a transaction test that I was performing a while back that might help you. In this example, I am using both drivers, I have an open connection with both drivers and I show an example of updating the dbname database with an insert and update statement. Note that even though I am using […]

[Read more →]

So, you are planning on downloading one of these two databases and aren’t quite sure which one suits your needs. Oracle XE is a scaled down version of Oracle’s flagship enterprise database. Some of the limitations are: 4GB database Maximum of 1GB of memory Cannot perform parallel processing of queries This is ideal for students, […]

[Read more →]

Ported a J2EE application this week to webtogo. I had an issue with my deployment due to the fact that I had an ‘_’ in my relative path. OJSP compiler translated that to ‘__’ and webtogo couldn’t find the package when I would reference the jsp. Also, noticed that the Webtogo Packaging Wizard doesn’t compile […]

[Read more →]