Hi Aslak,
Ok, i found other postgrsql jdbc driver, look better.... but also got
error....
i attach some files for you.....
and error like following:
It could display the java window correctly.... but no relation [Line]
between table......... ???
-------->8--------------
$ant war
Buildfile: build.xml
check-driver-present:
[echo]
/home/gordon/middlegen_cvs_update/middlegen/samples/lib/jxDBCon-jdbc3-0.9z.jar
true
panic-if-driver-not-present:
middlegen:
[middlegen] INFO [main] middlegen.Middlegen (Middlegen.java:268) -
Registering plugin html
[middlegen] INFO [main] middlegen.Middlegen (Middlegen.java:268) -
Registering plugin bmp20
[middlegen] INFO [main] middlegen.Middlegen (Middlegen.java:268) -
Registering plugin cmp20
[middlegen] INFO [main] middlegen.Middlegen (Middlegen.java:268) -
Registering plugin sunjdo10
[middlegen] Database URL:jdbc:postgresql:net//localhost/airline
[middlegen] Setting TZ GMT+08:00
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:418) - databaseProductName=PostgreSQL
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:499) - -- tables --
[middlegen] Setting TZ GMT+08:00
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:332) - -------setColumns(PERSONS)
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:381) - Guessed pk=person_id
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:332) - -------setColumns(RESERVATIONS)
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:381) - Guessed pk=reservation_id
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:332) - -------setColumns(FLIGHTS)
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:381) - Guessed pk=flight_id
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:228) - Imported Keys for PERSONS
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:228) - Imported Keys for RESERVATIONS
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:260) - flights is not among the wanted tables
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:260) - persons is not among the wanted tables
[middlegen] DEBUG [main] middlegen.MiddlegenPopulator
(MiddlegenPopulator.java:228) - Imported Keys for FLIGHTS
[middlegen] Setting TZ GMT+08:00
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table PERSONS's unique pk column:person_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table RESERVATIONS's unique pk column:reservation_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table FLIGHTS's unique pk column:flight_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table PERSONS's unique pk column:person_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table RESERVATIONS's unique pk column:reservation_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table FLIGHTS's unique pk column:flight_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table PERSONS's unique pk column:person_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table RESERVATIONS's unique pk column:reservation_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table FLIGHTS's unique pk column:flight_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table PERSONS's unique pk column:person_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table RESERVATIONS's unique pk column:reservation_id
[middlegen] DEBUG [main] middlegen.DbTable ( DbTable.java:168) -
Table FLIGHTS's unique pk column:flight_id
.....
..
..
......
compile-web:
[javac] Compiling 15 source files to
/home/gordon/middlegen_cvs_update/middlegen/samples/build/classes
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetAllAction.java:28:
cannot resolve symbol
[javac] symbol : class ReservationPK
[javac] location: package interfaces
[javac] import airline.ejb.interfaces.ReservationPK;
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetAllPersonsAction.java:28:
cannot resolve symbol
[javac] symbol : class ReservationPK
[javac] location: package interfaces
[javac] import airline.ejb.interfaces.ReservationPK;
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:28:
cannot resolve symbol
[javac] symbol : class ReservationPK
[javac] location: package interfaces
[javac] import airline.ejb.interfaces.ReservationPK;
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/MakeReservationAction.java:31:
cannot resolve symbol
[javac] symbol : class ReservationPK
[javac] location: package interfaces
[javac] import airline.ejb.interfaces.ReservationPK;
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:79:
cannot resolve symbol
[javac] symbol : class ReservationPK
[javac] location: class airline.web.struts.GetReservationAction
[javac] ReservationLocal reservation =
ReservationUtil.getLocalHome().findByPrimaryKey(new
ReservationPK(flightIdFk, personIdFk, reservationId));
[javac]
^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:83:
cannot resolve symbol
[javac] symbol : method getPerson ()
[javac] location: interface airline.ejb.interfaces.ReservationLocal
[javac] request.setAttribute("person",
reservation.getPerson());
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:84:
cannot resolve symbol
[javac] symbol : method getFlight ()
[javac] location: interface airline.ejb.interfaces.ReservationLocal
[javac] request.setAttribute("flight",
reservation.getFlight());
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update/middlegen/samples/src/java/airline/web/struts/MakeReservationAction.java:91:
cannot resolve symbol
[javac] symbol : method create
(java.lang.Integer,java.sql.Timestamp,java.lang.String,airline.ejb.interfaces.PersonLocal,airline.ejb.interfaces.FlightLocal)
[javac] location: interface airline.ejb.interfaces.ReservationLocalHome
[javac]
reservationHome.create(reservationId, new Timestamp((new
Date()).getTime()), "test comment", person, flight);
[javac] ^
[javac] 8 errors
BUILD FAILED
/home/gordon/middlegen_cvs_update/middlegen/samples/build.xml:328:
Compile failed; see the compiler error output for details.
Total time: 2 minutes 1 second
----------------------------->8-------------------
Gordon
<!-- =================================================================== -->
<!-- ant properties/targets for mysql -->
<!-- note: this is not a proper xml file (there is no root element) -->
<!-- it is intended to be imported from a *real* xml file -->
<!-- =================================================================== -->
<property name="database.script.file" value="${src.dir}/sql/${name}-postgresq.sql"/>
<property name="database.driver.file" value="${lib.dir}/jxDBCon-jdbc3-0.9z.jar"/>
<property name="database.driver" value="org.sourceforge.jxdbcon.JXDBConDriver"/>
<property name="database.url" value="jdbc:postgresql:net//localhost/airline"/>
<property name="database.userid" value="postgres"/>
<property name="database.password" value="postgres"/>
<property name="database.schema" value=""/>
<property name="database.catalog" value=""/>
<property name="database.datasource-mapping" value="PostgreSQL 7.2"/>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE preferences SYSTEM 'http://java.sun.com/dtd/preferences.dtd'>
<preferences EXTERNAL_XML_VERSION="1.0">
<root type="user">
<map />
<node name="middlegen">
<map />
<node name="airline">
<map />
<node name="tables">
<map />
<node name="FLIGHTS">
<map />
<node name="bmp20">
<map>
<entry key="base-class-name" value="Flight" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="base-class-name" value="Flight" />
</map>
</node>
<node name="columns">
<map />
<node name="arrival_utc">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="arrivalUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="arrivalUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="arrivalUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
</map>
</node>
</node>
<node name="departure_utc">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="departureUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="departureUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="departureUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
</map>
</node>
</node>
<node name="flight_id">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="flightId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="flightId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="flightId" />
<entry key="java-type" value="int" />
</map>
</node>
</node>
<node name="name">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="name" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="name" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="name" />
<entry key="java-type" value="java.lang.String" />
</map>
</node>
</node>
</node>
<node name="jdo">
<map>
<entry key="base-class-name" value="Flight" />
<entry key="callback" value="true" />
<entry key="destinationClassName" value="FlightBean" />
</map>
</node>
</node>
<node name="PERSONS">
<map />
<node name="bmp20">
<map>
<entry key="base-class-name" value="Person" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="base-class-name" value="Person" />
</map>
</node>
<node name="columns">
<map />
<node name="first_name">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="firstName" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="firstName" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="firstName" />
<entry key="java-type" value="java.lang.String" />
</map>
</node>
</node>
<node name="last_name">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="lastName" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="lastName" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="lastName" />
<entry key="java-type" value="java.lang.String" />
</map>
</node>
</node>
<node name="person_id">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="personId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="personId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="personId" />
<entry key="java-type" value="int" />
</map>
</node>
</node>
</node>
<node name="jdo">
<map>
<entry key="base-class-name" value="Person" />
<entry key="callback" value="true" />
<entry key="destinationClassName" value="PersonBean" />
</map>
</node>
</node>
<node name="RESERVATIONS">
<map />
<node name="bmp20">
<map>
<entry key="base-class-name" value="Reservation" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="base-class-name" value="Reservation" />
</map>
</node>
<node name="columns">
<map />
<node name="comment">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="comment" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="comment" />
<entry key="java-type" value="java.lang.String" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="comment" />
<entry key="java-type" value="java.lang.String" />
</map>
</node>
</node>
<node name="flight_id_fk">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="flightIdFk" />
<entry key="java-type" value="int" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="flightIdFk" />
<entry key="java-type" value="int" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="flightIdFk" />
<entry key="java-type" value="int" />
</map>
</node>
</node>
<node name="person_id_fk">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="personIdFk" />
<entry key="java-type" value="int" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="personIdFk" />
<entry key="java-type" value="int" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="personIdFk" />
<entry key="java-type" value="int" />
</map>
</node>
</node>
<node name="registration_utc">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="registrationUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="registrationUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
<entry key="local-get" value="true" />
<entry key="local-set" value="true" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="registrationUtc" />
<entry key="java-type" value="java.sql.Timestamp" />
</map>
</node>
</node>
<node name="reservation_id">
<map />
<node name="bmp20">
<map>
<entry key="java-name" value="reservationId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="cmp20">
<map>
<entry key="java-name" value="reservationId" />
<entry key="java-type" value="java.lang.Integer" />
<entry key="local-get" value="true" />
<entry key="local-set" value="false" />
<entry key="remote-get" value="false" />
<entry key="remote-set" value="false" />
</map>
</node>
<node name="jdo">
<map>
<entry key="java-name" value="reservationId" />
<entry key="java-type" value="int" />
</map>
</node>
</node>
</node>
<node name="jdo">
<map>
<entry key="base-class-name" value="Reservation" />
<entry key="callback" value="true" />
<entry key="destinationClassName" value="ReservationBean" />
</map>
</node>
</node>
</node>
</node>
</node>
</root>
</preferences>
