Skip to main content



      Home
Home » Archived » BIRT » "The selected driver cannot parse the given url" error...
"The selected driver cannot parse the given url" error... [message #114738] Tue, 24 January 2006 15:36 Go to next message
Eclipse UserFriend
Hello,

I just downloaded and installed Birt 2.0 and I'm having trouble setting
up my JDBC datasource. I go into create New Data Source, select JDBC
Data Source, and enter all of my information. I added our db2java.zip
driver to the org.eclipse.birt.report.data.oda.jdbc_2.0.0\drivers
directory, and I see two new Driver Class options, and no matter what I
put in the URL field I get this error:

The selected driver cannot parse the given url

Any ideas?

Thanks!
Trent
Re: "The selected driver cannot parse the given url" error... [message #114844 is a reply to message #114738] Tue, 24 January 2006 13:45 Go to previous messageGo to next message
Eclipse UserFriend
Trent,

Did you use the Manage Drivers button on the Datasource Wizard?
Take a look at the MySql example. It shows how to add that driver.
http://www.eclipse.org/birt/examples/reports/mysql/

Jason Weathersby
BIRT PMC

"Trent Ohannessian" <tohann@gmail.com> wrote in message
news:dr6346$arl$1@utils.eclipse.org...
> Hello,
>
> I just downloaded and installed Birt 2.0 and I'm having trouble setting up
> my JDBC datasource. I go into create New Data Source, select JDBC Data
> Source, and enter all of my information. I added our db2java.zip driver
> to the org.eclipse.birt.report.data.oda.jdbc_2.0.0\drivers directory, and
> I see two new Driver Class options, and no matter what I put in the URL
> field I get this error:
>
> The selected driver cannot parse the given url
>
> Any ideas?
>
> Thanks!
> Trent
Re: "The selected driver cannot parse the given url" error... [message #115853 is a reply to message #114844] Wed, 25 January 2006 10:10 Go to previous messageGo to next message
Eclipse UserFriend
Hey Jason,

Yes, I did go through that process and I added our db2java.zip to the
JAR Files listing. This caused two new drivers to show up on the
drivers tab:

COM.ibm.db2.jdbc.app.DB2Driver ( v8.1)
and
COM.ibm.db2.jdbc.net.DB2Driver ( v8.1)

....so I think adding our driver worked. I then went back to creating my
Data Source and no matter which driver I choose and what URL I put into
the URL box, I get the stated error. I've tried the following entries
for URL, and nothing worked:

jdbc:db2://ip.address:9999/databasename
jdbc:db2://hostname:9999/databasename
jdbc:db2:databasename
jdbc:db2:databasename;port=9999

I even tried this (which I know is wrong) just to see if I can get past
the parsing error, and it still errored out.

jdbc:db2://localhost/databasename

Any other ideas? :)

Thanks for your help,
Trent

Jason Weathersby wrote:
> Trent,
>
> Did you use the Manage Drivers button on the Datasource Wizard?
> Take a look at the MySql example. It shows how to add that driver.
> http://www.eclipse.org/birt/examples/reports/mysql/
>
> Jason Weathersby
> BIRT PMC
>
> "Trent Ohannessian" <tohann@gmail.com> wrote in message
> news:dr6346$arl$1@utils.eclipse.org...
>
>>Hello,
>>
>>I just downloaded and installed Birt 2.0 and I'm having trouble setting up
>>my JDBC datasource. I go into create New Data Source, select JDBC Data
>>Source, and enter all of my information. I added our db2java.zip driver
>>to the org.eclipse.birt.report.data.oda.jdbc_2.0.0\drivers directory, and
>>I see two new Driver Class options, and no matter what I put in the URL
>>field I get this error:
>>
>>The selected driver cannot parse the given url
>>
>>Any ideas?
>>
>>Thanks!
>>Trent
>
>
>
Re: "The selected driver cannot parse the given url" error... [message #116798 is a reply to message #115853] Wed, 25 January 2006 15:52 Go to previous messageGo to next message
Eclipse UserFriend
Trent,
A couple of questions:
(1) Did you see the error message "the selected driver cannot parse the
given url" when you do "Test Connection" in the new Data Source wizard?
(2) If yes, ignore the error and proceed to create a data set based on that
jdbc data source. Does it work? If not what errors do you see?
(3) How can I obtain a copy of the db2 driver you are testing with?

thanks,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Trent Ohannessian" <tohann@gmail.com> wrote in message
news:dr84dh$phd$1@utils.eclipse.org...
> Hey Jason,
>
> Yes, I did go through that process and I added our db2java.zip to the
> JAR Files listing. This caused two new drivers to show up on the
> drivers tab:
>
> COM.ibm.db2.jdbc.app.DB2Driver ( v8.1)
> and
> COM.ibm.db2.jdbc.net.DB2Driver ( v8.1)
>
> ...so I think adding our driver worked. I then went back to creating my
> Data Source and no matter which driver I choose and what URL I put into
> the URL box, I get the stated error. I've tried the following entries
> for URL, and nothing worked:
>
> jdbc:db2://ip.address:9999/databasename
> jdbc:db2://hostname:9999/databasename
> jdbc:db2:databasename
> jdbc:db2:databasename;port=9999
>
> I even tried this (which I know is wrong) just to see if I can get past
> the parsing error, and it still errored out.
>
> jdbc:db2://localhost/databasename
>
> Any other ideas? :)
>
> Thanks for your help,
> Trent
>
> Jason Weathersby wrote:
> > Trent,
> >
> > Did you use the Manage Drivers button on the Datasource Wizard?
> > Take a look at the MySql example. It shows how to add that driver.
> > http://www.eclipse.org/birt/examples/reports/mysql/
> >
> > Jason Weathersby
> > BIRT PMC
> >
> > "Trent Ohannessian" <tohann@gmail.com> wrote in message
> > news:dr6346$arl$1@utils.eclipse.org...
> >
> >>Hello,
> >>
> >>I just downloaded and installed Birt 2.0 and I'm having trouble setting
up
> >>my JDBC datasource. I go into create New Data Source, select JDBC Data
> >>Source, and enter all of my information. I added our db2java.zip driver
> >>to the org.eclipse.birt.report.data.oda.jdbc_2.0.0\drivers directory,
and
> >>I see two new Driver Class options, and no matter what I put in the URL
> >>field I get this error:
> >>
> >>The selected driver cannot parse the given url
> >>
> >>Any ideas?
> >>
> >>Thanks!
> >>Trent
> >
> >
> >
Re: "The selected driver cannot parse the given url" error... [message #117492 is a reply to message #116798] Thu, 26 January 2006 08:52 Go to previous messageGo to next message
Eclipse UserFriend
Hey Gary,

Yes, I did see that error after doing a "Test Connection". I apologize
for not mentioning that in my previous messages. I ignored the error
and continued with the setup, created a data set and it worked! It
connected to the database and showed me the tables. I'm off and running.

If you'd still like a copy of the driver, I could email you the zip
file. It's around 1.2 meg.

Thanks!
Trent

Gary Xue wrote:
> Trent,
> A couple of questions:
> (1) Did you see the error message "the selected driver cannot parse the
> given url" when you do "Test Connection" in the new Data Source wizard?
> (2) If yes, ignore the error and proceed to create a data set based on that
> jdbc data source. Does it work? If not what errors do you see?
> (3) How can I obtain a copy of the db2 driver you are testing with?
>
> thanks,
>
Re: "The selected driver cannot parse the given url" error... [message #118001 is a reply to message #117492] Thu, 26 January 2006 15:29 Go to previous messageGo to next message
Eclipse UserFriend
This sounds like a bug in the Test Connection feature then. Can you please
file a bugzilla entry and attach your JDBC driver so we can investigate?

thanks,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Trent Ohannessian" <tohann@gmail.com> wrote in message
news:drak7a$ij9$1@utils.eclipse.org...
> Hey Gary,
>
> Yes, I did see that error after doing a "Test Connection". I apologize
> for not mentioning that in my previous messages. I ignored the error
> and continued with the setup, created a data set and it worked! It
> connected to the database and showed me the tables. I'm off and running.
>
> If you'd still like a copy of the driver, I could email you the zip
> file. It's around 1.2 meg.
>
> Thanks!
> Trent
>
> Gary Xue wrote:
> > Trent,
> > A couple of questions:
> > (1) Did you see the error message "the selected driver cannot parse the
> > given url" when you do "Test Connection" in the new Data Source wizard?
> > (2) If yes, ignore the error and proceed to create a data set based on
that
> > jdbc data source. Does it work? If not what errors do you see?
> > (3) How can I obtain a copy of the db2 driver you are testing with?
> >
> > thanks,
> >
Re: "The selected driver cannot parse the given url" error... [message #118110 is a reply to message #118001] Thu, 26 January 2006 16:08 Go to previous message
Eclipse UserFriend
Done. I just created the Bugzilla entry and attached the JDBC driver.

Gary Xue wrote:
> This sounds like a bug in the Test Connection feature then. Can you please
> file a bugzilla entry and attach your JDBC driver so we can investigate?
>
> thanks,
>
Previous Topic:openReportDesign fails in 2.0.0 (final)
Next Topic:Page control?
Goto Forum:
  


Current Time: Mon Jun 16 19:41:35 EDT 2025

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

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

Back to the top