Re: Insert using connector j?

[douglas wilson]

YOu can use connector j with the insert statement im my sql. firstof connector j can be installed in to the server after that creating the table .

chown tomcat:tomcat /usr/local/tomcat/webapps/mmbase-webapp/WEB-INF/config/modules/jdbc.xml
chmod 640 /usr/local/tomcat/webapps/mmbase-webapp/WEB-INF/config/modules/jdbc.xml

Then create the database;
CREATE DATABASE <database name>;
USE <database name>;
GRANT INSERT <database name>.* TO
<mmuser>@'%' IDENTIFIED BY '<password>';