| Datasource [message #39586] |
Tue, 24 May 2005 15: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 #39678 is a reply to message #39586] |
Tue, 24 May 2005 17:13  |
| Eclipse User |
|
|
|
Originally posted by: bnowak.gfs.com
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 editors 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 #39742 is a reply to message #39586] |
Tue, 24 May 2005 18:25 |
 Scott Rosenbaum
Messages: 425
Registered: July 2009 |
Senior Member |
|
|
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 18:44 |
Scott Rosenbaum
Messages: 425
Registered: July 2009 |
Senior Member |
|
|
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 #40016 is a reply to message #39742] |
Tue, 24 May 2005 18:29 |
| Eclipse User |
|
|
|
Originally posted by: bnowak.gfs.com
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.04291 seconds
] 
Search
Help
Register
Login
Home
