Datatables server processing not working after publishing

Datatables server processing not working after publishing

motawfikmotawfik Posts: 5Questions: 3Answers: 0
edited February 2019 in Free community support

I have a project that uses data tables in it
It works fine on the localhost, but when I hosted the website the data table isn't working
DataTables warning: table id=baseTable - org.hibernate.TransactionException: JDBC begin transaction failed:
Popping up an alert with this message
I am using server side, the application is written in Java and hosted on Wildfly
(There are Arabic data if it matters)
I would appreciate any help
Thanks in advance

Edit
When I tried to view the JSON returned
{ draw: 1, recordsTotal: 0, recordsFiltered: 0, data: [ ], error: "org.hibernate.TransactionException: JDBC begin transaction failed: " }
This was the result

Answers

  • colincolin Posts: 15,143Questions: 1Answers: 2,586

    Hi @motawfik ,

    It looks like it's not able to communicate with an external server. It would be worth checking the browser's console in dev tools (hit F12), that may give some clues. Normally these would be permission issues, where the new server doesn't have access to the DB or some other resource.

    Cheers,

    Colin

  • motawfikmotawfik Posts: 5Questions: 3Answers: 0
    edited February 2019

    Thanks @colin, but the application is able to communicate with the server (as I have a login page that the credentials are saved at a table in the database)
    The server is a SQL Server that is hosted on the same computer, I hope to find an answer as it saves me a lot of time and efforts

This discussion has been closed.