You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by Pratik Patel <pa...@umail.iu.edu> on 2016/05/19 20:26:38 UTC

java.lang.RuntimeException: Failed to create database connection pool

Hi all,

I am trying to start airavata-server. But I am getting following error
while doing so:

Command Used:
$ ./airavata-server.sh start

Error:


2016-05-19 16:17:08,225 [main] ERROR org.apache.airavata.server.ServerMain
 - Server Start Error:
java.lang.RuntimeException: Failed to create database connection pool.
at
org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
at
org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
at
org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
at
org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
at
org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
at
org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
Caused by: java.sql.SQLException: Can't find class for driver:
at
org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
at
org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
at
org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
at
org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
... 6 more


--------------------------------------------------------------------------------------------------------------



I have attached log file in this email. Could someone point out where I am
going wrong?

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Pratik Patel <pa...@umail.iu.edu>.
Hi all,

Thanks for your help. I have now solved the error by correcting jdbc URL
for the credential store.I had forgot to change the name of the database to
'credential-store' from 'airavata_credentialstore'(as I had created DB with
name credential-store) in one of the URL.

Regards,
Pratik Patel


On Thu, May 19, 2016 at 5:13 PM, Supun Nakandala <su...@gmail.com>
wrote:

> Hi Pratik
> can you attach your airavata-server.properties file.
>
> On Thu, May 19, 2016 at 5:12 PM, Pratik Patel <pa...@umail.iu.edu>
> wrote:
>
>> Hi Eroma,
>>
>> I am using 5.1.39 version of the jar file. Do you think that newest
>> version would not work?
>>
>> Marlon,
>>
>> I have attached file content of my file in this email. I do not think its
>> corrupted. Do we need to comment out
>> 'credential.store.jdbc.driver=com.mysql.jdbc.Driver' these properties?
>> which provides driver name?
>>
>> Thanks,
>> Pratik Patel
>>
>> On Thu, May 19, 2016 at 5:05 PM, Pierce, Marlon <ma...@iu.edu> wrote:
>>
>>> Pratik, can you confirm that the mysql.jar is correct, uncorrupted,
>>> etc?  Use jar –tf or a similar command to list the contents.
>>>
>>>
>>>
>>> Marlon
>>>
>>>
>>>
>>> *From: *Eroma Abeysinghe <er...@gmail.com>
>>> *Reply-To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
>>> *Date: *Thursday, May 19, 2016 at 4:51 PM
>>> *To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
>>> *Subject: *Re: java.lang.RuntimeException: Failed to create database
>>> connection pool
>>>
>>>
>>>
>>> Hi Pratik,
>>>
>>>
>>>
>>> What is the version you have copied? I copied
>>> version mysql-connector-java-5.1.38-bin.jar and it worked fine.
>>>
>>> Could you try this version?
>>>
>>>
>>>
>>> Thanks,
>>> Eroma
>>>
>>>
>>>
>>> On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <pa...@umail.iu.edu>
>>> wrote:
>>>
>>> Hi Suresh,
>>>
>>> Thanks for prompt response.
>>>
>>> I have already added mysql.jar in 'lib' folder.
>>>
>>> [image: nline image 1]
>>>
>>>
>>>
>>> I have downloaded the jar file from '
>>> http://dev.mysql.com/downloads/connector/j/'. This link was provided in
>>> instructions. Does it automatically look for this jar file or I have to
>>> provide the complete path of the jar with file name in
>>> airavata-server.properties file?
>>>
>>> Thanks,
>>> Pratik Patel
>>>
>>>
>>>
>>> On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org> wrote:
>>>
>>> Hi Pratik,
>>>
>>>
>>>
>>> As you can see from “ Can't find class for driver:” it is looking for
>>> the mysql jar which should be Step 8 in instructions -
>>> http://airavata.readthedocs.io/en/latest/Airavata-Installation/
>>>
>>>
>>>
>>> Suresh
>>>
>>>
>>>
>>> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
>>>
>>>
>>>
>>> Hi all,
>>>
>>> I am trying to start airavata-server. But I am getting following error
>>> while doing so:
>>>
>>> Command Used:
>>> $ ./airavata-server.sh start
>>>
>>>
>>>
>>> Error:
>>>
>>>
>>>
>>>
>>>
>>> 2016-05-19 16:17:08,225 [main] ERROR
>>> org.apache.airavata.server.ServerMain  - Server Start Error:
>>>
>>> java.lang.RuntimeException: Failed to create database connection pool.
>>>
>>> at
>>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
>>>
>>> at
>>> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
>>>
>>> at
>>> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
>>>
>>> at
>>> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
>>>
>>> at
>>> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
>>>
>>> at
>>> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
>>>
>>> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
>>>
>>> Caused by: java.sql.SQLException: Can't find class for driver:
>>>
>>> at
>>> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
>>>
>>> at
>>> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
>>>
>>> at
>>> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
>>>
>>> at
>>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
>>>
>>> ... 6 more
>>>
>>>
>>>
>>> --------------------------------------------------------------------------------------------------------------
>>>
>>>
>>>
>>> I have attached log file in this email. Could someone point out where I
>>> am going wrong?
>>>
>>>
>>>
>>> <airavata.log>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Thank You,
>>>
>>> Best Regards,
>>>
>>> Eroma
>>>
>>
>>
>
>
> --
> Thank you
> Supun Nakandala
> Dept. Computer Science and Engineering
> University of Moratuwa
>

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Supun Nakandala <su...@gmail.com>.
Hi Pratik
can you attach your airavata-server.properties file.

