Ofbiz with Magnolia

[Suraj Alex]

Hi All,
    I want to integrate Magnolia to ofbiz and design UI of my ofbiz
application with Magnolia.What magnolia components should be downloaded
and how to integrate magnolia to ofbiz.

Regards,
    Suraj Alex

[hans_bakker]

I checked int this cms system briefly and it looks pretty similar when
you go in ofbiz to:

content -> websites -> cmssite -> cms

and surprise, it is already integrated.....

if you perhaps miss some functions? would be nice if you contribute
them?

Regards,
Hans

On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
> Hi All,
>     I want to integrate Magnolia to ofbiz and design UI of my ofbiz
> application with Magnolia.What magnolia components should be downloaded
> and how to integrate magnolia to ofbiz.
>
> Regards,
>     Suraj Alex
>
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

[Suraj Alex]

Hi All,
   I have integrated ofbiz and Magnolia by following the steps given inside
    http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide.

On executing the java program its showing an error the service name can not be located. Could anyone pls help me to solve this

Thanks,
   Suraj Alex


Hans Bakker wrote:

I checked int this cms system briefly and it looks pretty similar when
you go in ofbiz to:

content -> websites -> cmssite -> cms

and surprise, it is already integrated.....

if you perhaps miss some functions? would be nice if you contribute
them?

Regards,
Hans

On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
  

Hi All,
    I want to integrate Magnolia to ofbiz and design UI of my ofbiz 
application with Magnolia.What magnolia components should be downloaded 
and how to integrate magnolia to ofbiz.

Regards,
    Suraj Alex


    

[Suraj Alex]

>   Hi All,
>    I have integrated ofbiz and Magnolia by following the steps given
> inside
>     http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide.
>
> On executing the java program its showing an error the service name
> can not be located. Could anyone pls help me to solve this
>
> Thanks,
>    Suraj Alex
>
>
> Hans Bakker wrote:
>> I checked int this cms system briefly and it looks pretty similar when
>> you go in ofbiz to:
>>
>> content -> websites -> cmssite -> cms
>>
>> and surprise, it is already integrated.....
>>
>> if you perhaps miss some functions? would be nice if you contribute
>> them?
>>
>> Regards,
>> Hans
>>
>> On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
>>  
>>> Hi All,
>>>     I want to integrate Magnolia to ofbiz and design UI of my ofbiz
>>> application with Magnolia.What magnolia components should be downloaded
>>> and how to integrate magnolia to ofbiz.
>>>
>>> Regards,
>>>     Suraj Alex
>>>
>>>
>>>    

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

during the build, did this get compiled?
I don't see any instruction about a build file.


Suraj Alex sent the following on 3/25/2009 11:52 PM:

> Hi All,
>    I have integrated ofbiz and Magnolia by following the steps given inside
>     http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide.
>
> On executing the java program its showing an error the service name can not be
> located. Could anyone pls help me to solve this
>
> Thanks,
>    Suraj Alex
>
>
>
> Hans Bakker wrote:
>> I checked int this cms system briefly and it looks pretty similar when
>> you go in ofbiz to:
>>
>> content -> websites -> cmssite -> cms
>>
>> and surprise, it is already integrated.....
>>
>> if you perhaps miss some functions? would be nice if you contribute
>> them?
>>
>> Regards,
>> Hans
>>
>> On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
>>  
>>> Hi All,
>>>     I want to integrate Magnolia to ofbiz and design UI of my ofbiz
>>> application with Magnolia.What magnolia components should be downloaded
>>> and how to integrate magnolia to ofbiz.
>>>
>>> Regards,
>>>     Suraj Alex
>>>
>>>
>>>    

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJyzP7rP3NbaWWqE4RAnDCAJ9av635nwbpwDNnwlvBmj0jlvillwCgy9BV
g6JqoPr7W7ujxOg6HUSPwvs=
=94Cy
-----END PGP SIGNATURE-----

[Magnolia_Ofbiz]

