[appengine-java] Backends

[Sandeep Heggi]

Java documentation is not clear. Backend Java Api Overview documentation is 
not helping me to use the Backend service in Java. Please provide a link 
where I can find an example explaining the usage of this service..

Thank you 

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/google-appengine-java/-/ORGIvm4G8wAJ.
To post to this group, send email to google-appengine-java@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Project Help

[Sandeep R Pai]

we are doing a project on chatting with our created application, in
that how to get gmail contacts of an user in java!?plz help

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-java@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Cloud2db for Cassandra and MongoDb

[Sandeep Sathaye]

Hi Everyone,

Cloud2db <http://www.cloud2db.com/> is pleased to announce the support for
Cassandra and mongoDB cloud database platforms in addition to Google
Bigtable platform which it already supports. With this new release you will
be able to transparently choose between Google Bigtable, Cassandra and
MongoDB as your cloud database platform.

Please download the Cloud2db software from the following link.

Download <http://cloud2db-server.appspot.com/website/download.html>(Google
Bigtable, Cassandra, MongoDB)

Cloud2db provides a standards-based abstraction layer over cloud databases.
This product provides you with performance and scalability of cloud platform
along with structure, standards and interoperability of RDBMS, SQL and JDBC.

With Cloud2db, you will be able to manage your data on cloud platforms by
using established concepts of RDBMS, SQL and JDBC, and thereby preserving
your existing investments in tools, technologies, frameworks and skills.

Here are Cloud2db features:

   - Manage data on Google Bigtable, Cassandra and MongoDB using familiar
   concepts of RDBMD, SQL
  - Referential integrity (Primary Keys, Foreign Keys)
  - Role Based Security
  - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
  - Subqueries (Exists, Not Exists, In)
  - DDL & DML
  - Transactions (for the datastores supporting transactions)
  - ANSI SQL stored functions
  - Views
  - BLOB and CLOB support (for the datastores supporting BLOBs)


   - Use any JDBC compliant tools and frameworks in the market to interact
   with the Google Datastore. For example.
  - Squirrel SQL (database management)
  - Power Architect (data modeling)
  - Jasper Reports (reporting)
  - Hibernate (Object To Relational mapping)
  - All JDBC compliant tools


   - Port exiting RDBMS instances to cloud databases

Please visit our website http://www.cloud2db.com and try out the free trial
version. Please visit google group
Cloud2db<http://groups.google.com/group/cloud2db> to
share your feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Enter Data using Queues/Task

[Sandeep Ghosh]

Hi,
   Thanx for your reply.But i dont know how to use task/Queues.can u plz
send me some example and steps i need to follow.
Thanx
Sandeep

On Mon, Aug 2, 2010 at 7:13 PM, John Patterson wrote:

> There is no way around the 30 second limit yet.  You must break up your
> work into tasks - probably start one task for each for each URL.  The
> Deferred library linked to below makes this easy to manage.
>
>
> On 2 Aug 2010, at 23:13, Sandeep Ghosh wrote:
>
> Hi,
>  Twig is good but the problem i am facing is that from the browser i am
> passing a load command as parameter like this
> *http://localhost:/sbphishlock?load*
> which tells my code that i need to load the data.
> now in the logic i have written few logic to process in a loop
> 1)Reads a csv file containg a list of URL's(may be 3000)
> 2)downloads each URL HTML pages and tokenize it
> 3)Creating a Object and storing in the database
>
> Problem is first 2 points itself takes a lot of time
> I think i need to use Task/Queues so that i can start a task for each url
>
> But i dont know what i need to do for task/Queues
> moreover is there any other way of doing this
> Can u help me regarding this
>
> Thanx
> Sandeep
>
> On Sun, Aug 1, 2010 at 1:25 AM, John Patterson wrote:
>
>> I mean "bulk put" - that is using DatastoreService.put(Iterable) or JDO's
>> makePersistentAll(...)
>>
>> If you do one call with many instances instead of many calls with one
>> instance it will be a lot faster.
>>
>> On 31 Jul 2010, at 14:49, Sandeep Ghosh wrote:
>>
>> Hi,
>>  can i do bulk load in Java.
>> Can you Please give me a sample code.
>>
>> Thanx
>> Sandeep
>>
>> On Fri, Jul 30, 2010 at 6:22 PM, John Patterson wrote:
>>
>>>
>>> On 30 Jul 2010, at 18:10, Sandeep Ghosh wrote:
>>>
>>>  Hi,
>>>>  I am facing promlem of entering many data into the Google App
>>>> engine database as its taking more then 30 sec time limit.
>>>>
>>>> PersistenceManager pm = PMF.get().getPersistenceManager();
>>>> for(;;)
>>>> {
>>>> EnterData data = new EnterData(key,value,new Text(totaData));//
>>>> EnterData is my class Entity
>>>> pm.makePersistent(data);
>>>> }
>>>>
>>>> How can i use the Tasks/Queues in this scenario
>>>>
>>>
>>> You could try using bulk put rather than making a datastore call for
>>> every iteration.
>>>
>>> You can also do many store operations in parallel if you use Twig like
>>> this:
>>>
>>> for (...)
>>> {
>>>datastore.store().instance(data).later();
>>> }
>>>
>>> this is an non-blocking async call that returns immediately and lets you
>>> run all your operations in parallel.
>>>
>>> Otherwise, to use task queues I would recommend using the Deferred
>>> library to chain tasks:
>>>
>>>
>>> http://groups.google.com/group/google-appengine-java/browse_thread/thread/6f736624cc820d5b
>>>
>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Google App Engine for Java" group.
>>> To post to this group, send email to
>>> google-appengine-j...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> google-appengine-java+unsubscr...@googlegroups.com
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/google-appengine-java?hl=en.
>>>
>>>
>>
>>
>> --
>> "Kind words can be short and easy to speak,
>> but their echoes are truly endless."
>> Mother Teresa
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> google-appengine-java+unsubscr...@googlegroups.com.
>> For more options, visit this group at
>> http://groups.google.com/group/google-appengine-java?hl=en.
>>
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> google-appengine-java+unsubscr...@googlegroups.com
>

Re: [appengine-java] Enter Data using Queues/Task

[Sandeep Ghosh]

Hi,
 Twig is good but the problem i am facing is that from the browser i am
passing a load command as parameter like this
*http://localhost:/sbphishlock?load*
which tells my code that i need to load the data.
now in the logic i have written few logic to process in a loop
1)Reads a csv file containg a list of URL's(may be 3000)
2)downloads each URL HTML pages and tokenize it
3)Creating a Object and storing in the database

Problem is first 2 points itself takes a lot of time
I think i need to use Task/Queues so that i can start a task for each url

But i dont know what i need to do for task/Queues
moreover is there any other way of doing this
Can u help me regarding this

Thanx
Sandeep

On Sun, Aug 1, 2010 at 1:25 AM, John Patterson wrote:

> I mean "bulk put" - that is using DatastoreService.put(Iterable) or JDO's
> makePersistentAll(...)
>
> If you do one call with many instances instead of many calls with one
> instance it will be a lot faster.
>
> On 31 Jul 2010, at 14:49, Sandeep Ghosh wrote:
>
> Hi,
>  can i do bulk load in Java.
> Can you Please give me a sample code.
>
> Thanx
> Sandeep
>
> On Fri, Jul 30, 2010 at 6:22 PM, John Patterson wrote:
>
>>
>> On 30 Jul 2010, at 18:10, Sandeep Ghosh wrote:
>>
>>  Hi,
>>>  I am facing promlem of entering many data into the Google App
>>> engine database as its taking more then 30 sec time limit.
>>>
>>> PersistenceManager pm = PMF.get().getPersistenceManager();
>>> for(;;)
>>> {
>>> EnterData data = new EnterData(key,value,new Text(totaData));//
>>> EnterData is my class Entity
>>> pm.makePersistent(data);
>>> }
>>>
>>> How can i use the Tasks/Queues in this scenario
>>>
>>
>> You could try using bulk put rather than making a datastore call for every
>> iteration.
>>
>> You can also do many store operations in parallel if you use Twig like
>> this:
>>
>> for (...)
>> {
>>datastore.store().instance(data).later();
>> }
>>
>> this is an non-blocking async call that returns immediately and lets you
>> run all your operations in parallel.
>>
>> Otherwise, to use task queues I would recommend using the Deferred library
>> to chain tasks:
>>
>>
>> http://groups.google.com/group/google-appengine-java/browse_thread/thread/6f736624cc820d5b
>>
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> google-appengine-java+unsubscr...@googlegroups.com
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/google-appengine-java?hl=en.
>>
>>
>
>
> --
> "Kind words can be short and easy to speak,
> but their echoes are truly endless."
> Mother Teresa
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
>  --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>



