Android Question Please a simple RDC MySql example

P

persianpowerman1

Active Member
Licensed User
Longtime User
could someone put up a simple RDC Mysql example with explanation. .. cz i have asked so many people and none seem to really know what/why/how...??

for eg...
what goes in serverIP or namr or Url
where to put DB name... passwords etc..

do i have to keep changing the config file for every Db?

can there be an example DB on a remote server that we can try stuff on???
 
Sort by date Sort by votes
P

persianpowerman1

Active Member
Licensed User
Longtime User
buddy... i wouldnt be posting a request for help all over ... if i was receiving it... unlike before ... this time its been a week of begging and no one seems to know ... really weird...

you asked me for the errors and problems in ....
Tutorial Connect Android to MySQL Database Tutorial.
i've given them to you... still awaiting ... what is to be done...

now i have left my errors in the tutorial you have again indicated...
but its just to weird... unlike ever... no one seems to know whats going on with RDC...

please just clear this for me... cz its just consuming all my time...

I also have made a small DB on sql4.freesqldatabase.com... i have been give DB password...

so if you can just indicate to me how am i suppose to put what parameters where ... i can be on my way.. cz honestly.. no one seems to know
like...
do i have to edit the Server i made everytime there is a new DB?
or do i edit the Config.properties file everytime there is a new DB? etc etc...

thanx buddy

YO!han
 
Upvote 0

barx

Well-Known Member
Licensed User
Longtime User
Have you followed the framework setup section of this post

From what I understand the RDC is a middle ware. I.E you have to setup RDC on a web connectable server of some sort. Then your app connects to RDC server and the the RDC server interacts with DB.
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
hey Barx.. thanx a lot.. what ever i have got right till now is thanx to you!... yeah.. i got what you said...

but im still getting errors... have posted them... one of them were similar to what Derez got... so i've written to him... lets see what he says.. and how he got around it...

my server is running... but my app keeps giving errors..
in the Browser test for the server... i get this error...


RemoteServer is running (Sat Dec 07 21:25:25 IST 2013)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
Click to expand...

so waiting for Derez... hope to get some clarity there.. cz he actually did have this same error...
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
so is it cz my server isnt working correctly.. as im getting that error...

RemoteServer is running (Sat Dec 07 21:25:25 IST 2013)
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
Click to expand...
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
here... config.properties..

B4X: 
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/test?characterEncoding=utf8

User=db_user
Password=my_password
ServerPort=17178


sql.create_table=CREATE TABLE animals (\
    id INT NOT NULL AUTO_INCREMENT,\
    name CHAR(30) NOT NULL,\
    image BLOB,\
    PRIMARY KEY (id))
sql.insert_animal=INSERT INTO animals VALUES (null, ?,?)
sql.select_animal=SELECT name, image FROM animals WHERE name = ?
 
Upvote 0
K

keirS

Well-Known Member
Licensed User
Longtime User
You should have:

JdbcUrl=jdbc:mysql://sql4.freesqldatabase.com/sql$$$$$$?characterEncoding=utf8

Replace the $$$$$$ with the number part of your database name.
User=
Should be the username that was emailed to you.
Password =
Should be the password that was emailed to you.
 
Upvote 0
P

persianpowerman1

Active Member
Licensed User
Longtime User
WOOOOOhoooo! KeirS... ur a genius. ... so i changed the Port to the port they emailed me too..
and look what i got....

RemoteServer is running (Sun Dec 08 10:55:28 IST 2013)
Connection successful.
Click to expand...

thanx man...
........ so now trying that animal name example... and some stuff... thanx again

will write to you if i have a bump..
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Example [B4XPages] jRDC2 + MySql CRUD + Login
2 3
Replies
43
Views
19K
aeric
  • Article
Share My Creation (PHP/MySQL/API) User Login App
4 5 6
Replies
108
Views
75K
aeric
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
171K
Erel
  • Locked
  • Article
Android Example RDC - Simple way to create your own back-end database
4 5 6
Replies
102
Views
79K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
358K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…