OFBiz › OFBiz - User

Ofbiz with Magnolia

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

32 messages Options

Jack Liu-2

RE: OFBiz's jdbc driver

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:[hidden email]]
Sent: 2009年3月27日 18:03
To: [hidden email]
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:[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

Re: OFBiz's jdbc driver

Administrator

You need to do more
http://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/geronimo/src/org/ofbiz/geronimo/GeronimoTransactionFactory.java

Jacques

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

>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:[hidden email]]
> Sent: 2009年3月27日 18:03
> To: [hidden email]
> 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:[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-----
>

Magnolia_Ofbiz

Re: Ofbiz with Magnolia

In reply to this post by madppiper-2

>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.
>
>

Jack Liu-2

RE: OFBiz's jdbc driver

In reply to this post by BJ Freeman

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:[hidden email]]
Sent: 2009年3月27日 18:03
To: [hidden email]
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:

Jacques Le Roux

Re: OFBiz's jdbc driver

Administrator

Did you make some changes ?

Jacques

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

>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:[hidden email]]
> Sent: 2009年3月27日 18:03
> To: [hidden email]
> 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:[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-----
>

David E Jones-3

Re: OFBiz's jdbc driver

In reply to this post by Jack Liu-2

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:[hidden email]]
> Sent: 2009年3月27日 18:03
> To: [hidden email]
> 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:[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-----

Jack Liu-2

RE: OFBiz's jdbc driver

In reply to this post by Jacques Le Roux

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

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

Did you make some changes ?

Jacques

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

Jack Liu-2

RE: OFBiz's jdbc driver

If I start OFBiz with startOfBiz.bat, it' ok,
while in eclipse, I run Start.java, it fails.

-----Original Message-----
From: Jack Liu [mailto:[hidden email]]
Sent: 2009年3月30日 15:22
To: [hidden email]; 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:[hidden email]]
Sent: 2009年3月30日 15:17
To: [hidden email]
Subject: Re: OFBiz's jdbc driver

Did you make some changes ?

Jacques

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

BJ Freeman

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:[hidden email]]
> Sent: 2009年3月30日 15:22
> To: [hidden email]; 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:[hidden email]]
> Sent: 2009年3月30日 15:17
> To: [hidden email]
> Subject: Re: OFBiz's jdbc driver
>
> Did you make some changes ?
>
> Jacques
>
> From: "Jack Liu" <[hidden email]>
>> 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:[hidden email]]
>> Sent: 2009年3月27日 18:03
>> To: [hidden email]
>> 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:[hidden email]]
>>>> 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-----

Jack Liu-2

RE: OFBiz's jdbc driver

http://docs.ofbiz.org/display/OFBIZ/Running+and+Debugging+OFBiz+in+Eclipse
It works

Thank you, BJ Freeman.

-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: 2009年3月30日 16:53
To: [hidden email]
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:

BJ Freeman

Re: OFBiz's jdbc driver

-----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:[hidden email]]
> Sent: 2009年3月30日 16:53
> To: [hidden email]
> 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:[hidden email]]
>> 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-----

sumit

Re: Ofbiz with Magnolia

In reply to this post by madppiper-2

Hi,

can you tell me how to write that groovy script for fetching content from magnolia to ofbiz and where i have to put that groovy script file

Thanks
Sumit