Question & Answer > View Question

Cannot create PoolableConnectionFactor in the LOGS

Confluence User - 13 Jan, 2021

Hi guys,

I'm started using recently Joget cloud community edition.

I'm trying to make a simple UPDATE at the Post Processing Tool-> DATABASE UPDATE TOOL to test something I need with the following QUERY.

update app_fd_test set field1="yessss"

But nothing was UPDATED and reviewing the LOGS, I see this error: Cannot create PoolableConnectionFactor in the LOGS, and I'm guessing that is the origin of the problem, can you guys help me please?

I would like also to see the tables structure to see table & field names.... where is it possible with this community edition cloud version?

And if it is no possible in the cloud edition, if not, using the desktop edition, where I can see table structures and make queries?

THANKS!!

server;forms

3

Confluence User •

13 Jan, 2021 •

confluenceUser •

•

confluenceUser •

If you download and install the Joget DX on-premise version, you can access the database running on MariaDB using DB tools like SQLyog Community. The database name is jwdb and your app form records are stored into the database as app_fd_tablename. Table columns or fields in your form are named as c_fieldId. You can access the database in your Joget app and populate your forms using JDBC Form Binder, for example.

Confluence User •

14 Jan, 2021 •

confluenceUser •

•

confluenceUser •

Thanks Matthew, I downloaded SQLyog Community, but I get this error message: Can't connect to MySQLServer on 'localhost' when I try to connect. I read other article saying that the password for the ROOT user is blank.

THANKS IN ADVANCE.

Confluence User •

14 Jan, 2021 •

confluenceUser •

1 •

confluenceUser •

The Joget database connection string can be found in the text file "[JogetFolder]\wflow\app_datasource-default.properties". The default setting is:

workflowDriver=com.mysql.jdbc.Driver
workflowUrl=jdbc\:mysql\://localhost\:3307/jwdb?characterEncoding\=UTF-8&useSSL\=false&allowPublicKeyRetrieval\=true
workflowUser=root
profileName=
workflowPassword=

1

CSV | Excel | XML | PDF

Your answer

Print

Cannot create PoolableConnectionFactor in the LOGS

3

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

3.builder-style-0edfad5f-8026-4ca1-ac58-a55061ec0f00{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-bb76c327-0eea-4cb8-a2d3-6c929ddad1a1{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

3

Your answer