Configuring Sybase SQL Anywhere 11 databse server on Jboss 5.0 Application

Posted on 2010-01-06
Last Modified: 2013-12-02
I am connecting my web application which is running on JBoss 5.0 server using MySql server currently to a databsse on Sybase SQL Anywhere 11.
I have managed to run the database server and migrated my databse.. now i am stuck at configuring and connecting the database server to my application. I am using hibernate framework to handle all the databse operations.
I have configured the  sybase-ds.xml file in my jboss deploy folder.
downloaded the driver class file and stored it in my jbos/lib folder.
I dont even know whether this supports hibernate or not..
i checked the hibernate documentation... where i got the info that it is supported.

Can someone please help me with the connection and configuration..

Question by:panshul007
    LVL 11

    Accepted Solution

    I don't have sybase with me but I am sure that sybase would be supported by Hibernate. Hibernate states that it supports Sybase 12.5 (JConnect 5.5).

    The following are the broad steps that you would need to take to migrate the database; Hibernate is popular because you can move to different databases with minimal/no changes to code.

    1. Edit the hibernate-cfg.xml to change the dialect to "org.hibernate.dialect.SybaseAnywhereDialect"
    2. Change the id-generators if they are used in your hbm files to "native" so that the database specific sequence generators are picked up automatically by Hiberante.
    3. If you are using SP, mySQL specific data functions you would need to convert them to Sybase stuff.

    Let me know if you encounter specific issues that you cannot solve.
    LVL 11

    Expert Comment

    This is another custom dialects available where the Author claims he supports version 11.
    LVL 11

    Expert Comment

    All the relevant information related to the question has been provided which will enable @panshul007 to migrate the application to another database.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
    This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now