On Thu, May 19, 2016 at 5:12 PM, Pratik Patel <pa...@umail.iu.edu> wrote:

> Hi Eroma,
>
> I am using 5.1.39 version of the jar file. Do you think that newest
> version would not work?
>
> Marlon,
>
> I have attached file content of my file in this email. I do not think its
> corrupted. Do we need to comment out
> 'credential.store.jdbc.driver=com.mysql.jdbc.Driver' these properties?
> which provides driver name?
>
> Thanks,
> Pratik Patel
>
> On Thu, May 19, 2016 at 5:05 PM, Pierce, Marlon <ma...@iu.edu> wrote:
>
>> Pratik, can you confirm that the mysql.jar is correct, uncorrupted, etc?
>> Use jar –tf or a similar command to list the contents.
>>
>>
>>
>> Marlon
>>
>>
>>
>> *From: *Eroma Abeysinghe <er...@gmail.com>
>> *Reply-To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
>> *Date: *Thursday, May 19, 2016 at 4:51 PM
>> *To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
>> *Subject: *Re: java.lang.RuntimeException: Failed to create database
>> connection pool
>>
>>
>>
>> Hi Pratik,
>>
>>
>>
>> What is the version you have copied? I copied
>> version mysql-connector-java-5.1.38-bin.jar and it worked fine.
>>
>> Could you try this version?
>>
>>
>>
>> Thanks,
>> Eroma
>>
>>
>>
>> On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <pa...@umail.iu.edu>
>> wrote:
>>
>> Hi Suresh,
>>
>> Thanks for prompt response.
>>
>> I have already added mysql.jar in 'lib' folder.
>>
>> [image: nline image 1]
>>
>>
>>
>> I have downloaded the jar file from '
>> http://dev.mysql.com/downloads/connector/j/'. This link was provided in
>> instructions. Does it automatically look for this jar file or I have to
>> provide the complete path of the jar with file name in
>> airavata-server.properties file?
>>
>> Thanks,
>> Pratik Patel
>>
>>
>>
>> On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org> wrote:
>>
>> Hi Pratik,
>>
>>
>>
>> As you can see from “ Can't find class for driver:” it is looking for the
>> mysql jar which should be Step 8 in instructions -
>> http://airavata.readthedocs.io/en/latest/Airavata-Installation/
>>
>>
>>
>> Suresh
>>
>>
>>
>> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
>>
>>
>>
>> Hi all,
>>
>> I am trying to start airavata-server. But I am getting following error
>> while doing so:
>>
>> Command Used:
>> $ ./airavata-server.sh start
>>
>>
>>
>> Error:
>>
>>
>>
>>
>>
>> 2016-05-19 16:17:08,225 [main] ERROR
>> org.apache.airavata.server.ServerMain  - Server Start Error:
>>
>> java.lang.RuntimeException: Failed to create database connection pool.
>>
>> at
>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
>>
>> at
>> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
>>
>> at
>> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
>>
>> at
>> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
>>
>> at
>> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
>>
>> at
>> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
>>
>> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
>>
>> Caused by: java.sql.SQLException: Can't find class for driver:
>>
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
>>
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
>>
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
>>
>> at
>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
>>
>> ... 6 more
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> I have attached log file in this email. Could someone point out where I
>> am going wrong?
>>
>>
>>
>> <airavata.log>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>>
>> Thank You,
>>
>> Best Regards,
>>
>> Eroma
>>
>
>