-- 
"Kind words can be short and easy to speak,
but their echoes are truly endless."
Mother Teresa

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Enter Data using Queues/Task

[Sandeep Ghosh]

Hi,
 can i do bulk load in Java.
Can you Please give me a sample code.

Thanx
Sandeep

On Fri, Jul 30, 2010 at 6:22 PM, John Patterson wrote:

>
> On 30 Jul 2010, at 18:10, Sandeep Ghosh wrote:
>
>  Hi,
>>  I am facing promlem of entering many data into the Google App
>> engine database as its taking more then 30 sec time limit.
>>
>> PersistenceManager pm = PMF.get().getPersistenceManager();
>> for(;;)
>> {
>> EnterData data = new EnterData(key,value,new Text(totaData));//
>> EnterData is my class Entity
>> pm.makePersistent(data);
>> }
>>
>> How can i use the Tasks/Queues in this scenario
>>
>
> You could try using bulk put rather than making a datastore call for every
> iteration.
>
> You can also do many store operations in parallel if you use Twig like
> this:
>
> for (...)
> {
>datastore.store().instance(data).later();
> }
>
> this is an non-blocking async call that returns immediately and lets you
> run all your operations in parallel.
>
> Otherwise, to use task queues I would recommend using the Deferred library
> to chain tasks:
>
>
> http://groups.google.com/group/google-appengine-java/browse_thread/thread/6f736624cc820d5b
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>


-- 
"Kind words can be short and easy to speak,
but their echoes are truly endless."
Mother Teresa

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Enter Data using Queues/Task

[Sandeep Ghosh]

Hi,
   I am facing promlem of entering many data into the Google App
engine database as its taking more then 30 sec time limit.

PersistenceManager pm = PMF.get().getPersistenceManager();
for(;;)
{
EnterData data = new EnterData(key,value,new Text(totaData));//
EnterData is my class Entity
pm.makePersistent(data);
}

How can i use the Tasks/Queues in this scenario

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Cloud2db for Amazon SimpleDB

[Sandeep Sathaye]

Hi Everyone,

Cloud2db <http://www.cloud2db.com/> is pleased to announce the support for
Amazon SimpleDB platform in addition to Google Bigtable platform which it
already supports. With this new release you will be able to transparently
choose between Amazon SimpleDB and Google Bigtable as your cloud database
platform.

Please download the Cloud2db Server and JDBC driver for Amazon SimpleDB and
Google Bigtable from the following links.

Download <http://cloud2db.appspot.com/website/download.html>(Google
Bigtable)
Download <http://cloud2db.appspot.com/website/downloadAws.html>(Amazon
SimpleDB)

Please refer to the following links to get started with Cloud2db.

Getting Started
<http://cloud2db.appspot.com/website/gettingStarted.html>(Google
Bigtable)
Getting Started
<http://cloud2db.appspot.com/website/gettingStartedAws.html> (Amazon
SimpleDB)

Cloud2db provides a standards-based abstraction layer over cloud databases.
This product provides you with performance and scalability of cloud database
platforms along with structure, standards and interoperability of RDBMS, SQL
and JDBC.

With Cloud2db, you will be able to manage your data on cloud platforms by
using established concepts of RDBMS, SQL and JDBC, and thereby preserving
your existing investments in tools, technologies, frameworks and skills.

Here are Cloud2db features:

   - Manage data on cloud databases using familiar concepts of RDBMD, SQL
  - Referential integrity (Primary Keys, Foreign Keys)
  - Role Based Security
  - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
  - Subqueries (Exists, Not Exists, In)
  - DDL & DML
  - Transactions (only for the datastores supporting transactions)
  - ANSI SQL stored functions
  - Views
  - BLOB and CLOB support (only for the datastores supporting BLOBs)


   - Use any JDBC compliant tools and frameworks in the market to interact
   with the cloud databases. For example.
  - Squirrel SQL (database management)
  - Power Architect (data modeling)
  - Jasper Reports (reporting)
  - Hibernate (Object To Relational mapping)
  - All JDBC compliant tools


   - Port exiting RDBMS instances to cloud databases

Please visit our website http://www.cloud2db.com and try out the free trial
version of our product by registering at
http://cloud2db.com/website/registration.html<http://cloud2db.appspot.com/website/registration.html>
. Please visit google group
Cloud2db<http://groups.google.com/group/cloud2db> to
share your feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] duplicates when updating a detached objects field which hold a collection

[Sandeep Arneja]

i am updating a field of a detached object which holds a collection.
every object in the collection have another collection.

upon updating i see duplicates. the old entires in the collection are
present as well as the new one. any ideas why?

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Hibernate support for Google App Engine (Cloud2db)

[Sandeep Sathaye]

Hi Everyone,

Cloud2db <http://www.cloud2db.com/> is pleased to announce the availability
of Hibernate framework on Google App Engine. Now you can use Hibernate to
access Cloud2db instances running on Google App Engine (Bigtable Datastore).
You can also use Hibernate tools like database reverse engineering plugin
directly against Cloud2db instances running on Google App Engine.

You will need to install Cloud2db and register your appspot prior to
deploying the Hibernate framework. Here are links to Download
<http://cloud2db.appspot.com/website/download.html>and
Registration<http://cloud2db.appspot.com/website/registration.html>
.

Here are the links to Hibernate distribution and a code sample.

http://cloud2db.appspot.com/website/distributions/hibernate_dist.zip
http://cloud2db.appspot.com/website/distributions/hibernate_sample.zip

Please deploy Hibernate JAR files and sample code in your GAE environment.

Please run the TestServer.java Servlet from the sample code to test the
Hibernate functionality. Please make sure that this Servlet is accessed as
an Admin resource by using the following entry in your web.xml file (use
your servlet URL in  tag).

  

 


   admin

  

Thanks,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Objectify - Twig - SimpleDS articles

[Sandeep Sathaye]

Hi Guillermo,

I agree with you completely. Here are my thoughts on the subject.

Relational theory, SQL and JDBC are functional specifications and RDBMS
vendors implement these specifications. Actually speaking data model has
nothing to do with technology. A data model in software engineering is an
abstract model that describes how data is represented and accessed. Data
models formally define data elements and relationships among data elements
for a domain of interest.

The tools which extrapolate proper strategy for storing and accessing data
on the underlying datastore based on the data model and expose it via SQL
and JDBC in both client/server and server mode have a great advandage. This
is our goal at Cloud2db. This abstraction layer also gives you complete
flexibility of choosing your underlying datastore. For example, we are about
to release Cloud2db Amazon SimpleDB and Hadoop Hbase implementations soon.

Thanks,

Sandeep.
On Tue, Mar 30, 2010 at 11:03 AM, Guillermo Schwarz <
guillermo.schw...@gmail.com> wrote:

> Andreas,
>
> I think there is more misunderstanding again.
>
> SQL can be run on top of a file system (fseek, read, write) or on top of a
> persistent hashmap (datastore).
>
> If you create a SQL interface on top of any of those, then it is a
> relational database, not a fake but a real relational database. Why would I
> want a relational database? Consistency, for starters. ACID transactions.
> Set operations.
>
> Read:
> 1. http://www.buzzle.com/articles/advantages-of-relational-databases.html
> 2. http://www.sunadal.co.uk/db.php
> 3. http://www.euclideanspace.com/software/information/relational/index.htm
>
> Working directly with aseembly code and bits may be what you prefer, but if
> history is correct, computer science is about building abstractions. Good
> abstractions. I agree that you can create the wrong tools for the job, but
> that doesn't stop other people to investigate and innovate to create better
> tools (better abstractions).
>
> BTW: You dont need to use JDBC directly when working with CloudDB or jiql.
> You can always select Hibernate, JDO or even JPA. The advantage of using an
> extra level of abstraction is that if later the DataStore changes or there
> is a new alternative to the DataStore that is faster (but has a new API) all
> you need to do is to reimplement SQL on top of it and voila: All your
> applications have been ported effortlessly. That's the whole point of using
> abstraction layers.
>
> Cheers,
> Guillermo.
>
>
> On Tue, Mar 30, 2010 at 10:49 AM, Andreas Borglin <
> andreas.borg...@gmail.com> wrote:
>
>>
>> Ok, you seem to misunderstand me quite a bit here.
>>
>> I never said it can't be used. I just said that I don't want to.
>> Other than for portability reasons, why would I want to pretend that
>> the datastore is relational by using a framework that emulates this?
>>
>> My main requirement, which was formed after using j...@gae, is that I
>> want to use a framework that has a natural mapping to the datastore.
>>
>> I'm not saying that there is anything wrong with JDO/JPA, cloud2db or
>> jiql in general. I'm just saying that, for me, it makes more sense to
>> use a framework that exposes the true nature of the datastore (which
>> is very different from a relational database), instead of hiding it
>> under a portable abstraction layer. Simplicity and performance is more
>> important than portability for me. That is of course not true for many
>> other projects, so I'm only speaking from my perspective.
>>
>> If you can argue that jiql (or any other multi-platform framework like
>> cloud2db, etc) can provide a natural mapping to the datastore AND be
>> as efficient as the low-level wrappers, I'm all ears. j...@gae didn't
>> do it for me at least.
>>
>> I never said that GWT had anything to do with SQL. I just don't want
>> to use JDBC.
>>
>> On Mar 30, 3:51 pm, Guillermo Schwarz 
>>  wrote:
>> > Andreas,
>> >
>> > I don't get it. You can use JDO and Hibernate with SQL. Given that
>> > jiql has a Hibernate config file, I guess using Hibernate with jiql
>> > would be so easy.
>> >
>> > What does GWT and JSP have to do with SQL anyway?
>> >
>> > Cheers,
>> > Guillermo.
>> >
>> > On 30 mar, 03:51, Andreas Borglin  wrote:
>> >
>> >
>> >
>> > > Hi again.
>> >
>> > > I had a look at jiql.
>> > > "jiql is a JDBC wrapper for accessing Google DataStore on Google App
>> > > Engine for JAVA.
>> > > jiql supports th

