Menu
▾
▴
Re: [Opensims-user] Torque and MySQL
|
From: Mando E. <ma...@sy...> - 2008-12-04 15:48:14
|
Nick, I'm afraid my MySQL-fu is weak :). Can you do the following for me? Make sure that "jar tvf mysql-connector jar" has org/mysql/jdbc/Driver somewhere in the listing. Like I said, I've only really done this with Postgres, so I'm not familiar with which jars work with various mysql and java combos. -- Mando Escamilla On Dec 4, 2008, at 9:43 AM, Ritter, Nicholas wrote: > I have copied the jar to the same classpaths listed via "ant - > diagnostics" and it has not changed the outcome at all. I installed > the distro (centos 5.2) package for postgres jdbc to see where they > put it, and then I copied the mysql jar to there and it still didn't > work. The error returned has been exactly the same throughout > everything I have tried. Of the 3, or so, versions of the mysql j/ > connector available, I am not sure I am using the correct version > for the version of ant/tomcat/java I am using. > > To make things easier on myself, I started of with using the ant, > tomcat, apache, and java that is bundled with CentOS 5.2 x86_64. > This involves: > > java 1.4.2 via gnu gij version 4.1.2 > ant 1.6.5 > tomcat5 (5.5.23) > > I have never worked with ant/tomcat/java so I am in the dark a bit. > I tried following the install information on the MySQL website and > realized that the version of J/Connector I am using ( mysql- > connector-java-5.1.7 ) is JDBC v4 driver, and may not be supported > with my version of Java...but I have not been able to figure out how > to find the version of JDBC that my system supports. > > I am somewhat curious as to why I specify the path to the driver in > the build.properties file when the driver should, or needs, to be in > the global CLASSPATH and thus would be loadable by default. > > Nick > > > -----Original Message----- > From: Mando Escamilla [mailto:ma...@sy...] > Sent: Wed 12/3/2008 4:45 PM > To: ope...@li... > Subject: Re: [Opensims-user] Torque and MySQL > > Nicholas, > > That's a great question :). I'm relatively new to the opensims > project, so I've never fully investigated getting opensims running > with MySQL (which is pretty embarrassing, I must admit). > > I'd take a look at two things: > > 1) Make sure that opensims/torque/lib is in opensims/java/ > classpath.xml > 2) Make sure that org.mysql.jdbc.Driver is actually in the mysql- > connector jar file. > > Frankly, the classpath stuff is very much a mess right now :(. It > definitely takes some tweaking and poking to get everything in place. > > Try hacking around with those two things, and if you can't make any > head way let me know. > > Thanks, > > -- > Mando Escamilla > > On Dec 3, 2008, at 4:03 PM, Ritter, Nicholas wrote: > >> Ok...did some digging...and downloaded the J/Connector v5.1.7 jar >> from MySQL.com. >> >> I copied the mysql-connector-java-5.1.7-bin.jar to the Torque /lib >> dir. >> >> I then edited the build.properties to show the following: >> >> db.platform = mysql >> db.jdbc.driver = org.mysql.jdbc.Driver >> db.jdbc.jar = /opt/opensims/tools/torque/lib/mysql-connector- >> java-5.1.7-bin.jar >> >> I then run: "ant preflight clean config build test datadump" from >> the "/opt/opensims/tools/torque" directory. I get the following >> error: >> >> Buildfile: build.xml >> >> config: >> [copy] Copying 1 file to /opt/opensims/build >> >> load_properties: >> >> preflight: >> [echo] >> [echo] Now using Torque to build OpenSIMS database ... >> [echo] >> [echo] platform: mysql >> [echo] driver: org.mysql.jdbc.Driver >> [echo] JAR file: /opt/opensims/tools/torque/lib/mysql- >> connector-java-5.1.7-bin.jar >> [echo] user: <censored for this post> >> [echo] password: <censored for this post> >> [echo] create URL: jdbc:mysql://localhost:3306/mysql >> [echo] build URL: jdbc:mysql://localhost:3306/opensims >> [echo] db URL: jdbc:mysql://localhost:3306/opensims >> [echo] valid query: SELECT 1 >> [echo] >> [echo] ...the answer should be '1' >> [echo] ...otherwise, your database properties are not quite right. >> [echo] >> >> BUILD FAILED >> /opt/opensims/tools/torque/build.xml:246: Class Not Found: JDBC >> driver org.mysql.jdbc.Driver could not be loaded >> >> Total time: 0 seconds >> >> >> I figured this is a CLASSPATH issue? How do I solve it? >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's >> challenge >> Build the coolest Linux based applications with Moblin SDK & win >> great prizes >> Grand prize is a trip for two to an Open Source event anywhere in >> the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Opensims-user mailing list >> Ope...@li... >> https://lists.sourceforge.net/lists/listinfo/opensims-user > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Opensims-user mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/opensims-user > > > < > winmail > .dat > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win > great prizes > Grand prize is a trip for two to an Open Source event anywhere in > the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________ > Opensims-user mailing list > Ope...@li... > https://lists.sourceforge.net/lists/listinfo/opensims-user |