-- 
Thank you
Supun Nakandala
Dept. Computer Science and Engineering
University of Moratuwa

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Pratik Patel <pa...@umail.iu.edu>.
Hi Eroma,

I am using 5.1.39 version of the jar file. Do you think that newest version
would not work?

Marlon,

I have attached file content of my file in this email. I do not think its
corrupted. Do we need to comment out
'credential.store.jdbc.driver=com.mysql.jdbc.Driver' these properties?
which provides driver name?

Thanks,
Pratik Patel

On Thu, May 19, 2016 at 5:05 PM, Pierce, Marlon <ma...@iu.edu> wrote:

> Pratik, can you confirm that the mysql.jar is correct, uncorrupted, etc?
> Use jar –tf or a similar command to list the contents.
>
>
>
> Marlon
>
>
>
> *From: *Eroma Abeysinghe <er...@gmail.com>
> *Reply-To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
> *Date: *Thursday, May 19, 2016 at 4:51 PM
> *To: *"dev@airavata.apache.org" <de...@airavata.apache.org>
> *Subject: *Re: java.lang.RuntimeException: Failed to create database
> connection pool
>
>
>
> Hi Pratik,
>
>
>
> What is the version you have copied? I copied
> version mysql-connector-java-5.1.38-bin.jar and it worked fine.
>
> Could you try this version?
>
>
>
> Thanks,
> Eroma
>
>
>
> On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <pa...@umail.iu.edu>
> wrote:
>
> Hi Suresh,
>
> Thanks for prompt response.
>
> I have already added mysql.jar in 'lib' folder.
>
> [image: nline image 1]
>
>
>
> I have downloaded the jar file from '
> http://dev.mysql.com/downloads/connector/j/'. This link was provided in
> instructions. Does it automatically look for this jar file or I have to
> provide the complete path of the jar with file name in
> airavata-server.properties file?
>
> Thanks,
> Pratik Patel
>
>
>
> On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org> wrote:
>
> Hi Pratik,
>
>
>
> As you can see from “ Can't find class for driver:” it is looking for the
> mysql jar which should be Step 8 in instructions -
> http://airavata.readthedocs.io/en/latest/Airavata-Installation/
>
>
>
> Suresh
>
>
>
> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
>
>
>
> Hi all,
>
> I am trying to start airavata-server. But I am getting following error
> while doing so:
>
> Command Used:
> $ ./airavata-server.sh start
>
>
>
> Error:
>
>
>
>
>
> 2016-05-19 16:17:08,225 [main] ERROR org.apache.airavata.server.ServerMain
>  - Server Start Error:
>
> java.lang.RuntimeException: Failed to create database connection pool.
>
> at
> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
>
> at
> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
>
> at
> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
>
> at
> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
>
> at
> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
>
> at
> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
>
> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
>
> Caused by: java.sql.SQLException: Can't find class for driver:
>
> at
> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
>
> at
> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
>
> at
> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
>
> at
> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
>
> ... 6 more
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> I have attached log file in this email. Could someone point out where I am
> going wrong?
>
>
>
> <airavata.log>
>
>
>
>
>
>
>
>
>
> --
>
> Thank You,
>
> Best Regards,
>
> Eroma
>

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by "Pierce, Marlon" <ma...@iu.edu>.
Pratik, can you confirm that the mysql.jar is correct, uncorrupted, etc?  Use jar –tf or a similar command to list the contents.

