topic Re: My Java jdbc class couldn't be accessed through Activity in Alfresco Archive

My Java jdbc class couldn't be accessed through Activity

pratikbhatt — Thu, 16 May 2013 05:48:04 GMT

<strong>For Database Connectivity I have Created class as below</strong>package com.db.connection;import java.sql.*;public class DbConnection { private String JDBC_DRIVER = "com.mysql.jdbc.Driver"; private String JDBC_URL = "jdbc:mysql://localhost:3306/Pratik"; public Connection

Re: My Java jdbc class couldn't be accessed through Activity

pratikbhatt — Thu, 16 May 2013 05:54:19 GMT

<Strong>This file is for Activiti BPM Process</Strong>

Re: My Java jdbc class couldn't be accessed through Activity

sebastian_s — Thu, 16 May 2013 07:48:00 GMT

Hello Pratik,

you didn't give a sufficient description of your problem and you did not provide an exception stacktrace either.

Sebastian

Re: My Java jdbc class couldn't be accessed through Activity

pratikbhatt — Fri, 17 May 2013 05:20:41 GMT

Hello Sebastian
Actually no error arise in this code, but somehow data from filled form can't be inserted using above jdbc connection… and I have tested above jdbc code in separate simple java class to insert data in database, and this code work fine but when I am trying to insert data from Activiti Process Form, No data can be inserted through this class. all necessary .jar files are included where those files are needed.
Thank you

Re: My Java jdbc class couldn't be accessed through Activity

pratikbhatt — Sat, 18 May 2013 06:46:42 GMT

Hello Sebastian

When I am doing unit testing I can find these warnings on Eclipse console

May 18, 2013 11:37:18 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [activiti.cfg.xml]
May 18, 2013 11:37:20 AM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on engine with resource org/activiti/db/create/activiti.h2.create.engine.sql
May 18, 2013 11:37:20 AM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on history with resource org/activiti/db/create/activiti.h2.create.history.sql
May 18, 2013 11:37:20 AM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
INFO: performing create on identity with resource org/activiti/db/create/activiti.h2.create.identity.sql
May 18, 2013 11:37:20 AM org.activiti.engine.impl.ProcessEngineImpl <init>
INFO: ProcessEngine default created
May 18, 2013 11:37:20 AM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
INFO: Processing resource sales.bpmn20.xml
May 18, 2013 11:37:20 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XMLSchema currently not supported as typeLanguage
May 18, 2013 11:37:20 AM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
INFO: XPath currently not supported as expressionLanguage
id 5 sales:1:4

please help me to solve my problem

Re: My Java jdbc class couldn't be accessed through Activity

ronald_van_kuij — Sun, 19 May 2013 09:49:39 GMT

What you post now are no warnings, but INFO messages… And if you don't have more info, it is impossible for us to help.

And if System.out.println("Record Successfully Inserted"); is called but there is no data…. i'd check transaction management or (auto)commit