You're online.
http://processing.org/reference/libraries/

well, to be honest i only used it locally so far ... i'm not the super-geek in these things (ssh & java), so let me know if you find out how to do this.

( applets using the lib will 100% sure run into security restrictions with java's sandbox, only allowing you to connect to the same domain the applet came from )

F

someone here know about ssh-tunnels and java or mysql? is it possible to set up a ssh-tunnel (from java?) to automatically redirect the mysql-connection to the remote host? any pointers welcome ...

great, i've sent you a goodie via mail. see if that works better ...
looking forward to hear from you.

F

wow. super you're gold!
F

this is not needed with the new version (002) ... it already includes that specific driver ( 3.1 ). note that it's not a good idea to have the driver in the extensions since it might conflict with a newer version later ...

it will soon be available from my site, once we're done with testing. i'll let you know here.


F

Well, this one has me stumped..I figured out the MySQL library, figured out its best not to do the querying within the draw() method, etc.

So I'm trying to create a class SQL that has all my queries embedded within methods. What I have so far is this:

Code:

import de.bezier.mysql.*;

MySQL msql;
sql sqlFuncs;


// created 2005-05-10 by fjenett
// updated 2005-05-12 by fjenett

void setup()
{
  size(100,100);
  sqlFuncs = new sql(user,password,database,host);
  numChapters = sqlFuncs.selectCount();
  println(numChapters);
  
}

class sql {
 String user = "root";
 String pass = "projecto";
 String database = "solaris";
 String table = "images";
 String host = "localhost";
  
  sql( "localhost", "solaris", "root", "projecto", this)
  {
     mysql = new MySQL( host, db, username, password, this);
     if ( !mysql.connect() )
    println("not connected");
  } 

  int selectCount()
  {
	mysql.query( "SELECT COUNT(*) FROM " + table );
	return mysql.getInt("COUNT(*)");
  }
}
 

Does anybody (fjen as well?) have any ideas what I'm doing wrong, or what the library doesn't like?

thanks for all of your help...

sorry, i'm on vacation ...

Code:

import de.bezier.mysql.*; 
 
MySQL mysql; 
sql sqlFuncs;
 
void setup() 
{ 
  size(100,100); 
  sqlFuncs = new sql(this); 
  int numChapters = sqlFuncs.selectCount(); 
  println(numChapters); 
   
} 
 
class sql { 
 String user = "root"; 
 String pass = "----"; 
 String database = "----"; 
 String table = "----"; 
 String host = "localhost";

// you can't pass values the way you did ...
//
/* please take the time to lookup and learn about classes, constructors and variable scope. */
  sql(PApplet _p)
  { 
     mysql = new MySQL( host, database, user, pass, _p); 
     if ( !mysql.connect() ) 
    println("not connected"); 
  }  
 
  int selectCount() 
  { 
 mysql.query( "SELECT COUNT(*) FROM " + table );
 mysql.next();  // you need to jump to the first result here!
 return mysql.getInt("COUNT(*)");
  } 
}
 

F


http://www.shiffman.net/itp/classes/ICM/week2/index.html
http://www.shiffman.net/itp/classes/ICM/week5/index.html