Re: [appengine-java] JIQL and SQL on appengine

[Sandeep Sathaye]

Hi Jeff,

You mentioned in your post about splitting your large requests into smaller
requests and then collate the results. This is exactly how Cloud2db JDBC
client driver works. For example if you have a large number of entities in
your datastore which you want to process. You can just write a standard sql
query and Cloud2db JDBC driver will handle splitting it into smaller chunks
and return you the results. You will never be hit by 30s request time limit.

You also mentioned about the GUI tools to access the data. All standard JDBC
client tools work seamlessly with Cloud2db JDBC driver. We use Squirrel JDBC
client extensively to access the data. This tool works very well.

Thanks,

Sandeep.
On Tue, Mar 30, 2010 at 4:51 AM, Jeff Schnitzer  wrote:

> Hey, so one of the things I complained about in Andreas' great article
> is the difficulty of doing analytics on appengine.  GAE is great for
> operational systems, but ad-hoc queries require writing a bunch of
> code that is further complicated by the
> queue-30s-write-temp-data-to-datastore-requeue process.  Painful.
>
> I miss being able to run SQL.  I *don't* miss writing code against
> JDBC, and I *don't* miss configuring Java<->SQL systems like
> Hibernate, but I do miss the SQL command prompt when I want to know
> how many users logged in last week or what they've been doing.
>
> I'm tantalized by systems like Cloud2db and Jiql but it seems like
> you're focusing on building operational systems with JDBC.  I'm much
> happier writing my operational code in java at the higher level of
> objects and getting the better fidelity of mapping to native
> operations that you will with Objectify, JDO, or whatnot.  Maybe there
> are people who still write JDBC apps but they've got to be a pretty
> masochistic lot.
>
> What I really want is a bit of software (perhaps a version) that I can
> deploy into my application, and a command line (or GUI) tool I can use
> on my local box.  The tool would take my SQL statements (including
> joins and aggregation functions), turn this into a series of 30s
> requests, collate the results, and print them.  It could take hours,
> fine - as long as it eventually comes up with the answer.  I'd be
> willing to pay several hundred dollars for a tool like this.
>
> Is there any chance that JIQL will go in that direction?  Or are you
> thinking along the lines of the Cloud2db folks, basically "all or
> nothing".  I don't want to write JDBC apps, I just want to
> occasionally run some ad-hoc SQL against my existing apps.
>
> Thanks,
> Jeff
>
> On Tue, Mar 30, 2010 at 12:51 AM, Andreas Borglin
>  wrote:
> > Hi again.
> >
> > I had a look at jiql.
> > "jiql is a JDBC wrapper for accessing Google DataStore on Google App
> > Engine for JAVA.
> > jiql supports the use of standard SQL as a method for accessing
> > the DataStore"
> >
> > Even if I had seen jiql earlier I wouldn't have considered it anyway
> > because,
> >
> > 1. I want the API to make perfect sense for working with the
> > datastore. "Standard SQL" doesn't meet this requirement.
> > 2. I use GWT. Not JSP or any other technology to dynamically generate
> > pages on server side.
> >
> > On Mar 29, 8:52 pm, Guillermo Schwarz 
> > wrote:
> >> One question: Why didn't you consider jiql?
> >>
> >>
> >>
> >>
> >>
> >> On Mon, Mar 29, 2010 at 1:04 PM, Blake  wrote:
> >> > +1
> >>
> >> > On Mar 29, 4:03 am, Andreas Borglin 
> wrote:
> >> > > Hi all.
> >>
> >> > > I recently decided to migrate away from JDO to one of the third
> party
> >> > > datastore frameworks. At first I had only heard about objectify, but
> >> > > after some further digging I  found out about 5 other frameworks as
> >> > > well (Twig, SimpleDS, siena, slim3, cloud2db).
> >>
> >> > > I was only interested in simple wrapper frameworks that acted as a
> >> > > convenience layer above the AppEngine low-level API. I _want_ the
> >> > > framework to expose the true nature of the datastore, but at the
> same
> >> > > time relieve the developer of the tedious tasks that's involved when
> >> > > working with the low-level API directly. It is much easier to work
> >> > > with the AppEngine datastore when its concepts, features,
> constraints
> >> > > and limitations are exposed directly. You can read more about the
> >> > > reasons for this in the article.
> >>
> >> >

Re: [appengine-java] Re: Objectify - Twig - SimpleDS articles

[Sandeep Sathaye]

Hi,

You can try Cloud2db also. Please see the website http://www.cloud2db.com.
This works with any JDBC client tools/frameworks like Squirrel,
PowerArchitect, Hibernate in a client/server mode. This also works on Google
App Engine server with native JDBC driver.

Thanks,

Sandeep.

On Tue, Mar 30, 2010 at 3:51 AM, Andreas Borglin
wrote:

> Hi again.
>
> I had a look at jiql.
> "jiql is a JDBC wrapper for accessing Google DataStore on Google App
> Engine for JAVA.
> jiql supports the use of standard SQL as a method for accessing
> the DataStore"
>
> Even if I had seen jiql earlier I wouldn't have considered it anyway
> because,
>
> 1. I want the API to make perfect sense for working with the
> datastore. "Standard SQL" doesn't meet this requirement.
> 2. I use GWT. Not JSP or any other technology to dynamically generate
> pages on server side.
>
> On Mar 29, 8:52 pm, Guillermo Schwarz 
> wrote:
> > One question: Why didn't you consider jiql?
> >
> >
> >
> >
> >
> > On Mon, Mar 29, 2010 at 1:04 PM, Blake  wrote:
> > > +1
> >
> > > On Mar 29, 4:03 am, Andreas Borglin  wrote:
> > > > Hi all.
> >
> > > > I recently decided to migrate away from JDO to one of the third party
> > > > datastore frameworks. At first I had only heard about objectify, but
> > > > after some further digging I  found out about 5 other frameworks as
> > > > well (Twig, SimpleDS, siena, slim3, cloud2db).
> >
> > > > I was only interested in simple wrapper frameworks that acted as a
> > > > convenience layer above the AppEngine low-level API. I _want_ the
> > > > framework to expose the true nature of the datastore, but at the same
> > > > time relieve the developer of the tedious tasks that's involved when
> > > > working with the low-level API directly. It is much easier to work
> > > > with the AppEngine datastore when its concepts, features, constraints
> > > > and limitations are exposed directly. You can read more about the
> > > > reasons for this in the article.
> >
> > > > This left me with objectify, Twig and SimpleDS. (siena and cloud2db
> > > > are multi-platform and slim3 is more than just a datastore framework)
> >
> > > > I spent some time researching these when I got the idea to write an
> > > > article about them. I contacted the authors for each framework and
> > > > asked if they would be interested in participating. Passionate as
> they
> > > > are, they agreed :-). Thanks to Jeff Schnitzer (objectify), John
> > > > Patterson (Twig) and Ignacio Coloma (SimpleDS) for this.
> >
> > > > The goal is to publish two articles; one interview with the authors,
> > > > and one where I solve some typical scenario with each framework.
> > > > The interview article has now been published and can be found
> athttp://
> > > borglin.net/gwt-project/?page_id=604.
> > > > The code example article will be posted sometime in the upcoming two
> > > > weeks.
> >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "Google App Engine for Java" group.
> > > To post to this group, send email to
> > > google-appengine-j...@googlegroups.com.
> > > To unsubscribe from this group, send email to
> > > google-appengine-java+unsubscr...@googlegroups.com unsubscr...@googlegroups.com>
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/google-appengine-java?hl=en.
> >
> > --
> > Saludos cordiales,
> >
> > Guillermo Schwarz
> > Sun Certified Enterprise Architect
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Unable to upload application

