SourceForge.net Logo
Main Overview Wiki Issues Forum Build Fisheye

Welcome, Guest
Guest Settings
Help

Compass Support Forums » Compass » Compass Users

Thread: Lot of document and Mysql

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


Permlink Replies: 8 - Pages: 1 - Last Post: Dec 3, 2011 4:40 AM Last Post By: longchamp
HurtMarley

Posts: 1
Registered: 4/23/07
Lot of document and Mysql
Posted: Apr 23, 2007 6:12 AM
 
  Click to reply to this thread Reply
Hello,
I had developed a software using lucene, but recently I had to store the indexes in a database (MySQL), so I tried Compass.
But I have a recurrent error when I try to add a lot of new entry in the index. I think this error append because MySQL haven't free port.
Is it possible to add several documents in an index with only one connection to the database?

Excuse my English.

try
{
DataSource source = new MonDataScource();
JdbcDirectory jdbcDir = new JdbcDirectory(source, new MySQLInnoDBDialect(), "TABLEINDEX");
IndexWriter jdbcWriter = new IndexWriter(jdbcDir, new FrenchAnalyzer());
while (true)
{
//vect = list of document
if (vect.size() != 0)
{
File file = ((Job) vect.get(0)).getUrl();
jdbcWriter.addDocument(FileDocument.Document(file));
//suppression de l'id traité
vect.remove(0);
}
else
{
//attente si la liste est vide
synchronized (vect)
{
logger.debug("Indexation thread wait");
try
{
vect.wait();
}
catch (Exception e)
{
System.err.println("sync error");
}
}
}
}
}
catch (Exception e)
{
System.err.println("Indexation thread stoped");
e.printStackTrace();
}
//si le thread shutdown
finally
{
logger.fatal("Indexation thread stoped");
}
}

--------------error message -------------------------------
Indexation thread stoped

org.apache.lucene.store.jdbc.JdbcStoreException: Failed to open jdbc connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: connect

STACKTRACE:

java.net.SocketException: java.net.BindException: Address already in use: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.infotel.arcsys.MonDataScource.getConnection(MonDataScource.java:30)
at org.apache.lucene.store.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:44)
at org.apache.lucene.store.jdbc.support.JdbcTemplate.executeSelect(JdbcTemplate.java:100)
at org.apache.lucene.store.jdbc.handler.AbstractFileEntryHandler.fileExists(AbstractFileEntryHandler.java:59)
at org.apache.lucene.store.jdbc.JdbcDirectory.fileExists(JdbcDirectory.java:322)
at org.apache.lucene.index.IndexFileDeleter.deleteFile(IndexFileDeleter.java:226)
at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:1612)
at org.apache.lucene.index.IndexWriter.optimize(IndexWriter.java:900)
at org.apache.lucene.index.IndexWriter.addIndexes(IndexWriter.java:1065)
at com.infotel.arcsys.CreateIndexThread.run(CreateIndexThread.java:106)
at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: connect

STACKTRACE:

java.net.SocketException: java.net.BindException: Address already in use: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.infotel.arcsys.MonDataScource.getConnection(MonDataScource.java:30)
at org.apache.lucene.store.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:44)
at org.apache.lucene.store.jdbc.support.JdbcTemplate.executeSelect(JdbcTemplate.java:100)
at org.apache.lucene.store.jdbc.handler.AbstractFileEntryHandler.fileExists(AbstractFileEntryHandler.java:59)
at org.apache.lucene.store.jdbc.JdbcDirectory.fileExists(JdbcDirectory.java:322)
at org.apache.lucene.index.IndexFileDeleter.deleteFile(IndexFileDeleter.java:226)
at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:1612)
at org.apache.lucene.index.IndexWriter.optimize(IndexWriter.java:900)
at org.apache.lucene.index.IndexWriter.addIndexes(IndexWriter.java:1065)
at com.infotel.arcsys.CreateIndexThread.run(CreateIndexThread.java:106)
at java.lang.Thread.run(Thread.java:534)

