Create SIARD hangs with error: Cannot read properties of null

[krosenbe]

Connecting to Oracle database, error on first table - all columns for this table are defined as not null.

Below is relevant error messages:
2025-11-20 12:02:11,397 [main] INFO com.databasepreservation.DBVTK - Starting DBVTK v3.1.7 using Java 21.0.8 with PID 7648
...
2025-11-20 12:14:44,822 [http-nio-auto-1-exec-7] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed: java.lang.NoClassDefFoundError: oracle/xml/parser/v2/XMLParseException] with root cause
java.lang.ClassNotFoundException: oracle.xml.parser.v2.XMLParseException
at java.base/java.net.URLClassLoader.findClass(Unknown Source)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at org.springframework.boot.loader.net.protocol.jar.JarUrlClassLoader.loadClass(JarUrlClassLoader.java:107)
at org.springframework.boot.loader.launch.LaunchedClassLoader.loadClass(LaunchedClassLoader.java:91)
at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
at oracle.jdbc.driver.NamedTypeAccessor$XMLFactory.createXML(NamedTypeAccessor.java:117)
at oracle.jdbc.driver.NamedTypeAccessor.getOracleObject(NamedTypeAccessor.java:236)
at oracle.jdbc.driver.NamedTypeAccessor.getString(NamedTypeAccessor.java:350)
at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:289)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:376)
at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:596)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.rawToCellUnsupportedDataType(JDBCImportModule.java:1763)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.convertRawToCell(JDBCImportModule.java:1714)
at com.databasepreservation.modules.oracle.in.Oracle12cJDBCImportModule.convertRawToCell(Oracle12cJDBCImportModule.java:307)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.convertRawToRow(JDBCImportModule.java:1660)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.migrateDatabaseTo(JDBCImportModule.java:2111)
at com.databasepreservation.DatabaseMigration.migrate(DatabaseMigration.java:123)
at com.databasepreservation.common.server.controller.SIARDController.createSIARD(SIARDController.java:350)
at com.databasepreservation.common.api.v1.MigrationResource.run(MigrationResource.java:207)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:188)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:547)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:577)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:494)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:431)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:731)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
2025-11-20 12:14:45,020 [http-nio-auto-1-exec-2] ERROR Uncaught - [0:0:0:0:0:0:0:1] Uncaught Exception: (TypeError) : Cannot read properties of null (reading 'Wg')
java.lang.Throwable: null
at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:195)
at org.springframework.validation.DataBinder.createObject(DataBinder.java:928)
at org.springframework.validation.DataBinder.construct(DataBinder.java:903)
at org.springframework.web.bind.ServletRequestDataBinder.construct(ServletRequestDataBinder.java:116)
at org.springframework.web.servlet.mvc.method.annotation.ServletModelAttributeMethodProcessor.constructAttribute(ServletModelAttributeMethodProcessor.java:157)
at org.springframework.web.method.annotation.ModelAttributeMethodProcessor.resolveArgument(ModelAttributeMethodProcessor.java:148)
at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122)
at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:224)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:178)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:547)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at com.databasepreservation.common.filter.OnOffFilter.doFilter(OnOffFilter.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:577)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:494)
at org.glassfish.jersey.servlet.ServletContainer.doFilter(ServletContainer.java:431)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:175)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:150)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:731)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:391)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:896)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)

[dosubot]

Hi @krosenbe! I'm Dosu and I’m helping the dbptk-ui team.

Your error is caused by a missing Oracle XML parser jar (such as xmlparserv2.jar or xdb6.jar) in the classpath, which is required for handling Oracle XMLType columns. The Oracle JDBC driver tries to use oracle.xml.parser.v2.XMLParseException when reading certain data types, and if that class isn't available, you'll get the NoClassDefFoundError you see, which then leads to the SIARD creation process failing and the "Cannot read properties of null" error downstream. This is a known prerequisite for Oracle exports in DBPTK and similar tools (reference).

DBPTK Desktop and UI do not provide a straightforward way to add extra jars to the classpath. The recommended approach is to use DBPTK Developer, where you can add the required Oracle jars (including the XML parser jar) to the classpath when running the migration command (reference). For example:

java -classpath /path/to/xmlparserv2.jar:/path/to/dbptk-app.jar com.databasepreservation.Main migrate ...

If you must use the UI/Desktop, a workaround is to unpack the dbvtk.war file, add the required jar to WEB-INF/libs, and repack it, but this is not officially supported and can be tricky (reference).

The "Cannot read properties of null" error is likely a side effect of the missing class, not a separate bug. Recent NPE fixes for SIARD creation are already included in your version, so the root cause is almost certainly the missing Oracle XML parser jar (reference).

To resolve: ensure all required Oracle jars, especially the XML parser jar, are present in the classpath when running DBPTK. If you need step-by-step instructions for your specific environment, let me know which Oracle JDBC driver version you are using and whether you are running DBPTK as Desktop, UI, or Developer.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}    

[luis100]

Sure, we accept pull-requests.

[krosenbe]

@MilaCodesIt,

The table in question has an Oracle XMLType column.

I got notification from @dosu (dosubot) indicating that this is a known issue with Oracle missing a JDBC library (xmlparserv2.jar).

Unfortunately, I'm unable to use DBPTK Developer and have not been successful at unpacking dbvtk.war, adding the jar, and repacking.

I could use detailed instructions for how to do this - or a new version of DBPTK with the XML parser jar included...

[dosubot]

The error is due to the missing Oracle XML parser jar (like xmlparserv2.jar), which is required for Oracle XMLType columns. DBPTK UI/Desktop doesn't have a built-in way to add extra jars, but you can work around this by modifying the dbvtk.war file. Here’s a step-by-step guide (reference):

1. Backup your existing dbvtk.war file.
2. Rename dbvtk.war to dbvtk.zip.
3. Extract the contents of dbvtk.zip to a folder.
4. Copy your xmlparserv2.jar (or the required Oracle XML parser jar) into the WEB-INF/lib directory inside the extracted folder.
5. Repack the contents back into a zip file. Make sure you select the contents of the extracted folder (not the folder itself) when zipping, so the structure matches the original war.
6. Rename the new zip file back to dbvtk.war.
7. Replace the original dbvtk.war with your modified one.

Tips:

• On Windows, use 7-Zip or a similar tool that preserves the directory structure. On Linux/macOS, you can use the zip command.
• If the application fails to start after repacking, double-check that the WEB-INF/lib directory is at the correct level in the war and that you didn’t accidentally nest folders.
• This process is not officially supported and can break the app if not done carefully (reference).

Legal note: The DBPTK team cannot distribute Oracle jars like xmlparserv2.jar due to Oracle’s licensing restrictions. You must obtain the jar from Oracle and add it yourself (reference).

If you let me know your OS (Windows, Linux, macOS), I can provide more tailored command-line instructions.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}

   

[luis100]

DBPTK UI/Desktop uses Spring Boot underneath, that could be configured to run with configurable classpath instead of "java -jar" command. https://medium.com/@mak0024/provide-external-jars-for-the-spring-boot-application-c65821ce6368

Then, a folder could be elected to have user provided jars, and the initialization script should be updated to list and include of these user provided jars in the java command:
https://github.com/keeps/dbptk-desktop/blob/master/app/components/dbvtk.js#L151

[krosenbe]

I didn't quite follow how to modify SpringBoot configuration... Tried the developer version and specified the missing xmlparserv2.jar with the following command line and got the same error as my original post:

java -cp "E:\app\xmlparserv2.jar" -Dfile.encoding=UTF-8 -jar dbptk-app-4.0.0.jar -i oracle -is xxx -ii xxx -iu xxx -ip "xxx" -ipn 1521 -ial -e siard-2 -ef "xxx" -ec -ep -emd "xxx" -ema "xxx" -emdo "xxx" -emdot "xxx" -emcm xxx

[krosenbe]

Here's the error message I received:
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/xml/binxml/BinXMLMetadataProvider
at oracle.jdbc.driver.NamedTypeAccessor$XMLFactory.createXML(NamedTypeAccessor.java:117)
at oracle.jdbc.driver.NamedTypeAccessor.getOracleObject(NamedTypeAccessor.java:236)
at oracle.jdbc.driver.NamedTypeAccessor.getString(NamedTypeAccessor.java:350)
at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:289)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:376)
at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:596)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.rawToCellUnsupportedDataType(JDBCImportModule.java:1763)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.convertRawToCell(JDBCImportModule.java:1714)
at com.databasepreservation.modules.oracle.in.Oracle12cJDBCImportModule.convertRawToCell(Oracle12cJDBCImportModule.java:307)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.convertRawToRow(JDBCImportModule.java:1660)
at com.databasepreservation.modules.jdbc.in.JDBCImportModule.migrateDatabaseTo(JDBCImportModule.java:2111)
at com.databasepreservation.DatabaseMigration.migrate(DatabaseMigration.java:123)
at com.databasepreservation.Main.runMigration(Main.java:295)
at com.databasepreservation.Main.internalMain(Main.java:125)
at com.databasepreservation.Main.main(Main.java:81)
Caused by: java.lang.ClassNotFoundException: oracle.xml.binxml.BinXMLMetadataProvider
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:641)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:188)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:526)
... 15 more

[luis100]

You can't mix "-cp" and "-jar". So you need to add dbptk-app-4.0.0.jar also to cp and also identify the main class.

Checkout this instructions: https://github.com/keeps/dbptk-developer?tab=readme-ov-file#example-to-convert-from-oracle-to-siard2

[dosubot]

Hi, @krosenbe. I'm Dosu, and I'm helping the dbptk-ui team manage their backlog and am marking this issue as stale.

Issue Summary:

• You reported failures creating an SIARD from an Oracle DB due to missing Oracle XML parser classes.
• The root cause was missing Oracle XML parser jars (e.g., xmlparserv2.jar) needed for Oracle XMLType columns.
• Suggestions included adding these jars to the classpath via DBPTK Developer or by unpacking and modifying dbvtk.war for UI/Desktop.
• Clarifications on the correct Java command syntax for including external jars were provided.
• The issue was resolved by successfully adding the required jars and running the tool with the correct setup.

Next Steps:

• Please confirm if this issue is still relevant with the latest version of dbptk-ui by commenting below.
• If no further updates are provided, I will automatically close this issue in 7 days.

Thank you for your understanding and contribution!