SourceForge.net Logo
Main Overview Wiki Issues Forum Build Fisheye

Welcome, Guest
Guest Settings
Help

Compass Support Forums » Compass » Compass Users

Thread: Compass 1.2.2 / Oracle 10g: Index empty, although being written to

This question is answered. Helpful answers available: 1. Correct answers available: 1.


Permlink Replies: 13 - Pages: 1 - Last Post: Jan 3, 2012 8:57 PM Last Post By: good
Christian Aust

Posts: 19
Registered: 4/21/08
Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Apr 25, 2008 3:43 AM
 
  Click to reply to this thread Reply
Attachment compass.cfg.xml (966 bytes)
Hi,

I'm using Compass and Oracle in an EJB scenario (no spring), getting my datasource from the application server's JNDI registry. Compass is configured using an XML file, mapping objects to the index. During startup, there's nothing wrong showing up in the logs.

My application gathers data from an ERP server which takes some time, so I "batch-update" the index: Objects to be added/deleted to/from the index are cached in a buffer and every 100 objects that buffer is cleared: I create a transaction from the compass session, execute a number of save/delete operations and commit that transaction. Any exceptions would show up in the logs.

Unfortunately, the changes are not written to the database. During startup, a table is created, but it stays empty most of the time, even if I add some thousands of entries. Both index manager and optimizer threads are running, I've left them with their default configurations. After some 8-10 thousand operations, the index thread stalls and doesn't seem to do anything: Nothing in the logs, no CPU activity, not network activity.

This happens both with my local Geronimo server as well as the central SAP Netweaver server.

Can anybody point me in the right direction? Am I missing anything? I post my configuration of compass, although -from the docs- there's nothing too exciting in it. Any help is appreciated. Kind regards,

Christian

Edited by: Christian Aust on Apr 25, 2008 4:48 AM

The transaction that session.beginTransaction() returns is always a LocalTransaction, although I'm within a managed environment. There's a JNDI key java:comp/UserTransaction available, but I didn't yet succeed in getting compass to work with it.

Could it be that all changes just end up waiting in that un-commited managed transaction, while (from a local perspective) the changes are already commited? Effectively never reaching the DB?

Edited by: Christian Aust on Apr 25, 2008 6:30 AM

Using the TransactionManagerLookup for Geronimo 1.1 found on the Hibernate mailing list, Compass starts up. However, now I get this message every few seconds after startup, and haven't even saved anything into the index...

13:32:13,547 WARN LuceneSearchEngine Transaction not committed/rolled backed, rolling back

http://www.mail-archive.com/user@geronimo.apache.org/msg05048.html

Setting jta.cacheUserTransaction to false in the configuration XML gives me loads of this message:

14:13:40,749 INFO JTASyncTransactionFactory Failed to locate a UserTransaction under java:comp/UserTransaction, creating UserTransactionAdapter in its place

Stunning: I can positively say that there's a UserTransaction instance under that key: Directly looking it up for test purposes gives me:

org.apache.geronimo.transaction.context.OnlineUserTransaction@1bd8575
Shay Banon

Posts: 4,028
Registered: 9/6/05
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Apr 26, 2008 6:10 AM   in response to: Christian Aust in response to: Christian Aust
Helpful
  Click to reply to this thread Reply
I would suggest the following:

1. Don't inject the datasource from Jndi, configure Compass to work in a managed=false mode, and have Compass create the connection to the database. Just check if this works.

2. You will need to configure Compass with JTA when working with Jndi database (preferable) with managed=true. Now, the question is how you are going to get it in Geronimo environment, which I have not tried. It works in a very similar manner to Hibernate, but I can't help much more than that.
Christian Aust

Posts: 19
Registered: 4/21/08
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Apr 26, 2008 8:53 AM   in response to: Shay Banon in response to: Shay Banon
 
  Click to reply to this thread Reply
Hi Shay,

thanks for your input, I'll try to see if it works if I let Compass do the database pooling. Next thing monday morning. :-)

