I am trying to create a DB connection to an MySql database using flowscript.
Here is sample code from my .js file:
var dbSelector = cocoon.getComponent(Packages.org.apache.avalon.excalibur.datasource.DataSourceComponent.ROLE + "Selector");
var dataSrc = "">
var conn = dataSrc.getConnection();
conn.update("INSERT INTO Fixture(name,year,managerID) VALUES('john','11-10-2004','M1');");
/////////////////////////////////////////////////////////////////////////////////
"mysql-pool" is the jdbc name in cocoon.xconf
When I run the application I don't get any errors,but I don't get any data
in my Fixture table ...Does anyone know what I am doing wrong or how to further diagnose the problem?
Basically, how do I put data into the table?"
I am using cocoon 2.1.3,
Microsoft Windows XP professional.
jsdk1.4.2
jetty servlet engine.
Kelly
MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
