Re: Users - Running OFBiz with MySQL on FreeBSD

Posted by Si Chen-2 on May 05, 2006; 6:45pm
URL: http://ofbiz.116.s1.nabble.com/Users-Running-OFBiz-with-MySQL-on-FreeBSD-tp138917p138919.html

Just so you know: opentaps downloads include the JDBC driver for MySQL and PostgreSQL.  If you're using OFBiz off SVN you'll need to go put it there yourself. 

Si

David E Jones wrote:

The JDBC driver must be on the OFBiz classpath. If you copy it into one of the lib directories, like ofbiz/framework/entity/lib/jdbc where the others are, then it will pick it up when you start.

-David


Walter Vaughan wrote:
  

I've been playing with this problem for the last 24 hours and I give up.

I am wanting to test OFBiz using MySQL 5.0 on FreeBSD platform.

I followed the directions at
http://www.opentaps.org/index.php?option=com_content&task=view&id=37&Itemid=62

and it looks like it the failure is using jdbc...
<code>
      [java] 7465  (main) [   GenericDelegator.java:176:INFO ] Delegator "default
" initializing helper "localmysql" for entity group "org.ofbiz".
      [java] 7477  (main) [   GenericDelegator.java:193:INFO ] Doing database che
ck as requested in entityengine.xml with addMissing=true
      [java] 7649  (main) [            UtilXml.java:242:DEBUG] XML Read 0.029s: f
ile:/usr/local/ofbiz/ofbiz/base/config/jndiservers.xml
      [java] 7706  (main) [   XADataSourceImpl.java:170:WARN ] unable to load dri
ver
      [java] java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
</code>

I have tried a simple jdbc test, but I am not sure if its me or the connector 
that is not working.  Does someone have a link to a step by step tutorial for 
testing jdbc-mysql?

# pkg_info | grep jdk
jdk-1.4.2p8_3       Java Development Kit 1.4.2
linux-sun-jdk-1.4.2.11 Sun Java Development Kit 1.4 for Linux
# pkg_info | grep mysql
mysql-client-5.0.20 Multithreaded SQL database (client)
mysql-connector-java-3.1.12 MySQL Connector/J: JDBC interface for MySQL
mysql-server-5.0.20 Multithreaded SQL database (server)

Thanks

--
Walter
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
    

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users


  

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users