Marlon

From: Eroma Abeysinghe <er...@gmail.com>
Reply-To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Date: Thursday, May 19, 2016 at 4:51 PM
To: "dev@airavata.apache.org" <de...@airavata.apache.org>
Subject: Re: java.lang.RuntimeException: Failed to create database connection pool

Hi Pratik,

What is the version you have copied? I copied version mysql-connector-java-5.1.38-bin.jar and it worked fine.
Could you try this version?

Thanks,
Eroma

On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <pa...@umail.iu.edu>> wrote:
Hi Suresh,

Thanks for prompt response.
I have already added mysql.jar in 'lib' folder.
[nline image 1]

I have downloaded the jar file from 'http://dev.mysql.com/downloads/connector/j/'. This link was provided in instructions. Does it automatically look for this jar file or I have to provide the complete path of the jar with file name in airavata-server.properties file?

Thanks,
Pratik Patel

On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org>> wrote:
Hi Pratik,

As you can see from “ Can't find class for driver:” it is looking for the mysql jar which should be Step 8 in instructions - http://airavata.readthedocs.io/en/latest/Airavata-Installation/

Suresh

On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu>> wrote:

Hi all,

I am trying to start airavata-server. But I am getting following error while doing so:

Command Used:
$ ./airavata-server.sh start

Error:


2016-05-19 16:17:08,225 [main] ERROR org.apache.airavata.server.ServerMain  - Server Start Error:
java.lang.RuntimeException: Failed to create database connection pool.
at org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
at org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
at org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
at org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
at org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
Caused by: java.sql.SQLException: Can't find class for driver:
at org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
at org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
at org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
at org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
... 6 more


--------------------------------------------------------------------------------------------------------------



I have attached log file in this email. Could someone point out where I am going wrong?

<airavata.log>





--
Thank You,
Best Regards,
Eroma

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Eroma Abeysinghe <er...@gmail.com>.
Hi Pratik,

What is the version you have copied? I copied
version mysql-connector-java-5.1.38-bin.jar and it worked fine.
Could you try this version?

Thanks,
Eroma

On Thu, May 19, 2016 at 4:34 PM, Pratik Patel <pa...@umail.iu.edu> wrote:

> Hi Suresh,
>
> Thanks for prompt response.
>
> I have already added mysql.jar in 'lib' folder.
> [image: Inline image 1]
>
> I have downloaded the jar file from '
> http://dev.mysql.com/downloads/connector/j/'. This link was provided in
> instructions. Does it automatically look for this jar file or I have to
> provide the complete path of the jar with file name in
> airavata-server.properties file?
>
> Thanks,
> Pratik Patel
>
> On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org> wrote:
>
>> Hi Pratik,
>>
>> As you can see from “ Can't find class for driver:” it is looking for the
>> mysql jar which should be Step 8 in instructions -
>> http://airavata.readthedocs.io/en/latest/Airavata-Installation/
>>
>> Suresh
>>
>> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
>>
>> Hi all,
>>
>> I am trying to start airavata-server. But I am getting following error
>> while doing so:
>>
>> Command Used:
>> $ ./airavata-server.sh start
>>
>> Error:
>>
>>
>> 2016-05-19 16:17:08,225 [main] ERROR
>> org.apache.airavata.server.ServerMain  - Server Start Error:
>> java.lang.RuntimeException: Failed to create database connection pool.
>> at
>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
>> at
>> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
>> at
>> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
>> at
>> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
>> at
>> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
>> at
>> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
>> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
>> Caused by: java.sql.SQLException: Can't find class for driver:
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
>> at
>> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
>> at
>> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
>> ... 6 more
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> I have attached log file in this email. Could someone point out where I
>> am going wrong?
>>
>> <airavata.log>
>>
>>
>>
>