During my further research Friday, I found out that I was able to use JTA exactly in the same way like it works for hibernate, so I wrote a JTA lookup manager for Geronimo 1.1 that actually works. However, as soon as the scheduled index optimizer kicks in (every 10 seconds), I get a warning about a transaction not being commited or rolled back. I dont remember the actual wording but it's somewhat related to a transaction being in state STARTED when it isn't expected to be.

Debugging through the code showed that the LuceneIndexEngine eventually called commit() but still that warning appeared. Any idea?

Oh, BTW: The issue about UserTransaction not being available was a bummer: UserTransaction is available in JNDI only if the bean manages the transactions, not the container. Stupid me... took me a day to find out, almost.

Regards,

Christian
Shay Banon

Posts: 4,028
Registered: 9/6/05
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Apr 26, 2008 10:47 AM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
JNDI is a pain..., I know. Tell me how it goes on Monday.
Christian Aust

Posts: 19
Registered: 4/21/08
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Apr 29, 2008 9:19 AM   in response to: Shay Banon in response to: Shay Banon
 
  Click to reply to this thread Reply
Switching to plain JDBC instead of JTA immediately cures my pain. I'll stick with that for the time being, looking into container-managed transactions later. Maybe.

Thanks!
Mcdermott

Posts: 3
Registered: 10/7/09
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Oct 7, 2009 7:08 AM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
The post is really a very informative one. But in my opinion the best way to gain basic knowledge is a book. I’m having a book on OLAP which contains great tips for beginner as well as advanced users. The book is available on Amazon & you can buy an e-book directly from the publisher by writing OLAPWorldPress@gmail.com.
louisvuittonbox

Posts: 411
Registered: 8/23/11
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Aug 23, 2011 9:32 PM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
Welcome to louis vuitton online! Here at our online shop, we enable you to select as many styles louis vuitton bags as you can at greatly discounted prices. Established in 2006, We have already landed so many returning customers from louis vuitton outlet. We have been known for the authentic quality of our items,such as louis vuitton belts and louis vuitton purses unsurpassed customer service, rapid delivery, unique prices and so on and so forth. What we did, are doing and will do is only to make our esteemed customers consume those world-renowned luxury designer merchandise with peace of mind. So we sincerely hope that you could be our next returning customer. We are confident that you will be quite satisfied with everything we offer here. Wish you a very good shopping louis vuitton store!
factoryoutlet

Posts: 523
Registered: 10/5/11
coach factory outlet
Posted: Oct 5, 2011 9:51 PM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply

coach factory outlet offer excellent, elegant coach products in order to generate room for your new collections.They're purchased more quickly that you may at any time imagine.coach factory store is the greatest destination to buy what type of bags you like. If you need to manage a new Coach carrier and most preferable strategy is to the coach regarding coupon codes.Here's your new way to look sophisticated styles. Carry the hot coach factory outlet store of this summer and be the true trendsetter!in the market you definitely can find various colorways that are designed in as well as the high quality that applied in. For most of you would like to come. So just come to our coach factory outlet online store to choose one.

coach factory outlet is really sizzling kinds of shopping way for you. With the usage of the replica designer coach bags, you can surely be able to change your individual looks in a stunning manner.You know, Coach items are so perfect and fascinating. Now I grow up, and find coach outlet on the Internet offering affordable products with reliable quality.Many fashionable women match with practical Coach Purses which will make the street shopping become relaxed,and make every person can enjoy more diversiform combination in coach factory outlet online.The coach factory outlet store are utilized for formal event in company area that will display your excellent taste.Not only does a briefcase make is easier to carry things.

Almost everyone has identified effectively about this, below, among the best to make sure you will get much more information about coach outlet.In the coach outlet online shop, a collection of high quality and hottest Coach Shoulder Bags is offered to you. They are all at the best prices you will ever find.

You know, Coach items are so perfect and fascinating. Now I grow up, and find coach outlet on the Internet offering affordable products with reliable quality.Once visit, you will be unable to restrain loving it. Warmly welcome all of you to the Summer Sales Promotion on coach factory outlet.coach factory outlet has new coach laptop bags in listing. No matter which style do you want, we can provide it for you.Coach bags enjoy high popularity throughout the world. I would like to share the coach factory outlet online with you. What are you waiting for? Just come to visit.

coach factory outlet supplies the newest and most fashionable brand Coach on sale.The more Coach shoulder bags you order, the more discount you will get.It's wonderful to find out it does not slip in your signature at the bottom of the case and the appearance of brass accents from coach outlet online, Because women who can look stylish this summer.coach outlet has a zippered closure and buckles for extra security. Shiny brass hardware, rounded leather handle, and an interior pocket. It also includes a limited edition Hawaii luggage tag and lock.You can find all kinds of coach bags whatever you chose which one in coach factory outlet online will never be out of fashion. Not only they have many nice and design styles, but also made from the finest leather and fabric.

With the great diversity of styles, patterns and sizes available nowadays, finding the right pieces to highlight your personality is quite important. coach outlet offers exactly what you want.coach factory outlet supplies the newest and most fashionable brand Coach on sale.The more Coach shoulder bags you order, the more discount you will get.Look at this golden Coach bag in the? coach factory outlet online.Those new bags with classic and fashionable design are more and more popular now!After graduating from university, my cousin came back to my hometown from USA last month. She told me that coach outlet store is very popular among her classmate.

coach outlet online own a couple of line, color, or the selected theme, it should be a good choice. It may be the place where offer the bag ladies handbag, you will be able to follow a course of education or training receives for the slim project chest strap wallet.coach outlet will send you a coupon in the post to use in their upon only after you type a achieve. The Coach bags are customarily somewhat many than the ones in the stores.In particular, products from coach factory outlet with leather design are fashionable, handmade,leading the wave of American pop.It with simple,durable and unique style to win consumers.coach factory not only supply with the highest quality crystal at reasonable price but also provide good after-sales service. Companies operating purposes: science and technology in order to survive, credibility and development, strict quality control.

coach outlet handbags's special design and fashion is certainly and so eye-catching, I hope you are able to get much more attention towards the Cheap Coach Crossbody.As long as you open our coach factory outlet webpage, you will view various Coach New Arrivals which are the most popular also the most fashionable in this year.Are you anxious to choose some of the brand bags? Are you searching for reliable sellers? When you come to the coach factory outlet online, these are not problems.

At the coach outlet online you have the largest selection of the day. If you touch the item and like it, keep it in your possession until you make your final decision.Over the years, coach factory online has added a multitude of new handbag shapes, styles and materials to their collection. However, the highest care is taken that every Coach handbags is both aesthetically beautiful and functional.Are you searching for a cool and stylish coach bag? The coach factory outlet online Online is your first priority.

factoryoutlet

Posts: 523
Registered: 10/5/11
louis vuitton outlet
Posted: Oct 5, 2011 9:57 PM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply

louis vuitton outlet leads you to bags collection of wide, such as LV bags and LV handbag etc. They are main name in luxury and style. It is excellent quality, fine Italian technology and extraordinary beauty.LV is universally renowned as a luxury brand. louis vuitton online store offers customers the newest fashion collections which can make you different.

In the past, Louis Vuitton only emphasis on classic, but in recent year, Louis Vuitton change its strategy and style to acquire new breakthrough. Especially louis vuitton bags like Louis Vuitton Vernis Wallet.Want to become more charming and faddish? Go to visit louis vuitton outlet webpage and select the most suitable products for yourself.

Want to become more charming and faddish? Go to visit louis vuitton outlet webpage and select the most suitable products for yourself.louis vuitton outlet online may often be the consideration alternative inside of your event to get these kinds of bags.Is without a doubt louis vuitton online seriously is present? Is it possible to offer an outlet designed for Louis Vuitton merchandise speaks out?

The choices are likely to be basically countless seeing that louis vuitton outlet occurs with the help of completely new and also incredible concepts once in a while.Mainly because mentioned before, you could buy in the louis vuitton online, via the producer's the web outlet. Owning worn it in past times. They can supply a appropriate evaluate for the property's simplicity as well as client service description.louis vuitton outlet online is the method to show the confidence of our handbags. The person who show himself in front of other people is a confident one.

LV bags in the louis vuitton outlet are a feminine update on an urban classic. With plenty of room for all of your essentials this covetable carryall will take you through the weekend in style.LV is universally renowned as a luxury brand. louis vuitton online store offers customers the newest fashion collections which can make you different.

