java - Configure IReport and Firebird -


i using ireport jasper report. backend database in firebird. trying configure ireport firebird couldn't succeed. have added firebird jar file in classpath of ireport gui. after add firebird in services of ireport. services window shows me firebird driver. after when right-click on driver , connect using selected got window in have put credentials.

user nmae: sysdba password : masterkey jdbc url: jdbc:firebirdsql:localhost/3050:c:\users\waqas\desktop\mobilestore.fdb

when click on ok button. ireport goes connecting database mode , after long time didn't response. still connecting firebird.

i assuming have firebird installed , firebird running service. user account running firebird service not have access user profile , therefor unable open database file in c:\users\waqas\desktop\mobilestore.fdb. put file in location accessible users (or user linked firebird service), c:\databases\.

that said, expect scenario result in error immediately, might different problem.

edit

you indicate in comments, receive java.lang.classnotfoundexception: org.firebirdsql.jdbc.fbdriver. means did not add jaybird jdbc driver classpath of ireport.

you can download jaybird (firebird jdbc) driver http://www.firebirdsql.org/en/jdbc-driver/

i don't use ireport myself, according this tutorial can add driver under tools > options > ireport, tab classpath. need add jaybird-full-2.2.3.jar, or jaybird-2.2.3.jar , connector-api-1.5.jar (from lib folder in jaybird zip).

edit 2

i have downloaded ireport , tried myself. there 2 ways of making database connection firebird ireport, both work me:

database jdbc connection

the first option database jdbc connection, requires driver on classpath:

  1. go tools, options, ireport, classpath , add jaybird-full-2.2.3.jar
  2. click on create datasource icon on welcome tab
  3. select database jdbc connection , click next
  4. give datasource name
  5. for jdbc driver enter org.firebirdsql.jdbc.fbdriver
  6. for url enter jdbc url database (eg jdbc:firebirdsql://localhost/d:/data/db/employee.fdb)
  7. enter username , password

a click on test should show "connection test successful!". can use database connection.

netbeans database jdbc connection

the other method of connecting netbeans database jdbc connection

  1. go window, services
  2. expand databases service
  3. right click on drivers, new driver
  4. under driver file(s) add jaybird-full-2.2.3.jar
  5. driver class , name filled in automatically; click ok
  6. right click new firebird (jca/jdbc driver) entry , select connect using
  7. enter username , password, , jdbc url, click ok
  8. click create datasource icon
  9. select netbeans database jdbc connection
  10. enter name , select connection dropdown

Comments

Post a Comment