ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Bush <netbeans...@yahoo.com.au>
Subject Re: How to switch from Derby to MySQL environment
Date Tue, 15 Feb 2011 02:33:38 GMT
Hi Antoine,
 
No, your suggestion is incorrect but it was partly my fault. Let's look at the 
brief error message below again before going into detail on where the issue is 
coming from:
........
create_datasource:
[exec] JDBC connection pool EmpServDB_ch3 created successfully.
[exec] Command create-jdbc-connection-pool executed successfully.
[exec] JDBC resource jdbc/EmpServDB_ch3 created successfully.
[exec] Command create-jdbc-resource executed successfully.
 
run_sql:
BUILD FAILED
C:\Temp\ProJPA2\config\common.xml:144: 
java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error 
connecting to server localhost on port 1527 with message Connection refused: 
connect.
 
The problem is that it is referencing the Derby SQL server 
from C:\Temp\ProJPA2\config\common.xml below which I have not included in this 
post earlier:
 <?xml version="1.0" encoding="iso-8859-1"?>
<project name="common">
<property file="common.properties"/>.......<target name="run_sql">
<sql driver="org.apache.derby.jdbc.ClientDriver"
url="jdbc:derby://${DERBY_HOST}:${DERBY_PORT}/${DB_NAME};create=true"
userid="${DERBY_USER}"
password="${DERBY_PWD}"
src="etc/sql/db.sql"
onerror="continue">
<classpath>
<pathelement path="${DERBY_CLASSPATH}"/>
</classpath>
</sql>
</target>
</project> 
 This "run_sql" target using Derby variable settings in 
C:\Temp\ProJPA2\config\common.properties below to connect to Derby server and 
failed because I have turned it off and turn on MySQL which listens on port 3306 
instead:
 
##################################################
# Derby Database properties 
##################################################
DERBY_INSTALL=${SERVER_HOME}/javadb
DERBY_PORT=1527
DERBY_HOST=localhost
DERBY_USER=APP
DERBY_PWD=APP
DERBY_SYSTEM_HOME=${EXAMPLES_HOME}/database
DERBY_CLASSPATH=${DERBY_INSTALL}/lib/derby.jar;${DERBY_INSTALL}/lib/derbynet.jar;${DERBY_INSTALL}/lib/derbyclient.jar;${DERBY_INSTALL}/lib/derbytools.jar

The net result is the 
C:\Temp\ProJPA2\examples\Chapter3\16-employeeService\etc\sql\db.sql below get 
run (instead of Chapter2 - does not use GF & is working with MySQL):
 DROP TABLE EMPLOYEE;
CREATE TABLE EMPLOYEE (ID INTEGER NOT NULL, NAME VARCHAR(255), SALARY BIGINT, 
PRIMARY KEY (ID)); 
In addition, the following 
C:\Temp\ProJPA2\examples\Chapter3\16-employeeService\etc\persistence\META-INF\persistence.xml
 that is used by this Glassfish v3 already has some of these MySQL connection 
detail:
 <?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence 
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="EmployeeService">
<jta-data-source>jdbc/EmpServDB_ch3</jta-data-source>
<properties>
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
<property name="javax.persistence.jdbc.url" 
value="jdbc:mysql://localhost:3306/EmployeeDB"/>
<property name="javax.persistence.jdbc.password" value="123456"/>
<property name="javax.persistence.jdbc.user" value="applicationuser"/>
<property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>
<!-- enable this property to see SQL and other logging -->
<property name="eclipselink.logging.level" value="FINE"/>
</properties>
</persistence-unit>
</persistence> 
Again, the question is how to clear all Derby related 
entries/variables/properties in both C:\Temp\ProJPA2\config\common.xml & 
C:\Temp\ProJPA2\config\common.properties and replace them with the equivalent 
MySQL settings so that Ant (
 
Thanks alot,
Jack<target name="run_sql">) no longer look for port 1527.

----- Original Message ----
From: Antoine Levy-Lambert <antoine@gmx.de>
To: Ant Users List <user@ant.apache.org>
Sent: Fri, 11 February, 2011 1:39:24 AM
Subject: Re: How to switch from Derby to MySQL environment

Hello Jack,

you probably need to start a MySQL server on port 152 ?

Antoine


47.  BUILD FAILED  
48.  
C:\ProJPA2\config\common.xml:144: java.sql.SQLNonTransientConnectionException: 
java.net.ConnectException : Error connecting to server localhost on port 152

On 2/10/2011 7:29 AM, Jack Bush wrote:
> Hi All,
>
> I would like to run a JPA Derby packaged tutorial in MySQL. This 
pre-configured
> exercise runs fine with Derby using Ant built script. However, it would failed
> to build after having attempted to replace the Derby properties with MySQL.
> Below are some configuration files used by this exercise:
>
>
> I am running JDK1.6.0_20, GF3.1, Ant 1.8.2 on Windows XP.
>
> Your suggestion would be much appreciated.
>
> Thanks,
>
> Jack
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


      

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message