US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: JNDI and Firebird

  1. #1
    Join Date
    Jul 2006
    Posts
    3

    Default JNDI and Firebird

    Hi everybody.
    Sorry for my English, I don’t write very well.
    I’ve a problem with my connection to a firebird database. I have replied the file query1.xaction and I have made a firebird-ds.xml. But I don’t know why, that connection don’t run, and in other parts of Pentaho, I’ve managed to create reports.
    I have make a Mondrian schema, a Kettle transformation (the new database runs), but the xaction said me:
    JPivot Error ...An error happened servicing a JPivot request. Please see the server console for more details.

    When I see the server console, it’s written:
    14:40:03,125 ERROR [RequestFilter] cause java.lang.RuntimeException: Datasource java:comp/env/jdbc/firebird is not configured properly

    In the firebird-ds.xml, there is this code:
    <?xml version="1.0" encoding="UTF-8"?>
    <datasources>
    <local-tx-datasource>
    <jndi-name>firebird</jndi-name>
    <connection-url>jdbc:firebirdsql://localhost:8080/C:\\Pentaho.1.1.7\\pentaho-demo\\data\\CUBE_KETTLE.FDB
    </connection-url>
    <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
    <user-name>SYSDBA</user-name>
    <password>masterkey</password>
    </local-tx-datasource>
    </datasources>

    Is there someone who have got this problem before? I don’t see topics in the forum about JNDI and Firebird.
    Thanks for your help, have a good day
    Antoine

  2. #2
    Join Date
    Mar 2006
    Posts
    684

    Default Re:JNDI and Firebird

    I don't know much about firebird, but I did some quick googling on firebird jdbc connection string. and I looks like it runs on 3050 not 8080.

    this might be a good place for you to check out:
    http://www.firebirdsql.org/index.php?op=devel&sub=jdbc
    if you haven't already.

    Another tip that you could try is to get the Report Design Wizard to connect to it and then look at the jndi connection it creates in the $RDW/resources/solutions/system/simple-jndi/jdbc.properties. That will help make sure you put the right stuff in there as well as be able to test the connection b4 deploying the -ds.xml.

    Hope that might help you taste the happy,

    Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  3. #3
    Join Date
    Jul 2006
    Posts
    3

    Default Re:JNDI and Firebird

    Thanks.
    I've change the port number. The problem was I wrote firebird like this and not like FireBird, it's very important.
    Thanks for all

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •