You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Suraj Alex <su...@xminds.com> on 2009/03/26 06:00:11 UTC

Ofbiz with Magnolia

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

Re: Ofbiz with Magnolia

Posted by Suraj Alex <su...@xminds.com>.
>   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
>>>
>>>
>>>

Re: Ofbiz with Magnolia

Posted by madppiper <pa...@mutschler.ch>.
@ 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...
-- 
View this message in context: http://www.nabble.com/Ofbiz-with-Magnolia-tp22715993p22725534.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Ofbiz with Magnolia

Posted by vi...@x-minds.info.
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.
>
>

Re: Ofbiz with Magnolia

Posted by Jacques Le Roux <ja...@les7arts.com>.
Please Paul,

Could you add these comments to the wiki page ?

TIA 

Jacques

From: "madppiper" <pa...@mutschler.ch>
> 
> 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.
>

Re: Ofbiz with Magnolia

Posted by madppiper <pa...@mutschler.ch>.
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.

Re: OFBiz's jdbc driver

Posted by Jacques Le Roux <ja...@les7arts.com>.
You need to do more
http://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/geronimo/src/org/ofbiz/geronimo/GeronimoTransactionFactory.java

Jacques

From: "Jack Liu" <ja...@aicent.com>
>I use OFBiz 4.0.
> In entityengine.xml
> I changed transaction-factory from org.ofbiz.geronimo.GeronimoTransactionFactory to
> org.apache.commons.dbcp.ConnectionFactory
> but it doesn't work.....
>
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: 2009年3月27日 18:03
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
>
> -----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:jack.liu@aicent.com]
>> Sent: 2009年3月27日 17:18
>> To: user@ofbiz.apache.org
>> 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-----
>

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
I use OFBiz 4.0.
In entityengine.xml
I changed transaction-factory from org.ofbiz.geronimo.GeronimoTransactionFactory to
org.apache.commons.dbcp.ConnectionFactory
but it doesn't work.....


-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net] 
Sent: 2009年3月27日 18:03
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

-----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:jack.liu@aicent.com] 
> Sent: 2009年3月27日 17:18
> To: user@ofbiz.apache.org
> 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-----

Re: OFBiz's jdbc driver

Posted by David E Jones <da...@hotwaxmedia.com>.
This looks like the problem with the new webslinger stuff running on  
Java 5. Adam has fixed this a few days ago, so an update is a good idea.

If that doesn't fix it... please reply with the OFBiz revision number  
you're using, and the version of Java you're running in.

-David


On Mar 30, 2009, at 12:32 AM, Jack Liu wrote:

> I downloaded OFBiz trunk version.
> But when I am starting OFBiz, below errors occur:
>
>
> org.ofbiz.base.start.StartupException: Cannot start()  
> org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing  
> StandardFileSystemManager (Could not load VFS configuration from  
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
> 	at  
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: 
> 103)
> 	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> 	at org.ofbiz.base.start.Start.startServer(Start.java:312)
> 	at org.ofbiz.base.start.Start.start(Start.java:316)
> 	at org.ofbiz.base.start.Start.main(Start.java:399)
> org.ofbiz.base.container.ContainerException: Initializing  
> StandardFileSystemManager (Could not load VFS configuration from  
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> 	at  
> org 
> .ofbiz 
> .commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> 	at  
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: 
> 101)
> 	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> 	at org.ofbiz.base.start.Start.startServer(Start.java:312)
> 	at org.ofbiz.base.start.Start.start(Start.java:316)
> 	at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not  
> load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/ 
> vfs-providers.xml".
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 199)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager 
> .configurePlugins(StandardFileSystemManager.java:156)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl.StandardFileSystemManager.init(StandardFileSystemManager.java: 
> 129)
> 	at  
> org 
> .webslinger 
> .commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> 	at  
> org 
> .webslinger 
> .commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> 	at  
> org 
> .ofbiz 
> .commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> 	... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple  
> providers registered for URL scheme "ofbiz-home".
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java: 
> 174)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager 
> .addProvider(StandardFileSystemManager.java:362)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 262)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 195)
> 	... 10 more
> org.ofbiz.base.container.ContainerException: Initializing  
> StandardFileSystemManager (Could not load VFS configuration from  
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> 	at  
> org 
> .ofbiz 
> .commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> 	at  
> org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java: 
> 101)
> 	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> 	at org.ofbiz.base.start.Start.startServer(Start.java:312)
> 	at org.ofbiz.base.start.Start.start(Start.java:316)
> 	at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not  
> load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/ 
> vfs-providers.xml".
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 199)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager 
> .configurePlugins(StandardFileSystemManager.java:156)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl.StandardFileSystemManager.init(StandardFileSystemManager.java: 
> 129)
> 	at  
> org 
> .webslinger 
> .commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> 	at  
> org 
> .webslinger 
> .commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> 	at  
> org 
> .ofbiz 
> .commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> 	... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple  
> providers registered for URL scheme "ofbiz-home".
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java: 
> 174)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager 
> .addProvider(StandardFileSystemManager.java:362)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 262)
> 	at  
> org 
> .apache 
> .commons 
> .vfs 
> .impl 
> .StandardFileSystemManager.configure(StandardFileSystemManager.java: 
> 195)
> 	... 10 more
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: 2009年3月27日 18:03
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
>
> -----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:jack.liu@aicent.com]
>> Sent: 2009年3月27日 17:18
>> To: user@ofbiz.apache.org
>> 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-----

Re: OFBiz's jdbc driver

Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

good
in the future please to use new email, instead of replying to one that
is not related, since this was a different problem.
the reason is that this emails have an ID that is used by the archive
programs for search.

if someone was searching for how do debug they would not figure this
email subject would have that.
:D


Jack Liu sent the following on 3/30/2009 2:12 AM:
> http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse
> It works
> 
> Thank you, BJ Freeman.
> 
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net] 
> Sent: 2009年3月30日 16:53
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
> 
> here is a good place to become familar with.
> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
> there is a section on eclipse
> 
> one of them is
> http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse
> 
> hope that helps
> 
> Jack Liu sent the following on 3/30/2009 1:14 AM:
>> If I start OFBiz with startOfBiz.bat, it' ok, 
>> while in eclipse, I run Start.java, it fails.
> 
> 
>> -----Original Message-----
>> From: Jack Liu [mailto:jack.liu@aicent.com] 
>> Sent: 2009t330
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ0JUerP3NbaWWqE4RAl8uAJ4gKAQu5hvdfm0ljPqizjiHZA9WgwCeKFDx
4vCu149Yc4Ryp274S0/mBhY=
=QjuR
-----END PGP SIGNATURE-----

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse
It works

Thank you, BJ Freeman.

-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net] 
Sent: 2009年3月30日 16:53
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

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

here is a good place to become familar with.
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
there is a section on eclipse

one of them is
http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse

hope that helps

Jack Liu sent the following on 3/30/2009 1:14 AM:
> If I start OFBiz with startOfBiz.bat, it' ok, 
> while in eclipse, I run Start.java, it fails.
> 
> 
> -----Original Message-----
> From: Jack Liu [mailto:jack.liu@aicent.com] 
> Sent: 2009年3月30日 15:22
> To: user@ofbiz.apache.org; Jacques Le Roux
> Subject: RE: OFBiz's jdbc driver
> 
> No, but debug in eclipse.
> Anything wrong in build path?
> 
> 
> -----Original Message-----
> From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
> Sent: 2009年3月30日 15:17
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
> 
> Did you make some changes ?
> 
> Jacques
> 
> From: "Jack Liu" <ja...@aicent.com>
>> I downloaded OFBiz trunk version.
>> But when I am starting OFBiz, below errors occur:
>>
>>
>> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing 
>> StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
>> ... 5 more
>> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
>> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
>> ... 10 more
>> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
>> ... 5 more
>> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
>> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
>> ... 10 more
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: 2009年3月27日 18:03
>> To: user@ofbiz.apache.org
>> Subject: Re: OFBiz's jdbc driver
>>
> 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:jack.liu@aicent.com]
>>>> Sent: 2009t327
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ0IiIrP3NbaWWqE4RArTpAJ47SByD2mytLZHlKkrUQfgvhjgNhgCeKeWG
C+k1QHpowAhTD6H8fLSgFBA=
=zfw7
-----END PGP SIGNATURE-----

Re: OFBiz's jdbc driver

Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

here is a good place to become familar with.
http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
there is a section on eclipse

one of them is
http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse

hope that helps

