HI,
Well, i did that and using default database demo data of ofbiz installation
was successful.
when running from MSSQL it is not able to load demo data as explained in my
previous mail.
For running through MSSQL, i did following --->
1) i changed following entries in entityengine.xml
At line no 53
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localmssql"/>
2) I defined datasource at line 520.
<datasource name="localmssql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="dbo"
field-type-name="mssql"
check-on-start="true"
add-missing-on-start="true"
join-style="ansi"
alias-view-columns="false"
use-fk-initially-deferred="false">
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc-uri="jdbc:sqlserver://localhost:1433;databaseName=ofbiz;SelectMethod=cursor;"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"/>
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->
</datasource>
3) i put sqljdbc.jar at E:\workspace\ofbiz4.0\framework\entity\lib\jdbc .
*when i am running ant run-install , the database is created , so there is
no issue with connection.
what could be the reason.
*
Thanks,
Abhijeet Pandey
On Fri, Aug 7, 2009 at 1:41 PM, BJ Freeman <bjf...@free-man.net> wrote:
> my guess is you don't have the entityengine.xml configured properly.
> I suggest first you do a OOTB run-install with the default DB (derby)
> this way you can verify that everything else is working properly.
> Then do mods step by step and validate.
> following the setup guides.
>
> also read through this
> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
>
> Abhijeet Pandey sent the following on 8/6/2009 11:31 PM:
> > Hi,
> >
> > yes i found following error from runtime\logs\ofbiz.html What could be
> the
> > reason?
> >
> > Also please let me know what is the best way to view log. it is from file
> or
> > in the console of eclipse.
> >
> >
> >
> >
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:394:INFO ]
> > 00000 of 10134 from
> > file:/E:/workspace/ofbiz4.0/specialpurpose/webpos/data/DemoPosData.xml
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:399:INFO ]
> The
> > following errors occured in the data load:
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoProduct.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoTopic.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> > "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoTree.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoFactoids.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,457 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoConfigurator.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoRentalProduct.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoTaxAuthority.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoOrderPeopleData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoOrderTestData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoMarketing.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoPurchasing.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoStandardCosting.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoFinAccount.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoProductCategoriesI18nData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/ecommerce/data/DemoTreeContent.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> > "file:/E:/workspace/ofbiz4.0/specialpurpose/pos/data/DemoRetail.xml";
> Error
> > was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/projectmgr/data/ProjectMgrDemoData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/googlecheckout/data/DemoGoogleCheckoutData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> >
> "file:/E:/workspace/ofbiz4.0/specialpurpose/myportal/data/MyPortalDemoData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:401:INFO ]
> > [install.loadData]: Error loading XML Resource
> > "file:/E:/workspace/ofbiz4.0/specialpurpose/webpos/data/DemoPosData.xml";
> > Error was: A transaction error occurred reading data
> > 2009-08-07 11:55:12,473 (main) [EntityDataLoadContainer.java:405:INFO ]
> > =-=-=-=-=-=-= Finished the data load with 10134 rows changed.
> > 2009-08-07 11:55:12,473 (main) [ ContainerLoader.java:114:INFO ] Shutting
> > down containers
> >
> >
> >
> > Thanks,
> >
> > Abhijeet pandey
> >
> >
> >
> > On Thu, Aug 6, 2009 at 11:58 PM, BJ Freeman <bjf...@free-man.net> wrote:
> >
> >> do you have any compile errors
> >> are there any errors in the log files
> >>
> >>
> http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginners+Development+Guide+Using+Practice+Application+%28Hello+World...%29
> >>
> >> Abhijeet Pandey sent the following on 8/6/2009 6:35 AM:
> >>> Hi BJ,
> >>>
> >>> Thanks.
> >>>
> >>> i downloaded ofbiz from trunk.
> >>> and and did ant run-install , but it doesn't loaded with demo data
> unlike
> >>> when i downloaded ofbiz from
> >>> http://svn.ofbiz.org/svn/ofbiz/trunk .
> >>>
> >>> how to load demo data.
> >>>
> >>> also you have mentioned that trunk works well with tutorial. which
> >> tutorial
> >>> and you send me the link for the same.
> >>>
> >>> On Wed, Aug 5, 2009 at 3:17 PM, BJ Freeman <bjf...@free-man.net>
> wrote:
> >>>
> >>>> trunk : http://svn.apache.org/repos/asf/ofbiz/trunk
> >>>> release9.04
> http://svn.apache.org/repos/asf/ofbiz/branches/release09.04
> >>>> release4.0 http://svn.apache.org/repos/asf/ofbiz/branches/release4.0
> >>>> as to which it depends one what you are after.
> >>>> if you just starting use the Trunk since it is the most up to date and
> >>>> works with the tutorial.
> >>>>
> >>>>
> >>>> Abhijeet Pandey sent the following on 8/5/2009 2:41 AM:
> >>>>> so which one should i used to get the code?
> >>>>>
> >>>>> i checked out from
> >>>>>
> >>>>> http://svn.ofbiz.org/svn/ofbiz/trunk
> >>>>>
> >>>>>
> >>>>> is that fine? i didn't get the "themes" folder as told by you.
> >>>>>
> >>>>>
> >>>>> which one to use --> 4.0 or 9.04 ? Also can you please tell me the
> SVN
> >>>>> location for downloading these two.
> >>>>>
> >>>>> Thanks,
> >>>>>
> >>>>> Abhijeet Pandey
> >>>>>
> >>>>> On Wed, Aug 5, 2009 at 3:00 PM, BJ Freeman <bjf...@free-man.net>
> >> wrote:
> >>>>>> *http://svn.ofbiz.org/svn/ofbiz/trunk
> >>>>>> was before ofbiz became part of apache.
> >>>>>> the rev is 7941
> >>>>>> since then we have done two releases 4.0 and 9.04
> >>>>>> current rev is 801085
> >>>>>>
> >>>>>>
> >>>>>> Abhijeet Pandey sent the following on 8/5/2009 2:26 AM:
> >>>>>>> Hi,
> >>>>>>>
> >>>>>>> Thanks for this .
> >>>>>>>
> >>>>>>> should i do the checkout again ?
> >>>>>>>
> >>>>>>>
> >>>>>>> just wanted to know what is the difference between doing checkout
> >> from
> >>>> i
> >>>>>>> checked out ofbiz from using SVN.
> >>>>>>>
> >>>>>>> *http://svn.ofbiz.org/svn/ofbiz/trunk and
> >>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/ .*
> >>>>>>>
> >>>>>>> as i did a checkout from
> >>>>>>> *http://svn.ofbiz.org/svn/ofbiz/trunk . what is the difference
> >> between
> >>>>>>> the two locations ?
> >>>>>>>
> >>>>>>> little confuse about this .*Please help.
> >>>>>>>
> >>>>>>> Thanks,
> >>>>>>>
> >>>>>>> Abhijeet Pandey
> >>>>>>>
> >>>>>>>
> >>>>>>> On Wed, Aug 5, 2009 at 2:36 PM, BJ Freeman <bjf...@free-man.net>
> >>>> wrote:
> >>>>>>>> match you image to
> >>>>>>>> http://svn.apache.org/viewvc/ofbiz/trunk/
> >>>>>>>> you will notice the last folder is theme
> >>>>>>>> if yours does not match this then do an update
> >>>>>>>>
> >>
> http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Source+Repository+and+Access
> >>>>>>>> Abhijeet Pandey sent the following on 8/4/2009 10:22 PM:
> >>>>>>>>> Hi,
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> how can i know which ofbiz version i am using.
> >>>>>>>>>
> >>>>>>>>> i checked out ofbiz from using SVN.
> >>>>>>>>>
> >>>>>>>>> http://svn.ofbiz.org/svn/ofbiz/trunk
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Plz let me know if i have done something wrong.
> >>>>>>>>>
> >>>>>>>>> THanks,
> >>>>>>>>>
> >>>>>>>>> Abhijeet Pandey
> >>>>>>>>>
> >>>>>>>>> On Tue, Aug 4, 2009 at 8:56 PM, BJ Freeman <bjf...@free-man.net>
> >>>>>> wrote:
> >>>>>>>>>> What Version of ofbiz are you using.
> >>>>>>>>>>
> >>>>>>>>>> Abhijeet Pandey sent the following on 8/3/2009 11:14 PM:
> >>>>>>>>>>> Hi,
> >>>>>>>>>>>
> >>>>>>>>>>> couldn't find the folder themes in ofbiz home.
> >>>>>>>>>>>
> >>>>>>>>>>> These are the folder which are under ofbiz -->
> >>>>>>>>>>>
> >>>>>>>>>>> applications
> >>>>>>>>>>>
> >>>>>>>>>>> framework
> >>>>>>>>>>>
> >>>>>>>>>>> hot-deploy
> >>>>>>>>>>>
> >>>>>>>>>>> runtime
> >>>>>>>>>>>
> >>>>>>>>>>> specialpurpose
> >>>>>>>>>>>
> >>>>>>>>>>> and few batch files and ant files.
> >>>>>>>>>>>
> >>>>>>>>>>> is it that i have missed something.
> >>>>>>>>>>> Plz let me know.
> >>>>>>>>>>>
> >>>>>>>>>>> Thanks,
> >>>>>>>>>>> Abhijeet Pandey
> >>>>>>>>>>> On Tue, Aug 4, 2009 at 4:31 AM, BJ Freeman <
> bjf...@free-man.net>
> >>>>>>>> wrote:
> >>>>>>>>>>>> {ofbizhome}/themes/mutilex
> >>>>>>>>>>>> had the layout of the default Ecommerce.
> >>>>>>>>>>>> the CSS file position things.
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>>>> Abhijeet Pandey sent the following on 8/2/2009 10:32 PM:
> >>>>>>>>>>>>> Hello Everyone,
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> I am new to Ofbiz and i have installed it on my system.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> i have few queries, it will be nice if i can get some help /
> >>>> guide.
> >>>>>>>>>>>>> i want to change the look and feel of the site. like say i
> >> don't
> >>>>>> want
> >>>>>>>>>> to
> >>>>>>>>>>>> put
> >>>>>>>>>>>>> logo and want to put Advertisement in header or i would like
> to
> >>>> put
> >>>>>>>>>>>> search
> >>>>>>>>>>>>> box in header.
> >>>>>>>>>>>>> Like i don't want to show promotional stuff on top at home
> >> page.
> >>>> i
> >>>>>>>> want
> >>>>>>>>>>>> to
> >>>>>>>>>>>>> put them in middle and i would like to put some thing else
> over
> >>>>>>>> there.
> >>>>>>>>>>>>> also how i can decide what all will come in left and right?
> how
> >> i
> >>>>>> can
> >>>>>>>>>>>> change
> >>>>>>>>>>>>> the footer? how i can attach static pages ? how i can put
> those
> >>>>>> links
> >>>>>>>>>> in
> >>>>>>>>>>>>> header / footer?
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> Idea is how to do all this, how i can know which ftl file is
> >> for
> >>>>>>>> which
> >>>>>>>>>>>> page,
> >>>>>>>>>>>>> which tables are there for which purpose.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> Plz guide me what is the best way to go about it.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> Thanks in advance.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>
> >>>>>>>>>>>> --
> >>>>>>>>>>>> BJ Freeman
> >>>>>>>>>>>> http://www.businessesnetwork.com/automation
> >>>>>>>>>>>> http://bjfreeman.elance.com
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >>>>>>>>>>>> Systems Integrator.
> >>>>>>>>>>>>
> >>>>>>>>>>>>
> >>>>>>>>>> --
> >>>>>>>>>> BJ Freeman
> >>>>>>>>>> http://www.businessesnetwork.com/automation
> >>>>>>>>>> http://bjfreeman.elance.com
> >>>>>>>>>>
> >>>>>>>>>>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >>>>>>>>>> Systems Integrator.
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>> --
> >>>>>>>> BJ Freeman
> >>>>>>>> http://www.businessesnetwork.com/automation
> >>>>>>>> http://bjfreeman.elance.com
> >>>>>>>>
> >>>>>>>>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >>>>>>>> Systems Integrator.
> >>>>>>>>
> >>>>>>>>
> >>>>>> --
> >>>>>> BJ Freeman
> >>>>>> http://www.businessesnetwork.com/automation
> >>>>>> http://bjfreeman.elance.com
> >>>>>>
> >>>>>>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >>>>>> Systems Integrator.
> >>>>>>
> >>>>>>
> >>>> --
> >>>> BJ Freeman
> >>>> http://www.businessesnetwork.com/automation
> >>>> http://bjfreeman.elance.com
> >>>>
> >>>>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >>>> Systems Integrator.
> >>>>
> >>>>
> >>>
> >> --
> >> BJ Freeman
> >> http://www.businessesnetwork.com/automation
> >> http://bjfreeman.elance.com
> >>
> >>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >> Systems Integrator.
> >>
> >>
> >
> >
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
>
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
>
>
--
Abhijeet Pandey
