Re: [Red5] osflash: red5 page restructured
looks a lot cleaner, easier to navigate -- Donald Donald's Profile: 1 View this thread: http://www.nixspot.com/red5/showthread.php?t=25 ___ Red5 mailing list Red5@osflash.org http://osflash.org/mailman/listinfo/red5_osflash.org
[Red5] Red5 and Mysql
I spent a lot of time reading different sites on how to use mysql and
red5
this is what i got put together to get a basic connection and
insert some data into the database and retrieve it back from the
database.
you will need to download the jconnector from the mysql site
http://dev.mysql.com/downloads/connector/j/5.0.html
and extract it into you WEB-INF/lib folder for your project
Server Side Java code
package demo;
import org.red5.server.adapter.ApplicationAdapter;
import java.sql.*;
public class Application extends ApplicationAdapter {
int id_num = 0;
String name = ;
///MYSQL SECTION
public String mysql() {
try {
Statement stmt;
ResultSet queryresult;
Class.forName(com.mysql.jdbc.Driver);
String url = jdbc:mysql://localhost/dbname;
Connection mysql_conn = DriverManager.getConnection(
url,dbuser, dbpassword);
stmt = mysql_conn.createStatement();
stmt.executeUpdate(INSERT INTO table (id , name) VALUES
(null , 'somevalue'));
queryresult = stmt.executeQuery(SELECT * from table
ORDER BY id LIMIT 1);
while(queryresult.next()){
int var1= queryresult.getInt(id);
String var2= queryresult.getString(name);
id_num = var1;
name = var2;
}
mysql_conn.close();
}catch( Exception e ) {
e.printStackTrace();
}
return name + / + id_num;
}
//END MYSQL SECTION
}
Client Side Flash code
mysql.onRelease = function() {
var mysqlObj:Object = new Object();
nc.call(mysql, mysqlObj);
mysqlObj.onResult = function(test) {
var my_str:String = test;
var my_array:Array = my_str.split(/);
id.text = (my_array[0]);
id_name.text = (my_array[1]);
};
};
--
Donald
'NixSpot' (http://www.nixspot.com)'
' (http://www.nixspot.com/red5/../)
Donald's Profile: 1
View this thread: http://www.nixspot.com/red5/showthread.php?t=42
___
Red5 mailing list
Red5@osflash.org
http://osflash.org/mailman/listinfo/red5_osflash.org
Re: [Red5] adobe flash media encoder
FME crashed red5 was still running fine, i tired it using windows XP with a server running locally and with my main red5 server (Linux - Centos) crashed every time, and also as far as FME goes i could not get it to run at all on Vista. Thijs Triemstra | Collab;68 Wrote: Donald, what crashed, Red5 or FME? I don't have a windows machine to test it with atm but mabye anyone can tell us how it performs with red5 vs. flash media server.. Thijs Op 16-mrt-2007, om 2:05 heeft Donald het volgende geschreven: I have tried it a few times with different cams and it crashed every time, would be a great option once it is stable. Joachim Bauch wrote: Hey guys, Chris Allen schrieb: Well I bet it's possible to figure out what they are doing and add that to Red5 so that it is compatible. Yep, and this was done in r1760 ;) FME can now connect and broadcast to Red5! FME seems to be not too stable, at least it crashed a lot of times with AVs while trying to connect it to Red5. They seem to expect certain objects (like the response to connect) to be serialized in a given order, so that took a while to figure out... Joachim ___ Red5 mailing list Red5 (AT) osflash (DOT) org http://osflash.org/mailman/listinfo/red5_osflash.org ___ Red5 mailing list Red5 (AT) osflash (DOT) org http://osflash.org/mailman/listinfo/red5_osflash.org ___ Red5 mailing list Red5 (AT) osflash (DOT) org http://osflash.org/mailman/listinfo/red5_osflash.org -- Donald 'NixSpot' (http://www.nixspot.com)' ' (http://www.nixspot.com/red5/../) Donald's Profile: 1 View this thread: http://www.nixspot.com/red5/showthread.php?t=41 ___ Red5 mailing list Red5@osflash.org http://osflash.org/mailman/listinfo/red5_osflash.org