Is there any change should be done inside the build.xml?

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> during the build, did this get compiled?
> I don't see any instruction about a build file.
>
>
> Suraj Alex sent the following on 3/25/2009 11:52 PM:
>> Hi All,
>>    I have integrated ofbiz and Magnolia by following the steps given
>> inside
>>     http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide.
>>
>> On executing the java program its showing an error the service name can
>> not be
>> located. Could anyone pls help me to solve this
>>
>> Thanks,
>>    Suraj Alex
>>
>>
>>
>> Hans Bakker wrote:
>>> I checked int this cms system briefly and it looks pretty similar when
>>> you go in ofbiz to:
>>>
>>> content -> websites -> cmssite -> cms
>>>
>>> and surprise, it is already integrated.....
>>>
>>> if you perhaps miss some functions? would be nice if you contribute
>>> them?
>>>
>>> Regards,
>>> Hans
>>>
>>> On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
>>>
>>>> Hi All,
>>>>     I want to integrate Magnolia to ofbiz and design UI of my ofbiz
>>>> application with Magnolia.What magnolia components should be
>>>> downloaded
>>>> and how to integrate magnolia to ofbiz.
>>>>
>>>> Regards,
>>>>     Suraj Alex
>>>>
>>>>
>>>>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJyzP7rP3NbaWWqE4RAnDCAJ9av635nwbpwDNnwlvBmj0jlvillwCgy9BV
> g6JqoPr7W7ujxOg6HUSPwvs=
> =94Cy
> -----END PGP SIGNATURE-----
>

[madppiper-2]

Ähm... nope, not at all. Perhaps you could give me the complete error? I am assuming that perhaps you did not add the correct folder for the service file to be loaded into your ofbiz-component file...

Which reminds me: the given instruction is slightly incomplete, if you revise it, you will need to edit cmsUrl within the .java file here: public static String cmsUrl = "http://www.google.com";

and change the location to your local path of the magnolia instance  and I think you can safely remove the

public static final String module = Magnolia.class.getName();

That should remove the dependency - it is not used within the script anyhow...

[madppiper-2]

Oh and before I forget: you may also need to write your own bsh/groovy file with correct information on which data to fetch...


For my own application I wrote a script that fetches data based on the context path and locale. I wrote a groovy file that will get the context path url and create a url string to be passed to the Magnolia java file. I also added a few more services, which then allow an easier access to the data... But in theory, the Magnolia.java file can be left mainly untouched and should work just as well as mine does...

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I am apologize I don't understand any of this.
so I am not going to waste your time.
guess hans has a better grasp then I do.


[hidden email] sent the following on 3/26/2009 1:07 AM:

> Is there any change should be done inside the build.xml?
>
> during the build, did this get compiled?
> I don't see any instruction about a build file.
>
>
> Suraj Alex sent the following on 3/25/2009 11:52 PM:
>>>> Hi All,
>>>>    I have integrated ofbiz and Magnolia by following the steps given
>>>> inside
>>>>     http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide.
>>>>
>>>> On executing the java program its showing an error the service name can
>>>> not be
>>>> located. Could anyone pls help me to solve this
>>>>
>>>> Thanks,
>>>>    Suraj Alex
>>>>
>>>>
>>>>
>>>> Hans Bakker wrote:
>>>>> I checked int this cms system briefly and it looks pretty similar when
>>>>> you go in ofbiz to:
>>>>>
>>>>> content -> websites -> cmssite -> cms
>>>>>
>>>>> and surprise, it is already integrated.....
>>>>>
>>>>> if you perhaps miss some functions? would be nice if you contribute
>>>>> them?
>>>>>
>>>>> Regards,
>>>>> Hans
>>>>>
>>>>> On Thu, 2009-03-26 at 10:30 +0530, Suraj Alex wrote:
>>>>>
>>>>>> Hi All,
>>>>>>     I want to integrate Magnolia to ofbiz and design UI of my ofbiz
>>>>>> application with Magnolia.What magnolia components should be
>>>>>> downloaded
>>>>>> and how to integrate magnolia to ofbiz.
>>>>>>
>>>>>> Regards,
>>>>>>     Suraj Alex
>>>>>>
>>>>>>
>>>>>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJy0p1rP3NbaWWqE4RAm6VAJ9LqdN0usd3tQ0TYWqDl2V4PMYaIwCgvp0j
HeVFOFovYRRoU7QLViegB7A=
=niLt
-----END PGP SIGNATURE-----

