Hmmmm,
Looks like id_table is something from HSQL. I
updated both my project.properties and
torque.properties to point to mysql. I can see from
the new entries in turbine_user that I am indeed
pointed to mysql. Seems like the email portlet
thinks I am pointed to HSQL (somehow) and thus is
looking for a id_table table. I don't see anything in
email.xreg or in the code I looked at that seems to
affect this. Any hints would be great.
Thanks...
--- Mark Divitt <[EMAIL PROTECTED]> wrote:
>
> Hi Folks,
> Any clue why the email portlet is looking
> for
> 'jetspeed15.id_table' (see below) when inside
> org.apache.jetspeed.om.apps.email.BaseEmailInboxPeer
> is the following snipnet
>
> public static final String TABLE_NAME =
> "EMAIL_INBOX";
>
>
> I have done a full maven clean then maven war, no
> help. Something is not getting mapped right I
> believe.
> This must be some sort of Torque issue. Is id_table
> some sort of Torque default?
>
> I am using POP3.
>
> On a side note, the email portlet seems to have
> problems cleaning up after itself and thus getting
> the
> "POP3 mailbox locked by another user" messages. This
> is caused by the portlet reopened the mailbox
> without
> closing cleanly...
>
>
>
> 2004-05-15 18:56:24,984 [Thread-9] INFO
> EmailPortlet
> - BuildNormalContext in EmailPortlet
> 2004-05-15 18:56:26,146 [Thread-9] INFO Email -
> empty
> date!!!!!!!
> 2004-05-15 18:56:26,146 [Thread-9] INFO Email - ###
> check new message in Email
> 2004-05-15 18:56:26,146 [Thread-9] INFO Email -
> status 1
> 2004-05-15 18:56:26,146 [Thread-9] INFO
> EmailPortlet
> - [RJPY] Trying to write into DB...
> 2004-05-15 18:56:26,146 [Thread-9] INFO
> EmailPortlet
> - [RJPY] This email is not yet in the DB...
> 2004-05-15 18:56:26,156 [Thread-9] ERROR
> EmailPortlet
> - Error in DBInsert()
> java.sql.SQLException: General error: Table
> 'jetspeed15.id_table' doesn't exist
> at com.mysql.jdbc.MysqlIO.sendCommand(Unknown
> Source)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown
> Source)
> at com.mysql.jdbc.MysqlIO.sqlQuery(Unknown Source)
> at com.mysql.jdbc.Connection.execSQL(Unknown
> Source)
> at com.mysql.jdbc.Connection.execSQL(Unknown
> Source)
> at com.mysql.jdbc.Statement.executeUpdate(Unknown
> Source)
> at
> com.mysql.jdbc.jdbc2.Statement.executeUpdate(Unknown
> Source)
> at
>
org.apache.torque.oid.IDBroker.updateQuantity(IDBroker.java:916)
> at
>
org.apache.torque.oid.IDBroker.storeIDs(IDBroker.java:678)
> at
>
org.apache.torque.oid.IDBroker.getNextIds(IDBroker.java:448)
> at
>
org.apache.torque.oid.IDBroker.getIdAsBigDecimal(IDBroker.java:336)
> at
>
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:720)
> at
>
org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639)
> at
>
org.apache.jetspeed.om.apps.email.BaseEmailInboxPeer.doInsert(BaseEmailInboxPeer.java:217)
> at
>
org.apache.jetspeed.om.apps.email.BaseEmailInboxPeer.doInsert(BaseEmailInboxPeer.java:190)
>
>
>
>
> --- Jonathan Hawkins
> <[EMAIL PROTECTED]> wrote:
> > That did the trick, shame that exception lead me
> to
> > believe that there
> > was a problem in the EmailPortlet !!
> >
> > Thanks for your assistance
> >
> > Jon
> >
> > -----Original Message-----
> > From: Jonas Lim [mailto:[EMAIL PROTECTED]
> > Sent: 05 May 2004 07:52
> > To: Jetspeed Users List
> > Subject: Re: Email Portlet
> >
> > Can you check if you have mail.jar on your
> > web-inf\lib. I'm not sure if
> > it
> > is included in the jetspeed distribution.
> >
> > Regards,
> > Jonas
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Jonathan Hawkins"
> > <[EMAIL PROTECTED]>
> > To: "'Jetspeed Users List'"
> > <[EMAIL PROTECTED]>
> > Sent: Wednesday, May 05, 2004 2:20 PM
> > Subject: RE: Email Portlet
> >
> >
> > > I am using the binary distribution. Email.class
> > and EmailPortlet.class
> > > both exist within the jetspeed-1.5.jar. I have
> > also tried adding my
> > own
> > > debug statements and manually including the
> > classes under
> > > WEB-INF\classes etc.
> > >
> > > I have tried using Exchange Server and Sendmail
> > IMAP server,but as the
> > > class does not get loaded that won't make any
> > difference.
> > >
> > > Again, any assistance very much appreciated.
> > >
> > > -----Original Message-----
> > > From: Jonas Lim [mailto:[EMAIL PROTECTED]
> > > Sent: 05 May 2004 03:10
> > > To: Jetspeed Users List
> > > Subject: Re: Email Portlet
> > >
> > > Hi John,
> > >
> > > Did you check if the EmailPortlet.class was
> > created? Also, did the
> > > error
> > > appear when you added the portlet or when you
> > click some actions in
> > the
> > > email portlet? Btw, what mail server are you
> > using?
> > >
> > > Regards,
> > > Jonas
> > >
> > > ----- Original Message -----
> > > From: "Jonathan Hawkins"
> > <[EMAIL PROTECTED]>
> > > To: "'Jetspeed Users List'"
> > <[EMAIL PROTECTED]>
> > > Sent: Wednesday, May 05, 2004 3:22 AM
> > > Subject: Email Portlet
> > >
> > >
> > > > Trying to use the email portlet that ships
> with
> > 1.5
> > > >
> > > > Keep getting the following exception
> > > >
> > > > [04 May 2004 20:19:38 DEBUG] -
> > GenericMVCPortlet: Executing action
> > > > [portlets.ema
> > > > il.EmailPortlet] for portlet [Email]
> > > > [04 May 2004 20:19:38 ERROR] -
> GenericMVCPortlet
> > - error executing
> > > > action
> > > > java.lang.ClassNotFoundException:
> > > >
> > > > Requested Action not found:
> > portlets.email.EmailPortlet
> > > > Turbine looked in the following
> > modules.packages path:
> > > > [org.apache.jetspeed.modules,
> > org.apache.turbine.modules]
> > > >
> > > > at
> > > >
> >
>
org.apache.turbine.modules.ActionLoader.getInstance(ActionLoader.java
> > > > :174)
> > > >
> > > > Any assistance greatly appreciated
> > > >
> > > > Jon Hawkins
> > > >
>
=== message truncated ===
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
