Re: how to create themes with JSP
Thank you BJ, I created a header.jsp: VisualThemeResource visualThemeId=FLAT_GREY resourceTypeEnumId=VT_HDR_TMPLT_LOC resourceValue=component://flatgrey/includes/header.jsp sequenceId=01/ tried it but I got this: [java] 2011-07-11 02:58:18,630 (http-0.0.0.0-8443-1) [ ControlServlet.java:230:ERROR] [java] exception report -- [java] Error in request handler: [java] Exception: org.ofbiz.widget.screen.ScreenRenderException [java] Message: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp (Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp) [java] cause - [java] Exception: java.lang.IllegalArgumentException [java] Message: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp [java] stack trace --- [java] java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp Am I missing something ? On Sun Jul 10,2011 09:39 pm, BJ Freeman wrote: JSP is being depreciated, but is usable. take a look at the seed data for Themes and see if you can duplicate the ftl's Mansour Al Akeel sent the following on 7/10/2011 5:56 PM: Is't possible to create themes with JSP ?
Re: how to create themes with JSP
BJ, sorry! foregot to include the version number. I am using realse 10.04 from the zip file. Thank you On Mon Jul 11,2011 03:05 am, Mansour Al Akeel wrote: Thank you BJ, I created a header.jsp: VisualThemeResource visualThemeId=FLAT_GREY resourceTypeEnumId=VT_HDR_TMPLT_LOC resourceValue=component://flatgrey/includes/header.jsp sequenceId=01/ tried it but I got this: [java] 2011-07-11 02:58:18,630 (http-0.0.0.0-8443-1) [ ControlServlet.java:230:ERROR] [java] exception report -- [java] Error in request handler: [java] Exception: org.ofbiz.widget.screen.ScreenRenderException [java] Message: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp (Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp) [java] cause - [java] Exception: java.lang.IllegalArgumentException [java] Message: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp [java] stack trace --- [java] java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp Am I missing something ? On Sun Jul 10,2011 09:39 pm, BJ Freeman wrote: JSP is being depreciated, but is usable. take a look at the seed data for Themes and see if you can duplicate the ftl's Mansour Al Akeel sent the following on 7/10/2011 5:56 PM: Is't possible to create themes with JSP ?
Re: how to create themes with JSP
I don't use JSP and except for webtools, and the index.jsp in each webapp I don't know of any JSP used in ofbiz. As I mentioned it is not supported except for being used at the level it is used now. unless someone else chimes in you pretty much on your own. Mansour Al Akeel sent the following on 7/11/2011 12:05 AM: Thank you BJ, I created a header.jsp: VisualThemeResource visualThemeId=FLAT_GREY resourceTypeEnumId=VT_HDR_TMPLT_LOC resourceValue=component://flatgrey/includes/header.jsp sequenceId=01/ tried it but I got this: [java] 2011-07-11 02:58:18,630 (http-0.0.0.0-8443-1) [ ControlServlet.java:230:ERROR] [java] exception report -- [java] Error in request handler: [java] Exception: org.ofbiz.widget.screen.ScreenRenderException [java] Message: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp (Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp) [java] cause - [java] Exception: java.lang.IllegalArgumentException [java] Message: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp [java] stack trace --- [java] java.lang.IllegalArgumentException: Rendering not yet supported for the template at location: component://flatgrey/includes/header.jsp Am I missing something ? On Sun Jul 10,2011 09:39 pm, BJ Freeman wrote: JSP is being depreciated, but is usable. take a look at the seed data for Themes and see if you can duplicate the ftl's Mansour Al Akeel sent the following on 7/10/2011 5:56 PM: Is't possible to create themes with JSP ?
Re: Entity Engine Doc out of date
BJ Freeman wrote: http://ofbiz.apache.org/docs/entity.html comes up first in search engines. *it talks about a transaction class not used for a long time.* however updating it for 3.0, 9.04 and 10.4? Hi, I have been just trying to understand the OFBiz transaction mechanisms (for research purposes), and I came about this post (sorry if not directly related to the documentation issue). Do you mean that the whole JTA Support section is outdated, or only some parts of it? That is, aren't TransactionFactory and TransactionUtil classes still being used? Or only the Tyrex-related classes are outdated? Thanks. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Entity-Engine-Doc-out-of-date-tp3638948p3659253.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Entity Engine Doc out of date
look at the /framework/entity/config/entityengine.xml ahmadi sent the following on 7/11/2011 4:17 AM: BJ Freeman wrote: http://ofbiz.apache.org/docs/entity.html comes up first in search engines. *it talks about a transaction class not used for a long time.* however updating it for 3.0, 9.04 and 10.4? Hi, I have been just trying to understand the OFBiz transaction mechanisms (for research purposes), and I came about this post (sorry if not directly related to the documentation issue). Do you mean that the whole JTA Support section is outdated, or only some parts of it? That is, aren't TransactionFactory and TransactionUtil classes still being used? Or only the Tyrex-related classes are outdated? Thanks. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Entity-Engine-Doc-out-of-date-tp3638948p3659253.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Entity Engine Doc out of date
http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/config/entityengine.xml?view=log BJ Freeman sent the following on 7/11/2011 5:51 AM: look at the /framework/entity/config/entityengine.xml ahmadi sent the following on 7/11/2011 4:17 AM: BJ Freeman wrote: http://ofbiz.apache.org/docs/entity.html comes up first in search engines. *it talks about a transaction class not used for a long time.* however updating it for 3.0, 9.04 and 10.4? Hi, I have been just trying to understand the OFBiz transaction mechanisms (for research purposes), and I came about this post (sorry if not directly related to the documentation issue). Do you mean that the whole JTA Support section is outdated, or only some parts of it? That is, aren't TransactionFactory and TransactionUtil classes still being used? Or only the Tyrex-related classes are outdated? Thanks. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Entity-Engine-Doc-out-of-date-tp3638948p3659253.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Creating parties
Ok, I ordered the book, and just recieved it. I will check this part as soon as I can. I didn't recieve the CD with the book. Is this important ? On Mon Jun 27,2011 09:29 am, BJ Freeman wrote: as both Adrian and I mentioned most of that would be described well in the Data model book that ofbiz was modeled after, which is why not much documentation is written specifically in ofbiz. There are emails in the archive that have covered different parts of your question. Actually it has been a good time for the Documentation for over 6 years, problem is getting someone to volunteer to do it. We have added internal Help in ofbiz that needs to be filled out. ANY VOLUNTEERS. Normally such Contributions have been from someone hiring someone to do the documentation, because it takes a lot of time to volunteer and those that have to make a living do not have such time free. Then that documentation was volunteered to ofbiz community. I limit my volunteer time per subject on the mailing list to 15 min, unless i have a vested interest in it. I have even stopped answering on here because my time has become very limited. as an example this email took over two hours to finish because of interruptions to do business. so maybe others that have the time will volunteer the information you desire. Most find the charge for the BOOK a lot less than hiring someone, or volunteering the time to document. That said, feel free once you understand to volunteer you time to documented this the way you think it should be done. BTW I have made this offer to others that presented the same proposal in the past and they have not volunteer such documentation yet. I would suggest you draw an organizational chart then use the fields in ofbiz to associated the chart to relationships. There is no ONE organization chart. Demo employee shows two relationships as examples, in a normal Company there may be many relationships. like the one that says the demo employee is a employee. you would use roles and relationship Mansour Al Akeel sent the following on 6/27/2011 4:28 AM: BJ thank you. My question is related more to ofbiz usage. In the relationship page: https://demo-trunk.ofbiz.apache.org/partymgr/control/EditPartyRelationships?partyId=DemoEmployee you can see some fields that are not clear to me. To be more specific, We have: in the role of | is Aof Party| in the role of There two relations for DemoEmployee. And each relation has two fields in the Role Of. Further more, there is some confusion about where to relate employee to organization. I mean if you go to: https://demo-trunk.ofbiz.apache.org/partymgr/control/viewprofile?partyId=DemoEmployee You will see four tabs with labels indicates similar functionality: -Roles -Link Party -Relationships -Segments What is the difference between these ? To add employee to Organization I need to use . ? May be it's a good opportunity to discuss and document each of them, instead of referring me to the BOOK ;) On Sun, Jun 26, 2011 at 9:10 PM, BJ Freeman bjf...@free-man.net wrote: there is not much documented in ofbiz about party. however if you read the Data model book Vol I you will see a lot about partyrelationsips. Good diagram on pg 41 In this case you would have party relationship with the company that supplies contractors so you need to setup the roles of each party then setup the relationship between them start with organizational party relationship then individual (person) realtionships with organizations. example the programmer would be a employee role with the recruitment company if they contract, then the programmer would have a contractor relationship with the Company. the rest you can get from the demo data or you can look at the demo site at the different parties to see the relationships. Mansour Al Akeel sent the following on 6/26/2011 4:43 PM: Hello all, I didn't use the parties component extensively, and don't know a lot about it. Here's the scenario we have. Three Group parties: Programmers Recruiter Sales /marketing/Distributing The distributor obtains the requirements and hires the Programmers through the Recruitment company. Billing is done by hour. In each company there's two employees that interact with the system. programmer1 , programmer2 hr manager 1, hr manager2 project manager1, project manager2 We need to setup the system, to handle the requirements communication, timesheet, project management ... etc. I have created the three group parties, and 6 employees parties, and stopped there not knowing how to connect them. How to associate users (employee) with companies (Group Party) ? I tried to go to Relationships page and use Add other party relationship, but those fields are not clear to me. For example in the Role of etc. Let's say I need
Re: Creating parties
cd is not important, since you have all entity related info in the webtools. Mansour Al Akeel sent the following on 7/11/2011 8:21 AM: Ok, I ordered the book, and just recieved it. I will check this part as soon as I can. I didn't recieve the CD with the book. Is this important ? On Mon Jun 27,2011 09:29 am, BJ Freeman wrote: as both Adrian and I mentioned most of that would be described well in the Data model book that ofbiz was modeled after, which is why not much documentation is written specifically in ofbiz. There are emails in the archive that have covered different parts of your question. Actually it has been a good time for the Documentation for over 6 years, problem is getting someone to volunteer to do it. We have added internal Help in ofbiz that needs to be filled out. ANY VOLUNTEERS. Normally such Contributions have been from someone hiring someone to do the documentation, because it takes a lot of time to volunteer and those that have to make a living do not have such time free. Then that documentation was volunteered to ofbiz community. I limit my volunteer time per subject on the mailing list to 15 min, unless i have a vested interest in it. I have even stopped answering on here because my time has become very limited. as an example this email took over two hours to finish because of interruptions to do business. so maybe others that have the time will volunteer the information you desire. Most find the charge for the BOOK a lot less than hiring someone, or volunteering the time to document. That said, feel free once you understand to volunteer you time to documented this the way you think it should be done. BTW I have made this offer to others that presented the same proposal in the past and they have not volunteer such documentation yet. I would suggest you draw an organizational chart then use the fields in ofbiz to associated the chart to relationships. There is no ONE organization chart. Demo employee shows two relationships as examples, in a normal Company there may be many relationships. like the one that says the demo employee is a employee. you would use roles and relationship Mansour Al Akeel sent the following on 6/27/2011 4:28 AM: BJ thank you. My question is related more to ofbiz usage. In the relationship page: https://demo-trunk.ofbiz.apache.org/partymgr/control/EditPartyRelationships?partyId=DemoEmployee you can see some fields that are not clear to me. To be more specific, We have: in the role of | is Aof Party| in the role of There two relations for DemoEmployee. And each relation has two fields in the Role Of. Further more, there is some confusion about where to relate employee to organization. I mean if you go to: https://demo-trunk.ofbiz.apache.org/partymgr/control/viewprofile?partyId=DemoEmployee You will see four tabs with labels indicates similar functionality: -Roles -Link Party -Relationships -Segments What is the difference between these ? To add employee to Organization I need to use . ? May be it's a good opportunity to discuss and document each of them, instead of referring me to the BOOK ;) On Sun, Jun 26, 2011 at 9:10 PM, BJ Freeman bjf...@free-man.net wrote: there is not much documented in ofbiz about party. however if you read the Data model book Vol I you will see a lot about partyrelationsips. Good diagram on pg 41 In this case you would have party relationship with the company that supplies contractors so you need to setup the roles of each party then setup the relationship between them start with organizational party relationship then individual (person) realtionships with organizations. example the programmer would be a employee role with the recruitment company if they contract, then the programmer would have a contractor relationship with the Company. the rest you can get from the demo data or you can look at the demo site at the different parties to see the relationships. Mansour Al Akeel sent the following on 6/26/2011 4:43 PM: Hello all, I didn't use the parties component extensively, and don't know a lot about it. Here's the scenario we have. Three Group parties: Programmers Recruiter Sales /marketing/Distributing The distributor obtains the requirements and hires the Programmers through the Recruitment company. Billing is done by hour. In each company there's two employees that interact with the system. programmer1 , programmer2 hr manager 1, hr manager2 project manager1, project manager2 We need to setup the system, to handle the requirements communication, timesheet, project management ... etc. I have created the three group parties, and 6 employees parties, and stopped there not knowing how to connect them. How to associate users (employee) with companies (Group Party) ? I tried to go to Relationships page and use Add other party relationship, but those fields are not clear to me. For
Re: upload pdf content for a task
BJ, I tried cleaning and reinstalling the data many times, with no luck. It doesn't hurt to try once more, but I am certain it won't help. On Sat Jul 09,2011 05:43 pm, Mansour Al Akeel wrote: Ok, I created an issue before I foreget something: https://issues.apache.org/jira/browse/OFBIZ-4336 Will attach additional info when I have them. On Sat Jul 09,2011 02:31 pm, BJ Freeman wrote: can do the same thing in eclipse but you have to know the pattern you looking for. If I had time would go through history available through svn. Mansour Al Akeel sent the following on 7/9/2011 2:25 PM: BJ, I appreciate your help. I am looking to report it, but may be it will help a bit more if I can locate the date/revision where the bug was introduced. I use git which allows me to perform binary search in the history to locate the bug. I will see what I can come up with. On Sat, Jul 9, 2011 at 5:05 PM, BJ Freeman bjf...@free-man.net wrote: open a Jira and put all that you have found so far. Mansour Al Akeel sent the following on 7/9/2011 1:24 PM: Release 10.04 is working fine. I can upload PDF files, jar files, zip files, JPG images ... etc. It looks like a bug was introduced somewhere. On Sat, Jul 9, 2011 at 2:00 PM, BJ Freeman bjf...@free-man.net wrote: The demo I have is not the current trunk so I can not confirm. when have some free time will download the trunk and run a test. can not guaranteeing that will be soon. Mansour Al Akeel sent the following on 7/9/2011 10:10 AM: I am not using selinux. It's disabled. I just tried to start ofbiz as a root, and the same issue. Changed the database engine from derby to postgresql, and the same problem exists. I am using gentoo. java version 1.6.0_26 Java(TM) SE Runtime Environment (build 1.6.0_26-b03) Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode) Can you please confirm it's working on your local machine with the default config. If it's not working either, this means I am missing some config. I think this is the only way to narrow down the issue. Thank you. On Sat Jul 09,2011 09:38 am, BJ Freeman wrote: I have not addressed this particular upload. I doubt my solution of not using the bulk upload would work for you. I don't use the trunk or any ofbiz pure code so I can't be of any help further than i have been. it is something particular to the files you are having trouble with and is not the code, since it works on the demo. how about the JDK I run Centos 5.6 with open JDK but the recommended is the Sun JDK. Just a way out thought, possibly a selinux setting. Mansour Al Akeel sent the following on 7/9/2011 8:42 AM: BJ, how did you fix it? My JAVA_OPTS is -Xms1024m -Xmx2048m with 8 GB machine. Is there any settings for the uploaded files. I tried uploading a 31 MB text file and it went through and worked fine. Still can not upload a 260 KB PDF file ! I just started again from scratch, and got the source from git, rebuilt and ran the new instance with no luck, and the same results. Something wierd going on. I am working on linux wich is what the demo is running. Any idea ? On Sat Jul 09,2011 08:32 am, BJ Freeman wrote: it would be memory size. uploads require use of global memory. if you don't have enough then the upload is aborted. Atleast that was my experience on uploading large files. Mansour Al Akeel sent the following on 7/9/2011 7:00 AM: BJ, I really appreciate your help. I am a bit lost here. The issue exists only on my local instance. The demo https://demo-trunk.ofbiz.apache.org/ is working properly. My local instance is pulled from trunk. Not sure if there's some configuration I missed. On Sat, Jul 9, 2011 at 9:40 AM, Mansour Al Akeel mansour.alak...@gmail.com wrote: thank you BJ. It is working on the demo. On Sat, Jul 9, 2011 at 4:20 AM, BJ Freeman bjf...@free-man.net wrote: somewhere between the PorjectScreens.xml#EditProjectContents and saveLocalFileDataResource the information is not put in context, is my guess. Mansour Al Akeel sent the following on 7/8/2011 9:11 PM: I am unable to upload jpg images either. Some formats are ok like xml, text, png. The log says there's no content found, but the file is a valid pdf file, and it exists! I am stuck, and need some help. Thank you a lot. Here's the log: [java] org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) [java] org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [java] org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) [java]
Re: upload pdf content for a task
BJ, I tried cleaning and rebuilding: ./ant clean-all ./ant run-install ./ant run With: ofbiz 10.04 from zip, it worked fine. ofbiz trunk, can not upload pdf. Failed ofbiz 11.04 branch from git, it didn't work. Failed So it has nothing to do with the data seeds. On Sat Jul 09,2011 05:43 pm, Mansour Al Akeel wrote: Ok, I created an issue before I foreget something: https://issues.apache.org/jira/browse/OFBIZ-4336 Will attach additional info when I have them. On Sat Jul 09,2011 02:31 pm, BJ Freeman wrote: can do the same thing in eclipse but you have to know the pattern you looking for. If I had time would go through history available through svn. Mansour Al Akeel sent the following on 7/9/2011 2:25 PM: BJ, I appreciate your help. I am looking to report it, but may be it will help a bit more if I can locate the date/revision where the bug was introduced. I use git which allows me to perform binary search in the history to locate the bug. I will see what I can come up with. On Sat, Jul 9, 2011 at 5:05 PM, BJ Freeman bjf...@free-man.net wrote: open a Jira and put all that you have found so far. Mansour Al Akeel sent the following on 7/9/2011 1:24 PM: Release 10.04 is working fine. I can upload PDF files, jar files, zip files, JPG images ... etc. It looks like a bug was introduced somewhere. On Sat, Jul 9, 2011 at 2:00 PM, BJ Freeman bjf...@free-man.net wrote: The demo I have is not the current trunk so I can not confirm. when have some free time will download the trunk and run a test. can not guaranteeing that will be soon. Mansour Al Akeel sent the following on 7/9/2011 10:10 AM: I am not using selinux. It's disabled. I just tried to start ofbiz as a root, and the same issue. Changed the database engine from derby to postgresql, and the same problem exists. I am using gentoo. java version 1.6.0_26 Java(TM) SE Runtime Environment (build 1.6.0_26-b03) Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode) Can you please confirm it's working on your local machine with the default config. If it's not working either, this means I am missing some config. I think this is the only way to narrow down the issue. Thank you. On Sat Jul 09,2011 09:38 am, BJ Freeman wrote: I have not addressed this particular upload. I doubt my solution of not using the bulk upload would work for you. I don't use the trunk or any ofbiz pure code so I can't be of any help further than i have been. it is something particular to the files you are having trouble with and is not the code, since it works on the demo. how about the JDK I run Centos 5.6 with open JDK but the recommended is the Sun JDK. Just a way out thought, possibly a selinux setting. Mansour Al Akeel sent the following on 7/9/2011 8:42 AM: BJ, how did you fix it? My JAVA_OPTS is -Xms1024m -Xmx2048m with 8 GB machine. Is there any settings for the uploaded files. I tried uploading a 31 MB text file and it went through and worked fine. Still can not upload a 260 KB PDF file ! I just started again from scratch, and got the source from git, rebuilt and ran the new instance with no luck, and the same results. Something wierd going on. I am working on linux wich is what the demo is running. Any idea ? On Sat Jul 09,2011 08:32 am, BJ Freeman wrote: it would be memory size. uploads require use of global memory. if you don't have enough then the upload is aborted. Atleast that was my experience on uploading large files. Mansour Al Akeel sent the following on 7/9/2011 7:00 AM: BJ, I really appreciate your help. I am a bit lost here. The issue exists only on my local instance. The demo https://demo-trunk.ofbiz.apache.org/ is working properly. My local instance is pulled from trunk. Not sure if there's some configuration I missed. On Sat, Jul 9, 2011 at 9:40 AM, Mansour Al Akeel mansour.alak...@gmail.com wrote: thank you BJ. It is working on the demo. On Sat, Jul 9, 2011 at 4:20 AM, BJ Freeman bjf...@free-man.net wrote: somewhere between the PorjectScreens.xml#EditProjectContents and saveLocalFileDataResource the information is not put in context, is my guess. Mansour Al Akeel sent the following on 7/8/2011 9:11 PM: I am unable to upload jpg images either. Some formats are ok like xml, text, png. The log says there's no content found, but the file is a valid pdf file, and it exists! I am stuck, and need some help. Thank you a lot. Here's the log: [java] org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:554) [java] org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [java]
How to configure OFBiz database using MS Sql Server 2008 R2
Hello, I need help to configure and can create me OFBiz database in MS Sql Server 2008 R2. I download the jdbc v2 and v3, with none working. Copy it to D:\ofbiz\ofiz-trunk-20110705\framework\entity\lib\ jdbc. Also edit the file D:\ofbiz\ofbiz-trunk-20110705\framework\entity\lib\jdbc\entityengine.xml with the following configuration: entity-eca-reader=main entity-group-reader=main delegator distributed-cache-clear-enabled=false entity-model-reader=main name=default group-name=org.ofbiz group-map datasource-name=localmssql/ group-name=org.ofbiz.olap group-map datasource-name=localmssqlolap/ group-name=org.ofbiz.tenant group-map datasource-name=localmssqltenant/ ... 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 reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ read-data 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 time-between-eviction-runs-millis = 60 / ! - jndi-jdbc Jndi-server-name=default jndi-name=comp/env/jdbc/xa/localmssql isolation-level=ReadCommitted/ - ! - Orion Style JNDI name - / Datasource Please tell me I'm doing wrong or I'm missing, the connection to the database is local and is the Express version, and tried putting in the connection URL: • Localhost • Localhost: 1433 • Localhost: 1791 • The name of my PC, \ and SQLExpress Instance. No way you can connect. I have found no support for this connection. Regards, Rafael
Re: How to configure OFBiz database using MS Sql Server 2008 R2
Here's a link to the JDBC V4 driver: http://www.microsoft.com/download/en/details.aspx?displaylang=enid=11774 -- Jeroen van der Wal Stromboli b.v. +31 655 874050 On Mon, Jul 11, 2011 at 10:55 PM, Jeroen van der Wal jer...@stromboli.it wrote: We got it working in SQL Server 2008 R2 - add sqljdbc4.jar to /framework/entity/lib/jdbc folder - create a user ofbiz with password ofbiz (as in this example) - make sure you create the database on the sql server and grant the user ofbiz to create tables. Here's a snippet of entityengine.xml in /framework/entity/config (it looked like you copied it to the wrong folder): 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-indices-unique=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://ams-s-sql08.ecp.loc:1433;databaseName=ofbiz;SelectMethod=cursor; jdbc-username=ofbiz jdbc-password=ofbiz isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250 time-between-eviction-runs-millis=60/ !-- jndi-jdbc jndi-server-name=default jndi-name=comp/env/jdbc/xa/localmssql isolation-level=ReadCommitted/ -- !-- Orion Style JNDI name -- /datasource Hope this helps. -- Jeroen van der Wal Stromboli b.v. +31 655 874050 On Mon, Jul 11, 2011 at 10:35 PM, Rafael Rondon raron...@gmail.com wrote: Hello, I need help to configure and can create me OFBiz database in MS Sql Server 2008 R2. I download the jdbc v2 and v3, with none working. Copy it to D:\ofbiz\ofiz-trunk-20110705\framework\entity\lib\ jdbc. Also edit the file D:\ofbiz\ofbiz-trunk-20110705\framework\entity\lib\jdbc\entityengine.xml with the following configuration: entity-eca-reader=main entity-group-reader=main delegator distributed-cache-clear-enabled=false entity-model-reader=main name=default group-name=org.ofbiz group-map datasource-name=localmssql/ group-name=org.ofbiz.olap group-map datasource-name=localmssqlolap/ group-name=org.ofbiz.tenant group-map datasource-name=localmssqltenant/ ... 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 reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ read-data 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 time-between-eviction-runs-millis = 60 / ! - jndi-jdbc Jndi-server-name=default jndi-name=comp/env/jdbc/xa/localmssql isolation-level=ReadCommitted/ - ! - Orion Style JNDI name - / Datasource Please tell me I'm doing wrong or I'm missing, the connection to the database is local and is the Express version, and tried putting in the connection URL: • Localhost • Localhost: 1433 • Localhost: 1791 • The name of my PC, \ and SQLExpress Instance. No way you can connect. I have found no support for this connection. Regards, Rafael
Re: upload pdf content for a task
did you do it the ok seems I get a different situation each time we talk. here is what I think you have stated: 1) no problem with 10.04 zip file. 2)_no problems with demo-trunk. 3) problems with svn This tells me it is not the svn code but something in your process, maybe even the git since most use svn clients. suggest you download the zip for from the latest snapshot, and do ./ant run if works then repeat the clean and rebuild. Mansour Al Akeel sent the following on 7/11/2011 11:51 AM: BJ, I tried cleaning and rebuilding: ./ant clean-all ./ant run-install ./ant run With: ofbiz 10.04 from zip, it worked fine. ofbiz trunk, can not upload pdf. Failed ofbiz 11.04 branch from git, it didn't work. Failed So it has nothing to do with the data seeds. On Sat Jul 09,2011 05:43 pm, Mansour Al Akeel wrote: Ok, I created an issue before I foreget something: https://issues.apache.org/jira/browse/OFBIZ-4336 Will attach additional info when I have them. On Sat Jul 09,2011 02:31 pm, BJ Freeman wrote: can do the same thing in eclipse but you have to know the pattern you looking for. If I had time would go through history available through svn. Mansour Al Akeel sent the following on 7/9/2011 2:25 PM: BJ, I appreciate your help. I am looking to report it, but may be it will help a bit more if I can locate the date/revision where the bug was introduced. I use git which allows me to perform binary search in the history to locate the bug. I will see what I can come up with. On Sat, Jul 9, 2011 at 5:05 PM, BJ Freeman bjf...@free-man.net wrote: open a Jira and put all that you have found so far. Mansour Al Akeel sent the following on 7/9/2011 1:24 PM: Release 10.04 is working fine. I can upload PDF files, jar files, zip files, JPG images ... etc. It looks like a bug was introduced somewhere. On Sat, Jul 9, 2011 at 2:00 PM, BJ Freeman bjf...@free-man.net wrote: The demo I have is not the current trunk so I can not confirm. when have some free time will download the trunk and run a test. can not guaranteeing that will be soon. Mansour Al Akeel sent the following on 7/9/2011 10:10 AM: I am not using selinux. It's disabled. I just tried to start ofbiz as a root, and the same issue. Changed the database engine from derby to postgresql, and the same problem exists. I am using gentoo. java version 1.6.0_26 Java(TM) SE Runtime Environment (build 1.6.0_26-b03) Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode) Can you please confirm it's working on your local machine with the default config. If it's not working either, this means I am missing some config. I think this is the only way to narrow down the issue. Thank you. On Sat Jul 09,2011 09:38 am, BJ Freeman wrote: I have not addressed this particular upload. I doubt my solution of not using the bulk upload would work for you. I don't use the trunk or any ofbiz pure code so I can't be of any help further than i have been. it is something particular to the files you are having trouble with and is not the code, since it works on the demo. how about the JDK I run Centos 5.6 with open JDK but the recommended is the Sun JDK. Just a way out thought, possibly a selinux setting. Mansour Al Akeel sent the following on 7/9/2011 8:42 AM: BJ, how did you fix it? My JAVA_OPTS is -Xms1024m -Xmx2048m with 8 GB machine. Is there any settings for the uploaded files. I tried uploading a 31 MB text file and it went through and worked fine. Still can not upload a 260 KB PDF file ! I just started again from scratch, and got the source from git, rebuilt and ran the new instance with no luck, and the same results. Something wierd going on. I am working on linux wich is what the demo is running. Any idea ? On Sat Jul 09,2011 08:32 am, BJ Freeman wrote: it would be memory size. uploads require use of global memory. if you don't have enough then the upload is aborted. Atleast that was my experience on uploading large files. Mansour Al Akeel sent the following on 7/9/2011 7:00 AM: BJ, I really appreciate your help. I am a bit lost here. The issue exists only on my local instance. The demo https://demo-trunk.ofbiz.apache.org/ is working properly. My local instance is pulled from trunk. Not sure if there's some configuration I missed. On Sat, Jul 9, 2011 at 9:40 AM, Mansour Al Akeel mansour.alak...@gmail.com wrote: thank you BJ. It is working on the demo. On Sat, Jul 9, 2011 at 4:20 AM, BJ Freeman bjf...@free-man.net wrote: somewhere between the PorjectScreens.xml#EditProjectContents and saveLocalFileDataResource the information is not put in context, is my guess. Mansour Al Akeel sent the following on 7/8/2011 9:11 PM: I am unable to upload jpg images either. Some formats are ok like xml, text, png. The log says there's no content found, but the file is a valid pdf file, and it exists! I am stuck, and need some help. Thank you a lot.
Re: upload pdf content for a task
BJ, I tried the snapshot ofbiz-trunk-2011-07-05-v1142908.zip and tried it. It worked fine. Yes, what you stated is right for 1) and 2). 1) zip 10.04 is ok. 2) trunk-demo is ok. 3) snap shot zip is ok. 4) 11.04 from repo is NOT. 5) 10.04 from repo is NOT. 6) trunk from repo is NOT. I tested those with, ./ant clean-all ./ant run-install ./ant run The issue is to test uploading different content, and in my case is PDF files. I think this narrows it down to the repo, which I am accessing through git. I will checout the code using SVN sometime, and let you know. Thank you for your help BJ. On Mon Jul 11,2011 03:22 pm, BJ Freeman wrote: did you do it the ok seems I get a different situation each time we talk. here is what I think you have stated: 1) no problem with 10.04 zip file. 2)_no problems with demo-trunk. 3) problems with svn This tells me it is not the svn code but something in your process, maybe even the git since most use svn clients. suggest you download the zip for from the latest snapshot, and do ./ant run if works then repeat the clean and rebuild.
