Access to a MySQL Database via Flash and Java

[Rom]

Hi everybody.

First, sorry for my poor english (as I am not one !!)

My request is : I'm working on a project for my school in relation with Flash, Java and MySQL.

The thing is, as I am not very improved in those technologies, I'm looking for some help.

The project is : I've to access to MySQL through Java ( I don't how), to check a login and password.
The second point is, after being logged in, I need to update the database by sending some datas in XML and, in an other way, receive datas in the same format to continue.

The XML file will be stored in the local machine, and will have to be sent after when the user get connected.

Could somebody help me to do this, 'cause I'm working on it for two weeks and nothing has been made.

It would be really nice to help me.
ThX.

[vesa kortelainen]

Could somebody help me to do this, 'cause I'm working on it for two weeks and nothing has been made.

sounds buys  & hard project to do. How much u know about Java? How about MySql queries? How about sending data in and out from Flash movie, see here

Hrmmms  

[Rom]

Hi and thanks for answering so quickly.

Well, my knowing of Java is quite poor.

What I've made, is to install a java socket server waiting for a connection via socket.

Could I use this one to make my connection to MySQL ?

I know how to make a jdbc connection with java but the fact is, is it possible to insert this connection to the socket server to use its functionalities ?

If it could be possible and if you could help me to do that, it would be great !!

Thx.

[Jorge Solis]

Not sure about your goals. Putting a conection to a database into a socket? Why? You can just acces your database and use any of the asynchronous ways Flash offers to do it, like the loadVars() object. The way Flash manages sockets is trough the XML object. Are you doing some multiuser app? Or why you need Java sockets?

Jorge

[Rom]

Sorry, forget about he idea of using socket.
It was a mistake.

In fact, my application is for e-learning.
The swf is an animation that permits to anybody to test his knowing about subjects.

And I have to do is, for the first connection, to check the loggin and password in MySQL.
And then, once he's logged in, save his level in a XML file ( stored in the local machine), and send it to the database.

And all this stuff using Java (school imperatives !!)

So that's what I have to do and it"s really complciated and frustrating whrn you don't know how to do.

Thanks for all the answers that will permit me to go on.

[Ronald Wernecke]

Hi Rom,
for to start, you need somthing on the server doing the database access, it can be a java program running on the server.

This program generates a XML data stream and sends it to output (towards a browser or flash).

So all basic datahandlig must be done by a serverside component or script.

Hpe this helps you a little