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.112: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.112: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.112: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.112: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.112: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.
