Thank you very much Charlie, finally I've done it!Here I post the things I've done:1- First you have to do a Java class, with public methods. Here is my Java class:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import org.alfresco.repo.processor.BaseProcessorExtension;
public class MyPOJO extends BaseProcessorExtension
{
public Connection conn = null;
private void openConnection() throws SQLException
{
if (conn == null)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
System.setProperty("sqlfile.charset", "ISO-8859-1");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/DBname","user","password");
}
catch (Exception ex)
{
System.err.println("Error at initialization block");
ex.printStackTrace();
if (conn != null)
{
try
{
conn.close();
conn = null;
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
}
public boolean insert(String foo, String bar) throws SQLException
{
boolean sqlRet = true;
this.openConnection();
if (conn != null)
{
String insertString = "INSERT INTO SampleTable(foo,bar) VALUES (?,?);";
PreparedStatement insertStatement = null;
insertStatement = conn.prepareStatement(insertString);
insertStatement.setString(1, foo);
insertStatement.setString(2, bar);
try
{
insertStatement.executeUpdate();
}
catch (SQLException ex)
{
ex.printStackTrace();
sqlRet = false;
}
finally
{
if(insertStatement != null)
{
insertStatement.close();
}
}
}
return sqlRet;
}
private void closeConnection() throws SQLException
{
if (conn != null)
{
if (conn.isValid(1) == true)
{
try
{
conn.close();
conn = null;
}
catch (SQLException e)
{
e.printStackTrace();
}
}
else if (conn.isClosed() == false)
{
try
{
conn.close();
conn = null;
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
protected void finalize() throws SQLException
{
this.closeConnection();
}
}
This class creates a connection with a MySQL DB and inserts some stuff into it.2- Then you have to make a .jar file and put it into /tomcat/webapps/alfresco/WEB-INF/lib.3- You have to add your POJO to the /tomcat/webapps/alfresco/WEB-INF/classes/alfresco/script-services-context.xml
<bean id="MyPOJOScript" parent="baseJavaScriptExtension" class="MyPOJO">
<property name="extensionName">
<value>myPOJO</value>
</property>
</bean>
4- In each task node of your workflow, you have to put a tag that tells that you are going to put some javascript code, and then put "myPOJO.insert(…,…)"So thats all!Joel
