dear all,

I have just started working with processing and am trying to pull data from a MySQL database (which I have a little experience of). I know the database is working (at ‘localhost’) as I am able to add and read from it through PHP.

I have installed the MySQL libraries into processing and am trying the example script provided by Florian Jenett  (http://www.bezier.de/mysql/). I am not able to connect property (I think). I initially tried running on the server using localhost and this was unsuccessful, I have now tried to run it on my machine using the IP address and appropriate permissions. But still no luck. Any help?

Thanks for any help, Aidan

Here is my code (libraries added, just not shown here for brevity)

----------------–

MySQL msql;

void setup()
{
   size( 100, 100 );

   // this example assumes that you are running the
   // mysql server locally (on "localhost").
   //
   String user     = "GOTTHISRIGHT";
   String pass     = " GOTTHISRIGHT ";

   // name of the database to use
   String database = "- GOTTHISRIGHT ";

   // name of the table that will be created
   String table    = "--SUPPLIEDNEWTABLENAME--";

   // connect to database of server "localhost"
   msql = new MySQL( "localhost", database, user, pass, this );
   
   if ( msql.connect() )
   {  
       // create a table with an id and a word
       msql.execute( "CREATE TABLE IF NOT EXISTS " + table + " ("+
                         "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,"+
                         "word VARCHAR( 255 )"+
                     ")"
                   );
                   
       // fill the table with some data
       //
       msql.execute( "INSERT INTO " + table + " (word) VALUES (\"Lorem\")" );
       msql.execute( "INSERT INTO " + table + " (word) VALUES (\"ipsum\")" );
       msql.execute( "INSERT INTO " + table + " (word) VALUES (\"dolor\")" );

       // now read it back out
       //
       msql.query( "SELECT * FROM " + table );
       
       while (msql.next())
       {
           String s = msql.getString("word");
           int n = msql.getInt("id");
           println(s + "   " + n);
       }
       
       // need to find out how many rows there are in table?
       //
       msql.query( "SELECT COUNT(*) FROM " + table );
       msql.next();
       println( "number of rows: " + msql.getInt(1) );
   }
   else
   {
       // connection failed !
   }
}

void draw()
{
   // i know this is not really a visual sketch ...
}

hey Florian,

I am sure your code is bang-on, the issue is with me understanding things!

I have been trying to run it locally and as an applet. In both instances the MySQL database is remote. I can connect to the database through other means thanks. I am also able to check the server with

shell>  mysql -h <host> -u <user> -p

and this is successful. When I run pde locally I get this message

java.net.SocketException
MESSAGE: java.net.ConnectException: Operation timed out

any thoughts?

thanks, Rowe