R: R: App + ConnectorJ + MXJ deployment

Hi Eric, 

 

I'm back to the development machine willing to start from scratch. 

 

============================================================================
===

STEP 1  

 

My small Java app (unaware of Connector-MXJ) runs properly and connects 

to MySQL Server on the default port 3306: 

*         to my database “rua142” 

*         with the username “utente142”

*         with the password “pulsar” 

*         with the following JDBC URL Connection (with no explicit port
reference): 

 

Connection  dbConn =
DriverManager.getConnection("jdbc:mysql://localhost/rua142?user=utente142&pa
ssword=pulsar");

 

============================================================================
===

 

STEP 2

 

I suppose I should make the Java app aware of Connector-MXJ by changing 

my Java class which manages the DB connection. 

Is the attached java file properly changed ? 

 

============================================================================
=== 

 

STEP 3

 

Is step # 3 

“Creating your own Connector/MXJ Package” and “Deploying Connector/MXJ with
a pre-configured database” 

Following paragraph 27.4.5.1 and 27.4.5.2 of the online manual ?

 

============================================================================
=== 

 

Cheers 

Roberto

 

 

 

 

 

 

-----Messaggio originale-----
Da: Eric Herman [mailto:[email protected]] 
Inviato: lunedì 25 settembre 2006 14.03
A: tech
Cc: [email protected]
Oggetto: Re: R: App + ConnectorJ + MXJ deployment

 

Hi Roberto,

 

At first glance, the only serious issue I see is that it looks like the

port was forgotten in the JDBC URL connection string:

 

> dbConn = DriverManager.getConnection("jdbc:mysql://localhost/" +

> DATABASE + "?user=" + USERID + "&password=" + PASSWORD); 

 

That should really look more like:

 

"jdbc:mysql://localhost" + port + "/" + ...


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