[Magnolia_Ofbiz]

 I have added magnolia.java inside hot-deploy/myapplication/src and the
service.xml file inside hot-deploy/myapplication/servicedef and the path
of service.xml is mentioned ofbiz-component.xml.I have downloaded and
used Magnolia-bundled-webapp3.6.5
  On executing Magnolia.java I have got the following result
.F
Time: 0.016
There was 1 failure:
1)
warning(junit.framework.TestSuite$1)junit.framework.AssertionFailedError:
No tests found in org.brandsparadise.cms.Magnolia
        at org.brandsparadise.cms.Magnolia.main(Magnolia.java:81)

FAILURES!!!
Tests run: 1,  Failures: 1,  Errors: 0

  Could u help me to solve this.
with regards
vishnupriya

>
> Ähm... nope, not at all. Perhaps you could give me the complete error? I
> am
> assuming that perhaps you did not add the correct folder for the service
> file to be loaded into your ofbiz-component file...
>
> Which reminds me: the given instruction is slightly incomplete, if you
> revise it, you will need to edit cmsUrl within the .java file here: public
> static String cmsUrl = "http://www.google.com";
>
> and change the location to your local path of the magnolia instance  and I
> think you can safely remove the
>
> public static final String module = Magnolia.class.getName();
>
> That should remove the dependency - it is not used within the script
> anyhow...
> --
> View this message in context:
> http://www.nabble.com/Ofbiz-with-Magnolia-tp22715993p22717734.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Jacques Le Roux]

Please Paul,

Could you add these comments to the wiki page ?

TIA

Jacques

From: "madppiper" <[hidden email]>

>
> Oh and before I forget: you may also need to write your own bsh/groovy file
> with correct information on which data to fetch...
>
>
> For my own application I wrote a script that fetches data based on the
> context path and locale. I wrote a groovy file that will get the context
> path url and create a url string to be passed to the Magnolia java file. I
> also added a few more services, which then allow an easier access to the
> data... But in theory, the Magnolia.java file can be left mainly untouched
> and should work just as well as mine does...
> --
> View this message in context: http://www.nabble.com/Ofbiz-with-Magnolia-tp22715993p22717801.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Magnolia_Ofbiz]

hi,
  can u explain me how to customize UI pages of my ofbiz application using
Magnolia.
with regards
vishnupriya

>
> Oh and before I forget: you may also need to write your own bsh/groovy
> file
> with correct information on which data to fetch...
>
>
> For my own application I wrote a script that fetches data based on the
> context path and locale. I wrote a groovy file that will get the context
> path url and create a url string to be passed to the Magnolia java file. I
> also added a few more services, which then allow an easier access to the
> data... But in theory, the Magnolia.java file can be left mainly untouched
> and should work just as well as mine does...
> --
> View this message in context:
> http://www.nabble.com/Ofbiz-with-Magnolia-tp22715993p22717801.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[madppiper-2]

@ Jacques:  done :)

http://docs.ofbiz.org/display/OFBIZ/Magnolia+CMS+Integration+Guide


@vishnupriya :

well, I myself have also completed the steps I mentioned at the bottom of the guide, so I can now skip through the content provided within the magnolia instance and then display the content at any location of my choice. All I need to do is add the cms groovy file, which is in parts similar to the code snipplet I now added to the guide, and then display the box I want at a location I want.

As for Magnolia: you need to create your own ftl templates that serve your purpose. in magnolia-freemarker files you can define code that is displayed to the author-instance only and hence have single scripts that display editor-bars to the author instance, and display only the content on my ofbiz pages...

[madppiper-2]

