[appengine-java] How to preload SQL data into datasource
Hi All, I'm working on migrating sample application to GAE. In my local environment my application is deployed on Tomcat pointing to MySQL datasource. I made relevant changes and deployed this application on GAE. as this application is using JPA expecting entities to be created on GAE but, what about my data from MySQL tables? is there a way to push this data on GAE? Any pointers would be highly appreciated. Thanks, Suresh -- 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: How to preload SQL data into datasource
Hi Didier,
Thanks for quick reply.
I tried the following...
1) Checked from app engine console and statistics are displayed as
mentioned in blog
2) Installed python 1.4.0 SDK 9my appengine SDK is 1.3.8)
3) When I run,
appcfg.py create_bulkloader_config
--url=http://appid.appspot.com/remote_api --application=appid
--filename=config.yml
(replaces appid with my application id)
It created a file with following data:
--
#!/usr/bin/env python
#
# Copyright 2007 Google Inc.
#
# Licensed under the Apache License, Version 2.0 (the License);
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an AS IS BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
Convenience wrapper for starting an appengine tool.
import os
import sys
if not hasattr(sys, 'version_info'):
sys.stderr.write('Very old versions of Python are not supported.
Please '
'use version 2.5 or greater.\n')
sys.exit(1)
version_tuple = tuple(sys.version_info[:2])
if version_tuple (2, 4):
sys.stderr.write('Error: Python %d.%d is not supported. Please use '
'version 2.5 or greater.\n' % version_tuple)
sys.exit(1)
if version_tuple == (2, 4):
sys.stderr.write('Warning: Python 2.4 is not supported; this program
may '
'break. Please use version 2.5 or greater.\n')
DIR_PATH = os.path.abspath(os.path.dirname(os.path.realpath(__file__)))
SCRIPT_DIR = os.path.join(DIR_PATH, 'google', 'appengine', 'tools')
EXTRA_PATHS = [
DIR_PATH,
os.path.join(DIR_PATH, 'lib', 'antlr3'),
os.path.join(DIR_PATH, 'lib', 'django'),
os.path.join(DIR_PATH, 'lib', 'fancy_urllib'),
os.path.join(DIR_PATH, 'lib', 'ipaddr'),
os.path.join(DIR_PATH, 'lib', 'webob'),
os.path.join(DIR_PATH, 'lib', 'yaml', 'lib'),
]
SCRIPT_EXCEPTIONS = {
dev_appserver.py : dev_appserver_main.py
}
def fix_sys_path():
Fix the sys.path to include our extra paths.
sys.path = EXTRA_PATHS + sys.path
def run_file(file_path, globals_, script_dir=SCRIPT_DIR):
Execute the file at the specified path with the passed-in globals.
fix_sys_path()
script_name = os.path.basename(file_path)
script_name = SCRIPT_EXCEPTIONS.get(script_name, script_name)
script_path = os.path.join(script_dir, script_name)
execfile(script_path, globals_)
if __name__ == '__main__':
run_file(__file__, globals())
--
This is not same as what was explained in blog posting.
This file do not have any data related to entities etc... did I miss
anything?
Thanks,
Suresh
--
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] petstore deployment
Hi All, I'm trying to deploy petstore 2.0 on Google app engine (SDK 1.3.8). So many limitations from app engine... I had to many changes on JSF side to deploy the app. After the deployment process, I'm stuck with JSF rendering issue... no clue how to proceed with the same. --- SEVERE: JSF1054: (Phase ID: RENDER_RESPONSE 6, View ID: /index.jsp) Exception thrown during phase execution: javax.faces.event.phaseevent[source=com.sun.faces.lifecycle.lifecyclei...@aaf063] javax.servlet.ServletException at javax.faces.webapp.FacesServlet.service(FacesServlet.java:325) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166) ... --- Major problem I'm having is no logs being generated on development environment. Exception stack says, more information could be found at 'server logs' but, no logs are generated on local machine. When I try to host it on app. engine ( so that, I can view logs from app. engine dashboard)... the deployment fails with following exception. Latest SDK: Release: 1.4.0 Timestamp: Thu Dec 02 04:44:18 GMT+05:30 2010 API versions: [1.0] --- Your SDK: Release: 1.3.8 Timestamp: Wed Oct 13 20:36:43 GMT+05:30 2010 API versions: [1.0] --- Please visit http://code.google.com/appengine for the latest SDK. Creating staging directory Scanning for jsp files. Compiling jsp files. Scanning files on local disk. Scanned 250 files. Scanned 500 files. Initiating update. java.io.IOException: Error posting to URL: https://appengine.google.com/api/appversion/create?app_id=petstore5version=1; 404 Not Found This application does not exist (app_id=u'petstore5'). I have SDK 1.3.8; does this mean, I can't use this version anymore? Any pointers would be highly appreciated. Thanks, Suresh -- 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.
