[Middlegen-user] Latest CVS Version [2002/07/12] got error for Postgresql & JBOSS

Discussion:

Gordon Luk

2002-07-12 02:24:03 UTC

Hi Aslak,

run "ant middlegen I just cvs get the latest version of middlegen. and
change build.xml header for few line ( postgres... jboss)... and
then"... but got error... should i download the latest development
postgresql driver ? current, i just using come with middlegen cvs .

----------------------->8-----------------------------
$ ant middlegen
Buildfile: build.xml

check-driver-present:
[echo]
/home/gordon/middlegen_cvs_update2/middlegen/samples/lib/postgresql.jar true

panic-if-driver-not-present:

middlegen:
[middlegen] (middlegen.Middlegen 305 ) Registering plugin html
[middlegen] (middlegen.Middlegen 305 ) Registering plugin bmp20
[middlegen] (middlegen.Middlegen 305 ) Registering plugin cmp20
[middlegen] (middlegen.Middlegen 305 ) Registering plugin sunjdo10
[middlegen] Database URL:jdbc:postgresql://localhost/airline
[middlegen] (entitybean.Entity20Plugin ? ) If a preference file exists,
the viewtype settings will be ignored.
[middlegen] (entitybean.Entity11Plugin ? ) If a preference file exists,
the readonly settings will be ignored.
[middlegen] (middlegen.MiddlegenPopulator 208 ) ERROR: Unable to
identify an ordering operator '<' for type 'bytea'
[middlegen] Use an explicit ordering operator or modify the query

[middlegen] java.sql.SQLException: ERROR: Unable to identify an ordering
operator '<' for type 'bytea'
[middlegen] Use an explicit ordering operator or modify the query