Jack Liu sent the following on 3/30/2009 1:14 AM:
> If I start OFBiz with startOfBiz.bat, it' ok, 
> while in eclipse, I run Start.java, it fails.
> 
> 
> -----Original Message-----
> From: Jack Liu [mailto:jack.liu@aicent.com] 
> Sent: 2009年3月30日 15:22
> To: user@ofbiz.apache.org; Jacques Le Roux
> Subject: RE: OFBiz's jdbc driver
> 
> No, but debug in eclipse.
> Anything wrong in build path?
> 
> 
> -----Original Message-----
> From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
> Sent: 2009年3月30日 15:17
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
> 
> Did you make some changes ?
> 
> Jacques
> 
> From: "Jack Liu" <ja...@aicent.com>
>> I downloaded OFBiz trunk version.
>> But when I am starting OFBiz, below errors occur:
>>
>>
>> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing 
>> StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
>> ... 5 more
>> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
>> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
>> ... 10 more
>> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
>> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
>> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
>> at org.ofbiz.base.start.Start.startServer(Start.java:312)
>> at org.ofbiz.base.start.Start.start(Start.java:316)
>> at org.ofbiz.base.start.Start.main(Start.java:399)
>> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
>> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
>> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
>> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
>> ... 5 more
>> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
>> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
>> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
>> ... 10 more
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:bjfree@free-man.net]
>> Sent: 2009年3月27日 18:03
>> To: user@ofbiz.apache.org
>> Subject: Re: OFBiz's jdbc driver
>>
> 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:jack.liu@aicent.com]
>>>> Sent: 2009t327
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJ0IiIrP3NbaWWqE4RArTpAJ47SByD2mytLZHlKkrUQfgvhjgNhgCeKeWG
C+k1QHpowAhTD6H8fLSgFBA=
=zfw7
-----END PGP SIGNATURE-----

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
If I start OFBiz with startOfBiz.bat, it' ok, 
while in eclipse, I run Start.java, it fails.


-----Original Message-----
From: Jack Liu [mailto:jack.liu@aicent.com] 
Sent: 2009年3月30日 15:22
To: user@ofbiz.apache.org; Jacques Le Roux
Subject: RE: OFBiz's jdbc driver

No, but debug in eclipse.
Anything wrong in build path?


-----Original Message-----
From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
Sent: 2009年3月30日 15:17
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

Did you make some changes ?

Jacques

From: "Jack Liu" <ja...@aicent.com>
>I downloaded OFBiz trunk version.
> But when I am starting OFBiz, below errors occur:
>
>
> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing 
> StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: 2009年3月27日 18:03
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
>
> -----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:jack.liu@aicent.com]
>> Sent: 2009年3月27日 17:18
>> To: user@ofbiz.apache.org
>> 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-----
>

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
No, but debug in eclipse.
Anything wrong in build path?


-----Original Message-----
From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
Sent: 2009年3月30日 15:17
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

Did you make some changes ?

Jacques

From: "Jack Liu" <ja...@aicent.com>
>I downloaded OFBiz trunk version.
> But when I am starting OFBiz, below errors occur:
>
>
> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing 
> StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: 2009年3月27日 18:03
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
>
> -----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:jack.liu@aicent.com]
>> Sent: 2009年3月27日 17:18
>> To: user@ofbiz.apache.org
>> 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-----
>

Re: OFBiz's jdbc driver

Posted by Jacques Le Roux <ja...@les7arts.com>.
Did you make some changes ?

Jacques

From: "Jack Liu" <ja...@aicent.com>
>I downloaded OFBiz trunk version.
> But when I am starting OFBiz, below errors occur:
>
>
> org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing 
> StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
> org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
> at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
> at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
> at org.ofbiz.base.start.Start.startServer(Start.java:312)
> at org.ofbiz.base.start.Start.start(Start.java:316)
> at org.ofbiz.base.start.Start.main(Start.java:399)
> Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from 
> "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
> at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
> at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
> ... 5 more
> Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
> at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
> at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
> ... 10 more
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: 2009年3月27日 18:03
> To: user@ofbiz.apache.org
> Subject: Re: OFBiz's jdbc driver
>
> -----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:jack.liu@aicent.com]
>> Sent: 2009年3月27日 17:18
>> To: user@ofbiz.apache.org
>> 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-----
>

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
I downloaded OFBiz trunk version.
But when I am starting OFBiz, below errors occur:


org.ofbiz.base.start.StartupException: Cannot start() org.ofbiz.commons.vfs.CommonsVfsContainer (Initializing StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".))
	at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:103)
	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
	at org.ofbiz.base.start.Start.startServer(Start.java:312)
	at org.ofbiz.base.start.Start.start(Start.java:316)
	at org.ofbiz.base.start.Start.main(Start.java:399)
org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
	at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
	at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
	at org.ofbiz.base.start.Start.startServer(Start.java:312)
	at org.ofbiz.base.start.Start.start(Start.java:316)
	at org.ofbiz.base.start.Start.main(Start.java:399)
Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
	at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
	at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
	at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
	... 5 more
Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
	at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
	... 10 more
