| Datasource [message #39586] |
Tue, 24 May 2005 11:14  |
Eclipse User |
|
|
|
Originally posted by: bnowak.gfs.com
Hey,
I'm running throught the BIRT tutorial but would like to use my own data
source. I'm having trouble setting up the data source. This is probably
pretty simple but I'm new to Eclipse and have been out of programming for
a bit.
Anyway, I had no problem defining drivers and setting up data connections
for the SQL Explorer plug-in! Can I leverage these?
Anyway, I would like to connect to either a Progress or an Oracle DB
initially.
Thanks,
b5
|
|
|
|
| Re: Datasource [message #39742 is a reply to message #39586] |
Tue, 24 May 2005 14:25  |
| Eclipse User |
|
|
|
Barry,
In short you need to create a new data source.
Select Jdbc Data Source from the New Data Source wizard.
Click on the Manage Drivers button.
Add your jar ojdbc14.jar file, ($ORA_HOME/jdbc/lib/ojdbc14.jar should be
available if you have installed Oracle client)
The database URL will look like: jdbc:oracle:thin:@server:1521:tlps
(where server is the server name, 1521 is the port, and tlps is instance
name).
That should do it,
Scott Rosenbaum
BIRT PMC
Barry wrote:
> Hey,
>
> I'm running throught the BIRT tutorial but would like to use my own
> data source. I'm having trouble setting up the data source. This is
> probably pretty simple but I'm new to Eclipse and have been out of
> programming for a bit.
>
> Anyway, I had no problem defining drivers and setting up data
> connections for the SQL Explorer plug-in! Can I leverage these?
>
> Anyway, I would like to connect to either a Progress or an Oracle DB
> initially.
>
> Thanks,
>
> b5
>
|
|
|
| Re: Datasource [message #39865 is a reply to message #39678] |
Tue, 24 May 2005 14:44 |
| Eclipse User |
|
|
|
Okay,
Problem is that you have an older build. I am running on the latest code
in CVS, which should be the same as last nights build. It seems fairly
stable. I think that this feature is in the M3 build too. There is a way
that you can configure drivers in the older builds, but since all of
that has been removed, it is not really worth going into.
Scott Rosenbaum
BIRT PMC
Barry wrote:
> OK, I tried following the instructions under the installation
> instructions,
> "You will likely want to use your own JDBC driver with BIRT. Use the
> data source editor�s JDBC driver management wizard. To start the
> wizard, open a BIRT report design, go to the Data Explorer view, right
> click on �Data Sources� and select �New Data Source�. Choose �JDBC
> Data Source� and click �Next�. In the next dialog, choose �Manage
> Drivers�� to bring up the �Manage JDBC Drivers� dialog.
> In the �JAR Files� tab, click on �Add�� to add the JAR file required
> by your JDBC driver. Then go to the �Driver� tab to confirm that the
> list of drivers includes the new drivers added. You may also want to
> assign a display name and URL template for the new drivers in this tab."
>
> I don't get the an option to choose "Manage Drivers..."
> b5
>
>
|
|
|
|
| Re: Datasource [message #40140 is a reply to message #40016] |
Tue, 24 May 2005 15:46 |
| Eclipse User |
|
|
|
Barry,
I may be wrong but I don't think there is any real difference between a
jar file and a zip file, other than a jar file is supposed to contain
java classes. I think that BIRT should support *.zip files. If you
could file a bugzilla entry that would be great.
https://bugs.eclipse.org/bugs/query.cgi
Just a note, the BIRT developers are really working hard to close out
all of the active bugs right now. They may get a little over-zealous
and just close your bug as a WONTFIX since it is not a huge priority.
If you enter the bug as an enhancement, there is a good chance that it
will get fixed in the next release of the product.
Scott Rosenbaum
BIRT PMC
Barry wrote:
> Thanks Scott!
>
> I got it working by downloading the m3 build of Birt and installing.
> Everything worked pretty well from there except I learned a couple of
> things. (This is pretty green stuff and is kind of funny.)
>
> First, when you start Eclipse with the '-clean' extension it cleans
> everything! Is there anyway to retrieve some of my preferences or
> connection info for the SQLExplorer plugin?
>
> If not no big deal, just curious. I can rebuild it...
>
> Also, when adding a driver the only option available in the file type
> is '*.jar'. Some of our drivers are in *.zip files. I threw them in
> a new folder and renamed them with the .zip extension. Seems to be
> working fine, but will it cause any problems later? Would it be
> possible to add the '*.zip' extension to the file type list? (Or is
> this a horribly foolish idea?)
>
> Thanks again.
>
> b5
>
|
|
|
Powered by
FUDForum. Page generated in 0.04658 seconds
Home