OFBiz › OFBiz - User

Users - Running OFBiz with MySQL on FreeBSD

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 6 messages Options
Walter Vaughan
Reply | Threaded
Open this post in threaded view
♦
♦
|

Users - Running OFBiz with MySQL on FreeBSD

Walter Vaughan
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
Jacopo Cappellato
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Running OFBiz with MySQL on FreeBSD

Jacopo Cappellato
Walter,

did you put the jdbc driver in the framework/entity/jdbc folder?

Jacopo

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
David E. Jones
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Running OFBiz with MySQL on FreeBSD

David E. Jones
In reply to this post by Walter Vaughan
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
Si Chen-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Running OFBiz with MySQL on FreeBSD

Si Chen-2
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
Walter Vaughan
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Running OFBiz with MySQL on FreeBSD

Walter Vaughan
In reply to this post by Jacopo Cappellato
Jacopo Cappellato wrote:

> Walter,
> did you put the jdbc driver in the framework/entity/jdbc folder?

Now I did. I built the site using SVN instructions, and that was the problem
with the missing driver. I copied that file from my XP box and put it in the
framework/entity/lib/jdbc folder and it built all the files as needed formatted
as innoDB style so I should be ready to go.

Actually it doesn't seem any faster, but hey, it works.

Thanks
--
Walter
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Kenneth Porter
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Running OFBiz with MySQL on FreeBSD

Kenneth Porter
In reply to this post by Si Chen-2
On Friday, May 05, 2006 10:45 AM -0700 Si Chen
<[hidden email]> wrote:

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

That should probably be included in the wiki pages about those two DB's.


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Free forum by Nabble Edit this page