org.ofbiz.base.container.ContainerException: Initializing StandardFileSystemManager (Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".)
	at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:48)
	at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:101)
	at org.ofbiz.base.start.Start.startStartLoaders(Start.java:263)
	at org.ofbiz.base.start.Start.startServer(Start.java:312)
	at org.ofbiz.base.start.Start.start(Start.java:316)
	at org.ofbiz.base.start.Start.main(Start.java:399)
Caused by: org.apache.commons.vfs.FileSystemException: Could not load VFS configuration from "file:/C:/workspace/ofbiz/bin/META-INF/vfs-providers.xml".
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:199)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configurePlugins(StandardFileSystemManager.java:156)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.init(StandardFileSystemManager.java:129)
	at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:351)
	at org.webslinger.commons.vfs.VFSUtil.createStandardFileSystemManager(VFSUtil.java:345)
	at org.ofbiz.commons.vfs.CommonsVfsContainer.start(CommonsVfsContainer.java:43)
	... 5 more
Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "ofbiz-home".
	at org.apache.commons.vfs.impl.DefaultFileSystemManager.addProvider(DefaultFileSystemManager.java:174)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.addProvider(StandardFileSystemManager.java:362)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:262)
	at org.apache.commons.vfs.impl.StandardFileSystemManager.configure(StandardFileSystemManager.java:195)
	... 10 more

-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net] 
Sent: 2009年3月27日 18:03
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

-----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:jack.liu@aicent.com] 
> Sent: 2009年3月27日 17:18
> To: user@ofbiz.apache.org
> 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-----

Re: OFBiz's jdbc driver

Posted by BJ Freeman <bj...@free-man.net>.
-----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:jack.liu@aicent.com] 
> Sent: 2009年3月27日 17:18
> To: user@ofbiz.apache.org
> 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-----

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
OFBiz 4.0

-----Original Message-----
From: Jacques Le Roux [mailto:jacques.le.roux@les7arts.com] 
Sent: 2009年3月27日 18:13
To: user@ofbiz.apache.org
Subject: Re: OFBiz's jdbc driver

Which version of OFBiz are you using ?

Jacques

From: "Jack Liu" <ja...@aicent.com>
> OFBiz uses ofbiz-minerva.jar
>
> -----Original Message-----
> From: Jack Liu [mailto:jack.liu@aicent.com]
> Sent: 2009年3月27日 17:18
> To: user@ofbiz.apache.org
> 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 !
>
>

Re: OFBiz's jdbc driver

Posted by Jacques Le Roux <ja...@les7arts.com>.
Which version of OFBiz are you using ?

Jacques

From: "Jack Liu" <ja...@aicent.com>
> OFBiz uses ofbiz-minerva.jar
>
> -----Original Message-----
> From: Jack Liu [mailto:jack.liu@aicent.com]
> Sent: 2009年3月27日 17:18
> To: user@ofbiz.apache.org
> 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 !
>
>

RE: OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
OFBiz uses ofbiz-minerva.jar

-----Original Message-----
From: Jack Liu [mailto:jack.liu@aicent.com] 
Sent: 2009年3月27日 17:18
To: user@ofbiz.apache.org
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 !

OFBiz's jdbc driver

Posted by Jack Liu <ja...@aicent.com>.
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 !

Re: Ofbiz with Magnolia

Posted by vi...@x-minds.info.
> 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.
>
>

Re: Ofbiz with Magnolia

Posted by vi...@x-minds.info.
>hi,
>how could I share ftl files  between the two systems.
>
>
> 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.
>
>

Re: Ofbiz with Magnolia

Posted by madppiper <pa...@mutschler.ch>.


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.

Re: Ofbiz with Magnolia

Posted by vi...@x-minds.info.
 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.
>
>

Re: Ofbiz with Magnolia

Posted by madppiper <pa...@mutschler.ch>.
Ä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.

Re: Ofbiz with Magnolia

Posted by BJ Freeman <bj...@free-man.net>.
-----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.


vishnupriya@x-minds.info 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-----

Re: Ofbiz with Magnolia

Posted by vi...@x-minds.info.
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-----
>

Re: Ofbiz with Magnolia

Posted by BJ Freeman <bj...@free-man.net>.
-----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-----

Re: Ofbiz with Magnolia

Posted by Suraj Alex <su...@xminds.com>.
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
>>
>>
>>

Re: Ofbiz with Magnolia

Posted by Hans Bakker <ma...@antwebsystems.com>.
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