1 Reply Latest reply on Jun 26, 2013 4:46 PM by Joe Weinstein-Oracle

    Moving Database To New Server

    paulcarron

      Hi,

       

      I'm trying to move a SQL Server database from one server to another. I'm having a problem in that I have a Java application called Sostenuto which connects to this database. I have reconfigured the files in which I can find database details held but I still cant get the application to work with the database on the new server. The logs suggest some sort of login issue but I think I have the login setup correctly. Can anybody please advise? It's been a few years since I have had to look at logs etc so maybe I'm missing something really obvious. Below is an extract from my logs:

       

      2013-06-24 15:14:27,023 ERROR com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Cannot find reference for class="TIMESERVER"
      2013-06-24 15:14:27,023 INFO  com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Reinitialising reference for classTIMESERVER
      2013-06-24 16:14:27,023 INFO  com.sunrisesw.puma.MainCorbaClient.a - MCC->Resolved component=SCHEDULER
      2013-06-24 15:14:27,054 ERROR com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Cannot find reference for class="TIMESERVER"
      2013-06-24 15:14:27,054 INFO  com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Reinitialising reference for classTIMESERVER
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a - Database Parameters
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Server URL = jdbc:sqlserver://10.3.0.249:1433;DatabaseName=Sostenuto;
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Login = sunrise
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Driver Type = 4
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Minimum Connectionse = 10
      2013-06-24 16:14:27,351 INFO  com.sunrisesw.puma.database.ConnectionPool.a -  Increment Connections By = 2
      2013-06-24 15:14:27,382 INFO  com.sunrisesw.puma.MainCorbaClient.a - MCC->Resolved component=TIMESERVER
      2013-06-24 15:14:27,382 INFO  com.sunrisesw.puma.MainCorbaClient.a - MCC->Resolved component=TIMESERVER
      2013-06-24 15:14:40,960 FATAL com.sunrisesw.puma.database.ConnectionPool.<init> - Database driver initialisation failed:
      org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Cannot open database "Sostenuto" requested by the login. The login failed.)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
      at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
      at com.sunrisesw.puma.database.b.<init>(Unknown Source)
      at com.sunrisesw.puma.database.ConnectionPool.<init>(Unknown Source)
      at com.sunrisesw.puma.database.c.<clinit>(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.router.Router.populateMapping(Unknown Source)
      at com.sunrisesw.puma.router.Router.getInstance(Unknown Source)
      at com.sunrisesw.puma.presentation.AdminServlet.init(Unknown Source)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1133)
      at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:787)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:183)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
      at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
      at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "Sostenuto" requested by the login. The login failed.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
      at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
      at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
      at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
      ... 33 more
      2013-06-24 15:14:40,976 FATAL com.sunrisesw.puma.database.c.<clinit> - Init static block
      com.sunrisesw.puma.util.errorhandler.SysException
      at com.sunrisesw.puma.database.ConnectionPool.<init>(Unknown Source)
      at com.sunrisesw.puma.database.c.<clinit>(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.router.Router.populateMapping(Unknown Source)
      at com.sunrisesw.puma.router.Router.getInstance(Unknown Source)
      at com.sunrisesw.puma.presentation.AdminServlet.init(Unknown Source)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1133)
      at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:787)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:183)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
      at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
      at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
      2013-06-24 15:14:40,976 ERROR com.sunrisesw.puma.router.Router.populateMapping -
      java.lang.NullPointerException
      at com.sunrisesw.puma.database.c.singleSelectWithHaving(Unknown Source)
      at com.sunrisesw.puma.database.c.singleSelect(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.router.Router.populateMapping(Unknown Source)
      at com.sunrisesw.puma.router.Router.getInstance(Unknown Source)
      at com.sunrisesw.puma.presentation.AdminServlet.init(Unknown Source)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1133)
      at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:787)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:183)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
      at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
      at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
      at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
      at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
      at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
      at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
      2013-06-24 15:14:40,991 INFO  com.sunrisesw.puma.administration.license.a.a.<init> - Installation PSN = OOE7QUGFPPMCG6U5YDXA
      2013-06-24 15:14:40,991 INFO  com.sunrisesw.puma.administration.license.a.a.<init> - Mutlicast enabled status = true
      2013-06-24 15:14:40,991 INFO  com.sunrisesw.puma.administration.license.a.a.<init> - Multicast timeout interval = 1000
      2013-06-24 15:14:41,007 ERROR com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Cannot find reference for class="DBSQL"
      2013-06-24 15:14:41,007 INFO  com.sunrisesw.puma.MainCorbaClient.getObjectReference - MCC->Reinitialising reference for classDBSQL
      2013-06-24 15:14:41,069 INFO  com.sunrisesw.puma.MainCorbaClient.a - MCC->Resolved component=DBSQL
      2013-06-24 16:14:42,566 FATAL com.sunrisesw.puma.database.ConnectionPool.<init> - Database driver initialisation failed:
      org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Cannot open database "Sostenuto" requested by the login. The login failed.)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
      at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
      at com.sunrisesw.puma.database.b.<init>(Unknown Source)
      at com.sunrisesw.puma.database.ConnectionPool.<init>(Unknown Source)
      at com.sunrisesw.puma.database.c.<clinit>(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.administration.usermanagement.account.Account.getLanguageId(Unknown Source)
      at com.sunrisesw.puma.administration.usermanagement.account.Account.<clinit>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.if(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.char(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.e.a(Unknown Source)
      at com.sunrisesw.puma.MainCorbaServer.main(Unknown Source)
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "Sostenuto" requested by the login. The login failed.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
      at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
      at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
      at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
      at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
      ... 13 more
      2013-06-24 16:14:42,566 FATAL com.sunrisesw.puma.database.c.<clinit> - Init static block
      com.sunrisesw.puma.util.errorhandler.SysException
      at com.sunrisesw.puma.database.ConnectionPool.<init>(Unknown Source)
      at com.sunrisesw.puma.database.c.<clinit>(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.administration.usermanagement.account.Account.getLanguageId(Unknown Source)
      at com.sunrisesw.puma.administration.usermanagement.account.Account.<clinit>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.if(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.char(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.e.a(Unknown Source)
      at com.sunrisesw.puma.MainCorbaServer.main(Unknown Source)
      2013-06-24 16:14:42,566 ERROR com.sunrisesw.puma.MainCorbaServer.main - Sostenuto license status cannot be determined:
      java.lang.NullPointerException
      at com.sunrisesw.puma.database.c.singleSelectWithHaving(Unknown Source)
      at com.sunrisesw.puma.database.c.singleSelect(Unknown Source)
      at com.sunrisesw.puma.database.DBSQLAdapter.singleSelect(Unknown Source)
      at com.sunrisesw.puma.administration.usermanagement.account.Account.getLanguageId(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.if(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.a.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.<init>(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.b.char(Unknown Source)
      at com.sunrisesw.puma.administration.license.a.e.a(Unknown Source)
      at com.sunrisesw.puma.MainCorbaServer.main(Unknown Source)
      2013-06-24 16:14:42,566 INFO  com.sunrisesw.puma.MainCorbaServer.main -

      2013-06-24 16:14:42,566 INFO  com.sunrisesw.puma.MainCorbaServer.main - ###############  Sostenuto Business Components initialisation complete


      Jun 24, 2013 3:14:42 PM com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl convertThrowableToSystemException
      WARNING: "IOP00010202: (UNKNOWN) Unknown user exception thrown by the server"
      org.omg.CORBA.UNKNOWN:   vmcid: SUN  minor code: 202 completed: Maybe
      at com.sun.corba.se.impl.logging.ORBUtilSystemException.runtimeexception(ORBUtilSystemException.java:8365)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.convertThrowableToSystemException(CorbaMessageMediatorImpl.java:1918)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleThrowableDuringServerDispatch(CorbaMessageMediatorImpl.java:1868)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleThrowableDuringServerDispatch(CorbaMessageMediatorImpl.java:1821)
      at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:258)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1680)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
      at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
      at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
      at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
      at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1187)
      at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:398)
      Caused by: java.lang.NullPointerException
      at com.sunrisesw.puma.database.c.beginTransaction(Unknown Source)
      at com.sunrisesw.puma.database.DBSQL.beginTransaction(Unknown Source)
      at com.sunrisesw.puma.database.dbsqlpackage.b._invoke(Unknown Source)
      at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
      at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
      ... 8 more

       

      Any info/advice would be greatly appreciated.

       

      Cheers

      Paul

        • 1. Re: Moving Database To New Server
          Joe Weinstein-Oracle

          It seems clear the config that defines the properties for the

          creation of JDBC connections is broken. I would simplify

          the problem down to a 15-line HelloWorld example program

          from the MS SQLServer JDBC driver. Give that program the

          user,password, URL and properties you think should connect

          you to the DBMS, and once you get that working you'll know

          what to configure in the bigger environment.

          It may be that the new DBMS is not yet configured to accept

          'mixed mode' connections (simple TCP sockets) which is

          what JDBC needs...