** END NESTED EXCEPTION **

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.infotel.arcsys.MonDataScource.getConnection(MonDataScource.java:30)
at org.apache.lucene.store.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:44)
at org.apache.lucene.store.jdbc.support.JdbcTemplate.executeSelect(JdbcTemplate.java:100)
at org.apache.lucene.store.jdbc.handler.AbstractFileEntryHandler.fileExists(AbstractFileEntryHandler.java:59)
at org.apache.lucene.store.jdbc.JdbcDirectory.fileExists(JdbcDirectory.java:322)
at org.apache.lucene.index.IndexFileDeleter.deleteFile(IndexFileDeleter.java:226)
at org.apache.lucene.index.IndexWriter.mergeSegments(IndexWriter.java:1612)
at org.apache.lucene.index.IndexWriter.optimize(IndexWriter.java:900)
at org.apache.lucene.index.IndexWriter.addIndexes(IndexWriter.java:1065)
at com.infotel.arcsys.CreateIndexThread.run(CreateIndexThread.java:106)
at java.lang.Thread.run(Thread.java:534)

asd

Posts: 70
Registered: 10/12/11
Re: Lot of document and Mysql
Posted: Oct 12, 2011 10:21 PM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
on friends dvd a snow-covered ghost whisperer dvd high gilmore girls dvd ground gossip girl dvd for grey's anatomy dvd demonstration golden girls dvd rather hex dvd strong hogan's heroes dvd to watch. house md dvd Surprisingly, little house on the prairie dvd Kurosawas lie to me dvd characteristics the l word dvd as a lost dvd manager mash dvd organise monk dvd not blaze ncis dvd through one tree hill dvd in this seinfeld dvd video, sopranos dvd which star trek dvd seems spooks dvd to scrubs dvd require sex and the city dvd the six feet under dvd passion south park dvd and supernatural dvd dedication stargate atlantis dvd to the http://boxsetszone.com task that were clear-cut in the preceding film. Often advised as Kurosawas weakest video, Sanshiro Sugata: Part 2 is an pointless sequel that has little warrant out-of-doors of its chronicled anxiety as a part of propaganda.
pylxwzhj

Posts: 719
Registered: 10/15/11
Re: Lot of document and Mysql
Posted: Nov 9, 2011 3:06 AM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
Despite the anger

Coach Outlet

at Washington, voters

Chanel Bags

did not appear to be in a throw-the-bums-out frame

Coach Outlet

of mind at the city and state levels.

Coach Outlet

In Philadelphia, Mayor Michael Nutter,

Coach Outlet

a Democrat, won re-election, as did Mayor Greg Ballard,

LV Outlet

a Republican, in Indianapolis

Louis Vuitton

and Mayor Stephanie Rawlings-Blake,

Coach Outlet

a Democrat, in Baltimore. In Phoenix,

Chanel Handbags

Greg Stanton, a Democrat, was

Coach Factory Store

the winner while in San Francisco, Edwin M. Lee, the interim mayor,
lvzeng

Posts: 268
Registered: 11/13/11
louis vuitton
Posted: Nov 13, 2011 8:09 PM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
Owning

louis vuitton bags

of their own has been the dreams of many fad-seeking people for a quite long time.
You need not worry about the quality of the

coach outlet store online

for sale now. The Coach brand is famous for the perfect products.
I am so confused that I don,t even know where to buy the

louis vuitton

Handbags. Because I can prefer to chose the fashionable design, favorable price, top service .

coach outlet store online

with fashion style and top quality succeed. In any occasions they are very suitable and appropriate for its precise and rich design.
They're not chosen, so one of these ideal for you.For more flexibleness a lot more like these, there are lots of discount 'shoulder' variations outlet

louis vuitton bags

.

hermes birkin

is an Austrian success story par excellence. At the end of the 19th century Daniel Swarovski founded a company with the aim to cut crystals automatically.

coach outlet store

vision system is a visual enjoy, is a visual art. The particular design has been integrated function and the element of elegancy, then show you an exquisite and excellent product.
jenny

Posts: 271
Registered: 11/13/11
coach outlet store online
Posted: Nov 13, 2011 8:15 PM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
The

coach factory outlet

has been in business for many years. You can log in to find more information about its products and services.
At

louis vuitton sale

,you will find Louis Vuitton Vernis Wallet uses Vernis leather lining instead of classic Monogram canvas, meanwhile creates another classic style with fashion.
Here's your new way to look sophisticated styles. Carry the hot

