java - Android application connecting to an as400 database -
i'm trying android connected as400 server. unfortunately when click on connexion button, driver isn't loaded , don't know why.
here code:
package hello.world; import java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; import android.app.activity; import android.os.bundle; import android.view.view; public class helloworldactivity extends activity { /** called when activity first created. */ @override public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.main); } public void connexion(view view) throws sqlexception { system.out.println("tentative de connexion à la base de donnée."); //connexion string driver = "com.ibm.as400.access.as400jdbcdriver"; string url = "jdbc:as400://beaufix;transaction isolation=read uncommitted;date format=iso;naming=system;libraries=*libl"; connection conn = null; string username = "gmaobd60"; string password = "gmaobd60"; try { class.forname(driver).newinstance(); conn = drivermanager.getconnection(url,username,password); system.out.println("connected database"); conn.close(); system.out.println("disconnected database"); } catch (exception e) { e.printstacktrace(); system.out.println("error"); } } } here xmd code:
<button android:id="@+id/connexion" android:layout_width="196dp" android:layout_height="wrap_content" android:layout_marginleft="50dp" android:layout_margintop="100dp" android:text="@string/connexion" android:layertype="hardware" android:onclick="connexion" />
and here error log:
06-05 07:18:56.100: w/system.err(564): java.lang.classnotfoundexception: com.ibm.as400.access.as400jdbcdriver 06-05 07:18:56.155: w/system.err(564): @ java.lang.class.classforname(native method) 06-05 07:18:56.180: w/system.err(564): @ java.lang.class.forname(class.java:217) 06-05 07:18:56.212: w/system.err(564): @ java.lang.class.forname(class.java:172) 06-05 07:18:56.241: w/system.err(564): @ hello.world.helloworldactivity.connexion(helloworldactivity.java:33) 06-05 07:18:56.271: w/system.err(564): @ java.lang.reflect.method.invokenative(native method) 06-05 07:18:56.290: w/system.err(564): @ java.lang.reflect.method.invoke(method.java:511) 06-05 07:18:56.321: w/system.err(564): @ android.view.view$1.onclick(view.java:3039) 06-05 07:18:56.340: w/system.err(564): @ android.view.view.performclick(view.java:3511) 06-05 07:18:56.371: w/system.err(564): @ android.view.view$performclick.run(view.java:14105) 06-05 07:18:56.371: w/system.err(564): @ android.os.handler.handlecallback(handler.java:605) 06-05 07:18:56.380: w/system.err(564): @ android.os.handler.dispatchmessage(handler.java:92) 06-05 07:18:56.391: w/system.err(564): @ android.os.looper.loop(looper.java:137) 06-05 07:18:56.391: w/system.err(564): @ android.app.activitythread.main(activitythread.java:4424) 06-05 07:18:56.401: w/system.err(564): @ java.lang.reflect.method.invokenative(native method) 06-05 07:18:56.410: w/system.err(564): @ java.lang.reflect.method.invoke(method.java:511) 06-05 07:18:56.421: w/system.err(564): @ com.android.internal.os.zygoteinit$methodandargscaller.run(zygoteinit.java:784) 06-05 07:18:56.431: w/system.err(564): @ com.android.internal.os.zygoteinit.main(zygoteinit.java:551) 06-05 07:18:56.431: w/system.err(564): @ dalvik.system.nativestart.main(native method) 06-05 07:18:56.441: w/system.err(564): caused by: java.lang.noclassdeffounderror: com/ibm/as400/access/as400jdbcdriver 06-05 07:18:56.460: w/system.err(564): ... 18 more 06-05 07:18:56.460: w/system.err(564): caused by: java.lang.classnotfoundexception: com.ibm.as400.access.as400jdbcdriver 06-05 07:18:56.481: w/system.err(564): @ dalvik.system.basedexclassloader.findclass(basedexclassloader.java:61) 06-05 07:18:56.492: w/system.err(564): @ java.lang.classloader.loadclass(classloader.java:501) 06-05 07:18:56.492: w/system.err(564): @ java.lang.classloader.loadclass(classloader.java:461) 06-05 07:18:56.500: w/system.err(564): ... 18 more also i've tried many things came error. me please want work :(
and no didn't forget import jt400.jar "com.ibm.as400.access.as400jdbcdriver"
thank in advance, aurelian
i haven't tried ibm toolbox java (jt400.jar) may not compatible dalvik jvm. dalvik not 100% compatible implementation of java vm.
are sure want weight , security implications of library toolbox distributed on mobile device? recommend server (as/400) application provide services mobile clients while managing security, caching, etc.
a framework grails can deployed natively on as/400 makes server application breeze. , dealing xml or json services on http make mobile application easier, more robust, , heck of lot easier maintain.
i have similar application in production supporting on hundred windows ce/mobile clients (motorola/symbol handhelds). i'm looking forward porting client android once hardware available.
Comments
Post a Comment