Réf. : Re: Réf. : Re: PSML data.

[Pa...@unilog.fr]

I've modified jdbcX/AbstractJdbcXConnection.java where X is equal from 1 
to 3, to match the Web page modifications.

I've also modified core/QueryExecutor.java to filter objectdata ! It's 
perhaps not the best way but It's worked for me.

        /*
         * Send a query to the backend.
         */
        private void sendQueryV2() throws SQLException
        {
                for ( int i = 0; i < m_binds.length ; i++ )
                {
                        if ( m_binds[i] == null )
                                throw new 
PSQLException("postgresql.prep.param", new Integer(i + 1));
                }
                try
                {
                        pgStream.SendChar('Q');
                        for (int i = 0 ; i < m_binds.length ; ++i)
                        {
                             // BEGIN PAT : Filter 'objectdata' to remove 
it from query !
                            if ((m_sqlFrags[i].toString()).compareTo(", 
objectdata = ") == 0) {
                                m_binds[i] = new String("''");
                            }
                            // END PAT
 pgStream.Send(connection.getEncoding().encode(m_sqlFrags[i]));
 pgStream.Send(connection.getEncoding().encode(m_binds[i].toString()));
                        }

 
pgStream.Send(connection.getEncoding().encode(m_sqlFrags[m_binds.length]));
                        pgStream.SendChar(0);
                        pgStream.flush();

                }
                catch (IOException e)
                {
                        throw new PSQLException("postgresql.con.ioerror", 
e);
                }
        }

Hope this help.

Pat.

P.S. : I have Postgres7.2.1 and a JDBC driver for Postgres 7.2.x / Java 2.





Nikolaos Athanasis <at...@ics.forth.gr>
25/11/2003 19:05
Veuillez répondre à "Jetspeed Developers List"

 
        Pour :  Patrick.Meyer@unilog.fr
        cc :    Jetspeed Developers List <je...@jakarta.apache.org>
        Objet : Re: Réf. : Re: PSML data.


I have already tried this. I downloaded the source code of postgres,
installed it, but the Field.java file has other commands as these in the
patch. Thus, i cannot do anything about it...
Do i miss anything?


Nik..


On Tue, 25 Nov 2003 Patrick.Meyer@unilog.fr wrote:

> Hi,
>
> You need to modify the jdbc driver to avoid using the oid. See
> http://www.ingrid.org/jajakarta/turbine/en/turbine/torque/postgres-howto.html
> for more details.
> I can send you the driver if you want.
>
> I recommand you using an LDAP directory like OpenLDAP to store the users
> informations and PSML. You don't need then to use a specific driver.
>
> Best regards,
> Pat.
>
>
>
>
>
> Nikolaos Athanasis <at...@ics.forth.gr>
> 25/11/2003 17:11
> Veuillez répondre à "Jetspeed Developers List"
>
>
>         Pour :  David Sean Taylor <da...@bluesunrise.com>
>         cc :    Jetspeed Developers List 
<je...@jakarta.apache.org>
>         Objet : Re: PSML data.
>
>
> I agree with you: I first tried NOT to use Hypersonic DB with my 
jetspeed
> application. I tried to use postgres instead.
> However, it did not work. I followed the
> installation instsructions from the jetspeed site, but it seems that are
> several problems (i get a exception with something that has to do with
> timestamps, every time i try to add a new user.)
>
> I use the CVS version of (jetspeed), and the CVS of tomcat, under linux
> 7.3.
>
> If someone has come to a succesfull use of postgres with jetspeed, I
> would be very grateful to him if he could tell us how he did it.
>
> Nikos.
>
>
> On Tue, 25 Nov 2003, David Sean Taylor wrote:
>
> >
> > On Saturday, November 22, 2003, at 01:35  AM, nick the mytilian wrote:
> >
> > >
> > > Hi,
> > >
> > > I have built my own, with the source code of jetspeed. That is, from
> > > the
> > > ${JETSPEED_HOME}/built folder, i run "ant install", and jetspeed
> copied
> > > the files under $TOMCAT_HOME}/webapps/jetspeed..
> > >
> > > My problem is that every time i shut down tomcat, all users get
> > > dissapear.
> > > And i cannot understand how to solve the problem:
> > > Do i have to store the psml in the database, as it says in the
> jetspeed
> > > site? This seems not to work.
> > >
> > In any production system I strongly recommend moving the database out
> > of the webapp and not using the demo database: Hypersonic DB.
> > Your users should not disappear when you shut down Tomcat.
> > However the PSML and database will be overwritten if you redeploy your
> > webapp  using "ant deploy" or "ant install"
> > Be very careful with that
> > Try using "ant hotdeploy" to deploy incremental changes to your 
webapp.
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>
>
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org