dbTalk Databases Forums  

Configure JDBC Data Source for JasperSoft Server

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Configure JDBC Data Source for JasperSoft Server in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jorge Quintana
 
Posts: n/a

Default Configure JDBC Data Source for JasperSoft Server - 12-10-2009 , 04:33 PM






All,

I am testing JasperSoft Business Intelligence Suite, I downloaded the trial
version and I am able to run the demo application, my next step in the
evaluation is to be able to configure a Datasource for my SQL Anywhere
databsae, so i can define domains, and start creating repoorts, dashboards,
etc.

Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to
use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL
here is the info i am using

Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

where LFI_StaffCom_QA is the name of my ODBC datasource in the computer
where the JasperSoft Server is running

I am sure i am missing something here, any help will be greatly appreciated.

Thanks

Jorge

Reply With Quote
  #2  
Old   
Chris Keating (Sybase iAnywhere)
 
Posts: n/a

Default Re: Configure JDBC Data Source for JasperSoft Server - 12-10-2009 , 09:36 PM






Is the URLs use of the comma simply a typo?

What specifically is the behaviour when you attempt to connect to SQL
Anywhere using this configuration? Do you get an error or message?

-chris


Jorge Quintana wrote:
Quote:
All,

I am testing JasperSoft Business Intelligence Suite, I downloaded the trial
version and I am able to run the demo application, my next step in the
evaluation is to be able to configure a Datasource for my SQL Anywhere
databsae, so i can define domains, and start creating repoorts, dashboards,
etc.

Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to
use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL
here is the info i am using

Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

where LFI_StaffCom_QA is the name of my ODBC datasource in the computer
where the JasperSoft Server is running

I am sure i am missing something here, any help will be greatly appreciated.

Thanks

Jorge


Reply With Quote
  #3  
Old   
Glenn Paulley [Sybase iAnywhere]
 
Posts: n/a

Default Re: Configure JDBC Data Source for JasperSoft Server - 12-10-2009 , 10:32 PM



I think this

Quote:
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA
must be this

URL: jdbc:ianywhereriver=SQL Anywhere 10;DSN=LFI_StaffCom_QA

Glenn

Jorge Quintana wrote:
Quote:
All,

I am testing JasperSoft Business Intelligence Suite, I downloaded the trial
version and I am able to run the demo application, my next step in the
evaluation is to be able to configure a Datasource for my SQL Anywhere
databsae, so i can define domains, and start creating repoorts, dashboards,
etc.

Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to
use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL
here is the info i am using

Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

where LFI_StaffCom_QA is the name of my ODBC datasource in the computer
where the JasperSoft Server is running

I am sure i am missing something here, any help will be greatly appreciated.

Thanks

Jorge


--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Reply With Quote
  #4  
Old   
Jorge Quintana
 
Posts: n/a

Default Re: Configure JDBC Data Source for JasperSoft Server - 12-11-2009 , 08:16 AM



Thanks, got it to work, the comma was the problem i changed to semi colon
and is working now

"Chris Keating (Sybase iAnywhere)" <keating_nospam (AT) sybase (DOT) com> wrote in
message news:4b21be2a (AT) forums-1-dub (DOT) ..
Quote:
Is the URLs use of the comma simply a typo?

What specifically is the behaviour when you attempt to connect to SQL
Anywhere using this configuration? Do you get an error or message?

-chris


Jorge Quintana wrote:
All,

I am testing JasperSoft Business Intelligence Suite, I downloaded the
trial version and I am able to run the demo application, my next step in
the evaluation is to be able to configure a Datasource for my SQL
Anywhere databsae, so i can define domains, and start creating repoorts,
dashboards, etc.

Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want
to use JDBC but i can't get it to work, jaspersoft is asking for Driver
and URL here is the info i am using

Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

where LFI_StaffCom_QA is the name of my ODBC datasource in the computer
where the JasperSoft Server is running

I am sure i am missing something here, any help will be greatly
appreciated.

Thanks

Jorge

Reply With Quote
  #5  
Old   
Jorge Quintana
 
Posts: n/a

Default Re: Configure JDBC Data Source for JasperSoft Server - 12-11-2009 , 08:17 AM



Thanks, got it to work, the comma was the problem I changed to semi colon
and is working now

"Glenn Paulley [Sybase iAnywhere]" <paulley (AT) ianywhere (DOT) com> wrote

Quote:
I think this

URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

must be this

URL: jdbc:ianywhereriver=SQL Anywhere 10;DSN=LFI_StaffCom_QA

Glenn

Jorge Quintana wrote:
All,

I am testing JasperSoft Business Intelligence Suite, I downloaded the
trial version and I am able to run the demo application, my next step in
the evaluation is to be able to configure a Datasource for my SQL
Anywhere databsae, so i can define domains, and start creating repoorts,
dashboards, etc.

Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want
to use JDBC but i can't get it to work, jaspersoft is asking for Driver
and URL here is the info i am using

Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver
URL: jdbc:ianywhereriver=SQL Anywhere 10,DSN=LFI_StaffCom_QA

where LFI_StaffCom_QA is the name of my ODBC datasource in the computer
where the JasperSoft Server is running

I am sure i am missing something here, any help will be greatly
appreciated.

Thanks

Jorge



--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.