Magnolia_Ofbiz wrote

 I have added magnolia.java inside hot-deploy/myapplication/src and the
service.xml file inside hot-deploy/myapplication/servicedef and the path
of service.xml is mentioned ofbiz-component.xml.I have downloaded and
used Magnolia-bundled-webapp3.6.5
  On executing Magnolia.java I have got the following result

Looks to me like you haven't created the correct folders. Please note that the Magnolia.java file should be placed within

hot-deploy/myapplication/src/org/brandsparadise/cms/

[Magnolia_Ofbiz]

> I have restructured the folder and now my query is where I should save
the groovy file and myapplication contains ftl files and I want to use
Magnolia as cms for those templates.So what further things should I do.
wit regards
vishnupriya

>
>
> Magnolia_Ofbiz wrote:
>>
>>  I have added magnolia.java inside hot-deploy/myapplication/src and the
>> service.xml file inside hot-deploy/myapplication/servicedef and the path
>> of service.xml is mentioned ofbiz-component.xml.I have downloaded and
>> used Magnolia-bundled-webapp3.6.5
>>   On executing Magnolia.java I have got the following result
>>
>
>
> Looks to me like you haven't created the correct folders. Please note that
> the Magnolia.java file should be placed within
>
> hot-deploy/myapplication/src/org/brandsparadise/cms/
> --
> View this message in context:
> http://www.nabble.com/Ofbiz-with-Magnolia-tp22715993p22725596.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Jack Liu-2]

Hi, all

What driver does OFBiz use to connect db server?
For mysql's official jdbc driver,for example,
mysql-connector-java-5.1.7.jar
I can do the following:

PreparedStatement ps = null;

