Results 1 to 4 of 4

Thread: Urgent help: roo & Sybase Anywhere 11

  1. #1
    Join Date
    Nov 2010
    Posts
    15

    Default Urgent help: roo & Sybase Anywhere 11

    My RDBMS is up and running on port 1234.

    After setting topLevelPackage, I've entered the following:
    Code:
    persistence setup --provider HIBERNATE --database SYBASE --userName sa --password sa
    database properties set --key database.url --value jdbc:sybase:Tds:127.0.0.1:1234
    after that, database.properties content is:
    Code:
    #Updated at Fri Nov 26 14:53:54 CET 2010
    #Fri Nov 26 14:53:54 CET 2010
    database.password=sa
    database.url=jdbc\:sybase\:Tds\:127.0.0.1\:1234
    database.username=sa
    database.driverClassName=net.sourceforge.jtds.jdbc.Driver
    Everything looks OK, but command
    database introspect --schema sa
    just returns error message:
    Connection must not be null
    and nothing more! I can't make roo to work with Sybase Anywhere, any help?

  2. #2
    Join Date
    Nov 2010
    Posts
    15

    Default

    After installing 1.1.0.RELEASE, now after database introspect --schema schemaName, I'm getting the following error:
    No remote OBR repositories have matching add-ons matching your request
    JDBC driver not available for 'net.sourceforge.jtds.jdbc.Driver'

  3. #3
    Join Date
    Nov 2010
    Posts
    15

    Default

    After
    script --file install-jdbc-drivers.roo
    I'm getting the error as described in the first post.

    Maybe open source driver doesn't work well with Sybase Anywhere 11?

  4. #4
    Join Date
    Nov 2010
    Posts
    15

    Default

    @roo developers

    Accordingly to jtds.sourceforge.net/faq database url genereated by roo is invalid, it should be:
    jdbc:jtds:<server_type>://<server>[:<port>]

    With a valid url there is no error "Connection must not be null" anymore, but now I have another problem... I'm always getting error message that DB scheme not exists or is empty (which is not the case). I've tried various combinations for --scheme parameter, but without success.

    Any help??

Posting Permissions

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