-- 
Thank You,
Best Regards,
Eroma

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Pratik Patel <pa...@umail.iu.edu>.
Hi Suresh,

Thanks for prompt response.

I have already added mysql.jar in 'lib' folder.
[image: Inline image 1]

I have downloaded the jar file from '
http://dev.mysql.com/downloads/connector/j/'. This link was provided in
instructions. Does it automatically look for this jar file or I have to
provide the complete path of the jar with file name in
airavata-server.properties file?

Thanks,
Pratik Patel

On Thu, May 19, 2016 at 4:29 PM, Suresh Marru <sm...@apache.org> wrote:

> Hi Pratik,
>
> As you can see from “ Can't find class for driver:” it is looking for the
> mysql jar which should be Step 8 in instructions -
> http://airavata.readthedocs.io/en/latest/Airavata-Installation/
>
> Suresh
>
> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
>
> Hi all,
>
> I am trying to start airavata-server. But I am getting following error
> while doing so:
>
> Command Used:
> $ ./airavata-server.sh start
>
> Error:
>
>
> 2016-05-19 16:17:08,225 [main] ERROR org.apache.airavata.server.ServerMain
>  - Server Start Error:
> java.lang.RuntimeException: Failed to create database connection pool.
> at
> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
> at
> org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
> at
> org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
> at
> org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
> at
> org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
> at
> org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
> at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
> Caused by: java.sql.SQLException: Can't find class for driver:
> at
> org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
> at
> org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
> at
> org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
> at
> org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
> ... 6 more
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> I have attached log file in this email. Could someone point out where I am
> going wrong?
>
> <airavata.log>
>
>
>

Re: java.lang.RuntimeException: Failed to create database connection pool

Posted by Suresh Marru <sm...@apache.org>.
Hi Pratik,

As you can see from “ Can't find class for driver:” it is looking for the mysql jar which should be Step 8 in instructions - http://airavata.readthedocs.io/en/latest/Airavata-Installation/ <http://airavata.readthedocs.io/en/latest/Airavata-Installation/>

Suresh

> On May 19, 2016, at 4:26 PM, Pratik Patel <pa...@umail.iu.edu> wrote:
> 
> Hi all,
> 
> I am trying to start airavata-server. But I am getting following error while doing so:
> 
> Command Used:
> $ ./airavata-server.sh start
> 
> Error:
> 
> 
> 2016-05-19 16:17:08,225 [main] ERROR org.apache.airavata.server.ServerMain  - Server Start Error:
> java.lang.RuntimeException: Failed to create database connection pool.
> 	at org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:47)
> 	at org.apache.airavata.api.server.util.CredentialStoreInitUtil.initializeDB(CredentialStoreInitUtil.java:64)
> 	at org.apache.airavata.api.server.AiravataAPIServer.startAiravataServer(AiravataAPIServer.java:74)
> 	at org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:202)
> 	at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:292)
> 	at org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:141)
> 	at org.apache.airavata.server.ServerMain.main(ServerMain.java:124)
> Caused by: java.sql.SQLException: Can't find class for driver: 
> 	at org.apache.airavata.api.server.util.ConnectionPool.makeNewConnection(ConnectionPool.java:200)
> 	at org.apache.airavata.api.server.util.ConnectionPool.initialize(ConnectionPool.java:127)
> 	at org.apache.airavata.api.server.util.ConnectionPool.<init>(ConnectionPool.java:90)
> 	at org.apache.airavata.api.server.util.JdbcStorage.<init>(JdbcStorage.java:41)
> 	... 6 more
> 
> 
> --------------------------------------------------------------------------------------------------------------
> 
> 
> 
> I have attached log file in this email. Could someone point out where I am going wrong?
> 
> <airavata.log>