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
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?
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
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.
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
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?
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.
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.
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.
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?
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?
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?
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.
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.
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.
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,
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.
33 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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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?
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
11 Lijo wrote on Aug 27, 2008 at 3:40 am
sorry its webtogo
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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?
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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).
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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?
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
26 Attila wrote on Oct 3, 2008 at 3:36 am
Hi!
If I choose the exit option, the install finish.
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
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
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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?
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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!
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
31 rekounas wrote on Nov 5, 2008 at 4:48 am
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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,
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
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.
View this Comment in: English Chinese(S) Chinese(T) French Arabic Dutch German Greek Italian Japanese Korean Portuguese Russian Spanish
Leave a Comment