Hi ,
I am having the same problem with MS SQl Server 2000 with JDBC Service pack
3 drivers.Anyone please advice the solution to solve this bug.All the
parameters have been checked with login,pass and Driver name.
Please suggest atleast some know fixes for the error (see below).
Thanks
--Srini
*****************************************************************
2007-09-10 18:46:45,281 (main) [XAConnectionFactory.java:371:ERROR] Can't
get an XAConnection
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:223)
at
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnectionFactory.java:367)
at
org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:942)
at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
at org.ofbiz.minerva.pool.ObjectPool.fillToMin(ObjectPool.java:961)
at org.ofbiz.minerva.pool.ObjectPool.initialize(ObjectPool.java:533)
at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(XAPoolDataSource.java:313)
at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:349)
at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92)
at
org.ofbiz.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:158)
at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104)
at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82)
at
org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:105)
at
org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:832)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:141)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:130)
at org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1108)
at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:208)
at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:195)
at
org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:127)
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:184)
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:89)
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
at org.ofbiz.base.start.Start.startServer(Start.java:323)
at org.ofbiz.base.start.Start.start(Start.java:327)
at org.ofbiz.base.start.Start.main(Start.java:413)
2007-09-10 18:46:45,312 (main) [ ObjectPool.java:632:ERROR]
Exception in creating new object for pool
java.lang.RuntimeException: Could not create connection
at
org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:944)
at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:630)
at org.ofbiz.minerva.pool.ObjectPool.fillToMin(ObjectPool.java:961)
at org.ofbiz.minerva.pool.ObjectPool.initialize(ObjectPool.java:533)
at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.initialize(XAPoolDataSource.java:313)
at
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:349)
at
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:122)
at
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92)
at
org.ofbiz.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:158)
at
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104)
at
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82)
at
org.ofbiz.entity.jdbc.DatabaseUtil.getConnection(DatabaseUtil.java:105)
at
org.ofbiz.entity.jdbc.DatabaseUtil.getTableNames(DatabaseUtil.java:832)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:141)
at org.ofbiz.entity.jdbc.DatabaseUtil.checkDb(DatabaseUtil.java:130)
at org.ofbiz.entity.datasource.GenericDAO.checkDb(GenericDAO.java:1108)
at
org.ofbiz.entity.datasource.GenericHelperDAO.checkDataSource(GenericHelperDAO.java:208)
at org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:195)
at
org.ofbiz.entity.GenericDelegator.getGenericDelegator(GenericDelegator.java:127)
at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:184)
at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:89)
at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
at org.ofbiz.base.start.Start.startServer(Start.java:323)
at org.ofbiz.base.start.Start.start(Start.java:327)
at org.ofbiz.base.start.Start.main(Start.java:413)
CRM-TEAM wrote:
>
> hi...
> i'm trying to connect to mssqlServer 2000 ,but there is an error.
> i've installed the jdbc driver for mssqlserver and defined the class path
> .
> i've read the docs about how to install the jdbc for sql server 2000.
>
> can any one tell me how to solve the problem.
>
> thanks...
>
>
> _______________________________________________
> Dev mailing list
> [EMAIL PROTECTED]
> http://lists.ofbiz.org/mailman/listinfo/dev
>
--
View this message in context:
http://www.nabble.com/-OFBiz--Dev---a-data-base-problem-tf195870.html#a12594212
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
