[OFBiz] Dev - a data base problem

[CRM-TEAM]

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
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Jacques Le Roux]

Hi Mister no name ;o)

 

I don't think you will find much support on mssqlServer here. Why not using an open source database, like PostGresQL and such ?

 

Jacques

----- Original Message -----

From: [hidden email]

To: [hidden email]

Sent: Wednesday, August 03, 2005 5:14 PM

Subject: [OFBiz] Dev - a data base problem

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
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Adam Heath-2]

On Wed, 3 Aug 2005, 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.

Well, first you haven't provided anything that we can actually use to diagnose
your problem.

What error did you get?

What steps did you take to get to that error?

What version the software?

In short, give details.
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[David E. Jones]

I second the motion.... ;)

Details can sure help... There are people using SQL Server both in  
development and production, in fact I am now and have before worked  
with clients that prefer this database.

-David


On Aug 3, 2005, at 10:14 PM, Adam Heath wrote:

> On Wed, 3 Aug 2005, 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.
>>
>
> Well, first you haven't provided anything that we can actually use  
> to diagnose
> your problem.
>
> What error did you get?
>
> What steps did you take to get to that error?
>
> What version the software?
>
> In short, give details.
>
> _______________________________________________
> Dev mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/dev
>

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[BJ Freeman]

What does the profiler show?

-----Original Message-----
From: CRM-TEAM [mailto:[hidden email]]
Sent: Wednesday, August 03, 2005 3:14 PM
To: [hidden email]
Subject: [OFBiz] Dev - a data base problem

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
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[varadasrini]

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
[e-mail]
http://lists.ofbiz.org/mailman/listinfo/dev