This collection focus more on color selection compared with other LV handbags. Cute and sunshine design style increases its charm. louis vuitton outlet online provides you the very famous luxury worldwide brand.We are glad you come to join in our louis vuitton outlet online store, because the winter is upcoming now, Louis Vuitton released many new handbags to feedback our customers.Just come to visit once the louis vuitton online, you will fall in love with its fancy bags, purses, sunglasses, shoes and so on.

macmakeup12

Posts: 174
Registered: 9/21/11
MAC makeup
Posted: Oct 7, 2011 4:14 AM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
http://a123456777.mylivepage.com/http://www.thoughts.com/a123456777ahttp://www.mywebprofile.com/a123456777/blog/http://a123456777.over-blog.com/http://www.darksiders.net/user/a123456777/blogshttp://www.blurty.com/users/a123456777/http://a123456777.fotopages.com/http://www.graphicdesigncommunity.com/blogs.php?action=show_member_blog&ownerID=85833http://www.equestrianblogging.com/blogs/a123456777http://a123456777.createblog.com/blog/http://a123456777.inube.com/http://wu060231.blogtrue.com/http://wu060231.blog.163.com/http://hi.baidu.com/ab123456777a/bloghttp://blog.sina.com.cn/u/2350370677http://17847589.blog.hexun.com/http://blog.sohu.com/people/!d3UwNjAyMzFAaG90bWFpbC5jb20http://www.mackeupcc.19dog.com/blog/http://a123456777.insanejournal.com/http://phlog.net/a123456777http://www.blogstoday.co.uk/bloghome.aspx?username=a123456777http://www.holatu.com/user/a123456777/blogshttp://www.blogusers.com/sme_blog.php?u=a123456777http://www.art-ba-ba.com/blog/U/default.asp?UID=54175http://www.indyarocks.com/profile/profile_main.phphttp://wu060231.eklablog.com/http://www.adultblogs.com/users/a123456777/http://shenen011.tumblr.com/http://a123456777.livejournal.com/http://wu060231.blogspot.es/admin/http://www.freedatingsiteahead.co.uk/blogs.php?action=show_member_blog&ownerID=6264
http://american-idol-stars.com/blog/a123456777http://wu060231.blogoak.com/http://a123456.bloggd.org/http://www.sanalkahve.com/user/chenxin/blogshttp://wu060231.podbean.com/http://vidi.co.il/profile_blogs/tugmcgraw/http://a123456777.nipox.com/http://yaplog.jp/wu060231/http://www.article-live.com/authors/viewaccounthttp://users.section101.com/?page=user_blog&room=a123456777http://woodstockuniverse.com/?page=user_blog&room=a123456777http://fr.weblog.26l.com/weblog.2104449.html
http://yaplog.jp/wu060231/
miyao lin

Posts: 97
Registered: 11/20/11
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Jan 3, 2012 8:07 PM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
It really a good article.cheap oakley sunglassesFake Oakley Flak JacketOakley Half X sunglassesoakley eyewearOakley Antix sunglassesoakley sunglassesFake Oakley Fuel CellOakley Holbrook sunglassesoakley sunglasses discountedOakley Batwolf sunglassesOakley Antix SunglassesFake Oakley Fuel Cell Sunglassesoakley batwolf sunglassesOakley Bottlecap sunglassesOakley Bottlecap SunglassesFake Oakley Gascan SunglassesOakley Commit SQ SunglassesOakley Commit SQ sunglassesoakley five squared sunglassesFake Oakley PolarizedOakley Half X SunglassesOakley Dispatch sunglasses outletOakley Jupiter SunglassesOakley Encounter sunglassescheap oakley minute sunglassesCheap oakleys Bottlecap SunglassesOakley Pit Boss SunglassesCheap oakleys Fives Squared Sunglassesreplica Oakley Pit Boss SunglassesOakley Enduring Pace sunglassesOakley Polarized SunglassesOakley Fives Squared sunglassesoakley crosshair sunglassesCheap oakleys Flak Jacket SunglassesOakley Dangerous SunglassesCheap oakleys Frogskins SunglassesOakley Dart SunglassesFake Oakley Flak Jacket sunglassesoakley dispatch sunglassesOakley Forsake sunglassesOakley Encounter SunglassesCheap oakleys Fuel Cell SunglassesOakley Enduring Pace SunglassesCheap oakleys Gascan SunglassesOakley Fast Jacket SunglassesOakley Frogskins sunglassesOakley Fives SunglassesFake Oakley Gascan sunglassesoakley flak jacket sunglassesFake Oakley DispatchOakley Forsake SunglassesFake Oakley Fast JacketOakley Frogskins SunglassesOakley Hijinx sunglassesoakley fuel cell sunglassesOakley M Frame sunglassesoakley gascan sunglassesFake Oakley Five SquaredOakley Half Wire SunglassesFake Oakley FrogskinsFake Oakley Half XFake Oakley Polarized sunglassesFake Oakley HijinxOakley Polarized sunglassesFake Oakley HolbrookFake Oakley Straight Jacket sunglassesFake Oakley JupiterOakley Fuel Cell sunglassesFake Oakley JuryOakley Half Jacket sunglassesFake Oakley Monster DogOakley Half Wire sunglasses
anitas

