Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Error reading configuration: Unable to create lock manager(Trouble starting up the platform)
Error reading configuration: Unable to create lock manager [message #657458] Wed, 02 March 2011 20:26 Go to next message
Olly   is currently offline Olly Friend
Messages: 61
Registered: June 2010
Location: Florida
Member
I set my config string to
//Configure the Engine and start the Platform
config = new EngineConfig( );
config.setEngineHome( "/mydir/birt-runtime-2_6_1/ReportEngine" );
config.setLogConfig(null, Level.FINE);
Platform.startup(config);

The line Platform.startup(config) is the line that creates the error:
!ENTRY org.eclipse.osgi 4 0 2011-03-02 19:49:39.336
!MESSAGE Error reading configuration: Unable to create lock manager.
!STACK 0
java.io.IOException: Unable to create lock manager.
at org.eclipse.osgi.storagemanager.StorageManager.open(StorageM anager.java:687)
at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initFileMa nager(BaseStorage.java:213)
at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initialize (BaseStorage.java:147)
at org.eclipse.osgi.baseadaptor.BaseAdaptor.initializeStorage(B aseAdaptor.java:114)
at org.eclipse.osgi.framework.internal.core.Framework.initializ e(Framework.java:185)
at org.eclipse.osgi.framework.internal.core.Framework.<init>(Framework.java:157)
at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(Ecli pseStarter.java:286)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.doStartup( OSGILauncher.java:191)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.access$0(O SGILauncher.java:94)
at org.eclipse.birt.core.framework.osgi.OSGILauncher$1.run(OSGI Launcher.java:79)
at java.security.AccessController.doPrivileged(Native Method)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OS GILauncher.java:75)
at org.eclipse.birt.core.framework.Platform.startup(Platform.ja va:80)
at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:6 1)
at ExecuteModifiedReport.main(ExecuteModifiedReport.java:250)

What could the problem be? Any help is much appreciated as I've spent a good bit of time trying to figure this out.
Re: Error reading configuration: Unable to create lock manager [message #657460 is a reply to message #657458] Wed, 02 March 2011 20:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I assume this is on a linux/unix machine? If so does the process have
write permission on the
/mydir/birt-runtime-2_6_1/ReportEngine/configuration directory?

Jason

On 3/2/2011 3:26 PM, azuniga wrote:
> I set my config string to //Configure the Engine and start the Platform
> config = new EngineConfig( );
> config.setEngineHome( "/mydir/birt-runtime-2_6_1/ReportEngine" );
> config.setLogConfig(null, Level.FINE);
> Platform.startup(config);
>
> The line Platform.startup(config) is the line that creates the error:
> !ENTRY org.eclipse.osgi 4 0 2011-03-02 19:49:39.336
> !MESSAGE Error reading configuration: Unable to create lock manager.
> !STACK 0
> java.io.IOException: Unable to create lock manager.
> at org.eclipse.osgi.storagemanager.StorageManager.open(StorageM
> anager.java:687)
> at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initFileMa
> nager(BaseStorage.java:213)
> at org.eclipse.osgi.internal.baseadaptor.BaseStorage.initialize
> (BaseStorage.java:147)
> at org.eclipse.osgi.baseadaptor.BaseAdaptor.initializeStorage(B
> aseAdaptor.java:114)
> at org.eclipse.osgi.framework.internal.core.Framework.initializ
> e(Framework.java:185)
> at
> org.eclipse.osgi.framework.internal.core.Framework.<init>(Framework.java:157)
>
> at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(Ecli
> pseStarter.java:286)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.eclipse.birt.core.framework.osgi.OSGILauncher.doStartup(
> OSGILauncher.java:191)
> at org.eclipse.birt.core.framework.osgi.OSGILauncher.access$0(O
> SGILauncher.java:94)
> at org.eclipse.birt.core.framework.osgi.OSGILauncher$1.run(OSGI
> Launcher.java:79)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OS
> GILauncher.java:75)
> at org.eclipse.birt.core.framework.Platform.startup(Platform.ja va:80)
> at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:6 1)
> at ExecuteModifiedReport.main(ExecuteModifiedReport.java:250)
>
> What could the problem be? Any help is much appreciated as I've spent a
> good bit of time trying to figure this out.
>
Re: Error reading configuration: Unable to create lock manager [message #657686 is a reply to message #657460] Thu, 03 March 2011 16:10 Go to previous messageGo to next message
Olly   is currently offline Olly Friend
Messages: 61
Registered: June 2010
Location: Florida
Member
Jason, thanks for the quick response. as you suspected there weren't write permissions in the configuration folder and so I changed it to 777 and I don't receive that error anymore. However, my project cannot load the JDBC driver class: oracle.jdbc.driver.OracleDriver. Am I right to think that I should place the oracle.jdbc.driver.OracleDriver in the eclipse_all-in-one_with_BIRT/eclipse/plugins/org.eclipse.bir t.report.data.oda.jdbc_2.6.0.v20100524/drivers/ file? If so, I already have in there the ojdbc14.jar and i thought this was the driver. I have 2 projects, 1 that is designed using the report designer view and produces my .rptdesign. This project works fine and connects to the database and performs the queries and returns good results and my charts and graphs. I've got my Data Source set up and my data sets set up. However, my 2nd project I am trying to take this same .rptdesign and programmatically run it, using the already set up data source and data set, and this is where i am encountering problems.


The following items have errors:

Chart (id = 45):
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.

exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.execute(ExtendedGenerateExecutor.java:70)
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:77)
at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:637)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.executeQueries(ExtendedGenerateExecutor.java:205)
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.execute(ExtendedGenerateExecutor.java:65)
... 11 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne wException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:222)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:210)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:208)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:406)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:316)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:617)
... 15 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:760)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:862)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:246)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:235)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:165)
... 25 more