[middlegen] at org.postgresql.core.QueryExecutor.execute(Unknown Source)
[middlegen] at org.postgresql.Connection.ExecSQL(Unknown Source)
[middlegen] at org.postgresql.Connection.ExecSQL(Unknown Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedExportedKeys(Unknown
Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedExportedKeys(Unknown
Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedKeys(Unknown Source)
[middlegen] at
middlegen.MiddlegenPopulator.addRelations(MiddlegenPopulator.java:283)
[middlegen] at
middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:189)
[middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:382)
[middlegen] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java)
[middlegen] at org.apache.tools.ant.Task.perform(Task.java)
[middlegen] at org.apache.tools.ant.Target.execute(Target.java)
[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java)
[middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java)
[middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java)
[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java)
[middlegen] at org.apache.tools.ant.Main.start(Main.java)
[middlegen] at org.apache.tools.ant.Main.main(Main.java)

BUILD FAILED
/home/gordon/middlegen_cvs_update2/middlegen/samples/build.xml:126:
middlegen.MiddlegenException: Database problem:ERROR: Unable to identify
an ordering operator '<' for type 'bytea'
Use an explicit ordering operator or modify the query

Total time: 4 seconds
----------------------->8-----------------------------

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Aslak Hellesoy

2002-07-12 11:17:10 UTC

Permalink

The postgresql.jar in Middlegen is even newer than the latest released
development version. It was built from CVS yesterday, and it has some
bugfixes that aren't in the released development version. You could still
try the latest released development version from the postgres site, but I
doubt it'll work any better. Are you sure you don't have an old driver on
your classpath too?

Aslak

-----Original Message-----
Sent: 12. juli 2002 06:23
Subject: [Middlegen-user] Latest CVS Version [2002/07/12] got
error for Postgresql & JBOSS
Hi Aslak,
run "ant middlegen I just cvs get the latest version of middlegen. and
change build.xml header for few line ( postgres... jboss)... and
then"... but got error... should i download the latest development
postgresql driver ? current, i just using come with middlegen cvs .
----------------------->8-----------------------------
$ ant middlegen
Buildfile: build.xml
[echo]
/home/gordon/middlegen_cvs_update2/middlegen/samples/lib/postgresq
l.jar true
[middlegen] (middlegen.Middlegen 305 ) Registering plugin html
[middlegen] (middlegen.Middlegen 305 ) Registering plugin bmp20
[middlegen] (middlegen.Middlegen 305 ) Registering plugin cmp20
[middlegen] (middlegen.Middlegen 305 ) Registering plugin sunjdo10
[middlegen] Database URL:jdbc:postgresql://localhost/airline
[middlegen] (entitybean.Entity20Plugin ? ) If a preference file exists,
the viewtype settings will be ignored.
[middlegen] (entitybean.Entity11Plugin ? ) If a preference file exists,
the readonly settings will be ignored.
[middlegen] (middlegen.MiddlegenPopulator 208 ) ERROR: Unable to
identify an ordering operator '<' for type 'bytea'
[middlegen] Use an explicit ordering operator or modify the query
[middlegen] java.sql.SQLException: ERROR: Unable to identify an ordering
operator '<' for type 'bytea'
[middlegen] Use an explicit ordering operator or modify the query
[middlegen] at org.postgresql.core.QueryExecutor.execute(Unknown Source)
[middlegen] at org.postgresql.Connection.ExecSQL(Unknown Source)
[middlegen] at org.postgresql.Connection.ExecSQL(Unknown Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedExportedKeys(Unknown
Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedExportedKeys(Unknown
Source)
[middlegen] at
org.postgresql.jdbc2.DatabaseMetaData.getImportedKeys(Unknown Source)
[middlegen] at
middlegen.MiddlegenPopulator.addRelations(MiddlegenPopulator.java:283)
[middlegen] at
middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:189)
[middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:382)
[middlegen] at
org.apache.tools.ant.UnknownElement.execute(UnknownElement.java)
[middlegen] at org.apache.tools.ant.Task.perform(Task.java)
[middlegen] at org.apache.tools.ant.Target.execute(Target.java)
[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java)
[middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java)
[middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java)
[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java)
[middlegen] at org.apache.tools.ant.Main.start(Main.java)
[middlegen] at org.apache.tools.ant.Main.main(Main.java)
BUILD FAILED
middlegen.MiddlegenException: Database problem:ERROR: Unable to identify
an ordering operator '<' for type 'bytea'
Use an explicit ordering operator or modify the query
Total time: 4 seconds
----------------------->8-----------------------------
_________________________________________________________
Do You Yahoo!?
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
PC Mods, Computing goodies, cases & more
http://thinkgeek.com/sf
_______________________________________________
middlegen-user mailing list
https://lists.sourceforge.net/lists/listinfo/middlegen-user

Gordon Luk

2002-07-13 02:22:05 UTC

Permalink

Hi Aslak,

I think your cvs from postgresql jdbc driver got problem... as you see
problem on "type 'bytea'", but inside the airline database, not column
define in "bytea"... it should the driver return meta data got wrong info.

I had try old driver, no problem , middlegen task build successful. :-)

Gordon

Post by Aslak Hellesoy
The postgresql.jar in Middlegen is even newer than the latest released
development version. It was built from CVS yesterday, and it has some
bugfixes that aren't in the released development version. You could still
try the latest released development version from the postgres site, but I
doubt it'll work any better. Are you sure you don't have an old driver on
your classpath too?
Aslak

Gordon Luk

2002-07-13 02:45:07 UTC

Permalink

Aslak ,

I have try two driver , one is old postgresql driver, other one is
jxDBcon, two also got error , but all problem at web stuff also, all
relate to ReservationPK constructor in different parameter... is that
probelm on my setting...
as you know, i use Jboss... so the <cmp20> fkcmp is "false"... so middle
generete "ReservationPK constructor" different...

Gordon

--------->8-----old postgresql driver--------------
compile-web:
Overriding previous definition of reference to compile.class.path
[javac] Compiling 7 source files to
/home/gordon/middlegen_cvs_update2/middlegen/samples/build/classes
[javac]
/home/gordon/middlegen_cvs_update2/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:79:
cannot resolve symbol
[javac] symbol : constructor ReservationPK
(java.lang.Integer,java.lang.Integer,java.lang.Integer)
[javac] location: class airline.ejb.interfaces.ReservationPK
[javac] ReservationLocal reservation =
ReservationUtil.getLocalHome().findByPrimaryKey(new
ReservationPK(flightIdFk, personIdFk, reservationId));
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update2/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_update2/middlegen/samples/src/java/airline/web/struts/MakeReservationAction.java:91:
cannot resolve symbol
[javac] symbol : method create
(java.lang.Integer,java.sql.Timestamp,airline.ejb.interfaces.FlightLocal,airline.ejb.interfaces.PersonLocal)
[javac] location: interface airline.ejb.interfaces.ReservationLocalHome
[javac] reservationHome.create(reservationId, new Timestamp((new
Date()).getTime()), flight, person);
[javac]
[javac] 3 errors
--------->8-------------------

--------->8-----jxDBcon--------------
compile-web:
Overriding previous definition of reference to compile.class.path
[javac] Compiling 7 source files to
/home/gordon/middlegen_cvs_update2/middlegen/samples/build/classes
[javac]
/home/gordon/middlegen_cvs_update2/middlegen/samples/src/java/airline/web/struts/GetReservationAction.java:79:
cannot resolve symbol
[javac] symbol : constructor ReservationPK
(java.lang.Integer,java.lang.Integer,java.lang.Integer)
[javac] location: class airline.ejb.interfaces.ReservationPK
[javac] ReservationLocal reservation =
ReservationUtil.getLocalHome().findByPrimaryKey(new
ReservationPK(flightIdFk, personIdFk, reservationId));
[javac] ^
[javac]
/home/gordon/middlegen_cvs_update2/middlegen/samples/src/java/airline/web/struts/MakeReservationAction.java:91:
cannot resolve symbol
[javac] symbol : method create
(java.lang.Integer,java.sql.Timestamp,airline.ejb.interfaces.FlightLocal,airline.ejb.interfaces.PersonLocal)
[javac] location: interface airline.ejb.interfaces.ReservationLocalHome
[javac] reservationHome.create(reservationId, new Timestamp((new
Date()).getTime()), flight, person);
[javac] ^
[javac] 2 errors
--------->8-------------------