Re: OFBiz's jdbc driver

Mon, 30 Mar 2009 00:21:05 -0700
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:[email protected]]
Sent: 2009年3月27日 18:03
To: [email protected]
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:[email protected]]
Sent: 2009年3月27日 17:18
To: [email protected]
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.preparedstatementinp...@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-----





























					Reply via email to