topic Re: Not able to use my oracle database even after configuring db.properties file. in Alfresco Archive

Not able to use my oracle database even after configuring db.properties file.

shivam_0311 — Thu, 18 Feb 2016 11:51:27 GMT

My db.properties file contains..db=oraclejdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbcracle:thin:@MY_IP:xejdbc.username=myusernamejdbc.password=mypasswordand I am trying to run the bookOrder example from chapter1 of "Activiti in Action". On running this example i am getting following er

Re: Not able to use my oracle database even after configuring db.properties file.

hari — Thu, 18 Feb 2016 12:02:20 GMT

Hi Shivam,
Is the oracle service up and running when you tried to execute this ?
If its up, please check the connection url again.

Re: Not able to use my oracle database even after configuring db.properties file.

shivam_0311 — Thu, 18 Feb 2016 12:09:49 GMT

Thanks Harikiran,
yes, oracle service is up.and my jdbcUrl is jdbcracle:thin:@MY_IP:1521:xe
i wrote wrong url in above post by mistake.
but still facing the issue.

Re: Not able to use my oracle database even after configuring db.properties file.

hari — Fri, 19 Feb 2016 01:49:23 GMT

Unfortunately I use a different database so just cant give you the exact answer.
Can you do a quick check if everythings fine by writing a piece of java code to connect to database. If that gets connected then we should look at whats wrong here. Else you know where to look for.

Re: Not able to use my oracle database even after configuring db.properties file.

shivam_0311 — Fri, 19 Feb 2016 03:36:26 GMT

Yes,there is no issue with oracle database connection as my another application is working fine with the same database.
I am trying to run the application given in following link
http://www.codeproject.com/Tips/699392/Step-by-Step-your-First-journey-with-Activiti?fid=1849867&select=5202937&fr=1
I am seeing in the error that still this application is trying to connect to h2 localhost even after changing db.properties and activiti.cfg.xml.

Re: Not able to use my oracle database even after configuring db.properties file.

hari — Fri, 19 Feb 2016 05:20:24 GMT

I hope you have changed the db.properties in the below path.
<catalina_home>\webapps\activiti-explorer\WEB-INF\classes\db.properties.

Also I believe you have changed it in activiti.cfg.xml. Am I correct ? If so ideally it has to connect to which ever you have defined.

Re: Not able to use my oracle database even after configuring db.properties file.

shivam_0311 — Fri, 19 Feb 2016 06:47:59 GMT

Yes, I have changed db.properties in the above mentioned path.
My activiti.cfg.xml is as given below.

and I have put it in the class path of my activiti project and (in webapps\activiti-explorer\WEB-INF\classes and in webapps\activiti-explorer\WEB-INF\lib folder. (As I have read to put it in such locations in this forum itself)).
Is there any need to put it in other locations?

And i also want to mention that activiti-explorer is working fine with my oracle database,I am able to create task and users as well.But through creating activiti project in eclipse is not going to work with the same database.

Re: Not able to use my oracle database even after configuring db.properties file.

hari — Fri, 19 Feb 2016 08:53:19 GMT

I am not really sure whats wrong at your end but just to help you out, please refer to the below code snippet. I think this might be helpful to you. That's a standalone java code and I hope you should be able to take it forward from here.
<java>
public static void main(String args[]){
ProcessEngine processEngineInstance = ProcessEngineConfiguration
    .createStandaloneProcessEngineConfiguration()
    .setJdbcDriver("oracle.jdbc.driver.OracleDriver")
    .setJdbcUrl("jdbcracle:thin:@MY_IP:1521:xe")
    .setJdbcPassword("MY_user")
    .setJdbcUsername("MY_pass")
    .buildProcessEngine();

List<Task> tasks = processEngineInstance.getTaskService().createTaskQuery().taskAssignee("Kermit").list();
}
</java>
The above code gets all the tasks assigned to user Kermit from your database.

Re: Not able to use my oracle database even after configuring db.properties file.

hari — Fri, 19 Feb 2016 08:56:22 GMT

When the above thing works, you can just read the username, pwd, driver and connection string from a properties file and get your work done.

Re: Not able to use my oracle database even after configuring db.properties file.

shivam_0311 — Fri, 19 Feb 2016 09:28:57 GMT

Thanks , This code is working fine with my oracle database and I am able to fetch all assigned tasks to kermit.
But if you find the solution to my exact problem(Using Activiti Project with BPMN20.xml files),then please let me know.