coach outlet store online

of this summer and be the true trendsetter!
Several days ago, I chose one style of

hermes scarf

from the Swarovski Outlets, which has won good reputation from many customers.
It is a symbol regarding position not to mention nature, Here I would like to launch a excellent bags pertaining to business men, which may be

louis vuitton online

Cupertino M56398.
Almost everyone has identified effectively about this, below, among the best to make sure you will get much more information about

coach outlet

.
coach8outlet

Posts: 282
Registered: 11/13/11
Re: Lot of document and Mysql
Posted: Nov 14, 2011 1:52 AM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply

louis vuitton handbags

enjoy high reputation all over the world. They are designed for hand, elbow and shoulder carry thanks to comfortable flat leather handles.
If you have been to the mall lately and browsed

coach outlet

you may find that a high price tag goes along with just about everything in the mall.
This client-oriented and faith-rooted store aims at providing the best LV goods and services, such as top-class

louis vuitton uk

and free shipping.
Turn your attention to such discount coach sneakers for women from Coach Outlet Store online, you will find something unique and special of such authentic coach for sale at coach factory outlet store online.

louis vuitton outlet

online just like a person who want to show himself in front of other people, because he is confident enough, he can attain the respect of other people.
Bezel-set

hermes birkin bag

are showcased in all their brilliance in the chic and timeless design of this tennis bracelet. Rhodium-plated metal bracelet with foldover clasp.
The

coach outlet store online

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.
tonnyben

Posts: 270
Registered: 11/14/11
Re: Spring inheritance, lazy-init with Compass namespace?
Posted: Nov 14, 2011 2:42 AM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply

coach factory outlet online

featured with stylish leather bags and signature materials, and carry this bag, it can designate people seem to be captivatingly feminine and good-looking. Why not to buy one when it is at an affordable price?
The products that

louis vuitton outlet

is countless, such as: purses, bags, handbags, shoes, belt. Even the same kind of product includes the products for women, the products for men, for summer-day use, for winter-day use.So, it is probably far beyond your imagination.
As a perfect combination of classic and modern fashion,

coach outlet online

can show the customers'unique personality.

hermes birkin

is your premier online shop for a wide range of quality Swarovski Crystal products such as Swarovski Crystals earring, Jewelry, Bracelet etc.
You could find them in desirable quality and price. If you don't mind high class louis vuitton replica bags, have a good time at

louis vuitton outlet online

.

coach purses

tend to be among finest style strikes associated with these days! They're the standing image that many ladies possess, or even, intend on obtaining.
pylxwzhj

Posts: 719
Registered: 10/15/11
Re: Lot of document and Mysql
Posted: Nov 26, 2011 3:53 AM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
The generals, meanwhile,

Coach Outlet

issued an unusual apology for the

Chanel Handbags

deaths of at least 38 people

Coach Outlet

during the week of unrest

Chanel Bags

and the injuries of more than 2,000.

Coach Factory Outlet

But even as they hailed the dead

Coach Outlet Online

as “martyrs,” the generals also appeared

Coach Outlet

to justify killing them as criminals

Coach Outlet

who had attacked the Interior Ministry.

Coach Outlet Online

And they denied — despite the statements

Louis Vuitton Bags

of many witnesses, doctors and

Coach Factory Outlet

even the health ministry — that security

Louis Vuitton Bags

forces had fired live ammunition or birdshot in

Coach Outlet

their clashes with protesters, further inflaming anger.
longchamp

Posts: 272
Registered: 12/1/11
Re: Lot of document and Mysql
Posted: Dec 3, 2011 4:40 AM   in response to: HurtMarley in response to: HurtMarley
 
  Click to reply to this thread Reply
longchamp, il se révèle être and also vital de l'histoire des graphic designers français de cuir, bagages et maroquinerie Longchamp strain devenir l'un des meilleurs quartiers de la marque, et devenir united nations symbole de la haute société. Aujourd'hui, la marque your not seulement la perception limitée de Longchamp et de vendre des reports sac longchamp durante cuir haut de gamme et des bagages, mais à s'impliquer dans la style, accessoires, chaussures, sacs, bijoux, montres, des médias, du vin et d'autres régions du géant des indicateurs de tendance.www.sacslongchamp-france.org
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