Posts: 95
Registered: 11/20/11
Re: Compass 1.2.2 / Oracle 10g: Index empty, although being written to
Posted: Jan 3, 2012 8:09 PM   in response to: Christian Aust in response to: Christian Aust
 
  Click to reply to this thread Reply
I love this article, it's very well.oakley sunglasses saleFake Oakley Flak Jacket Sunglassesreplica Oakley Polarized SunglassesOakley Batwolf sunglasses outletoakley sunglasses wholesaleReplica Oakley Flak Jacket SunglassesOakley Restless SunglassesOakley Dispatch sunglassesreplica oakley sunglassesReplica Oakley Fuel Cell Sunglassesoakley scalpel sunglassesOakley Flak Jacket sunglassesreplica Oakley Commit SQ SunglassesFake Oakley GascanOakley Split Jacket SunglassesOakley Frogskins sunglasses outletoakley fives squared sunglassesFake Oakley Polarized Sunglassesoakley straight jacket sunglassesOakley Gascan sunglassesOakley Half Jacket SunglassesReplica Oakley Polarized SunglassesOakley Ten SunglassesFake Oakley Hijinx sunglassesreplica Oakley Half Wire SunglassesFake Oakley RadarOakley Zero SunglassesOakley Jawbone sunglassesreplica Oakley Half X SunglassesReplica Oakley sunglassesOakley Juliet sunglassesOakley Hijinx SunglassesCheap oakleys Commit SQ SunglassesOakley Jupiter sunglassesOakley Holbrook SunglassesReplica Oakley Fives SquaredOakley M Frame sunglasses outletoakley jawbone sunglassesReplica Oakley Flak JacketOakley Minute sunglassesoakley juliet sunglassesReplica Oakley FrogskinsOakley Monster Dog sunglassesreplica Oakley Jupiter SunglassesReplica Oakley Fuel CellOakley Oil Rig sunglassesOakley Jury SunglassesReplica Oakley GascanOakley Pit Boss sunglassesoakley m frame sunglassesCheap oakleys Half Wire SunglassesOakley Polarized sunglasses outletoakley minute sunglassesCheap oakleys Half X SunglassesOakley Radar sunglassesreplica oakley minute sunglassesCheap oakleys Hijinx SunglassesOakley Restless sunglassesoakley monster dog sunglassesCheap oakleys Jawbone SunglassesOakley Scalpel sunglassesOakley Necessity SunglassesCheap oakleys Oil Rig SunglassesOakley Straight Jacket sunglassesoakley oil rig sunglassesCheap oakleys Pit Boss SunglassesOakley Ten sunglassesOakley Pit Bull SunglassesCheap oakleys Radar SunglassesOakley Zero sunglassesOakley Plaintiff SunglassesCheap oakleys Straight Jacket Sunglasses
Legend
Guru: 2001 + pts
Expert: 501 - 2000 pts
Super-star: 101 - 500 pts
Assistant: 51 - 100 pts
Participant: 0 - 50 pts
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums