Re: R: App + Connector/MXJ deployment

Hello Roberto,

On Wed, 2006-09-20 at 12:18 +0200, tech wrote:
> Yes, Eric. My question is: what about Connector/J ?

Oh, I apologize. I did not understand your question the first time.

> 
> On my development pc I had copied mysql-connector-java-5.0.3-bin.jar to my 
> $JAVA_HOME/jre/lib/ext directory and it worked properly. 
> 
> Now, on the target pc I have the JRE and two jars: 
> 1) my Java application 
> 2) my own connector-mxj.jar with the pre-configured DB for the above
> application. 
> 
> But what about Connector/J ?

Oh, yes. You will need Connector/J as well ... both for Connector/MXJ to
contact the MySQL server, as well well as for your own application to
create database connections.


Just to be complete, the deployment machine's CLASSPATH will need:
(1) your java application 
(2) mysql-connector-java-5.0.3-bin.jar
(3) connector-mxj.jar
(4) aspectjrt.jar
(5) any other 3rd party libraries that your application relies upon


Cheers,
 -Eric

> 
> Cheers
> Roberto
> 
> 
> 
> 
> -----Messaggio originale-----
> Da: Eric Herman [mailto:[email protected]] 
> Inviato: martedì 19 settembre 2006 19.49
> A: tech
> Cc: [email protected]
> Oggetto: Re: App + Connector/MXJ deployment
> 
> On Tue, 2006-09-19 at 18:04 +0200, tech wrote:
> > Hi Eric, 
> > 
> >  
> > 
> > here is my situation. I have created: 
> > 
> >  
> > 
> > 1)       MySQLTest.jar (my Java application which queries properly the
> > MySQL Server on my development pc)
> > 
> >  
> > 
> > 2)       connector-mxj.jar (my own connector-mxj.jar with the
> > pre-configured DB for the above application, created following
> > paragraph 27.4.5.1 and 27.4.5.2 of the online manual) 
> > 
> >  
> > 
> > Now, I have another pc with the Java runtime environment and no
> > MySQL. 
> > 
> >  
> > 
> > Can you tell me how to proceed to deploy my Java application with its
> > own database on the second pc ?
> 
> Okay, sounds great. Provided the re-packaging of the connector.mxj jar
> is correct, it should be as simple as making certain that each of the
> jar files are in the CLASSPATH and starting your application.
> 
> You may wish to specify the "basedir" for the Connector/MXJ to use to
> write the database files to, because the default basedir is a
> subdirectory "java.io.tmpdir".
> 
> Do you have a more specific question?
> 
> Cheers,
>  -Eric
> > 
> P.S.: Please keep us posted on how it goes for you.
> 
> 
> > Thanks
> > 
> >  
> > 
> > Roberto Regazzoni
> > 
> >  
> > 
> >  
> > 
> > 
> -- 
> Eric Herman, Software Developer
> MySQL AB, www.mysql.com
> VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
> Mobile: +31 [0]6-20719662
> Are you MySQL certified?  www.mysql.com/certification
> 
> 
-- 
Eric Herman, Software Developer
MySQL AB, www.mysql.com
VoIP Ext: 6594   US: +1 408 213 6540  Europe: +46 18 174 400
Mobile: +31 [0]6-20719662
Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]