ps = _connection.prepareStatement( "insert into clients (cid,cname)
values (?,?)");
ps.setInt(1, 11);
ps.setString(2, "test");
System.out.println(ps.toString());
ps.executeUpdate();

through ps.toString I can get the sql sentence which will be sent to db
server
insert into clients (cid,cname) values (11,'test');

While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString
doesn't work.
System.out.println(_ps.toString())
It gets: org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool@1e07d3e

I tested a few cases and found out that when insert,update and delete
,ofbiz use it own driver, while select, it uses
mysql-connector-java-5.1.7.

Who can tell me why?

Thank you !

[Jack Liu-2]

OFBiz uses ofbiz-minerva.jar

-----Original Message-----
From: Jack Liu [mailto:[hidden email]]
Sent: 2009年3月27日 17:18
To: [hidden email]
Subject: OFBiz's jdbc driver

Hi, all

What driver does OFBiz use to connect db server?
For mysql's official jdbc driver,for example,
mysql-connector-java-5.1.7.jar
I can do the following:

PreparedStatement ps = null;

ps = _connection.prepareStatement( "insert into clients (cid,cname)
values (?,?)");
ps.setInt(1, 11);
ps.setString(2, "test");
System.out.println(ps.toString());
ps.executeUpdate();

through ps.toString I can get the sql sentence which will be sent to db
server
insert into clients (cid,cname) values (11,'test');

While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString
doesn't work.
System.out.println(_ps.toString())
It gets: org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool@1e07d3e

I tested a few cases and found out that when insert,update and delete
,ofbiz use it own driver, while select, it uses
mysql-connector-java-5.1.7.

Who can tell me why?

Thank you !

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DBCP connection pool that is now the default connection pool manager in
OFBiz (the old Minerva connection pool has been disabled by default)
as far as Jdbc except for the OTTB DB there are no jdbc drivers included
in ofbiz trunk.
Depending on the installation and DB used the installer has to determine
the correct jdbc for the DB they are connected to.


Jack Liu sent the following on 3/27/2009 2:21 AM:

> OFBiz uses ofbiz-minerva.jar
>
> -----Original Message-----
> From: Jack Liu [mailto:[hidden email]]
> Sent: 2009年3月27日 17:18
> To: [hidden email]
> Subject: OFBiz's jdbc driver
>
> Hi, all
>
> What driver does OFBiz use to connect db server?
> For mysql's official jdbc driver,for example,
> mysql-connector-java-5.1.7.jar
> I can do the following:
>
> PreparedStatement ps = null;
>
> ps = _connection.prepareStatement( "insert into clients (cid,cname)
> values (?,?)");
> ps.setInt(1, 11);
> ps.setString(2, "test");
> System.out.println(ps.toString());
> ps.executeUpdate();
>
> through ps.toString I can get the sql sentence which will be sent to db
> server
> insert into clients (cid,cname) values (11,'test');
>
> While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString
> doesn't work.
> System.out.println(_ps.toString())
> It gets: org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool@1e07d3e
>
> I tested a few cases and found out that when insert,update and delete
> ,ofbiz use it own driver, while select, it uses
> mysql-connector-java-5.1.7.
>
> Who can tell me why?
>
> Thank you !
>
>
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJzKRRrP3NbaWWqE4RAkR/AKC+pP9TUoXwY1ybPWEvIibR91AxTgCcCsqe
YxAIX3vkcHV10I+lTDH0PMQ=
=RPIB
-----END PGP SIGNATURE-----

[Jacques Le Roux]

Which version of OFBiz are you using ?

Jacques

From: "Jack Liu" <[hidden email]>

> OFBiz uses ofbiz-minerva.jar
>
> -----Original Message-----
> From: Jack Liu [mailto:[hidden email]]
> Sent: 2009年3月27日 17:18
> To: [hidden email]
> Subject: OFBiz's jdbc driver
>
> Hi, all
>
> What driver does OFBiz use to connect db server?
> For mysql's official jdbc driver,for example,
> mysql-connector-java-5.1.7.jar
> I can do the following:
>
> PreparedStatement ps = null;
>
> ps = _connection.prepareStatement( "insert into clients (cid,cname)
> values (?,?)");
> ps.setInt(1, 11);
> ps.setString(2, "test");
> System.out.println(ps.toString());
> ps.executeUpdate();
>
> through ps.toString I can get the sql sentence which will be sent to db
> server
> insert into clients (cid,cname) values (11,'test');
>
> While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString
> doesn't work.
> System.out.println(_ps.toString())
> It gets: org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool@1e07d3e
>
> I tested a few cases and found out that when insert,update and delete
> ,ofbiz use it own driver, while select, it uses
> mysql-connector-java-5.1.7.
>
> Who can tell me why?
>
> Thank you !
>
>

[Jack Liu-2]

OFBiz 4.0

-----Original Message-----
From: Jacques Le Roux [mailto:[hidden email]]
Sent: 2009年3月27日 18:13
To: [hidden email]
Subject: Re: OFBiz's jdbc driver

Which version of OFBiz are you using ?

Jacques

From: "Jack Liu" <[hidden email]>

> OFBiz uses ofbiz-minerva.jar
>
> -----Original Message-----
> From: Jack Liu [mailto:[hidden email]]
> Sent: 2009年3月27日 17:18
> To: [hidden email]
> Subject: OFBiz's jdbc driver
>
> Hi, all
>
> What driver does OFBiz use to connect db server?
> For mysql's official jdbc driver,for example,
> mysql-connector-java-5.1.7.jar
> I can do the following:
>
> PreparedStatement ps = null;
>
> ps = _connection.prepareStatement( "insert into clients (cid,cname)
> values (?,?)");
> ps.setInt(1, 11);
> ps.setString(2, "test");
> System.out.println(ps.toString());
> ps.executeUpdate();
>
> through ps.toString I can get the sql sentence which will be sent to db
> server
> insert into clients (cid,cname) values (11,'test');
>
> While n org.ofbiz.entity.jdbc.SQLProcessor, PreparedStatement.toString
> doesn't work.
> System.out.println(_ps.toString())
> It gets: org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool@1e07d3e
>
> I tested a few cases and found out that when insert,update and delete
> ,ofbiz use it own driver, while select, it uses
> mysql-connector-java-5.1.7.
>
> Who can tell me why?
>
> Thank you !
>
>