[Sandeep Sathaye]

I am having the same problem.

On Thu, Mar 18, 2010 at 6:26 PM, Peter Ondruska wrote:

> I am trying to upload my application but it fails everytime:
>
> com.google.appengine.tools.admin.AdminException: Unable to update app:
> Error posting to URL:
> https://appengine.google.com/api/appversion/create?app_id=f72dzzn5q5qt&version=2&;
> 500 Internal Server Error
>
> Server Error (500)
> A server error has occurred.
>
> at
> com.google.appengine.tools.admin.AppAdminImpl.update(AppAdminImpl.java:
> 62)
> at
>
> com.google.appengine.eclipse.core.proxy.AppEngineBridgeImpl.deploy(AppEngineBridgeImpl.java:
> 271)
> at
>
> com.google.appengine.eclipse.core.deploy.DeployProjectJob.runInWorkspace(DeployProjectJob.java:
> 145)
> at
>
> org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:
> 38)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
> Caused by: java.io.IOException: Error posting to URL:
>
> https://appengine.google.com/api/appversion/create?app_id=f72dzzn5q5qt&version=2&;
> 500 Internal Server Error
>
> Server Error (500)
> A server error has occurred.
>
> at
>
> com.google.appengine.tools.admin.ServerConnection.send(ServerConnection.java:
> 149)
> at
>
> com.google.appengine.tools.admin.ServerConnection.post(ServerConnection.java:
> 82)
> at
>
> com.google.appengine.tools.admin.AppVersionUpload.send(AppVersionUpload.java:
> 532)
> at
>
> com.google.appengine.tools.admin.AppVersionUpload.beginTransaction(AppVersionUpload.java:
> 349)
> at
>
> com.google.appengine.tools.admin.AppVersionUpload.doUpload(AppVersionUpload.java:
> 111)
> at
> com.google.appengine.tools.admin.AppAdminImpl.update(AppAdminImpl.java:
> 56)
> ... 4 more
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Authentication failure

[Sandeep Sathaye]

I implemented an automated login mechanism for accessing the database
product I am developing using ClientLogin URL (
https://www.google.com/accounts/ClientLogin).

My login mechanism was working fine for few weeks and it suddenly started
failing sometime last week with error "CaptchaRequired". Has anything
changed in ClientLogin interface during past few weeks? If that's the case,
how should I handle this scenario?

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Reporting on GAE in Java

[Sandeep Sathaye]

Try our product called Cloud2db . This works with
any JDBC complient client tools including JasperReports. Just install
Cloud2db on your appspot, create your tables and use provided JDBC driver
with JasperReports. Complete JasperReport suite will work including iReport.

On Thu, Mar 11, 2010 at 11:12 PM, David  wrote:

> Update:
>
> This website (http://www.jscriptive.org/2009/08/jasperreports-and-
> google-appengine.html) appears to confirm that it's a real issue
> rather than simply something I've done wrong or overlooked.
>
> This website (http://code.google.com/p/g2-report-engine/wiki/
> AppEngineSupport) seems to be a basic reporting tool that's
> specifically designed to work with GAE/J, albeit without the support
> of report building tools such as JasperReports' iReport.
>
> I'm still on the lookout for alternative reporting solutions if anyone
> can help me out?
>
> Cheers,
> David
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Objectify - Twig - approaches to persistence

[Sandeep Sathaye]

All these approaches are great but they lack structure, standards and
interoperability required to build large scale enterprise systems. The
better persistance approach is to build a database engine on top of Google
Datastore (Bigtable) which could be managed via a standard data model and
accessed via JDBC and SQL.
We have done that at Cloud2db . Please check it
out.
We just converted a database for an opensource issue tracking system called
JTRAC  from Mysql to Cloud2db without any change in
the datamodel. The JTRAC application uses Hibernate for object to relational
mapping. The JTRAC application now runs without a single line of code
change against Cloud2db instance on Google Datastore (Bigtable).

On Thu, Mar 11, 2010 at 1:02 PM, Bob  wrote:

> I've recently converted from JDO to Twig.  I've been able to remove an
> optimization hack that queried the datastore every 15 minutes to cache
> data from a 1+ minute operation.  I can now have end users execute
> essentially that same logic in real time.
>
> Have not tried Objectify so I can't comment on the comparison.  From a
> framework perspective I'm in the camp of "give me an easy and clean
> way to do what I do 80% of the time, and a low-level way to do
> anything else I need to do".
>
> -Bob
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Cloud2db - JDBC driver for Google Android platform

[Sandeep]

Hi Everyone,

Cloud2db is pleased to announce the availability of Cloud2db JDBC
driver for Google Android platform. With this driver you will be able
to access your Cloud2db instance from the Android applications using
standard JDBC concepts. Please download the Cloud2db Server and JDBC
driver from the following following link, 
http://cloud2db.appspot.com/website/download.html.

Cloud2db provides a standards-based abstraction layer over Google
Datastore (Bigtable).  This product provides you with performance and
scalability of GAE along with structure, standards and
interoperability of RDBMS, SQL and JDBC.

With Cloud2db, you will be able to manage your data on Google
Datastore by using established concepts of RDBMS, SQL and JDBC, and
thereby preserving your existing investments in tools, technologies,
frameworks and skills.

Here are Cloud2db features:

Manage data on Google Datastore using familiar concepts of RDBMD, SQL
. Referential integrity (Primary Keys, Foreign Keys)
. Role Based Security
. Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
. Subqueries (Exists, Not Exists, In)
. DDL & DML
. Transactions
. ANSI SQL stored functions
. Views
. BLOB and CLOB support

Use any JDBC compliant tools and frameworks in the market to interact
with the Google Datastore. For example.
. Squirrel SQL (database management)
. Power Architect (data modeling)
. Jasper Reports (reporting)
. Hibernate (Object To Relational mapping)
. All JDBC compliant tools

Port exiting RDBMS instances to Google Datastore

Please visit our website http://www.cloud2db.com and try out the free
trial version of our product by downloading it at
http://cloud2db.appspot.com/website/download.html. Please visit google
group Cloud2db to share your feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Best practices for datastore and JDO?

[Sandeep Sathaye]

Relational theory, SQL and JDBC are functional specifications and RDBMS
vendors implement these specifications. Actually speaking data model has
nothing to do with technology. A data model in software
engineering is
an abstract model  that
describes how data  is
represented and accessed. Data models formally define data
elements and
relationships among data elements for a domain of interest.

The principles you mentioned in your blog are correct but the difference is
that Cloud2db applies these principles without exposing these to designers
and developers. In short Cloud2db engine extrapolates proper strategy for
storing and accessing data based on your data model. There will be instances
where you will need to adjust your model for better performance. But don't
you do the same with RDBMS? Don't you de-normalize your models in certain
scenarios for better performance?

On Sat, Mar 6, 2010 at 9:49 AM, objectuser  wrote:

> I think the gap here is that a RDBMS (PostgreSQL) and the App Engine
> Datastore are totally different.  In fact, I think the latter
> influences your design much more than the former.
>
> The sorts of joins you used to be able to do in your DB to efficiently
> retrieve data don't work in the GAE datastore.  You need to build your
> data model around the queries you want to run efficiently.  To say
> again, your data needs to be modeled to support your most important
> queries.
>
> I go through some of the reasoning in the modeling section of my blog
> (I've been away from GAE for a while so some of this could have
> changed):
>
> http://objectuser.wordpress.com/google-app-engine/
>
> However, if you've not done so, I highly recommend reading the Google
> documentation:
>
> http://code.google.com/appengine/docs/java/datastore/
>
> On Mar 5, 6:54 am, vennervald  wrote:
> > Hi Guys
> >
> > We have a small application running on JBoss, Seam, Hibernate and
> > PostgreSQL that we are thinking about moving to GAE/J.
> > To test the datastore we uploaded our data 1-1 so all our tables from
> > Postgres were represented as entity types in the datastore with the
> > entities relating to eachother through their keys.
> > As a proof of concept of the performance of the datastore, we did an
> > implemented one of our heaviest reports by joining 6 entities
> > together. And the performance proved to be really bad. Infact we
> > received the deadline exception before we got to join all the
> > entities. From the platform we are running on now, this could be done
> > in less than a second.
> > This doesn't tell me that Google datastore is worthless. It tells me,
> > that I'm doing something wrong, and that I need to think differently
> > about the data structures to make it perform on GAE.
> > I've been looking around and I can't seem to find really good sources
> > on datastore/JDO best practises.
> > Does anybody have any good resources on this toppic?
> > I would really apriciate your help.
> >
> > /Jacob :)
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Best practices for datastore and JDO?

[Sandeep Sathaye]

Guillermo,

We have not formally published any benchmarks yet but here are some current
numbers for typical database operations. These tests were performed in
client/server mode using Cloud2db JDBC driver. Cloud2db JDBC driver has
ability to process queries/updates in incremental manner. This allows
Cloud2db to successfully execute queries/updates which process large amount
of data which would typically fail due to 30 sec request limit imposed by
GAE.

*Test 1: INSERT 1000 Rows in a table*

CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100));
INSERT INTO t1 VALUES(1,13153,'thirteen thousand one hundred fifty three');
INSERT INTO t1 VALUES(2,75560,'seventy five thousand five hundred sixty');
... 995 lines omitted
INSERT INTO t1 VALUES(998,66289,'sixty six thousand two hundred eighty
nine');
INSERT INTO t1 VALUES(999,24322,'twenty four thousand three hundred twenty
two');
INSERT INTO t1 VALUES(1000,94142,'ninety four thousand one hundred forty
two');

Time to process:   19 sec (53 records/sec)

*Test 2: UPDATE 1000 Rows from a table*

UPDATE t1 set b = b + 1;

Time to process:   25 sec ( 40 records/sec)

*Test 3: SELECT 1000 Rows from a table*

SELECT * FROM t1;

Time to process:   3 sec (333 records/sec)

*Test 4: SELECT 1000 Rows from two tables with join on indexed column*

CREATE TABLE t2(a INTEGER, b INTEGER, c VARCHAR(100));
INSERT INTO t2 VALUES(1,13153,'thirteen thousand one hundred fifty three');
INSERT INTO t2 VALUES(2,75560,'seventy five thousand five hundred sixty');
... 995 lines omitted
INSERT INTO t2 VALUES(998,66289,'sixty six thousand two hundred eighty
nine');
INSERT INTO t2 VALUES(999,24322,'twenty four thousand three hundred twenty
two');
INSERT INTO t2 VALUES(1000,94142,'ninety four thousand one hundred forty
two');

SELECT * FROM t1 INNER JOIN t2 on t1.a = t2.a;

Time to process:   9 sec ( 111 records/sec)

*Test 5: DELETE 1000 Rows from a table*

DELETE FROM t1;

Time to process:   21 sec ( 48 records/sec)

Thanks,

Sandeep.

On Fri, Mar 5, 2010 at 3:31 PM, Guillermo Schwarz <
guillermo.schw...@gmail.com> wrote:

> Sandeep,
>
> Have you run any TPC benchmarks against Cloud2db?
>
> Cheers,
> Guillermo.
>
> On 5 mar, 16:07, Sandeep Sathaye  wrote:
> > Hi Jacob,
> >
> > We just released a product called Cloud2db which could fit very well in
> your
> > architecture. Here are some details.
> >
> > Cloud2db Server provides a standards-based abstraction layer over Google
> > Datastore (Bigtable).  This product provides you with performance and
> > scalability of GAE along with structure, standards and interoperability
> of
> > RDBMS, SQL and JDBC.
> >
> > With Cloud2db, you will be able to manage your data on Google Datastore
> by
> > using established concepts of RDBMS, SQL and JDBC, and thereby preserving
> > your existing investments in tools, technologies, frameworks and skills.
> >
> > Here are Cloud2db features:
> >
> >- Manage data on Google Datastore using familiar concepts of RDBMD,
> SQL
> >   - Referential integrity (Primary Keys, Foreign Keys)
> >   - Role Based Security
> >   - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
> >   - Subqueries (Exists, Not Exists, In)
> >   - DDL & DML
> >   - Transactions
> >   - ANSI SQL stored functions
> >   - Views
> >   - BLOB and CLOB support
> >
> >- Use any JDBC compliant tools and frameworks in the market to
> interact
> >with the Google Datastore. For example.
> >   - Squirrel SQL (database management)
> >   - Power Architect (data modeling)
> >   - Jasper Reports (reporting)
> >   - Hibernate (Object To Relational mapping)
> >   - All JDBC compliant tools
> >
> >- Port exiting RDBMS instances to Google Datastore
> >
> > Please visit our websitehttp://www.cloud2db.comand try out the free trial
> > version of our product by registering athttp://
> cloud2db.appspot.com/website/registration.html. Please visit google
> > group Cloud2db <http://groups.google.com/group/cloud2db> to share your
> > feedback and thoughts.
> >
> > Sincerely,
> >
> > Sandeep Sathaye
> > Founder and Chief Architect
> > Cloud2db
> >
> > On Fri, Mar 5, 2010 at 7:54 AM, vennervald  >wrote:
> >
> > > Hi Guys
> >
> > > We have a small application running on JBoss, Seam, Hibernate and
> > > PostgreSQL that we are thinking about moving to GAE/J.
> > > To test the datastore we uploaded our data 1-1 so all our tables from
> > > Postgres were represented as entity types in the da

Re: [appengine-java] Best practices for datastore and JDO?

[Sandeep Sathaye]

Hi Jacob,

We just released a product called Cloud2db which could fit very well in your
architecture. Here are some details.

Cloud2db Server provides a standards-based abstraction layer over Google
Datastore (Bigtable).  This product provides you with performance and
scalability of GAE along with structure, standards and interoperability of
RDBMS, SQL and JDBC.

With Cloud2db, you will be able to manage your data on Google Datastore by
using established concepts of RDBMS, SQL and JDBC, and thereby preserving
your existing investments in tools, technologies, frameworks and skills.

Here are Cloud2db features:

   - Manage data on Google Datastore using familiar concepts of RDBMD, SQL
  - Referential integrity (Primary Keys, Foreign Keys)
  - Role Based Security
  - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
  - Subqueries (Exists, Not Exists, In)
  - DDL & DML
  - Transactions
  - ANSI SQL stored functions
  - Views
  - BLOB and CLOB support


   - Use any JDBC compliant tools and frameworks in the market to interact
   with the Google Datastore. For example.
  - Squirrel SQL (database management)
  - Power Architect (data modeling)
  - Jasper Reports (reporting)
  - Hibernate (Object To Relational mapping)
  - All JDBC compliant tools


   - Port exiting RDBMS instances to Google Datastore

Please visit our website http://www.cloud2db.com and try out the free trial
version of our product by registering at
http://cloud2db.appspot.com/website/registration.html. Please visit google
group Cloud2db <http://groups.google.com/group/cloud2db> to share your
feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db


On Fri, Mar 5, 2010 at 7:54 AM, vennervald wrote:

> Hi Guys
>
> We have a small application running on JBoss, Seam, Hibernate and
> PostgreSQL that we are thinking about moving to GAE/J.
> To test the datastore we uploaded our data 1-1 so all our tables from
> Postgres were represented as entity types in the datastore with the
> entities relating to eachother through their keys.
> As a proof of concept of the performance of the datastore, we did an
> implemented one of our heaviest reports by joining 6 entities
> together. And the performance proved to be really bad. Infact we
> received the deadline exception before we got to join all the
> entities. From the platform we are running on now, this could be done
> in less than a second.
> This doesn't tell me that Google datastore is worthless. It tells me,
> that I'm doing something wrong, and that I need to think differently
> about the data structures to make it perform on GAE.
> I've been looking around and I can't seem to find really good sources
> on datastore/JDO best practises.
> Does anybody have any good resources on this toppic?
> I would really apriciate your help.
>
> /Jacob :)
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] How to get application version from within code ?

[Sandeep Sathaye]

Try

com.google.apphosting.api.ApiProxy.getCurrentEnvironment()

On Wed, Mar 3, 2010 at 9:04 AM, JD  wrote:

> Is there anyway to get the application version  (from appengine-
> web.xml) ?
>
> In python the version is put in os environment, wondering if java has
> something similar.
>
> Thx
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Is there a way to interactively browse the content of bigtable in the development environment?

[Sandeep Sathaye]

Hi Christian,

We just released a product called Cloud2db which allows you to use any JDBC
client tool to interact with Google Datastore (Bigtable). Here are details.

Cloud2db Server provides a standards-based abstraction layer over Google
Datastore (Bigtable).  This product provides you with performance and
scalability of GAE along with structure, standards and interoperability of
RDBMS, SQL and JDBC.

With Cloud2db, you will be able to manage your data on Google Datastore by
using established concepts of RDBMS, SQL and JDBC, and thereby preserving
your existing investments in tools, technologies, frameworks and skills.

Here are Cloud2db features:

   - Manage data on Google Datastore using familiar concepts of RDBMD, SQL
  - Referential integrity (Primary Keys, Foreign Keys)
  - Role Based Security
  - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
  - Subqueries (Exists, Not Exists, In)
  - DDL & DML
  - Transactions
  - ANSI SQL stored functions
  - Views
  - BLOB and CLOB support


   - Use any JDBC compliant tools and frameworks in the market to interact
   with the Google Datastore. For example.
  - Squirrel SQL (database management)
  - Power Architect (data modeling)
  - Jasper Reports (reporting)
  - Hibernate (Object To Relational mapping)
  - All JDBC compliant tools


   - Port exiting RDBMS instances to Google Datastore

Please visit our website http://www.cloud2db.com and try out the free trial
version of our product by registering at
http://cloud2db.appspot.com/website/registration.html. Please visit google
group Cloud2db <http://groups.google.com/group/cloud2db> to share your
feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

On Sat, Feb 27, 2010 at 4:53 AM, Christian Schuhegger <
christian.schuheg...@gmail.com> wrote:

> Hello,
>
> is there a way to interactively browse the content of bigtable in the
> development environment? In principle I am looking for something like
> the quantum eclipse plugin for databases.
> http://quantum.sourceforge.net/
>
> Many Thanks,
> Christian
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Cloud2db (Universal database for cloud computing)

[Sandeep Sathaye]

Dear member:

Cloud2db <http://www.cloud2db.com/> is pleased to announce the availability
of Cloud2db Server which provides a standards-based abstraction layer over
Google Datastore (Bigtable).  This product provides you with performance and
scalability of GAE along with structure, standards and interoperability of
RDBMS, SQL and JDBC.

With Cloud2db, you will be able to manage your data on Google Datastore by
using established concepts of RDBMS, SQL and JDBC, and thereby preserving
your existing investments in tools, technologies, frameworks and skills.

Here are Cloud2db features:

   - Manage data on Google Datastore using familiar concepts of RDBMD, SQL
  - Referential integrity (Primary Keys, Foreign Keys)
  - Role Based Security
  - Joins (Inner Join, Left Outer Join, Theta Join, Cross Join)
  - Subqueries (Exists, Not Exists, In)
  - DDL & DML
  - Transactions
  - ANSI SQL stored functions
  - Views
  - BLOB and CLOB support


   - Use any JDBC compliant tools and frameworks in the market to interact
   with the Google Datastore. For example.
  - Squirrel SQL (database management)
  - Power Architect (data modeling)
  - Jasper Reports (reporting)
  - Hibernate (Object To Relational mapping)
  - All JDBC compliant tools


   - Port exiting RDBMS instances to Google Datastore

Please visit our website http://www.cloud2db.com and try out the free trial
version of our product by registering at
http://cloud2db.appspot.com/website/registration.html. Please visit google
group Cloud2db <http://groups.google.com/group/cloud2db> to share your
feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Re: Will a solution to the Java load latency come in Q2?

[Sandeep]

Hi,

One of the suggestions I have seen is to keep your home page as a
static HTML and as light as possible. This should enable loading app
within a couple of seconds even if the app is not loaded on any
server. Offcourse, if the kind of service provided through your site
and the user base demands faster first time load then what you are
asking is truly desirable.

Regards,
Sandeep

On Feb 24, 9:56 am, Timofey Koolin  wrote:
> Hello, for fast first load applications for user I set shedule for get
> main page of my application every minute.
>
> On Feb 23, 6:30 pm, Locke  wrote:
>
>
>
> > I plan on going live with my app in Q2, however, I can't subject my
> > users to App Engine's Java loading delays.
>
> > I recall that there has been talk of giving paying users the ability
> > to keep at least one instance of their Java apps "hot" at all times.
> > What are the chances of such a solution becoming available by the end
> > of Q2? If this solution or some other solution to this problem is
> > unlikely to be available in the next few months, I will reluctantly
> > have to begin porting my app to another platform.
>
> > Anyone know the status of this issue? Any info on the topic is
> > appreciated. Thanks.- Hide quoted text -
>
> - Show quoted text -

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Re: Help needed with Error

[Sandeep]

Couldn't derive anything useful from the other thread. I believe the
problem is with something on the server end and not the code.
Something that has been working for the last 4 weeks cannot crash so
abruptly in one screen and continue working on the other. Right now,
it seems like the entire datastore is down and I am facing this issue
in all my screens :(. Only the home page and static pages are working.

Thanks for the pointer though.

Regards,
Sandeep

On Feb 24, 8:50 pm, seleronm  wrote:
> Hi,
>
> This might be useful.
>
> Follow this 
> thread:http://groups.google.com/group/google-appengine/browse_thread/thread/...
>
> Please confirm.
> thanks.
>
> On 2月24日, 午後11:25, Sandeep  wrote:
>
>
>
> > I have been getting this error since my last deployment. Everything
> > works fine in my local setup but on the server it throws this
> > exception.
>
> > Caused by: java.io.NotSerializableException:
> > org.datanucleus.store.appengine.query.DatastoreQuery$2
> >         at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> >         at java.io.ObjectOutputStream.writeObject(Unknown Source)
> >         at java.util.ArrayList.writeObject(Unknown Source)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> >         at java.lang.reflect.Method.invoke(Unknown Source)
> >         at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
> >         at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> >         at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> >         at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> >         at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
> >         at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
> >         at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
> >         at java.io.ObjectOutputStream.writeObject0(Unknown Source)
> >         at java.io.ObjectOutputStream.writeObject(Unknown Source)
> >         at java.util.HashMap.writeObject(Unknown Source)
>
> > Check outwww.medavakkam.com/eGrocery
>
> > On click of Create new Order I get this error. The same datastore
> > calls are made in another flow and that is working fine.
>
> > Thanks & Regards,
> > Sandeep- Hide quoted text -
>
> - Show quoted text -

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Re: Deployment with Eclipse plug-in

[Sandeep]

Same here, haven't been able to deploy my updated app too.

java.io.IOException: Error posting to URL:
http://appengine.google.com/api/appversion/create?app_id=mdvk-chn&version=1&;
500 Internal Server Error



500 Server Error


Error: Server Error
The server encountered an error and could not complete your
request.If the problem persists, please report your problem and
mention this error message and the query that caused it.



at
com.google.appengine.tools.admin.ServerConnection.send(ServerConnection.java:
143)
at
com.google.appengine.tools.admin.ServerConnection.post(ServerConnection.java:
81)
at
com.google.appengine.tools.admin.AppVersionUpload.send(AppVersionUpload.java:
522)
at
com.google.appengine.tools.admin.AppVersionUpload.beginTransaction(AppVersionUpload.java:
339)
at
com.google.appengine.tools.admin.AppVersionUpload.doUpload(AppVersionUpload.java:
111)
at
com.google.appengine.tools.admin.AppAdminImpl.update(AppAdminImpl.java:
56)
at
com.google.appengine.eclipse.core.proxy.AppEngineBridgeImpl.deploy(AppEngineBridgeImpl.java:
271)
at
com.google.appengine.eclipse.core.deploy.DeployProjectJob.runInWorkspace(DeployProjectJob.java:
148)
at
org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:
38)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Also note: http://appengine.google.com/ is throwing 500 Internal
Errors. I do not think this is your app problem.

Regards,
Sandeep

On Feb 24, 9:00 pm, dominity  wrote:
> Hey, guys.
>
> Currently I've got this message during deployment.
>
> java.io.IOException: Error posting to 
> URL:http://appengine.google.com/api/appversion/create?app_id=caretransfer...
> 500 Internal Server Error
>
> 
> 
> 500 Server Error
> 
> 
> Error: Server Error
> The server encountered an error and could not complete your
> request.If the problem persists, please report your problem and
> mention this error message and the query that caused it.
> 
> 
>
> How does it be processed?
>
> Best regards, Alexander.

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Help needed with Error

[Sandeep]

I have been getting this error since my last deployment. Everything
works fine in my local setup but on the server it throws this
exception.

Caused by: java.io.NotSerializableException:
org.datanucleus.store.appengine.query.DatastoreQuery$2
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.writeObject(Unknown Source)
at java.util.ArrayList.writeObject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source)
at java.io.ObjectOutputStream.writeSerialData(Unknown Source)
at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source)
at java.io.ObjectOutputStream.writeObject0(Unknown Source)
at java.io.ObjectOutputStream.writeObject(Unknown Source)
at java.util.HashMap.writeObject(Unknown Source)

Check out www.medavakkam.com/eGrocery

On click of Create new Order I get this error. The same datastore
calls are made in another flow and that is working fine.

Thanks & Regards,
Sandeep

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Performance testing my App

[Sandeep]

Hi,

I wanted to know what is the procedure/notifications that need to be
followed to communicate to Google App support team in case I want to
run a performance test where I am going to be putting a load of 1000
users with 50 concurrent users.

Any inputs are appreciated!

Thanks in advance,
Sandeep

-- 
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Using Restlet to access datastore.

[Sandeep Sathaye]

You can access datastore through JDBC also. Please check this out.

http://www.cloud2db.com

On Wed, Jan 20, 2010 at 12:43 PM, Ikai L (Google)  wrote:

> Wow, Jeff, this actually looks pretty good. Did you write this? This is
> exactly the reason why we expose the low-level API!
>
> On Tue, Jan 19, 2010 at 7:28 PM, Jeff Schnitzer wrote:
>
>> Entities persisted with Objectify can be serialized in their entirety
>> (including keys) through GWT-RPC, so I'd be surprised if you had any
>> trouble using them with Restlet.  I have a number of times rendered
>> entity objects directly to JSON with JAX-RS, although there's no
>> reason you couldn't do that with JDO as well as long as you are really
>> careful about traversing object graphs.
>>
>> http://code.google.com/p/objectify-appengine/
>>
>> It's much lower level than JDO (and much more transparent about what's
>> actually going on under the covers) but still quite comfortable to
>> use.  It's also far easier to learn than JDO if you're starting from
>> scratch.
>>
>> Jeff
>>
>> On Tue, Jan 19, 2010 at 6:05 PM, Ikai L (Google) 
>> wrote:
>> > As far as I know, there isn't a native Restlet API for datastore access.
>> One
>> > more way to access the datastore is using the low-level API:
>> >
>> http://code.google.com/appengine/docs/java/javadoc/com/google/appengine/api/datastore/package-summary.html
>> > Typically, we only recommend using this API for framework builders.
>> Restlet
>> > is open source, so I'm sure if you contributed a great datastore API
>> they'd
>> > be happy to merge it.
>> >
>> > On Fri, Jan 15, 2010 at 1:56 PM, Mohammad Abdurraafay
>> >  wrote:
>> >>
>> >> Hey,
>> >>
>> >> I'm quite new to Google App Engine. But yeah, I'm trying to use
>> >> Restlet Framework to build RESTful Web Services. My question is, What
>> >> are all possible ways to access datastore? I know about JDO and JPA.
>> >> But I was wondering if I can use Restlet specific API to access
>> >> datastore. Please, if anyone tried it let me know.
>> >>
>> >> Thanks,
>> >> Abdurraafay.
>> >> http://bit.ly/Abdurraafay
>> >>
>> >> Sent from my iPhone
>> >>
>> >> --
>> >> You received this message because you are subscribed to the Google
>> Groups
>> >> "Google App Engine for Java" group.
>> >> To post to this group, send email to
>> >> google-appengine-j...@googlegroups.com.
>> >> To unsubscribe from this group, send email to
>> >> google-appengine-java+unsubscr...@googlegroups.com
>> .
>> >> For more options, visit this group at
>> >> http://groups.google.com/group/google-appengine-java?hl=en.
>> >>
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > Ikai Lan
>> > Developer Programs Engineer, Google App Engine
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> Groups
>> > "Google App Engine for Java" group.
>> > To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > google-appengine-java+unsubscr...@googlegroups.com
>> .
>> > For more options, visit this group at
>> > http://groups.google.com/group/google-appengine-java?hl=en.
>> >
>> >
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> google-appengine-java+unsubscr...@googlegroups.com
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/google-appengine-java?hl=en.
>>
>>
>>
>>
>
>
> --
> Ikai Lan
> Developer Programs Engineer, Google App Engine
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
-- 

You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group.

To post to this group, send email to google-appengine-j...@googlegroups.com.

To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Enforcing unique constraint

[Sandeep Sathaye]

GAE (Bigtable) doesn't support this kind of functionality. We have
implemented a relational database on top of GAE (Bigtable) which supports
referential integrity etc. Please check it out here,

http://www.cloud2db.com

On Mon, Jan 18, 2010 at 3:08 PM, Rusty Wright wrote:

> In your class, if you have a Collection of entities that you want to not
> have duplicates you can make it a Set, and be sure that you've provided a
> proper equals() and hashCode() for your entities; specifically, do not
> include the primary key because it starts out null when you instantiate the
> entity, and then is set after the entity is persisted.  I don't know if
> there is anything on the JDO or DataNucleus site that explains this but I do
> remember reading about it in either a Hibernate book or on the Hibernate
> site.
>
>
>
> tal wrote:
>
>> How do I enforce a unique constraint in GAE?
>>
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
>
>
-- 

You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group.

To post to this group, send email to google-appengine-j...@googlegroups.com.

To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] ImaHima looking for freelance Google App Engine/Java developer for Colabolo

