I had an existing working version of LiveCycle on Server A which had two drives; A.1 and A.2. Do to space constraints we decided to move the Adobe LiveCycle ES2 folder from drive A.1 to A.2. We had not created anything so we werent worried about loosing any data. When it was installed on to drive A.1 it was runnning on the default MYSQL database that is created when you install using jboss turnkey. . But now we want to connect our jboss application to a SQL server database. I went ahead and walked through the documentation in order create the database and users. I also made the modicications to the XML files within jboss. The problem I am having is when I try to run the LiveCycle ES2 Database Initialization in the Configuration Manager, I get the following error:
com.adobe.livecycle.bootstrap.BootstrapException: ALC-TTN-109-000: Could not establish a valid connection to server: [Unexpected end of file from server]
Caused by: java.net.SocketException: Unexpected end of file from server
... 6 more
Are there other files that I need to configure in order to switch the application from the default MYSQL to the new SQL Database? And is there any way for me to test the connection to the database before I attempt to initialize it.
First and foremost you cannot use the XMLs which are part of turnkey JBoss directly.
You should discard adobe-ds.xml and mysql-ds.xml from <LiveCycle Root>/jboss/server/<server profile>/deploy and get hold of SQL Server specific adobe-ds.xml and mssql-ds.xml and then make necessary modifications w.r.t your SQL Server.
In addition to this you would have to modify login-config.xml as well to add an entry of application policy for MSSQL DB.
If you have performed all these steps and still issues are coming then the error could be because of any of the reasons mentioned below:
The XMLs that you have configured
The connection pools configured
Missing database driver jar
I would recommend the following:
1) Make sure driver jar for SQL Server (most probably sqljdbc.jar) exists in <LiveCycle Root>/jboss/server/<server profile>/lib directory
2) Ensure that you have modified the following XML files correctly:
adobe-ds.xml and mssql-ds.xml inside <LiveCycle Root>/jboss/server/<server profile>/deploy directory