Derby connection error in BIRT [message #131921] |
Fri, 17 February 2006 02:24 |
Eclipse User |
|
|
|
Originally posted by: aimdliu.sina.com
Hi,all
I can connect derby database using IBM Cloudscape Workbench, but when i
use the database in BIRT following the step, there are some errors.
1. Go to this Data Explorer view and click on Data Sources.
2. Right-click Data Sources and select New Data Source.
3. In the list presented, select JDBC Data Source.
4. Click Next.
5. Click the Manage Drivers button.
6. Make sure the JAR Files tab is selected, and click Add.
7. Find the DB2 driver jars,select the first one, db2jcc.jar, and click
Open.
8. db2jcc.jar appears in the list of jars. Follow steps 6 and 7 again, but
this time add the db2jcc_license_c.jar file.
9. Click OK.
10.com.ibm.db2.jcc.DB2Driver (v2.4) is selected as the Driver Class.
11. Use this as the Database URL:
jdbc:derby:net://localhost:1527/PaymentDB;.
12. Input user name.
13. Input password.
14. Click the Test Connection button.
The error is"jave.net.ConnectException:error open socket to server
localhost on port 1527 with message: Connection refused: connect"
If i select "org.apache.derby.jdbc.EmbeddedDriver" in step 10, URL is:
jdbc:derby:C:\PaymentDB
The error is: failed to start Database 'C:\PaymentDB', see the next
exception for details.
Thanks in advance
Aimd
|
|
|
Re: Derby connection error in BIRT [message #131992 is a reply to message #131921] |
Fri, 17 February 2006 07:07 |
Eclipse User |
|
|
|
Originally posted by: aimdliu.sina.com
I have been working on the problem two days,
the output as follows:
org.eclipse.birt.data.engine.core.DataException: can't open driver
connection: org.eclipse.birt.report.data.oda.jdbc
can't get connection。
Failed to start database 'C:\PaymentDB', see the next exception for
details.
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:136)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:154)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:147)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:150)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:838)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:661)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.designer.internal.ui.util.DataSetMan ager.execute(DataSetManager.java:292)
at
org.eclipse.birt.report.designer.internal.ui.util.DataSetMan ager.execute(DataSetManager.java:269)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.ResultS etPreviewPage.updateResults(ResultSetPreviewPage.java:174)
at
org.eclipse.birt.report.designer.internal.ui.dialogs.ResultS etPreviewPage$4.run(ResultSetPreviewPage.java:432)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:3 5)
|
|
|
Powered by
FUDForum. Page generated in 0.02260 seconds