jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpares <bpa...@indra.es>
Subject Cannot insert null ("SYSTEM"."REP_FSENTRY"."FSENTRY_NAME")
Date Fri, 16 Mar 2007 09:05:19 GMT

Hi, i'm trying to initiate a connection with oracle from my java program. I
have been modifying repository.xml but when  i run 

Repository repository = new TransientRepository();
    		session = repository.login(
                    new SimpleCredentials(username,
password.toCharArray()));

i have this exception:

ERROR - failed to create folder entry: /
java.sql.SQLException: ORA-01400: no se puede realizar una inserción NULL en
("SYSTEM"."REP_FSENTRY"."FSENTRY_NAME")

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
	at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
	at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:862)
	at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1846)
	at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1771)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2361)
	at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.createDeepFolder(DbFileSystem.java:1306)
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.verifyRoodExists(DbFileSystem.java:1279)
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.init(DbFileSystem.java:363)
	at
org.apache.jackrabbit.core.fs.db.OracleFileSystem.init(OracleFileSystem.java:109)
	at
org.apache.jackrabbit.core.config.FileSystemConfig.init(FileSystemConfig.java:57)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:271)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:141)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:83)
	at
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:240)
	at
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:261)
	at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:329)
	at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:359)
	at adap.FirstHop.loginJackRabbit(FirstHop.java:55)
	at adap.FirstHop.main(FirstHop.java:37)
ERROR - failed to initialize file system
org.apache.jackrabbit.core.fs.FileSystemException: failed to create folder
entry: /
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.createDeepFolder(DbFileSystem.java:1310)
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.verifyRoodExists(DbFileSystem.java:1279)
	at
org.apache.jackrabbit.core.fs.db.DbFileSystem.init(DbFileSystem.java:363)
	at
org.apache.jackrabbit.core.fs.db.OracleFileSystem.init(OracleFileSystem.java:109)
	at
org.apache.jackrabbit.core.config.FileSystemConfig.init(FileSystemConfig.java:57)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryConfig.java:271)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:141)
	at
org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:83)
	at
org.apache.jackrabbit.core.TransientRepository$2.getRepository(TransientRepository.java:240)
	at
org.apache.jackrabbit.core.TransientRepository.startRepository(TransientRepository.java:261)
	at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:329)
	at
org.apache.jackrabbit.core.TransientRepository.login(TransientRepository.java:359)
	at adap.FirstHop.loginJackRabbit(FirstHop.java:55)
	at adap.FirstHop.main(FirstHop.java:37)
Caused by: java.sql.SQLException: ORA-01400: no se puede realizar una
inserción NULL en ("SYSTEM"."REP_FSENTRY"."FSENTRY_NAME")

if its helps, i show here my repositoy.xml

<Repository>


    <!--
        virtual file system where the repository stores global state
        (e.g. registered namespaces, custom node types, etc.)
    -->
		<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
						<param name="url"
value="jdbc:oracle:thin://@192.168.12.100:1521:simge"/>
                <param name="user" value="system"/>
                <param name="password" value="simgeume"/>
                <param name="schemaObjectPrefix" value="rep_"/>
    </FileSystem>

    
    <!--
        security configuration
    -->
    <Security appName="Jackrabbit">
        <!--
            access manager:
            class: FQN of class implementing the AccessManager interface
        -->
        <AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
            <!-- <param name="config" value="${rep.home}/access.xml"/> -->
        </AccessManager>

        <LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
           <!-- anonymous user name ('anonymous' is the default value) -->
           <param name="anonymousId" value="anonymous"/>
           <!--
              default user name to be used instead of the anonymous user
              when no login credentials are provided (unset by default)
           -->
           <!-- <param name="defaultUserId" value="superuser"/> -->
        </LoginModule>
    </Security>

    <!--
        location of workspaces root directory and name of default workspace
    -->
    <Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
    <!--
        workspace configuration template:
        used to create the initial workspace if there's no workspace yet
    -->
    <!--<Workspace name="${wsp.name}">-->
    <Workspace name="rep">
        <!--
            virtual file system of the workspace:
            class: FQN of class implementing the FileSystem interface
        -->
        <!--<FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>-->
        
        <FileSystem
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
					<param name="url"
value="jdbc:oracle:thin://@192.168.12.100:1521:simge"/>
                <param name="user" value="system"/>
                <param name="password" value="simgeume"/>
                <param name="schemaObjectPrefix" value="rep_"/>
    		</FileSystem>

        <!--
            persistence manager of the workspace:
            class: FQN of class implementing the PersistenceManager
interface
        -->
        <PersistenceManager
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
					    	<param name="url"
value="jdbc:oracle:thin://@192.168.12.100:1521:simge"/>
                <param name="user" value="system"/>
                <param name="password" value="simgeume"/>
                <param name="schemaObjectPrefix" value="${wsp.name}_"/>
                <!--<param name="schemaObjectPrefix" value="rep_"/>-->
                <param name="externalBLOBs" value="false"/>
         </PersistenceManager> 

        
        
        <!--
            Search index and the file system it uses.
            class: FQN of class implementing the QueryHandler interface
        -->
        <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <!--<param name="path" value="${wsp.home}/index"/>-->
            <param name="path" value="rep/index"/>
        </SearchIndex>
    </Workspace>

    <!--
        Configures the versioning
    -->
    <Versioning rootPath="${rep.home}/version">
        <!--
            Configures the filesystem to use for versioning for the
respective
            persistence manager
        -->
        
         <FileSystem
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
								<param name="url"
value="jdbc:oracle:thin://@192.168.12.100:1521:simge"/>
                <param name="user" value="system"/>
                <param name="password" value="simgeume"/>
                <param name="schemaObjectPrefix" value="rep_"/>
    		</FileSystem>
        
        <!--
            Configures the persistence manager to be used for persisting
version state.
            Please note that the current versioning implementation is based
on
            a 'normal' persistence manager, but this could change in future
            implementations.
        -->
        <PersistenceManager
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
					    	<param name="url"
value="jdbc:oracle:thin://@192.168.12.100:1521:simge"/>
                <param name="user" value="system"/>
                <param name="password" value="simgeume"/>
                <param name="schemaObjectPrefix" value="rep_"/>
                <!--<param name="schemaObjectPrefix"
value="${wsp.name}_"/>-->
                <param name="externalBLOBs" value="false"/>
         </PersistenceManager> 
    </Versioning>
    
    

    <!--
        Search index for content that is shared repository wide
        (/jcr:system tree, contains mainly versions)
    -->
    <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name="path" value="${rep.home}/repository/index"/>
    </SearchIndex>
</Repository>

what am i missing?

thanks!!

-- 
View this message in context: http://www.nabble.com/Cannot-insert-null-%28%22SYSTEM%22.%22REP_FSENTRY%22.%22FSENTRY_NAME%22%29-tf3413326.html#a9510888
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


Mime
View raw message