[Sandeep Sathaye]

Hi Neeraj,

My name is Sandeep Sathaye. I am a founder of a company called Cloud2db. Our
product provides standards based access to Google Bigtable. If you are using
any traditional relational database as a back-end for your application we
could port it seamlessly to Google Bigtable. We also provide consulting
services (design, architecture and development) for various aspects of
Google App Engine environment.

Here is our website,

(http://www.cloud2db.com).

Thanks,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

On Sun, Jan 10, 2010 at 5:31 AM, Neeraj Jhanji  wrote:

> Hello,
>
> ImaHima is looking for senior Java developer(s) to help with the
> ongoing development of Colabolo. Colabolo is a light-weight issue-
> tracking service developed by ImaHima, a company based in Tokyo. You
> can see a quick video demo here:
> http://www.colabolo.com/en/product/index.html#video
>
> The front-end client of Colabolo is an Adobe AIR application. The
> backend of Colabolo runs on Google App Engine for Java. You will be
> developing for this exciting new platform. There is also an iPhone
> client.
>
> We require deep web application development experience with Java and
> database design skills. Experience with App Engine, BigTable, Ruby on
> Rails, Flex and iPhone will be a plus. Personal attributes like
> passion for learning, attention to detail, quest for excellence,
> flexibility and clear written and spoken English communication skills
> are very welcome.
>
> You are expected to work remotely with the international development
> team located in Japan, Sweden and India. We can offer monthly salary
> or hourly-rate compensation. If interested, please send your ideas
> about Colabolo, resume and information about past projects to
> supp...@colabolo.com
>
> Thank you for your interest.
>
> best regards,
>
> Neeraj
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
>
>
-- 

You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group.

To post to this group, send email to google-appengine-j...@googlegroups.com.

To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: Scope of datastores -- accessible across multiple GAE applications?

[Sandeep Sathaye]

An abstraction layer is required on top of Google Bigtable to achieve this
kind of functionality. We are trying to achieve this through JDBC & SQL
route. Please check out this link (http://www.cloud2db.com).
On Sun, Dec 27, 2009 at 11:29 PM, Riyad  wrote:

> Michael,
>
> I'm not sure I follow -- I was literally thinking in the sense of
> "what values do I put in my persistence.xml / hibernate.cfg.xml file
> to get this app to connect back to that particular singular
> datastore?" for each of my 3 or 4 apps that want to share that same
> singular source of data -- basically what the JDBC settings would be.
>
> Creating a public API that is exposed via web services or something is
> fine/great/etc -- just not the use-case I needed.
>
> Maybe it was a dump question and the nature of the GAE beast is that 1
> app gets 1 data store and everything is sandboxed just by virtue of
> how the system is designed/intended... I might just be thinking about
> this wrong.
>
> Also, Merry Christmas and Happy New Year to you as well!
>
> Thanks,
> Riyad
>
> On Dec 26, 7:52 am, mike s  wrote:
> > Merry Christmas.
> >
> > Surely an important use of cloud computing is creating services that
> > can be shared?
> >
> > So why not implement your "harvester" with an API that allows other
> > apps, including your own, to read the database?  i.e. other
> > applications connect to your datastore through your application rather
> > than some other magic.   Wouldn't that be safer anyway?
> >
> > Michael
> >
> > On Dec 25, 4:46 am,Riyad wrote:
> >
> >
> >
> > > bump
> >
> > > On Dec 23, 9:50 pm,Riyad wrote:> What is the
> definedscopeof a datastore as used by your JDO/JPA code
> > > > in a Java application deployed on GAE? Can you only insert/retrieve
> > > > data for a pre-defined datastore associated with your running app, or
> > > > can you connect to another application's datastore and
> insert/retrieve
> > > > data from that data store as well?
> >
> > > > Example:
> >
> > > > Consider a very large data-mining application written and deployed on
> > > > GAE as separate applications:
> >
> > > > 1. Harvester -- application scrubs the web all day long looking for
> > > > information and inserting it into it's data store. Lots of the new
> > > > experiemntal Task API used here.
> >
> > > > 2. Website -- website used by customers to search the compiled data,
> > > > create accounts, and do other compelling things with it -- like rank
> > > > it. This would be reading/updating data from App #1's datastore.
> >
> > > > 3. Admin -- website used by admins to manually modify the information
> > > > in the system -- again, manipulating the data from App #1's
> datastore.
> >
> > > > Is this possible? Or would I just have to model this entire
> > > > application as a single huge GAE application in order to allow all
> > > > those pieces to share access to the datastore that the Harvester
> > > > creates and maintains?
> >
> > > > Thanks for the assist guys.
> >
> > > > Best,
> > > >Riyad
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
>

--

You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Relational Table using JDO

[Sandeep Sathaye]

We have build a software product to provide such functionality. You can
check it out at http://www.cloud2db.com.

On Fri, Dec 25, 2009 at 9:36 PM, Michael Chan  wrote:

> You can do some sort of relational mappings between entities but not to the
> full extend like RDBMS.
>
> Have you worked through the examples in
> http://code.google.com/appengine/docs/java/datastore/ yet?
>
>
>
> On Fri, Dec 25, 2009 at 9:36 PM, TiagoP  wrote:
>
>> Hi all,
>>
>> I have a simple doubt that I would like to see explained.
>>
>> I know a bit of relational databases but I don't understand how I can
>> do the same using JDO.
>>
>> As for example, I have a table users-plans which combines the table
>> user to the table plans. In table plans I have all the plans and I
>> just match it to the user in a "middle table".
>>
>> Could someone explain how this would work in GAE?
>>
>> Thanks and Merry Christmas!
>>
>>
>>
>> --
>>
>> You received this message because you are subscribed to the Google Groups
>> "Google App Engine for Java" group.
>> To post to this group, send email to
>> google-appengine-j...@googlegroups.com.
>> To unsubscribe from this group, send email to
>> google-appengine-java+unsubscr...@googlegroups.com
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/google-appengine-java?hl=en.
>>
>>
>>
>
>
> --
> Regards,
>
> Michael Hoi Sang Chan
>
> MSc Advanced Software Engineering
> Department of Computer Science
> King's College London
> Strand, LONDON
> WC2R 2LS
>
> Tel: +447881900965
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>

--

You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

Re: [appengine-java] Re: select count(*) ?

[Sandeep Sathaye]

Please check this out. You should be able to do queries returning greater
than 1000 rows. Obviously we have to work with google bigtable constraints
of 1000 rows etc. But our product does incremental queries to get you
desired results.

http://www.cloud2db.com

On Thu, Dec 17, 2009 at 6:12 PM, king  wrote:

> can anyone shine some lights on when the java datastore export will be
> available?
>
> On Dec 2, 11:19 am, king  wrote:
> > Jason, do you have a timeline for when:
> > 1. the cursor feature will be available?
> > 2. the data download feature be available for JAVA (not Python).
> >
> > On Oct 21, 10:54 am, "Jason (Google)"  wrote:
> >
> >
> >
> > > The query restrictions are an artifact of the way App
> Engine'sdatastoreis
> > > constructed, which makes certain operations (e.g. queries and reads)
> very
> > > fast and scalable but does limit the types of queries you can make,
> though
> > > you can typically get around these restrictions by re-thinking your
> model a
> > > bit.
> >
> > > We are working on adding built-in cursor support for easier paging
> through
> > > entities and have just added adatastorestatistics API for, among other
> > > things, getting the total entity count, even if it exceeds 1,000. More
> > > details here:
> >
> > >http://code.google.com/appengine/docs/java/datastore/stats.html
> >
> > > And we also have a dataexportutility included with the SDK to make it
> > > easier for you to back up or even move off of App Engine should you
> choose
> > > to, and we're continuing to look at ways of making App Engine,
> particularly
> > > thedatastorecomponent, easier to use.
> >
> > >http://code.google.com/appengine/docs/python/tools/uploadingdata.html.
> ..
> >
> > > - Jason
> >
> > > On Mon, Oct 19, 2009 at 1:53 PM, vetch  wrote:
> >
> > > > On 6 Paź, 10:03, "Jason (Google)"  wrote:
> > > > > * Because App Engine queries can only return up to 1,000 results,
> > > > > count(this) will never return above 1,000, even if you have more
> than
> > > > 1,000
> > > > > entities, so bear this in mind.
> >
> > > > I'm deeply shocked. This works like some black hole.
> >
> > > > You put your data there simply, but can't get them back that simply.
> >
> > > > In connection with restricions (inequality property filter), it is
> > > > even harder to get anything more complex.
> >
> > > > BiGAppEngine disappointment.
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "Google App Engine for Java" group.
> To post to this group, send email to
> google-appengine-j...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine-java+unsubscr...@googlegroups.com
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine-java?hl=en.
>
>
>

--

You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Cloud2db (Universal database for cloud computing)

[Sandeep]

Dear member,

My name is Sandeep Sathaye. I am a founder of a company called
Cloud2db. We have developed a product, which allows for an immediate
adaption of cloud database technologies into your enterprise
technology stack. This is truly a plug-and-play into the cloud
database technologies.

What is it?
Cloud2db is a universal database for cloud computing. Cloud2db brings
relational database functionality to cloud computing platforms by
bridging the gap between cloud database technologies and relational
database technologies.  Our product works seamlessly with most of the
popular cloud database technologies like Google Bigtable, Amazon
SimpleDB & Hadoop HBase and it also supports the relational database
standards ANSI SQL-92/ANSI SQL-99 and JDBC 3.0.

What Sets Us Apart?
While there are many cloud databases emerging geared towards better
performance and scalability, these lack the built-in support for the
standards, structure and interoperability that is required to
effectively and quickly implement enterprise class applications.  This
is where Cloud2db excels.  Cloud2db provides a standards-based
abstraction layer over these cloud technologies to provide you with
performance and scalability of cloud database platforms along with
structure, standards and interoperability of relational database
platforms.

Check It Out
Please visit our website http://www.cloud2db.com and try out the free
trial version of our product. Please visit google group Cloud2db to
share your feedback and thoughts.

Sincerely,

Sandeep Sathaye
Founder and Chief Architect
Cloud2db

--

You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en.

[appengine-java] Re: cant create temporary file

[sandeep]

Thanks jason. I wanted to run a public webservice which could convert
pdf to text online using PDFBox library. Because of this limitation
(not able to create temp file) this was a failure. :(

On Aug 31, 7:43 pm, "Jason (Google)"  wrote:
> You're correct that App Engine's filesystem is not writable. This is not
> likely to change soon, so any libraries that you depend on which assume a
> writable file system will have to be updated to use a supported mechanism.
> As you can see from the following wiki page, a growing number of libraries
> and frameworks are compatible with App Engine, Hibernate 
> notwithstanding.http://groups.google.com/group/google-appengine-java/web/will-it-play...
>
> Regarding your third point, App Engine does include a URL Fetch service
> which should allow you to issue HTTP requests (including POSTs) to other
> websites running on ports 80 or 443. In addition to the low-level API, a
> java.net-based wrapper is available:
>
> http://code.google.com/appengine/docs/java/urlfetch/
>
> - Jason
>
>
>
> On Sat, Aug 29, 2009 at 4:15 AM, sandeep  wrote:
>
> > Google app engine is good but it has limitations like:
> > 1. You cant create temporary files. Most java libraries rely on a
> > temporary folder for scratchpad. As GAE doesnt support filesystem
> > operations, all these go for a toss?
>
> > You cant upload files on to a file system. How does one expect to
> > manage static content then?
>
> > Any plans for temp files support atleast??
>
> > 2. Also had GAE supported hibernate it would have been a super boost
> > as most apps run today with spring + hibernate.
>
> > 3. Also you cant crawl other websites as http port is blocked that
> > means you can't do anything like HTTP post?.
>
> > Any suggestions on these esp point 1 ?Please help.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-java@googlegroups.com
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en
-~--~~~~--~~--~--~---

[appengine-java] cant create temporary file

[sandeep]

Google app engine is good but it has limitations like:
1. You cant create temporary files. Most java libraries rely on a
temporary folder for scratchpad. As GAE doesnt support filesystem
operations, all these go for a toss?

You cant upload files on to a file system. How does one expect to
manage static content then?

Any plans for temp files support atleast??

2. Also had GAE supported hibernate it would have been a super boost
as most apps run today with spring + hibernate.

3. Also you cant crawl other websites as http port is blocked that
means you can't do anything like HTTP post?.


Any suggestions on these esp point 1 ?Please help.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-java@googlegroups.com
To unsubscribe from this group, send email to 
google-appengine-java+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/google-appengine-java?hl=en
-~--~~~~--~~--~--~---