Chart (id = 46):
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.

exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.execute(ExtendedGenerateExecutor.java:70)
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor .execute(ExtendedItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:77)
at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:637)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.executeQueries(ExtendedGenerateExecutor.java:205)
at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec utor.execute(ExtendedGenerateExecutor.java:65)
... 11 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne wException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:222)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:210)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:208)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:406)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:316)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:617)
... 15 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:760)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:862)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:246)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:235)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:165)
... 25 more




Table (id = 4):
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.

exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1195)
at org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1174)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:96)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:77)
at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:637)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:80)
... 11 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne wException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:222)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:210)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:208)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:406)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:316)
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:617)
... 15 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find Driver(JDBCDriverManager.java:760)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi sterDriver(JDBCDriverManager.java:879)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load AndRegisterDriver(JDBCDriverManager.java:862)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:246)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)
at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:235)
at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:165)
... 25 more




Table table:
+ A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: ReferenceError: "dataSetRow" is not defined.
Script source: , line: 0, text:
dataSetRow["COUNTRY"]. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "dataSetRow" is not defined.
Script source: , line: 0, text:
dataSetRow["COUNTRY"]

What could the issue be?

[Updated on: Thu, 03 March 2011 16:58]

Report message to a moderator

Re: Error reading configuration: Unable to create lock manager [message #657709 is a reply to message #657686] Thu, 03 March 2011 16:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Do you have the driver in the jdbc plugin's drivers directory?

Jason

On 3/3/2011 11:10 AM, azuniga wrote:
> Jason, thanks for the quick response. as you suspected there weren't
> write permissions in the configuration folder and so I changed it to 777
> and I don't receive that error anymore. However, my project cannot load
> the JDBC driver class: oracle.jdbc.driver.OracleDriver. The following
> items have errors:
>
> Chart (id = 45):
> + An exception occurred during processing. Please see the following
> message for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
>
> exception.error ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.execute(ExtendedGenerateExecutor.java:70)
> at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor
> .execute(ExtendedItemExecutor.java:62)
> at org.eclipse.birt.report.engine.internal.executor.dup.Suppres
> sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
> at org.eclipse.birt.report.engine.internal.executor.l18n.Locali
> zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:65)
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:90)
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:99)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR
> un(RunAndRenderTask.java:180)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run
> (RunAndRenderTask.java:77)
> at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
> at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
> Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:637)
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteQuery(DteDataEngine.java:152)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:265)
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.executeQueries(ExtendedGenerateExecutor.java:205)
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.execute(ExtendedGenerateExecutor.java:65)
> ... 11 more
> Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne
> wException(ExceptionHandler.java:54)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:177)
> at org.eclipse.birt.data.engine.executor.DataSource.newConnecti
> on(DataSource.java:222)
> at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo
> urce.java:210)
> at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD
> ataSource(DataSourceRuntime.java:208)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour
> ce(QueryExecutor.java:406)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu
> tion(QueryExecutor.java:316)
> at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr
> eparedQuery.java:448)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr
> oduceQueryResults(PreparedDataSourceQuery.java:190)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:178)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute
> (PreparedOdaDSQuery.java:145)
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:617)
> ... 15 more
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot
> load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find
> Driver(JDBCDriverManager.java:760)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi
> sterDriver(JDBCDriverManager.java:879)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load
> AndRegisterDriver(JDBCDriverManager.java:862)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo
> nnect(JDBCDriverManager.java:246)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC
> onnection(JDBCDriverManager.java:212)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr
> l(Connection.java:235)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec
> tion.java:160)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo
> nnection.open(OdaConnection.java:250)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:165)
> ... 25 more
>
>
>
>
> Chart (id = 46):
> + An exception occurred during processing. Please see the following
> message for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
>
> exception.error ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.execute(ExtendedGenerateExecutor.java:70)
> at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor
> .execute(ExtendedItemExecutor.java:62)
> at org.eclipse.birt.report.engine.internal.executor.dup.Suppres
> sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
> at org.eclipse.birt.report.engine.internal.executor.l18n.Locali
> zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:65)
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:90)
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:99)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR
> un(RunAndRenderTask.java:180)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run
> (RunAndRenderTask.java:77)
> at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
> at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
> Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:637)
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteQuery(DteDataEngine.java:152)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:265)
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.executeQueries(ExtendedGenerateExecutor.java:205)
> at org.eclipse.birt.report.engine.executor.ExtendedGenerateExec
> utor.execute(ExtendedGenerateExecutor.java:65)
> ... 11 more
> Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne
> wException(ExceptionHandler.java:54)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:177)
> at org.eclipse.birt.data.engine.executor.DataSource.newConnecti
> on(DataSource.java:222)
> at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo
> urce.java:210)
> at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD
> ataSource(DataSourceRuntime.java:208)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour
> ce(QueryExecutor.java:406)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu
> tion(QueryExecutor.java:316)
> at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr
> eparedQuery.java:448)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr
> oduceQueryResults(PreparedDataSourceQuery.java:190)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:178)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute
> (PreparedOdaDSQuery.java:145)
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:617)
> ... 15 more
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot
> load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find
> Driver(JDBCDriverManager.java:760)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi
> sterDriver(JDBCDriverManager.java:879)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load
> AndRegisterDriver(JDBCDriverManager.java:862)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo
> nnect(JDBCDriverManager.java:246)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC
> onnection(JDBCDriverManager.java:212)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr
> l(Connection.java:235)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec
> tion.java:160)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo
> nnection.open(OdaConnection.java:250)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:165)
> ... 25 more
>
>
>
>
> Table (id = 4):
> + An exception occurred during processing. Please see the following
> message for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
>
> exception.error ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.engine.executor.ExecutionContext.add
> Exception(ExecutionContext.java:1195)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.add
> Exception(ExecutionContext.java:1174)
> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex
> ecuteQuery(QueryItemExecutor.java:96)
> at org.eclipse.birt.report.engine.executor.TableItemExecutor.ex
> ecute(TableItemExecutor.java:62)
> at org.eclipse.birt.report.engine.internal.executor.dup.Suppres
> sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
> at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe
> dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
> at org.eclipse.birt.report.engine.internal.executor.l18n.Locali
> zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
> at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking
> LM.layoutNodes(HTMLBlockStackingLM.java:65)
> at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout
> (HTMLPageLM.java:90)
> at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE
> ngine.layout(HTMLReportLayoutEngine.java:99)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR
> un(RunAndRenderTask.java:180)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run
> (RunAndRenderTask.java:77)
> at ExecuteModifiedReport.runReport(ExecuteModifiedReport.java:1 25)
> at ExecuteModifiedReport.main(ExecuteModifiedReport.java:252)
> Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An
> exception occurred during processing. Please see the following message
> for details:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:637)
> at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec
> uteQuery(DteDataEngine.java:152)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e
> xecute(AbstractDataEngine.java:265)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.exe
> cuteQuery(ExecutionContext.java:1876)
> at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex
> ecuteQuery(QueryItemExecutor.java:80)
> ... 11 more
> Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne
> wException(ExceptionHandler.java:54)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:177)
> at org.eclipse.birt.data.engine.executor.DataSource.newConnecti
> on(DataSource.java:222)
> at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo
> urce.java:210)
> at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD
> ataSource(DataSourceRuntime.java:208)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour
> ce(QueryExecutor.java:406)
> at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu
> tion(QueryExecutor.java:316)
> at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr
> eparedQuery.java:448)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr
> oduceQueryResults(PreparedDataSourceQuery.java:190)
> at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex
> ecute(PreparedDataSourceQuery.java:178)
> at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute
> (PreparedOdaDSQuery.java:145)
> at org.eclipse.birt.report.data.adapter.impl.DataRequestSession
> Impl.execute(DataRequestSessionImpl.java:617)
> ... 15 more
> Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot
> load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.find
> Driver(JDBCDriverManager.java:760)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.regi
> sterDriver(JDBCDriverManager.java:879)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.load
> AndRegisterDriver(JDBCDriverManager.java:862)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo
> nnect(JDBCDriverManager.java:246)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC
> onnection(JDBCDriverManager.java:212)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr
> l(Connection.java:235)
> at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec
> tion.java:160)
> at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo
> nnection.open(OdaConnection.java:250)
> at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o
> penConnection(ConnectionManager.java:165)
> ... 25 more
>
>
>
>
> Table table:
> + A BIRT exception occurred: Error evaluating Javascript expression.
> Script engine error: ReferenceError: "dataSetRow" is not defined.
> Script source: , line: 0, text:
> dataSetRow["COUNTRY"]. See next exception for more information.
> Error evaluating Javascript expression. Script engine error:
> ReferenceError: "dataSetRow" is not defined.
> Script source: , line: 0, text:
> dataSetRow["COUNTRY"]
> What could the issue be?
Re: Error reading configuration: Unable to create lock manager [message #657726 is a reply to message #657709] Thu, 03 March 2011 17:51 Go to previous messageGo to next message
Olly   is currently offline Olly Friend
Messages: 61
Registered: June 2010
Location: Florida
Member
I edited the post but it seems like it was after you got the chance to respond. I placed the ojdbc14.jar in the eclipse_all-in-one_with_BIRT/eclipse/plugins/org.eclipse.bir t.report.data.oda.jdbc_2.6.0.v20100524/drivers/ file? is this the correct driver? I have 2 projects, 1 that is designed using the report designer view and produces my .rptdesign. This project works fine and connects to the database and performs the queries and returns good results and my charts and graphs. I've got my Data Source set up and my data sets set up. However, my 2nd project I am trying to take this same .rptdesign and programmatically run it, using the already set up data source and data set, and this is where i am encountering problems.
Re: Error reading configuration: Unable to create lock manager [message #657729 is a reply to message #657709] Thu, 03 March 2011 18:09 Go to previous messageGo to next message
Olly   is currently offline Olly Friend
Messages: 61
Registered: June 2010
Location: Florida
Member
Alright, I ended up right clicking on the project>Run As>Run Configurations>Classpath and then adding the external jar: ojdbc14.jar to the bootstrap entries section and to the user entries section. It now works. Question is, will I have to do this for all the projects i create that will use an oracle database? Thanks for your help Jason.

-Alessandro
Re: Error reading configuration: Unable to create lock manager [message #657730 is a reply to message #657726] Thu, 03 March 2011 17:55 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If this is where you have the runtime:
config.setEngineHome( "/mydir/birt-runtime-2_6_1/ReportEngine"
The driver needs to be in the jdbc plugin's driver directory under:
config.setEngineHome(
" /mydir/birt-runtime-2_6_1/ReportEngine/plugins/--jdbcplugin- -/drivers
directory.

Jason

On 3/3/2011 12:51 PM, azuniga wrote:
> I edited the post but it seems like it was after you got the chance to
> respond. I placed the ojdbc14.jar in the
> eclipse_all-in-one_with_BIRT/eclipse/plugins/org.eclipse.bir
> t.report.data.oda.jdbc_2.6.0.v20100524/drivers/ file? is this the
> correct driver? I have 2 projects, 1 that is designed using the report
> designer view and produces my .rptdesign. This project works fine and
> connects to the database and performs the queries and returns good
> results and my charts and graphs. I've got my Data Source set up and my
> data sets set up. However, my 2nd project I am trying to take this same
> .rptdesign and programmatically run it, using the already set up data
> source and data set, and this is where i am encountering problems.
Re: Error reading configuration: Unable to create lock manager [message #657734 is a reply to message #657730] Thu, 03 March 2011 18:27 Go to previous message
Olly   is currently offline Olly Friend
Messages: 61
Registered: June 2010
Location: Florida
Member
I c, i removed the jars from the classpath and put the ojdbc14.jar in the /mydir/birt-runtime-2_6_1/ReportEngine/plugins/--jdbcplugin- -/drivers
directory and ran it to see if that would work and it did. Thx again.
Re: Error reading configuration: Unable to create lock manager [message #657737 is a reply to message #657729] Thu, 03 March 2011 18:19 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

If you put it in the runtime plugins directory you should not have to do
this.

Jason

On 3/3/2011 1:09 PM, azuniga wrote:
> Alright, I ended up right clicking on the project>Run As>Run
> Configurations>Classpath and then adding the external jar: ojdbc14.jar
> to the bootstrap entries section and to the user entries section. It now
> works. Question is, will I have to do this for all the projects i create
> that will use an oracle database? Thanks for your help Jason.
>
> -Alessandro
Previous Topic:Date comparison not working with Oracle
Next Topic:Group Header in Detail Line
Goto Forum:
  


Current Time: Tue Mar 19 11:05:09 GMT 2024

Powered by FUDForum. Page generated in 0.03679 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top