B4J Question sql initialize with Mysql

[raphipps2002]

I am new to B4J and Mysql. Using sqllite is so simple but I cant get how to initialize and create the db on my c drive.

Assuming I have created a folder c:\jcashbook on my drive.
I want to create the db in that directory called date.db

I have this in my code #AdditionalJar: mysql-connector-java-5.1.36-bin.jar

I assume like sqllite this is here to create the db? But it is incorrect anyway.

sql.Initialize("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/jCashbook/data.db")

I also dont understand the port.

Perhaps someone could write a simple tutorial to do this The ones I have read are difficult to understand for a novice.

 

[narek adonts]

As I know mySQL is a server and sqlite is a file so I dont think that you can create a mySql db with sql object.

 

[raphipps2002]

Hmm I see. So how do you create an mysql db with the tables?

 

[narek adonts]

I am not sure but I think you should download and install mysql and after that connect with b4j and do the other stuff

 

[raphipps2002]

lol thats the problem the other stuff lol

 

[Erel]

Why do you want to switch to MySQL?

You need to run and configure a MySQL server: http://www.wampserver.com/en/

 

[raphipps2002]

Hi Erel

I am re writing an app from scratch copying Vb.net and learning B4j at same time. Some clients now use apple mac but obviously cant use my app without emulators etc. i wanted to host the DB on a web server which makes it easy for me to administer and also its one skill i currently lack. So mysql on the net is a real interest.

I now understand i cant create a db dynamically. So on my 123-reg hosting i have created an Db using myphpadmin with username and pwd.

I now need to be able to read write etc. From what i have read i think i need httpjob. I am trying to get my head around that. But the first thing is the jdbcUrl.

 

[Erel]

You don't need HttpJob. You can directly connect to the database (see the SQL tutorial).

 

[raphipps2002]

Ok...I tried and it was the host site giving me incorrect details giving me problems. All fixed and working... thanks