Patric,
I tried your suggestion and it worked.
Thanks,
Weave
Patric Bechtel [[EMAIL PROTECTED]] wrote:
> On Mon, 30 Jul 2001 17:39:57 -0400, Brian Weaver wrote:
>
> Believe me, I'm using PostgreSQL too, in a rather complex mapping in
> a even more complex project. And I had the same prob, too.
> And first, I made the same as you: I patched PostgreSQLFactory.java.
> And later, I undid my patch again as I saw that the two statements
> select * from "Blubb"
> and
> select * from Blubb
> mean two different tables:
> "Blubb" means the table Blubb (which has to be created by create
> table "Blubb").
> Blubb means blubb (which can be created by using
> create table [BLUBB|blubb|Blubb|BlUbB]...
>
> see?
>
>
>
> >Um... I found an answer that worked, but it's not your solution. I'm
> >really unsure on the double quotes being used at all. I edited the
> >class: org.exolab.castor.jdo.drivers.PostgreSQLFactory.
> >
> >Below is my cvs diff of what I did. In essence I just removed the
> >double quoting from the SQL factory for PostgreSQL and all is
> >happy. Haven't had trouble since.
> >
> >
> >Index: src/main/org/exolab/castor/jdo/drivers/PostgreSQLFactory.java
> >===================================================================
> >RCS file:
>/cvs/castor/castor/src/main/org/exolab/castor/jdo/drivers/PostgreSQLFactory.java,v
> >retrieving revision 1.9
> >diff -r1.9 PostgreSQLFactory.java
> >94c94,95
> >< int index;
> >---
> >> return name;
> >> //int index;
> >96,99c97,100
> >< index = name.indexOf( '.' );
> >< if ( index > 0 )
> >< return "\"" + name.substring( 0, index ) + "\".\"" + name.substring(
>index + 1 ) + "\"";
> >< return '"' + name + '"';
> >---
> >> //index = name.indexOf( '.' );
> >> //if ( index > 0 )
> >> //return "\"" + name.substring( 0, index ) + "\".\"" +
>name.substring( index + 1 ) + "\"";
> >> //return '"' + name + '"';
> >
> >Later
> >
> >Weave
> >
> >
> >Patric Bechtel [[EMAIL PROTECTED]] wrote:
> >> On Fri, 27 Jul 2001 14:24:11 -0400, Brian Weaver wrote:
> >>
> >> The problem is not the statement, but your tables.
> >> If you use "Foo" in a query, it will scan for a table named Foo (with
> >> capital F), without the quotes it will (only!) scan for a table named
> >> foo (with lower case f).
> >> So what you've done is, you built your table events with a column
> >> named eventid, and Castor wants it be named eventID.
> >> Two solutions: Correct the mapping (sql name="eventid") or
> >> rename the column inside PostgreSQL (alter table...).
> >>
> >> hope that helps...
> >>
> >>
> >>
> >> >Hi,
> >> >
> >> >I've been playing with Castor for the past few days, looking
> >> >through the code when I've run into errors. I've finally
> >> >got my mapping.xml, database.xml, and java classes all "working"...
> >> >
> >> >Now when I execute an OQL statement it returns the following
> >> >error:
> >> >
> >> >org.exolab.castor.jdo.PersistenceException: Nested error: java.sql.SQLException:
>ERROR: No such attribute or
> >> function 'eventID'
> >> > while executing SELECT
> >>
>
>"events"."eventID","events"."eventUei","events"."nodeID","events"."eventTime","events"."eventHost","events"."ipAd
> >>
>
>dr","events"."eventDpName","events"."eventSnmpHost","events"."serviceID","events"."eventSnmp","events"."eventParm
> >>
>
>s","events"."eventCreateTime","events"."eventDescr","events"."eventLoggroup","events"."eventLogmsg","events"."eve
> >>
>
>ntSeverity","events"."eventPathOutage","events"."eventCorrelation","events"."eventSuppressedCount","events"."even
> >>
>
>tOperInstruct","events"."eventAutoAction","events"."eventOperAction","events"."eventOperActionMenuText","events".
> >>
>
>"eventNotification","events"."eventTticket","events"."eventTticketState","events"."eventForward","events"."eventM
> >>
>ouseOverText","events"."eventLog","events"."eventDisplay","events"."eventAckUser","events"."eventAckTime"
> FROM
> >> "events"
> >> >java.sql.SQLException: ERROR: No such attribute or function 'eventID'
> >> >
> >> > at org.postgresql.Connection.ExecSQL(Connection.java:533)
> >> > at org.postgresql.jdbc2.Statement.execute(Statement.java:294)
> >> > at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:59)
> >> > at
>org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:108)
> >> > at org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.execute(SQLEngine.java:1576)
> >> > at
>org.exolab.castor.persist.TransactionContext.query(TransactionContext.java:616)
> >> > at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:457)
> >> > at org.exolab.castor.jdo.engine.OQLQueryImpl.execute(OQLQueryImpl.java:404)
> >> > at org.opennms.netmgt.db.Test.run(Test.java:73)
> >> > at org.opennms.netmgt.db.Test.main(Test.java:33)
> >> >
> >> >I took the 'SELECT ... FROM "events"' and feed that into
> >> >pgsql. It didn't like it, but if I stripped out the double
> >> >quotes from the entire statement it worked fine...
> >> >
> >> >How do I disable the quoting around each element in castor. I'm working
> >> >with the latest CVS tree.
> >> >
> >> >Weave
> >> >
> >> >-----------------------------------------------------------
> >> >If you wish to unsubscribe from this mailing, send mail to
> >> >[EMAIL PROTECTED] with a subject of:
> >> > unsubscribe castor-dev
> >> >
> >> >
> >>
> >>
> >> sincerely,
> >>
> >> Patric Bechtel
> >> IPCON Informationssysteme
> >>
> >> PGP Public Key Fingerprint: 5579 8D11 C4A4 DD84 1CC0 D2D1 112F A924
> >>
> >> -----------------------------------------------------------
> >> If you wish to unsubscribe from this mailing, send mail to
> >> [EMAIL PROTECTED] with a subject of:
> >> unsubscribe castor-dev
> >
> >-----------------------------------------------------------
> >If you wish to unsubscribe from this mailing, send mail to
> >[EMAIL PROTECTED] with a subject of:
> > unsubscribe castor-dev
> >
> >
>
>
> sincerely,
>
> Patric Bechtel
> IPCON Informationssysteme
>
> PGP Public Key Fingerprint: 5579 8D11 C4A4 DD84 1CC0 D2D1 112F A924
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
