Hi, The table already exists: > Caused by: java.sql.SQLException: There is already an object named > 'J_PM_DEFAULT_REFS' in the database.
Could you provide more details as described at http://wiki.apache.org/jackrabbit/QuestionsAndAnswers "Reporting Problems"? Regards, Thomas On Wed, Nov 18, 2009 at 2:06 AM, Phukan, Anit <[email protected]> wrote: > Did anyone get the following type of exception while trying to use > org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager with > jndi lookup for datasource. > > > javax.jcr.RepositoryException: Cannot instantiate persistence manager > org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager: Schema > generation error: Issuing statement: create table J_PM_DEFAULT_REFS (NODE_ID > binary(16) not null, REFS_DATA image not null) : Schema generation error: > Issuing statement: create table J_PM_DEFAULT_REFS (NODE_ID binary(16) not > null, REFS_DATA image not null) > at > org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1292) > at > org.apache.jackrabbit.core.RepositoryImpl.access$800(RepositoryImpl.java:109) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > Caused by: java.sql.SQLException: Schema generation error: Issuing statement: > create table J_PM_DEFAULT_REFS (NODE_ID binary(16) not null, REFS_DATA image > not null) > at > org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.checkSchema(BundleDbPersistenceManager.java:449) > at > org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.init(BundleDbPersistenceManager.java:565) > at > org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1288) > ... 46 more > Caused by: java.sql.SQLException: There is already an object named > 'J_PM_DEFAULT_REFS' in the database. > at > net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) > at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) > at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) > at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) > at > net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) > at > net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) > at > net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664) > at > net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120) > at > net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073) > at > org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249) > at > org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.checkSchema(BundleDbPersistenceManager.java:438) > > Any advice would be appreciated. > > Thanks > Anit > > -----Original Message----- > From: Phukan, Anit [mailto:[email protected]] > Sent: Tuesday, November 17, 2009 3:54 PM > To: Dave Brosius; [email protected] > Subject: RE: IndexWriter lucene exception > > Thanks Dave, > > > > I was able to move ahead after including dependency for lucene_core version > 2.4.1. > > > > Now I am getting a different JAAS related error while trying to do a simple > login to the started repository. I am just using the SimpleLoginLodule of > jackrabbit in LoginModule of security config. > > > > 15:52:14,595 INFO [RepositoryImpl] SecurityManager = class > org.apache.jackrabbit.core.security.simple.SimpleSecurityManager > > 15:52:15,017 ERROR [UsersRolesLoginModule] Failed to load > users/passwords/role files > > java.io.IOException: No properties file: users.properties or defaults: > defaultUsers.properties found > > at org.jboss.security.auth.spi.Util.loadProperties(Util.java:198) > > at > org.jboss.security.auth.spi.UsersRolesLoginModule.loadUsers(UsersRolesLoginModule.java:186) > > at > org.jboss.security.auth.spi.UsersRolesLoginModule.createUsers(UsersRolesLoginModule.java:200) > > at > org.jboss.security.auth.spi.UsersRolesLoginModule.initialize(UsersRolesLoginModule.java:127) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > > Regards > > Anit > > > > ________________________________ > > From: Dave Brosius [mailto:[email protected]] > Sent: Tuesday, November 17, 2009 3:49 PM > To: [email protected] > Cc: Phukan, Anit > Subject: RE: IndexWriter lucene exception > > > > The closest thing to that constructor in 1.4.3 is > > public IndexWriter(Directory d, Analyzer a, boolean create) > > http://svn.apache.org/viewvc/lucene/java/tags/lucene_1_4_3/src/java/org/apache/lucene/index/IndexWriter.java?revision=150679&view=markup > > looks like you need version 2.1.0 at a minimum > > http://svn.apache.org/viewvc/lucene/java/tags/lucene_2_1_0/src/java/org/apache/lucene/index/IndexWriter.java?revision=507623&view=markup > > > -----Original Message----- > From: "Phukan, Anit" <[email protected]> > Sent: Tuesday, November 17, 2009 5:54pm > To: [email protected] > Subject: IndexWriter lucene exception > > Hi, > > Did anyone encounter this type of error while starting up the repository? I > am using lucene version 1.4.3 and jackrabbit-core version 1.5.5. Could it be > because I am using out of sync jars for these two? > > > java.lang.NoSuchMethodError: > org.apache.lucene.index.IndexWriter.<init>(Lorg/apache/lucene/store/Directory;Lorg/apache/lucene/analysis/Analyzer;)V > at > org.apache.jackrabbit.core.query.lucene.AbstractIndex.<init>(AbstractIndex.java:145) > at > org.apache.jackrabbit.core.query.lucene.VolatileIndex.<init>(VolatileIndex.java:65) > at > org.apache.jackrabbit.core.query.lucene.MultiIndex.resetVolatileIndex(MultiIndex.java:952) > at > org.apache.jackrabbit.core.query.lucene.MultiIndex.<init>(MultiIndex.java:298) > at > org.apache.jackrabbit.core.query.lucene.SearchIndex.doInit(SearchIndex.java:456) > at > org.apache.jackrabbit.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:59) > at > org.apache.jackrabbit.core.SearchManager.initializeQueryHandler(SearchManager.java:553) > at org.apache.jackrabbit.core.SearchManager.<init>(SearchManager.java:239) > at > org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.getSearchManager(RepositoryImpl.java:1723) > at > org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doPostInitialize(RepositoryImpl.java:1923) > at > org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:1836) > at > org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:483) > at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:324) > at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:621) > at > org.apache.jackrabbit.core.jndi.BindableRepository.createRepository(BindableRepository.java:140) > at > org.apache.jackrabbit.core.jndi.BindableRepository.init(BindableRepository.java:116) > at > org.apache.jackrabbit.core.jndi.BindableRepository.<init>(BindableRepository.java:105) > at > org.apache.jackrabbit.core.jndi.BindableRepositoryFactory.getObjectInstance(BindableRepositoryFactory.java:51) > at > org.apache.jackrabbit.core.jndi.RegistryHelper.registerRepository(RegistryHelper.java:74) > > > Thanks > Anit > > -----Original Message----- > From: Janne Jalkanen [mailto:[email protected]] > Sent: Tuesday, November 17, 2009 1:12 PM > To: [email protected] > Subject: Re: David's Model question : nt:unstructured and SNS > > > On 17 Nov 2009, at 14:50, Sandro Boehme wrote: > >> Alexander Klimetschek schrieb: >>> 2009/11/16 Fabián Mandelbaum <[email protected]>: >>>> It's simpler than fiddling around with this low-level stuff actually: >>>> >>>> Just create a DAO to abstract all JCR operations (as you should be >>>> doing already) >>> (To give my usual opinion about object content mapping and JCR:) If >>> you use DAOs this of course is a straight-forward solution (but only >>> for the code that uses the DAO layer), but I think that using JCR >>> directly is not "low-level" stuff: >> In my opinion an OCM adds statical type checking and the ability to add >> functionality (e.g. finder methods) to this types. > > JSPWiki uses a layer on top of JCR to > a) provide type/range checking for some values, and > b) to provide backwards API compatibility. > > /Janne > >
