DBRE - Null pointer

[srinivas_vsk]

Hi,

I have setup a oracle database and updated the database.properties to point to the database.

When i run database reverse engineer, i get this

dbre roo> database reverse engineer --schema app --package ~.entity
NullPointerException at org.springframework.roo.addon.jdbc.polling.interna l.PollingJdbcDriverManager.findAddOnsOffering(
PollingJdbcDriverManager.java:73)

Thanks

[MaximDim]

Same here:

db roo> database reverse engineer --package db --schema xxx
java.lang.NullPointerException
at org.springframework.roo.addon.jdbc.polling.interna l.PollingJdbcDriverManager.findAddOnsOffering(Poll ingJdbcDriver
Manager.java:73)
at org.springframework.roo.obr.internal.AddOnSearchMa nagerImpl.completeAddOnSearch(AddOnSearchManagerIm pl.java:27)
at org.springframework.roo.addon.jdbc.polling.interna l.PollingJdbcDriverManager.loadDriver(PollingJdbcD riverManager.
java:66)
at org.springframework.roo.addon.dbre.jdbc.Connection ProviderImpl.getConnection(ConnectionProviderImpl. java:40)
at org.springframework.roo.addon.dbre.jdbc.Connection ProviderImpl.getConnection(ConnectionProviderImpl. java:53)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.getConnection(DbreModelServiceImpl.java:266)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.getDatabase(DbreModelServiceImpl.java:188)
at org.springframework.roo.addon.dbre.DbreModelServic eImpl.refreshDatabase(DbreModelServiceImpl.java:14 1)
at org.springframework.roo.addon.dbre.DbreOperationsI mpl.reverseEngineerDatabase(DbreOperationsImpl.jav a:75)
at org.springframework.roo.addon.dbre.DbreCommands.se rializeDatabaseMetadata(DbreCommands.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.roo.support.util.ReflectionUti ls.invokeMethod(ReflectionUtils.java:191)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy$1.callback(ProcessMana gerHostedExec
utionStrategy.java:49)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.doTransactionally(DefaultProc essManager.ja
va:177)
at org.springframework.roo.process.manager.internal.D efaultProcessManager.execute(DefaultProcessManager .java:140)
at org.springframework.roo.process.manager.ProcessMan agerHostedExecutionStrategy.execute(ProcessManager HostedExecuti
onStrategy.java:47)
at org.springframework.roo.shell.AbstractShell.execut eCommand(AbstractShell.java:159)
at org.springframework.roo.shell.jline.JLineShell.pro mptLoop(JLineShell.java:327)
at org.springframework.roo.shell.jline.JLineShell.run (JLineShell.java:120)
at java.lang.Thread.run(Unknown Source)

[Alan Stewart]

What database are you using? We don't ship all the JDBC drivers due to their size. You will have to make sure the driver is in your maven repo

[srinivas_vsk]

Oracle

Yes i did update the pom to have the oracle driver but not clear what else is missing from the error message

[Alan Stewart]

These dependencies (from addon-jdbc) are required for Oracle:

		<dependency>
			<groupId>com.oracle.jdbc</groupId>
			<artifactId>com.springsource.oracle.jdbc</artifactId>
			<version>10.2.0.2</version>
		</dependency>
		<dependency>
			<groupId>javax.resource</groupId>
			<artifactId>com.springsource.javax.resource</artifactId>
			<version>1.5.0</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.transaction</groupId>
			<artifactId>com.springsource.javax.transaction</artifactId>
			<version>1.1.0</version>
			<scope>provided</scope>
		</dependency>

However, I don't like the NPE and will look at this
Alan

[srinivas_vsk]

well i tried with

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc5</artifactId>
<version>11.2.0.1.0</version>
<scope>provided</scope>
</dependency>

And also what you suggested to have. Still same message
Also the tab doesn't suggest what properties are needed, maybe still in works