I decided I wanted to replace Derby with SQL Server. I have Express on my laptop so was going to switch to it. I started following the process, attempting to to export everything. it failed with an error...
I noticed some errors when the server starts that seem related.Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Here is the startup in ufsserver.log...
Sun Jun 21 21:58:10: UFS Designer server component initialised successfully
Sun Jun 21 21:58:10: Workflow servlet component initialised successfully
Sun Jun 21 21:58:10: Error starting system service ebaseAssignmentService - com.ebasetech.ufs.utility.PersistenceException: Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Sun Jun 21 21:58:11: Error starting system service ebaseLogonService - com.ebasetech.ufs.utility.PersistenceException: Error getting connection from datasource UFSREPOSITORY, SQLException in StandardPoolDataSource:getConnection exception: java.sql.SQLException: SQLException in StandardPoolDataSource:getConnection no connection available java.sql.SQLException: Cannot get connection for URL jdbc:derby:UFS;create=false : Failed to start database 'UFS', see the next exception for details.
Sun Jun 21 21:58:11: FormCacheLoader: start
Sun Jun 21 21:58:11: FormCacheLoader: end