Frank, Just got back off holiday so missed this post but glad you solved it ... I did the same thing with rev levels!
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Frank Cazabon Sent: 07 July 2014 19:47 To: [email protected] Subject: [NF] Basic4Android JDBC to SQL Server Hi, I know Basic4Android is being used by a couple people here so I'm hoping someone can help me out. I am using the trial version and trying to follow an example from here: http://www.basic4ppc.com/android/forum/threads/remote-database-connector-connect-to-any-remote-db.31540/#content When I reach the step to run the server and test it out I get this message: RemoteServer is running (Mon Jul 07 14:26:14 BOT 2014) java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. The config.properties has this setup: #SQL Server DriverClass=net.sourceforge.jtds.jdbc.Driver JdbcUrl=jdbc:jtds:sqlserver://***.***.***.***:1433/IBC User=MyDatabase Password=MyPassword ServerPort=17178 The console window gets this displayed in it: at java.net.URLClassLoader.findClass(URLClassLoader.java:360) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:259) at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver ManagerDataSource.java:112) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag erDataSource.java:144) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:195) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:184) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource Pool.java:1086) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc ePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru n(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre adPoolAsynchronousRunner.java:648) Jul 07, 2014 2:26:43 PM com.mchange.v2.c3p0.DriverManagerDataSource ensureDriver Loaded WARNING: Could not load driverClass net.sourceforge.jtds.jdbc.Driver java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:372) at java.net.URLClassLoader$1.run(URLClassLoader.java:361) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:360) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:259) at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(Driver ManagerDataSource.java:112) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManag erDataSource.java:144) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:195) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnecti on(WrapperConnectionPoolDataSource.java:184) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionRe sourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResource Pool.java:1086) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPe ndingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourc ePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.ru n(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(Thre adPoolAsynchronousRunner.java:648) So I am guessing there is some problem with the DriverClass=net.sourceforge.jtds.jdbc.Driver but don't have any idea what it could be. Any ideas? -- Frank. Frank Cazabon --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
