Click here to Skip to main content
15,895,964 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
How to connect google apps to mysql database connection please help me step by step process and examples.


thank you.
Posted
Comments
Sandeep Mewara 6-Jun-12 6:49am    
What have you tried? Have you even Googled?

Googled 'connect google apps to mysql database connection'!

Found this: https://developers.google.com/apps-script/jdbc_overview[^]

Is this helpful?
 
Share this answer
 
i am use to jdoconfig.xml file

<persistence-manager-factory name="mysqldbconnection">
<property name="javax.jdo.PersistenceManagerFactoryClass">
value="org.datanucleus.store.appengine.jdo.DatastoreJDOPersistenceManagerFactory"/>
<property name="javax.jdo.option.ConnectionDriverName" value="com.mysql.jdbc.Driver">
<property name="javax.jdo.option.ConnectionURL" value="jdbc:mysql://localhost:3306/testproject">
<property name="javax.jdo.option.ConnectionUserName" value="root">
<property name="javax.jdo.option.ConnectionPassword" value="admin">
<property name="javax.jdo.option.NontransactionalRead" value="true">
<property name="javax.jdo.option.NontransactionalWrite" value="true">
<property name="javax.jdo.option.RetainValues" value="true">
<property name="datanucleus.appengine.autoCreateDatastoreTxns" value="true">


demo.java file:

package june.testproject.client;
import javax.jdo.JDOHelper;
import javax.jdo.PersistenceManagerFactory;

import java.sql.Connection;



public class demo {

public static void main(String[] argv) {

System.out.println("-------- MySQL JDBC Connection Testing ------------");

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

System.out.println("Where is your MySQL JDBC Driver?");
e.printStackTrace();
return;

}

System.out.println("MySQL JDBC Driver Registered!");
Connection connection = null;

//connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/googleapps","root", "admin");
final PersistenceManagerFactory pmfInstance = JDOHelper.getPersistenceManagerFactory("mysqldbconnection");
connection=(Connection) pmfInstance;

if (connection != null) {
System.out.println("You made it, take control your database now!");
} else {
System.out.println("Failed to make connection!");
}
}
}

command prompt execute

java -cp D:\Arul\Googleeclipse\testproject\war\WEB-INF\lib\mysql-connector-java-3.1.12-bin.jar;D:\Arul\Googleeclipse\testproject\src\june\testproject\client demo


error occur

Exception in thread "main" java.lang.NoClassDefFoundError: demo
Caused by: java.lang.ClassNotFoundException: demo
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: demo. Program will exit.


please help me command prompt execute procedure.

thanks.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900