We've used two - the Microsoft driver and JTDS. The Microsoft driver
created even more problems. David Jones had recommended JTDS, so we have
settled on that.
Vince Clark wrote:
Have you tried different jdbc drivers?
Dave Tenerowicz wrote:
We are still having issues with ofBiz and SQL Server 2005. Basically
the issue is that the automatic shopping list service does not run
after we change the db from Derby to SQL Server.
If we force the "runShoppingListAutoReorder" process to run, it seems
to hang. The process will run forever, as if waiting for input.
Although we can resolve the issue temporarily by commenting some
sections of createListReorders in shoppingListServices.java, this is
not a real solution.
Does anyone have any experience using SQL Server with ofBiz, or have
any idea what could be going on here?
Thanks!
Dave Tenerowicz
2007/8/8, William Perng <[EMAIL PROTECTED]>:
I tried the ntext, it still doesn't work for me. However, it works
after I comment out
"dispatcher.runAsync("sendOrderPayRetryNotification",
UtilMisc.toMap("orderId", orderId));" in createListReorders method
of ShoppingListServices.java. It is hung before the control reaches
the implementation of "sendOrderPayRetryNotification" service.
There is no error message since it looks like the system is waiting
for something.
Thanks
-----Original Message-----
From: Amine AZZI [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 3:58 PM
To: [email protected]; [EMAIL PROTECTED]
Subject: Re: ms sql server 2005 shoppinglist problem
Try put it ntext, this is the type I used (I didn't try text) Did
you reset ofbiz?
if it doesn't still work, try to see the log, or run the service
directly from the webtools module through the service reference menu
(you select the service, and then click on schedule)
2007/8/7, William Perng <[EMAIL PROTECTED]>:
>
> I double check my RUNTIME_DATA column in runtimeInfo table. It
has > been set to type "text", and it still doesn't work. Please
help, > thanks.
>
> -----Original Message-----
> From: William Perng [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 07, 2007 11:39 AM
> To: [email protected]
> Subject: RE: ms sql server 2005 shoppinglist problem
>
> The type of that column is text now. Thanks
>
> -----Original Message-----
> From: Amine AZZI [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 07, 2007 11:10 AM
> To: [email protected]; [EMAIL PROTECTED]
> Subject: Re: ms sql server 2005 shoppinglist problem
>
> it's because of the field runtimeInfo in the table RUNTIME_DATA
that > hasn't the suitable size, it should be changed to type text
or ntext.
>
> Amine.
>
> 2007/8/7, William Perng <[EMAIL PROTECTED]>:
> >
> > My ofbiz instance uses ms sql server 2005. The schedule service
> > doesn't generate orders from my automatic re-orders shopping lists.
> > If I force the "runShoppingListAutoReorder" process to run, it >
> seems the process will run forever. I don't see error in log > >
file. I have tried the source code from trunk and Release4.0, and >
> also tried ms jdbc driver and jtds driver. If I use derby,
everything
is ok.
> > Any idea ?
> >
> > Thanks
> >
> >
> > William Perng
> > [EMAIL PROTECTED]
> > (516) 742-7888 Ext; 223
> > Yahoo IM: william.perng
> >
> >
> >
> >
> >
>
>
>
>
>
>
--
Dave Tenerowicz
[EMAIL PROTECTED]
Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330
Visit us at http://www.salmonllc.com
