The Oracle Lite Blog

The Rekounas Blog about Oracle's Mobile Enterprise Application Platform

The Oracle Lite Blog header image 3

FAQ

I will attempt to answer your questions about Oracle Lite and Oracle here.

Share

109 Comments

109 responses so far ↓

  • 1 jaison antony wrote on Jun 23, 2008 at 6:06 pm

    We plan to use server initiated sync using oracle lite in our current project. Can you explain how the server initiated sync works?

    Does autosync agent makes a constant connection to server? How do we push server data changes to client in real time without client pull. What happens when the server tries to push data and there is no network available. What are the various protocols are used for the transport

    Much appreciated your help in this regard.

    We have little time left to decide between oracle and sybase solutions

    thanks

    Jaison Antony
    (516)803-2319


  • 2 John Gadbois wrote on Jun 27, 2008 at 8:49 am

    Have you ever seen a WTG-0310 error? I’m getting it while trying to publish a packaged jar.


  • 3 Wayne wrote on Jul 5, 2008 at 11:18 pm

    Hi,

    We have a Oracle Lite application that has resequenced the clients after a publication. I am wondering if there is a way of forcing a push of the server data to the clients whilst ignoring any transactions coming back from the client?

    Any assistance would be greatly appreciated.


  • 4 John Gadbois wrote on Jul 8, 2008 at 6:07 am

    Hi Gregg,
    I’m getting an error when trying to do an initial sync using the mSync API. The following is the error message:

    javax.servlet.ServletException: An internal error has occurred. Server busy

    Do you have any suggestions?

    Thanks,
    John


  • 5 John Gadbois wrote on Jul 8, 2008 at 7:25 am

    Hi Gregg,
    Another question? Is there a Java API to log into the mobile client? I haven’t been able to find one.

    Thanks,
    John


  • 6 Fabricio Gustavo wrote on Aug 7, 2008 at 12:05 pm

    how to extract ddl
    Hi, I would like to know if is there any way or tool to extract ddl database oracle lite?

    Thanks
    Excuse me for my english


  • 7 rekounas wrote on Aug 7, 2008 at 12:09 pm

    Hi Fabricio,

    Have you looked at the OLLOAD utility. It’s like sqlldr for oracle lite. I think that is what you are looking for right?


  • 8 lijo wrote on Aug 25, 2008 at 11:03 pm

    hi
    i want to increase the heap space for olite 10g client machine. Can u please tell about that?

    thanks
    Lijo


  • 9 rekounas wrote on Aug 26, 2008 at 2:48 am

    Hi Lijo,

    What type of client are you working with? And is it the database client or the webtogo or OC4J container?

    Thanks,

    Greg


  • 10 Lijo wrote on Aug 27, 2008 at 3:37 am

    its a ocjContainer . I specified -Xms512m -Xmx1024m in the webtogo.ora file in mobile server. But in the client environment we are dowloding a branchoffice and runing it.

    One more plz can u tell how to configure a webtogo server with eclipse. Plz help me with steps


  • 11 Lijo wrote on Aug 27, 2008 at 3:40 am

    sorry its webtogo


  • 12 rekounas wrote on Aug 27, 2008 at 4:54 am

    The file you want to modify is
    $ORACLE_HOME/j2ee/mobileserver/applications/mobileserver/setup/common/webtogo/webtogo.ora

    [WEBTOGO]
    JAVA_OPTION=-Djava.compiler=NONE -Xms256M -Xmx256M

    Do you have a webtogo application that you want to build with eclipse?

    Do you really need to allocate that much memory to the client? Or is this for the branch office administrator user? Are you running out of memory?


  • 13 Lijo wrote on Aug 27, 2008 at 9:53 pm

    ya i have a application. we used to start manually now just palniung to migrate to eclipse. but there is not server adapter available for this.

    I want to allocate memory to the client.


  • 14 Lijo wrote on Aug 27, 2008 at 10:49 pm

    First of all thanks for the solution its working properly now.

    Only eclipse part left


  • 15 Lijo wrote on Aug 28, 2008 at 5:29 am

    Hi, can you also tell how to configure the web to go sever in Jdeveloper.


  • 16 rekounas wrote on Aug 28, 2008 at 5:49 am

    Lijo, you can configure all those programs the way you would configure them for a deployment on any application server. I don’t have a step-by-step demo and I don’t know what architecture or framework you are using. The only part you need to be concerned about is the connection/connection pooling. You have to set up your datasource to use.

    http://download.oracle.com/docs/cd/B19188_01/doc/B15920/nvappdev.htm#sthref706

    There are better demos out there and when I find them, I will post them.

    You can use whatever IDE you choose, the deployment however has to be geared for OC4J or Webtogo (very similar).


  • 17 Lijo wrote on Aug 28, 2008 at 8:47 pm

    Thanks for the answer. Actually i was not able to configure the webtogo server in the application. I am using java in the application. I just want to configure the server


  • 18 rekounas wrote on Aug 29, 2008 at 12:59 am

    What version of the product are you using? And when you say “webtogo server”, are actually talking about the Mobile Server and not the software that is running on the client right?

    So, answer the following:

    What version of the product are you running?

    What type of deployment are you implementing? (Win32, Webtogo, OC4J)

    Are you running Oracle Application Server or Standalone more?


  • 19 Lijo wrote on Sep 1, 2008 at 1:26 am

    I am using oracle10g lite. the application is working on the webserver (WEBTOGO)

    I am not using any app server.

    in oracle lite 9i there was a java file
    [OravclePath]\Mobile\Sdk\wtgsdk\src\RunWebServer.java

    which was user to run the server in jdeveloper or eclipse but in 10g it doent exist.

    In eclipse how we add the tomcat server similarly i want to add webtogo (Mobile server) .

    Thanks
    Lijo


  • 20 rekounas wrote on Sep 1, 2008 at 2:53 am

    Hi Lijo,

    I think in the newer releases, that RunWebServer.java doesn’t work. I think I had tried it once and there are some methods that are either deprecated or removed entirely from the webtogo.jar file.

    So, I think your question is, “How do you get a webtogo application working with different application servers?”

    In JDeveloper, for example, you import your WAR file and then you set up your connection to use the polite driver instead of the webtogo driver for your database connection. The webtogo driver only works in the context of the Webtogo/OC4J environment. This should be the same in any other application server you are configuring. You can configure it to work with an Oracle driver and an Oracle database, but there are some Oracle specific JDBC methods that webtogo doesn’t support. This is why I recommend the Polite driver over the other two.


  • 21 Corintho wrote on Sep 15, 2008 at 5:36 am

    Hello!

    There was an application exemple using oracle lite + java or j2me?? unfortunately the exemples in oracla lite sdk using only vb.net 🙁


  • 22 rekounas wrote on Sep 15, 2008 at 5:50 am

    There is examples with J2ME and Java, .Net, and I believe there is a ADF/BC4J example in there as well on the SDK.


  • 23 Corintho wrote on Sep 15, 2008 at 6:08 am

    The exemples use java inside oracle lite like store procedures and etc… but I don’t find an application exemple in java or j2me, like the transport application in vb.net for Pocket pc.


  • 24 rekounas wrote on Sep 15, 2008 at 8:31 am

    Here is a quick sample of how to use the two Oracle Lite JDBC drivers:

    http://www.rekounas.org/2007/01/15/wtgjdbcdriver-vs-poljdbcdriver/

    If you are doing straight Java, not J2EE, you use the POLITE driver. If you are doing J2EE with the Webtogo or OC4J containers, you use the Webtogo Driver.

    Java programs in Oracle Lite work the same way as any other JDBC program. It’s just the driver that is different.


  • 25 Santiago wrote on Sep 23, 2008 at 12:24 pm

    Hi,

    Please help me, I got a problem published in Oracle Forums:

    http://forums.oracle.com/forums/thread.jspa?threadID=709883

    Regards,
    Santiago


  • 26 Attila wrote on Oct 3, 2008 at 3:36 am

    Hi!
    I need a little bit help! I’ve got a problem still installing the 11g Lite edition. In opposite with the install guide, I cannot add server options in the Reposiroty Wizard. But when I install the server and start the Wizard, it try to connect to the non-created database 🙂 If I choose the exit option, the install finish.
    After it I start the Mobile Server command line, I see, the next message: “Application: mobileserver does not exist. Error creating Web application: webtogo”. And the command line stopped.
    I don’t know what should I do, because it is almost a next-next-finish install wizar…
    Any idea?

    Thx your help!
    Bye and regards,
    Attila


  • 27 rekounas wrote on Oct 3, 2008 at 6:38 am

    The repwizard builds the database repository and deploys an application called mobileserver… basically the middle tier. Without that, you can’t do database replication.

    What exactly are you trying to accomplish? Do you just need the development kit, or do you need to install the server as well?


  • 28 Attila wrote on Oct 5, 2008 at 9:47 pm

    I would like to install a database server, where we can create databases. I downloaded this install kit from the Oracle web site, so I don’t know why is the difference between the installation and the install guide?
    Is this install kit appropriate?

    Thanks!


  • 29 rekounas wrote on Oct 6, 2008 at 1:51 am

    Mobile Server is a middle tier. You have to install a database first. If you need oracle lite to be your database, you install Embedded Oracle Lite. Or just install the Oracle Lite SDK.


  • 30 Kapil wrote on Nov 5, 2008 at 3:19 am

    Please explain the difference between “Oracle Lite Web” and “Oracle Lite Web OC4J” platforms.

    We are working on the requirement for a Mobile Application, which is already deployed on JBoss but we will be putting another instance on OAS for mobile users. We will have the same database being accessed from JBoss and OAS.


  • 31 rekounas wrote on Nov 5, 2008 at 4:48 am

    Please explain the difference between “Oracle Lite Web” and “Oracle Lite Web OC4J” platforms.

    Oracle Lite Web runs on a Servlet runner with limited technologies (Struts, Servlets, JSP, etc). Oracle Lite Web OC4J has all the capabilities of a J2EE application including JSF, EJB, ADF, etc.


  • 32 Narsi wrote on Nov 5, 2008 at 8:02 am

    I am running synchronization by runnig java program on linux. I am using Sync and Sync option classes. The synchronization process running succeful but after sync the program throws ocException and terminates before copy dabase files. This is happen only if the database files present in oldb40\ folder. I f I remove database files the sync is not giving any problem,


  • 33 rekounas wrote on Nov 5, 2008 at 8:30 am

    So, when you do an initial sync, you do not have an issue, but when you do an incremental you do?

    Set DEBUG=1 in SYNC section of the polite.ini before your next sync. There will be a debug#.txt generated from that sync. Examine the exception in the file to see what it is telling you.


  • 34 Vijayaraghavan K wrote on Dec 24, 2008 at 9:36 pm

    I have two questions

    1) Shall we able to rename the column in Oracle Lite. ( I am not able to rename the column with the below command whereas it works in oracle database edition. Alter table asset rename column asset_code to asset_id)

    2) Is it necessary to Install Oracle Application Server inorder to install Oracle Mobile Server.
    Is there are any documentation to Install Oracle Mobile Server.

    I am beginner for Oracle Mobile edition.

    Thanks
    Vijayaraghavan K


  • 35 rekounas wrote on Dec 25, 2008 at 1:30 am

    1. If you are talking about altering a synced table, the only way to alter its definition to rename the column is to use the APIs to drop and create the publication item again. There is an example in this post

    2. Oracle Application Server is not required for Mobile Server. If you have a suite of Oracle Applications, OAS would be your best solution for managing all the applications. But if you are only planning on using Mobile Server in a standalone environment, the standalone version will work.


  • 36 Dave R wrote on Jan 13, 2009 at 7:30 am

    We have deployed Oracle Lite 10g (webtogo) using remoteware to package the client files. when the user logs in for the first time and attempts a synch, the client asks if we want to update the client, we hit yes and in the middle of the update we get the error “c:\mobileclient\bin\webtogo.exe: the process cannot access the file becasue it is being used by another process.
    Any ideas how we can fix this?


  • 37 PALANI wrote on Jan 28, 2009 at 11:34 pm

    I have created a publication item using fast refresh mode. But when i check it in mobile server website, it says Complete refresh. ‘Cause :: client out of sync’ . It is taking 40 min to sync even though user changed only one record in oracle lite. Please help on this how to avoid this. in this scenario, I wanted only one record should be updated to main server instead of all records.


  • 38 Raghav wrote on Mar 10, 2009 at 12:02 am

    HI,For the first time we are using Olite and we need to develop jsp forms.I had read about web-to-Go. But my doubt is i shuld use J2EE or ADF for developing these new custom forms.
    If ADF where shuld i deploy these ADF components?

    i am new to this…Olite and MDB


  • 39 rekounas wrote on Mar 10, 2009 at 4:02 am

    Hi Raghav ,

    Oracle Lite has two types of deployments that fit your need. Webtogo and OC4J. Webtogo is a servlet runner meaning it will run JSPs and Servlets. So, you could develop your application using Struts which is basically JSP, Servlets. However, some J2EE features will not run in Webtogo such as EJBs. You can use a wider array of frameworks for OC4J. The OC4J version that comes with Oracle Lite is J2EE 1.3 compliant. You do not have to use ADF to build your application, but obviously Oracle will nudge you in that direction. There is a tutorial on how to build a ADF/BC4J application here.


  • 40 Sabyasachi Thakur wrote on Mar 12, 2009 at 3:40 am

    We are thinking of developing a retail POS software with open source platform for small retailers, which we will provide free of cost to them. We plan to develop the application on Java and UBUNTU linux for retailers, who will be given a PC with 2 GB RAM. There are 1000 such retail shops in 1st year and the same will scale up to 4000 in 3 years time frame. It will be on a distributed database architecture and am planning to have Oracle XE or Oracle Lite at retail POS.
    Each retailer will have internet connection with a VPN client. With this VPN they will be able to exchange data with the central Oracle enterprise server located beyond firewall.

    The product, customer and vendor masters will be replicated from HO to the clients for incremental changes daily . Summarised sales and inventory data from retail stores will be replicated to the Enterprise Oracle server centrally.

    Now I have seen Oracle XE at remote clients only support materialized views . Is it possible to use Oracle XE for the above mentioned case . Oracle Lite costs money and hence is not a preferred choice.

    Am looking at the best possible architecture for the above business requirement and your inputs will be of great help to me.


  • 41 rekounas wrote on Mar 12, 2009 at 4:19 am

    You should be able to use Oracle Lite’s Branch office technology. Oracle XE will be cheaper as it is free, but you will have to develop the synchronization methods between XE and EE.

    Branch Office is set up to work in a small network or office with up to 64 connected users. The users just need the client software on their machine and they can connect to the Branch Office machine. The BO machine then does synchronizations with the EE database.

    Am I correct in assuming this is what you want to accomplish?


  • 42 Sabyasachi Thakur wrote on Mar 12, 2009 at 10:33 pm

    Hi,
    Thanks for your response. In fact branch for me is a Point of sale terminal at retail store and sales and inevntory data from the store has to be exchanged with the HO database. Likewise master data from HO needs to be pushed to stores. I would like to know wehther data exchange by file transfer , by involving a staging server will be a better option compared to direct database replication between remote location and HO. If we are to use direct database replication, then the question is which database to be used Oracle lite or XE. Also XE has a 4GB limitation , not sure about Oracle Lite.


  • 43 rekounas wrote on Mar 13, 2009 at 6:04 am

    Oracle Lite has the 4 GB limitation on data. Indexes and BLOBs are stored in a separate data file and have a similar restriction.

    Oracle Lite is better for synchronization. But if you want replication, http://www.oracle.com/technology/products/dataint/index.html Oracle Advanced Replication is what you may want.

    Between the two, Oracle Lite synchronization fills a broader range of devices. It is easier to setup and administer as well. With Oracle Lite though, you have to be selective in what you synchronize though. Performance can be in issue if you are trying to replicate an entire EE database to a client machine.

    Data staging vs Synchronization, Synchronization wins hands down. You do have some limitations with Oracle Lite such as lack of PL/SQL. You stored procedures have to be written in Java, C++, or C#/.Net.


  • 44 Lijo Lawrance wrote on Mar 19, 2009 at 9:27 pm

    Hi rekounas,

    I want to deploy an application in Oraclelite 10g webtogo environment.

    is it possible to point the application to multiple schemas. if its is Plz tell me how

    Thanks
    Lijo Lawrance


  • 45 rekounas wrote on Mar 20, 2009 at 5:17 am

    Hi Lijo,

    When you create a publication item, you specify the table owner. You don’t have to do anything special.

    Here is what the java code looks like:

    cm.createPublicationItem(
    table.getName(), // name
    SCHEMA, // owner
    table.getStore(), // store
    table.getRefreshMode(), // refresh mode
    table.getSelectStmt(), // select stmt
    null, // callback package owner
    null); // callback package name

    The mobile workbench is basically the front-end to this call.


  • 46 Lijo Lawrance wrote on Mar 22, 2009 at 9:34 pm

    Hi rekounas,

    I am using branch office setup . so when i download it always points to only one schema.only i schema odb can be downloaded by the client

    thanks and regards
    Lijo Lawrance


  • 47 rekounas wrote on Mar 23, 2009 at 3:51 am

    You are correct. The oracle lite application consolidates the data down to one schema… SYSTEM. But, it can replicate across multiple schemas on the enterprise database.


  • 48 Lijo Lawrance wrote on Mar 24, 2009 at 4:35 am

    Hi


  • 49 Lijo Lawrance wrote on Mar 24, 2009 at 4:39 am

    Hi

    Can you please explain it more.
    i am using a smilar application for all schemas. but when i am publishing it using wtgapp i have to point the application to one schema. In branch office setup , i can download only for the last schema i have published the application. i want to put a single application which can point to multiple schema and while doing a branch office setup i need the odb to point to the schema of download.
    Thanks
    Lijo Lawrance


  • 50 Christian wrote on Mar 31, 2009 at 5:51 am

    OK. A new question from Germany…
    Greg, have you ever witnessed the POL-3207 “corrupted datapage detected” error?
    Have you any idea what causes is, or how it can be resolved easily, with emphasis on easily.
    Thanx
    Christian


  • 51 rekounas wrote on Mar 31, 2009 at 7:21 am

    Yes. I witnessed this on my own machine last week. I used the defragdb program to defrag my databases and that resolved the issue. Not sure what caused the issue though.


  • 52 Kallhands wrote on Apr 23, 2009 at 4:16 am

    Hello Greg. I’ve seen some OTN posts regarding silent install of the Win32 Mobile Client, though no “official” documentation of such seems to exist. Do you know if there is a method for silent install of the OC4J;US client to XP/Vista 32 platforms? Thanks in advance.


  • 53 rekounas wrote on Apr 23, 2009 at 4:50 am

    Hi Ken,

    The OC4J client is really just an extension of Win32. I will look for the parameters for silent install and post the results.

    I am currently working on a way to customize the OC4J installation.


  • 54 mARK wrote on Apr 30, 2009 at 7:55 am

    How do I start the transport application demo in Linux


  • 55 rekounas wrote on Apr 30, 2009 at 8:06 am

    Hi Mark,

    Isn’t the transport demo a .Net example?

    The synchronization basically works the same between Windows and Linux. But your front end application will have to be Java Swing or something like that. I don’t think there is an example for a Java application on Linux, but you could use their Oracle Lite Web or OC4J examples.


  • 56 jdkelly wrote on May 12, 2009 at 11:57 am

    Hi –

    Is there a way to create publications and publication items that will be persisted in oracle lite schemas other than “system”? For example, we’d like to keep lookup and data tables in schemas named “lookup” and “data”. I know msql can be used to “create schema” and “create user”, but don’t know how to create publications which will create those schemas when msync executes.

    Thanks!!


  • 57 rekounas wrote on May 12, 2009 at 12:32 pm

    Hi Jeff,

    Your question was:
    Is there a way to create publications and publication items that will be persisted in oracle lite schemas other than “system”? For example, we’d like to keep lookup and data tables in schemas named “lookup” and “data”. I know msql can be used to “create schema” and “create user”, but don’t know how to create publications which will create those schemas when msync executes.

    My response:
    You cannot synchronize data into schemas other then SYSTEM. You can create other schemas called LOOKUP and DATA by adding DDL scripts to your publication and deploying them. You will also need to add the DML to populate those tables, but they will not ever be synchronized unless you alter the publication item that holds those DDL/DML operations. I am thinking you are asking this because you have data that you do not want to compose for every user. In this case, you can use shared maps to help you out. Or you may be in a situation where your enterprise application is referencing LOOKUP.SOMETABLE in the SQL and you need to share this same function in your mobile application. If your case is the latter of the two, you may want to take a look at the use of synonyms.

    Here is an example:
    I have a table called SOMETABLE in the SYSTEM schema. You want SOMETABLE to be part of your LOOKUP schema. Replicate your table through the synchronization as every other publication. Then via adding DDL resource add a CREATE SYNONYM script for your table.

    Code Example:

    
    SQL> create schema test;
    
    Schema created
    
    SQL> CREATE SYNONYM TEST.SOMETABLE FOR SYSTEM.SOMETABLE;
    
    Synonym created
    
    SQL> SELECT COUNT(1) FROM TEST.SOMETABLE;
    COUNT(1)
    --------
       20679
    
    1 row(s) returned
    
    SQL>
    

  • 58 Jsahni wrote on Jun 3, 2009 at 6:22 am

    My setup is as follows:

    Oracle Database 10.2.0.4 on one server. This database has two schemas MOBILEADMIN and Application schema

    Mobile server on second server. This is installed on top of Oracle Application Server.

    I am trying to publish a jar file using packaging wizard but gives the following error :

    oracle.lite.sync.ConsolidatorException: CONS-10095: Cannot add or modify virtual primary key for a published store:: MOBILEADMIN.USERS

    This exception is raised for some other publication items as well, but all belong to Mobileadmin schema. I have also tried to create these publications using MDW tool. Using the tool I am able to create all the publication items which reside in application schema but the ones which are in Mobileadmin schema are not getting created.

    Please suggest.


  • 59 rekounas wrote on Jun 9, 2009 at 5:16 pm

    Jsahni,

    Make sure all your tables have a primary key.


  • 60 Martin wrote on Jun 23, 2009 at 12:13 pm

    Hi,

    is it possible to use alias (or virtual name) instead of the real name of the machine during the installation of olite. The installation doesn’t ask for the name we want to use, it take the real name of the machine. For failover we want to use another name. Can we “force” olite to take another name ?


  • 61 Christian wrote on Jul 1, 2009 at 11:26 pm

    Hi Greg,
    have you ever witnessed OLite deadlocking itself??

    //Christian


  • 62 Tom Watt wrote on Jul 23, 2009 at 5:03 pm

    One of our current sync problems is conflicts. The conflict flag is set to “S” so the records go into the CEQ$ tables. We are not sure why the data is already in the host tables but it usually is so we decided to let the client rule the show and set the conflict flag to “C”. I set it with the following api pgm.
    public class CLIENT_WINS_CAT
    {
    public static void main(String argv[]) throws Throwable
    {

    DriverManager.registerDriver ((Driver)Class.forName (“oracle.jdbc.driver.OracleDriver”).newInstance ());

    ConsolidatorManager cm = new ConsolidatorManager();

    cm.openConnection(“MOBILEADMIN”,”mobileadmin”,”jdbc:oracle:thin:@gator:1521:PSTCAT”);
    try
    {
    try{cm.removePublicationItem(“PSTLITEDB”, “FACILITY_MAINTENANCE”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCELOG”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCELOG_LINK”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCELOG_SUB”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCELOG_VEHICLES”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCEREQUESTCOC”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCE_CONDITION”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MANHOLECONDITIONEX”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MANHOLERECOMMENDATIONS”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MH_MAINTENANCE_ATTR”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “PIPERECOMMENDATIONS”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “PIPE_MAINTENANCE_ATTR”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “RESPONDING_UNITS”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “SSO_AGENCIES_NOTIFIED”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “SSO_REVISION_DICTIONARY”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “STOPPAGETAB1”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “STOPPAGETAB2”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “STOPPAGETAB3”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “STOPPAGETAB4”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “SYSTEMUSER”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MR_CHECKOUT”);}catch (Throwable e){e.printStackTrace();}
    try{cm.removePublicationItem(“PSTLITEDB”, “MAINTENANCE_GPS_LOG”);}catch (Throwable e){e.printStackTrace();}
    }
    catch (Throwable e)
    {
    System.out.println(“Error in removePubItem”);
    e.printStackTrace ();
    }
    try
    {

    try{cm.addPublicationItem(“PSTLITEDB”, “FACILITY_MAINTENANCE”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCELOG”, null, null, “C”, null, 100);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCELOG_LINK”, null, null, “C”, null, 490);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCELOG_SUB”, null, null, “C”, null, 103);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCELOG_VEHICLES”, null, null, “C”, null, 104);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCEREQUESTCOC”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCE_CONDITION”, null, null, “C”, null, 480);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MANHOLECONDITIONEX”, null, null, “C”, null, 440);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MANHOLERECOMMENDATIONS”, null, null, “C”, null, 430);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MH_MAINTENANCE_ATTR”, null, null, “C”, null, 450);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “PIPERECOMMENDATIONS”, null, null, “C”, null, 470);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “PIPE_MAINTENANCE_ATTR”, null, null, “C”, null, 460);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “RESPONDING_UNITS”, null, null, “C”, null, 2);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “SSO_AGENCIES_NOTIFIED”, null, null, “C”, null, 3);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “SSO_REVISION_DICTIONARY”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “STOPPAGETAB1”, null, null, “C”, null, 2);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “STOPPAGETAB2”, null, null, “C”, null, 2);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “STOPPAGETAB3”, null, null, “C”, null, 2);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “STOPPAGETAB4”, null, null, “C”, null, 2);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “SYSTEMUSER”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MR_CHECKOUT”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}
    try{cm.addPublicationItem(“PSTLITEDB”, “MAINTENANCE_GPS_LOG”, null, null, “C”, null, 1);}catch (Throwable e){e.printStackTrace();}

    }
    catch (Throwable e)
    {
    e.printStackTrace ();
    }
    cm.closeConnection();
    }
    }

    As you can see we removed the item and then added with the “C” flag. This seemed to work as expected but on the next sync the clients go “client of of sync” refreshes on all the items we changed and did not upload any updates from the client. We lost data that was entered after the last successful sync until the refreshs that occurred after the flag change.

    Once the refreshes were complete future updates were again uploaded.

    Please provide any insite you have on this issue. Maybe I just don’t understand the correct way to update Publication Items. I have tried to recreate this issue in our test system but have been unsuccessful.

    Thanks in advance, Tom


  • 63 Vikrant Yagnick wrote on Jul 30, 2009 at 9:10 pm

    Hi Greg,
    I am confused on the capabilities of the WebToGo OC4J container. This site and the forums claim that the OC4J container supports EJB’s. However, a Service Request with Oracle says that there is no EJB support. Can you provide an example(or point me to a link) where it is shown as how we can deploy a war file with WebtoGo OC4J.

    Thanks,
    Vikrant


  • 64 rekounas wrote on Jul 31, 2009 at 2:02 am

    Hi Vikrant,

    I have found a ADF EJB 3.0 example. I think Oracle Support may be correct in saying that their deployment does not support EJBs, but that doesn’t mean it can’t be done. After all, Webtogo-OC4J is running on a OC4J standalone environment.

    I have been meaning to put a blog post up about “How to deploy EJBs and EAR files”. So check back in a week or two on some progress.

    Thanks,

    Greg


  • 65 Archit wrote on Aug 17, 2009 at 4:59 am

    Hi,
    We have oracle lite application where we modify client data after applying it to server. We implemented AfterTranApply procedure for this requriement. But this modified data is not pushed to same client in subsequent compose or sync cycle. How do we force this data to client. Any help is greatly appreciated.

    Regards,
    Archit Kadakiya


  • 66 rekounas wrote on Aug 17, 2009 at 5:12 am

    Archit,

    So, you are changing data during apply phase and the compose phase is not picking it up?

    Does the change ever get to the client with subsequent syncs?


  • 67 Archit wrote on Aug 17, 2009 at 6:33 am

    Hi,

    First of all thanks for qucik reply. I see following:-

    1) Changes applied in server succesfully
    2) Data goes to client in subsequent syncs to other clients.
    3) Data never goes to client who initiated sync.

    Let me knwo if you need more details,

    Thanks,
    Archit


  • 68 Archit wrote on Aug 17, 2009 at 6:41 am

    Sorry for few typos in above message.


  • 69 rekounas wrote on Aug 17, 2009 at 8:32 am

    I came across this once and I had to set the publication item to complete refresh. Let me see if there is another way around it.


  • 70 Archit wrote on Aug 17, 2009 at 10:24 pm

    Hi,

    Complete refresh is not possible in our case due to high volume. We are investigating other possible approaches. Will update in case of success.

    Thanks for your reply,
    Archit.


  • 71 rekounas wrote on Aug 18, 2009 at 2:30 am

    In your customized package, do you have procedures for:

    BeforeCompose
    AfterCompose
    BeforeApply
    AfterApply
    BeforeTranApply
    AfterTranApply


  • 72 Archit wrote on Aug 18, 2009 at 10:17 pm

    Hi,

    Yes,I am implementing requried methods in my customized package. I am performing business logic in BeforeCompose method.

    Going through few rounds of testing and analysis, I found that CLID$$OWN column in respective CVR$ table of publication item controls data not being sent back to client which initiated sync. If any changes are made at sever side, this column stores NULL value and hence changes are sent to all clients. Further this column is populated by DML triggers on publication item using mobileadmin context (i.e. MOBILEADMIN.CONS_EXT.GET_CURR_CLIENT).

    With this understanding, solution working fine for me is as follows (in BeforeCompose method):-

    procedure BeforeCompose(clientname varchar2) as
    — UNSET CURRENT CLIENT in MOBILEADMIN CONTEXT
    MOBILEADMIN.CONS_EXT.SET_CURR_CLIENT(”);
    — EXECUTE BUSINESS LOGIC
    test_proc(clientname);
    — RESET CURRENT CLIENT in MOBILEADMIN CONTEXT for MGP to proceed normally
    MOBILEADMIN.CONS_EXT.SET_CURR_CLIENT(clientname);
    end BeforeCompose;

    Testing shows expected results so far.

    Let me know your comments.

    Thanks,
    Archit


  • 73 rekounas wrote on Aug 19, 2009 at 2:55 am

    Archit,

    I think you are correct. You have to tell the BeforeCompose Method that you have not downloaded a row yet.

    Is the solution working 100% for you now?


  • 74 Archit wrote on Aug 19, 2009 at 10:33 pm

    Hi,

    Yes, my soultion is working perfectly or atleast as requried/expected for my case. This solved my immediatie problem on hand. But let me know if you have some other workaround(solution) to the same problem.

    Thanks,
    Archit


  • 75 rekounas wrote on Aug 20, 2009 at 3:45 am

    Archit,

    Good to hear that your solution is working. The section in the documentation covering this topic feels like it is incomplete.

    I have run across this situation a couple of times and in my case, the tables and data were small. So setting to complete refresh was sufficient.

    I know complete refreshes aren’t desirable on the smaller devices but on Win32 and OC4J systems, they are sometime beneficial.


  • 76 Aravind wrote on Nov 2, 2009 at 10:14 pm

    Dear Rekounas,

    i have one small query about the enabling automatic synchronization.
    i have published the application via wtgpack ( oracle lite branch office )
    i have figured out that automatic sync is not enabled for my application
    is there any way to enable automatic sync to the already published application or should i have to do it from the beginning with MDW
    becoz i have already provided the weight and snapshot while publishing the application and more over there are nearly 300 tables in my application

    please clarify

    Regards,
    S.Aravind.


  • 77 rekounas wrote on Nov 3, 2009 at 5:40 am

    Hi S.Aravind,

    Thanks for a question.

    Before I answer this and you possibly pull out your hair and jump out the window… how many of those tables actually require an autosync?

    The reason that I ask is that wtgpack does not support the autosync feature and to create it with MDW or APIs, you have to drop the publication item and create it again.

    A code snippet of how to do it with the APIs is this:

    RuleInfo ri = Rules.RULE_MAX_DB_REC_ri;
    ri.params.put(Rules.PARAM_NREC,"5");
    String ruleText = cm.setSyncRuleParams(ri.type,ri.params);

    http://download.oracle.com/docs/cd/E12095_01/doc.10302/e12090/sync.htm#BCGBGFHG

    Let me know if you have questions on this.

    Greg


  • 78 Ashok Kumar.G wrote on Nov 12, 2009 at 9:11 pm

    Hi Rekounas,

    We are attempting to connect forms 10g to work with 10g Lite database and the need for it is given below.

    We have one system with 10g Forms, 10g AS & 10g Ent DB (online model).

    We are planning to integrate 10g Lite system with this system (online model) so that few users will work in offline model (Oracle Lite Technology) and existing users will still continue with the current system(Online Model).
    Both offline and online model will share the same database.

    We wanted to use the same Forms 10g screens in online model & offline model instead of developing a separate application in c#,java or .Net.

    Please help us in this regard.


  • 79 Archit wrote on Nov 17, 2009 at 8:35 pm

    Hi Rekounas,

    We are seeing “ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000” error for one of our webtogo application as number of publication items is more than 1000. Oracle accepted this as an bug but in mean time could you suggest some work around?

    Thanks,
    Archit Kadakiya.


  • 80 vikrant Yagnick wrote on Dec 5, 2009 at 4:08 am

    Hi Greg,

    In your post on “Testing Concurrent Synchronization in Oracle Lite” you mentioned that Oracle Support gave you a Perl Script to simualte N sync’s on one PC.

    Can, you post aht script on your website. It would really appreciate the help, as the other solution of setting up multiple PC’s with the SDK does not sound very sexy.


  • 81 Michael wrote on Dec 16, 2009 at 4:24 pm

    Hi Greg,

    We have a web application using j2ee deployed on a JBoss 4 server which is currently accessing an oracle db. The application eventually needs to continue to live on that server where users can access it and the use the oracle db, but when they disconnect from the server, they should sync the oracle db with the oracle lite db installed on their machine and use an application located on that server. Is there a way using the Oracle API’s to push the application, even as a war, to the users oracle lite application server or what approach should I be taking for this? I saw your code comparing the polite driver to the webtogo driver and I think that answered my question about how the app will decide which server to use and I saw in the java API the sync and sync option classes to synchronize the two db’s, but having the application live in two places is what is throwing me right now.
    Thanks,
    Michael


  • 82 Marcus B. wrote on Dec 31, 2009 at 8:40 am

    Hi Rekounas,

    I’m receiving a “POL-4800 can’t find the named object -4800:0” while trying to perform a client sync. This is happening on both my pre-prod and prod environments. I have tried with several different clients with the same result. My syncerr log states “..\..\ocapi\sysdbreaderwriter.cpp Line:297 rc:-4800” We are running 91Lite and patched to 5.0.2.8

    The error is occurring during the “Synchronize application data” process and webtogo seems to be crashing after the error is received.

    There was a similar post regarding this issue but took off into another direction.

    Your help with this matter would be much appreciated.

    Thanks in advance!

    -Marcus


  • 83 Marcus B. wrote on Dec 31, 2009 at 8:48 am

    Addition:

    mSync yeilds the same error in syncerr log.


  • 84 the yukon wrote on Jan 12, 2010 at 11:15 am

    I have used your tip for creating autoIncrement primary keys. It works well on my mobile Oracle Lite databases. However, when synchronizing (using Mobile Server and the msync utility) with a central database, new records (entered and synched from other clients) that I wish to have downloaded results in the before insert trigger being called again. Of course I do not want the before insert trigger to be called by msync, and regardless, the synchronization fails with “POL-8028 error in calling a Java method:”. This error seems to be due to the Connection conn parameter. How do I prevent triggers from being executed on the client when doing a synch?


  • 85 Chris wrote on Jan 18, 2010 at 12:46 am

    Hello,

    I get an error when opening mobile server:

    ERROR J2EE HTTP0004 Internal error raised tyring to instantiate web-application: webtogo defined in web site OC4J 10g (10.1.3) Default Web Site. Application: mobileserver does not exist. Error creating Web application: webtogo

    please help me


  • 86 dimagk wrote on Jan 20, 2010 at 2:54 am

    Hi Gregg,
    I am new in OLite. Our new app is synchronized from one table from the prod DB oracle 9.2 (character_set=el8iso8859p7), also in the polite.txt in pocket_pc we setup DB_CHAR_ENCODING= el8iso8859p7 (ALL_DATABASES) section
    and DB_ENCODING= el8iso8859p7 (SYNC)
    section. But after msync we get “?” in posket pc.

    Do we miss something in setup?

    Thanks a lot


  • 87 the yukon wrote on Feb 4, 2010 at 7:11 pm

    In Mobile Server I have multiple members which belong to more than one user. When using the msync utility in Oracle Lite 10.3.0.2, I can synchronize for a member by specifying the member and member’s password, and the “data owner” under the “User Context Options. I do not need to specify the data owner’s password.

    I want to build my own sync within my application, using the Java API.
    As far as I can see, the API includes a parameter for the user only, and no way to specify both the member and the “data owner”. Thus, in order to do a sync using the API, the application user, who is just a member, would need to know his data owner AND the data owner’s password. This is not a good thing, security-wise! Am I missing something in the API?


  • 88 Archit Kadakiya wrote on Apr 13, 2010 at 4:53 am

    Hi,

    I have a issue where webtogo application files downloaded to client has size 0 for many of the them. When checked on mobile server, I found proper application files are published and available for download. Could you point to possible reason for this?

    Thanks,
    Archit K


  • 89 Archit Kadakiya wrote on Apr 13, 2010 at 5:29 am

    Hi Rekounas,

    Thanks for quick reply. I am using Oracle Lite 10.3.0.2 with latest patch set. Yes, its webtogo-OC4j. I am packaging my application using packaging wizard and deploying it through mobile manager UI.

    Thanks,
    Archit Kadakiya


  • 90 guru wrote on Apr 26, 2010 at 5:51 am

    Please could you advice me : how could I try to connect Oracle Lite 10g R2/3 Database with
    Oracle Forms 10g. If have done, How do you connected the Oracle database
    into that applications. I have used Oracle forms 6i – have used adaptor to
    connect. Now I am not finding any J2CA/ADF/BC4J/AQ/etc.

    Please advise me.

    Thanks,
    Guru


  • 91 Archit Kadakiya wrote on May 17, 2010 at 6:27 am

    Hi Rekounas,

    Once again I am in need of your help for two issues (Oracle Lite 10.3.0.2) :-
    1) I am trying to reset password of webtogo-oc4j client using mobile devices-> Commands-> Reset password command from mobile manager. I understand that dmagent at client is responsible for pulling such commands. Even though dmagent is running on client, I see command still in queue in mobile manager. Is there any log created on server/client to check whether server tried to send the command/ client received and executed command? Any server/client configuration is required to use this feature?

    2) I want to verify user password when sync is triggered from client webtogo workspace. Any thoughts, how can I achieve this?

    Thanks,
    Archit Kadakiya


  • 92 Archit Kadakiya wrote on May 19, 2010 at 10:30 am

    Hi Rekounas,

    Thanks for quick response.
    1) Any enhancement in 10.3.0.3 for reset password? or can you suggest some workaround other than reinstalling application? We are going to deploy our offline application to a large insurer customer and we expect users to come up with reset password request very frequently?

    2) Also your thoughts on password verification before sync?

    Thanks,
    Archit Kadakiya


  • 93 Lijo Lawrance wrote on May 25, 2010 at 8:57 pm

    hi Rekounas
    I am trying to automate the file sync process of oracle lite. I have some doubts.

    1. Can i Bypass the oracle webtogo login in client and directly go to file sync.

    Thanks and Regards
    Lijo Lawrance


  • 94 Lijo Lawrance wrote on May 25, 2010 at 11:31 pm

    Hi Rekounas

    Is there any java file provided by oracle for doing the file base sync. I want to generate the file from client and send it to server.

    Thanks and Regards
    Lij Lawrance


  • 95 Archit Kadakiya wrote on Jun 9, 2010 at 7:26 am

    Hi Rekounas,

    Any idea when will oracle database lite 10.3.0.3 for AIX 5L will be available? Currently I see only downloads available for windows and Linux.

    Thanks,
    Archit K


  • 96 khadaree wrote on Jul 19, 2010 at 4:23 am

    Hi,
    can you suggest me a link for a java application working on oracle lite. I am trying since last week to sync with master database, but it is not happening.


  • 97 Paul wrote on Jul 22, 2010 at 11:55 pm

    Hi Rekounas,

    We have recently developed a java class to drop and create mobile publication. As I want to fully automate the process, is it possible to package and deploy the application through the API’s ? Also we sometimes have a requirment to just publish new version of the application with no need to publish snapshots. Is this possible please ?
    Regards, Paul.


  • 98 Marty Kuh wrote on Aug 28, 2010 at 9:44 am

    Hi Rekounas,
    I had a weird situation Friday. The compose stopped working. The apply phase is ok, but I can’t find a reason/error for the compose.

    i run a query against a table I know has dirty records but they don’t compose.
    select * from “MOBILEAPP”.”CVR$MDB_STOR_CNTC” where DMLTYPE$$ IN (‘I’);
    15 rows returned.

    I run:
    SELECT * FROM C$ALL_SID_LOGGED_TABLES WHERE DIRTY = ‘Y’
    ORDER BY 1,2

    and get 185 rows returned.

    Any help would be great. I see you are a Guru where I am just a “Grand Poo-Bah”


  • 99 herman wrote on Nov 4, 2010 at 12:52 am

    Hi Rekounas,

    I’ve been posting several threads on the OTN network, but am still hittin g solid rock when trying to sync my Pocket PC with a Oracle 10g Lite environment installed on it (the installation, performed apparently by the book, using WebToGo/Setup and ActiveSync to provide the Pcket PC client with the Ora 10g Lite software, is not a problem): when I run dmAgent and add the client server connection credentials the connection seems established because the client appears in the Mobile Devices screen within WebToGo, but when I try to run mSync (from the client) thereafter the mSync seems to be suspended: the screen is frozen and I cannot apply new input (it is “dead”), I can only escape by reverting to the windows environment or by manual restart. Can you help me out? I have one suggestion myself: the client OS is not what I thought it was, or something with the the Windows OS environment. How can I retrieve the applicable client OS (the client OS also appears in the Mobile devices page in WebToGo, but I suspect that it refers to the processor type and is not neccessarily the OS I need to install correctly on the “client” Pocker PC (it is a PDA/extended GSM-like device), Can you help me out with those questions?

    Greetings, Herman


  • 100 herman wrote on Nov 4, 2010 at 1:01 am

    Hi Rekounas,

    probably it is relevant to mention the client OS setups that I’ve aleady tried (and which failed): those are 1. Oracle Lite PPC2003 ARMV4 and 2. (after I noticed the OS parameter in the Mobile Device WebToGo page) Oracle Lite PPC2003 XScale.
    I published the application for a ARMV4x environment, because it seems that a publish for the XScale environment is not available (remarkable enough, because it looks contradictional to the list of possible OS’s that is supplied within WebToGo/Setup).

    Greetings, Herman


  • 101 Hakoo Desai wrote on Feb 15, 2011 at 11:04 am

    Hey,
    Big Hi from my side. I am new to J2ME and of course related to linked things also. I have installed Oracle 9 Express and Oracle 10g Lite on Windows. Can I use Oracle Lite/SQLite with J2ME and Synchronization facility? Do I need any specific platform like Symbian/ Blackberry?
    Kindly help me. Waiting for your answer.

    Thanking You,
    Hakoo Desai.


  • 102 Arun wrote on Mar 24, 2011 at 1:33 am

    I have created an Oracle Mobile ADF client with data sync. I have deployed this application to blackberry server. When I start the application, it asks for sync user credentials. I starts the data sync and throws the following exception

    ose exception: snap shot id 117 already exists. Any help on how to fix this?


  • 103 Stefan wrote on Jun 15, 2012 at 2:13 am

    We are using olite databases (Oracle lite 10.3.0.2.0) to provide offline access to data from our CRM system to our end users. Most databases were generated about two years ago and I was wondering what kind of maintenance should be applied to the databases (e.g. index rebuild, defragmentation, …) in order to keep them healthy and well performing. Our software provider mentioned a java parameter for index rebuild currently being set to 250 changes per table – does this seem reasonable and if not: what would be recommended?
    The client machines are set up with Windows XP or Windows 7 64 bit. The databases are between approx 200MB and 1.5 GB in size.


  • 104 rekounas wrote on Jun 15, 2012 at 3:36 am

    Are you noticing a performance decrease?


  • 105 Stefan wrote on Jun 15, 2012 at 3:43 am

    User have been complaining about bad offline performance and we have witnessed it in a web conf call. Whenever we set up a similar database at our site, however, it performs well. Long time for saving new records is one of the complaints we got (long means a couple of minutes).


  • 106 rekounas wrote on Jun 15, 2012 at 3:47 am

    Are you able to copy their DBs locally and execute the troublesome SQL? Inserts shouldn’t long at all. Unless there is some type of lock that it is waiting to release. This is Oracle Lite and not SQLite correct?


  • 107 Stefan wrote on Jun 15, 2012 at 3:57 am

    No, unfortunately not. They are located in locations (like Peru) quite far away from us in Europe and they have bad network connections. The offline DB is between 500 and 1000 MB. The offline DB version is Oracle lite 10.3.0.2.0


  • 108 rekounas wrote on Jun 15, 2012 at 4:04 am

    When you are performing a webex with the client, can you connect to their msql db and ensure that their indexes have actually been created on the db? In the past, I have found that if something fails during the initial build of the client db, then some actions don’t get triggered and the indexes/triggers/procedures/etc don’t get built. I would have to go back to the documentation on index rebuild parameter. I am not sure if that goes in the webtogo.ora or in the ini file on the client.


  • 109 kik for pc wrote on Jul 3, 2013 at 10:45 pm

    You’re so cool! I do not think I’ve read through anything like this before.
    So good to find another person with unique thoughts on this subject.
    Really.. many thanks for starting this up. This website is something that’s needed on the internet, someone with a little originality!


Leave a Comment

*