Hi David,
it's still very weird. I wonder if there wasn't something wrongly
created in the database structure for the email queue with the older
driver. If you get a chance to compare the tables from the old and new
driver, that would be interesting. PostgreSQL drivers are designed for
backwards compatibility, so getting the latest is usually a good idea,
even when you're using an earlier database.
Glad you got it working though, I was starting to feel lost ;-)
Take care,
Geert
David HM Spector wrote:
ok. this is just black magic at work. Its some kind of brain damage on
the part of the older pgsql jdbc driver. When I wiped the DB but still
left the code to set the cc/bcc lines to empty strings I saw the same
result. When I removed those two lines, and wiped the Db again it
suddenly has no problem that the contents of the ccaddresses and
bccaddresses fields are nulls and it works fine.
Oddly, I would never have run into this except for the fact that I was
(apparently mistakenly) under the impression that you still had to keep
Postgres jdbc drivers in sync with the version of Postgres you were
using. That'll teach me to be so anal retentive. :\
David
On Jan 2, 2007, at 4:39 PM, David HM Spector wrote:
nope. same result. I'm going to wipe the DB and have the app rebuild
itself, perhaps there's something odd the older JBDC driver did that's
breaking things. If that fails, I'll try a newer version of postgres
on a different machine.
_DHMS
Jan 2, 2007 4:33:00 PM
com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor$SendEmails
gotBeanInstance
WARNING: Email not sent due to an error while building the message.
Email{mId=1, [EMAIL PROTECTED],
[EMAIL PROTECTED], mSubject=NELA: Please activate
your new account, mBody=Greetings from the team at Never Eat Lunch Alone!
Welcome to Never Eat Lunch Alone (NELA)!
Your account has been created, please click the below link to complete
the activation.
http://0.0.0.0:8080/activate?code=5c64f375c21c3b3457e3434482cdc21c&id=1,
mCcAddresses=, mBccAddresses=}
javax.mail.internet.AddressException: Illegal address in string ``''
at
javax.mail.internet.InternetAddress.<init>(InternetAddress.java:94)
at
javax.mail.internet.InternetAddress.<init>(InternetAddress.java:119)
at
com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor$SendEmails.gotBeanInstance(DatabaseMailQueueExecutor.java:333)
at
com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor$SendEmails.gotBeanInstance(DatabaseMailQueueExecutor.java:257)
at
com.uwyn.rife.database.DbBeanFetcher.processRow(DbBeanFetcher.java:272)
at
com.uwyn.rife.database.DbRowProcessor.processRowWrapper(DbRowProcessor.java:118)
at
com.uwyn.rife.database.DbQueryManager.fetch(DbQueryManager.java:2933)
at
com.uwyn.rife.database.DbQueryManager.fetchAll(DbQueryManager.java:2967)
at
com.uwyn.rife.database.DbQueryManager.executeFetchAll(DbQueryManager.java:2397)
at
com.uwyn.rife.database.DbQueryManager.executeFetchAll(DbQueryManager.java:2345)
at
com.uwyn.rife.database.querymanagers.generic.AbstractGenericQueryManager._restore(AbstractGenericQueryManager.java:708)
at
com.uwyn.rife.database.querymanagers.generic.databasedrivers.generic.restore(generic.java:183)
at
com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor.executeTask(DatabaseMailQueueExecutor.java:232)
at com.uwyn.rife.scheduler.ExecutorThread.run(ExecutorThread.java:33)
at java.lang.Thread.run(Thread.java:613)
Jan 2, 2007 4:33:00 PM
com.uwyn.rife.mail.executors.DatabaseMailQueueExecutor executeTask
INFO: 0 mails were sent
On Jan 2, 2007, at 3:58 PM, Geert Bevin wrote:
https://svn.rifers.org/rife/trunk/lib/postgresql-8.1-407.jdbc3.jar
-------------------------------------------------------------------------------------------
David HM Spector
spector (at) zeitgeist.com
http://www.zeitgeist.com/
voice: +1 631.261.5013 fax:
+1 212.656.1443
~ ~ ~
"New and stirring things are belittled because if they are not
belittled, the
humiliating question arises, 'Why then are you not taking part in them?'"
--H. G. Wells
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
-------------------------------------------------------------------------------------------
David HM Spector
spector (at) zeitgeist.com
http://www.zeitgeist.com/
voice: +1 631.261.5013 fax: +1
212.656.1443
~ ~ ~
"New and stirring things are belittled because if they are not
belittled, the
humiliating question arises, 'Why then are you not taking part in them?'"
--H. G. Wells
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users
