Converting from HSQL to Sybase

[Migrated From Jforum.net]

I'd like to implement JForum using Sybase (because we have it and use it throughout the company). What steps do I need to follow to do that? I've created the sql for the database structure and built it; then I created the sql that initializes the database and implemented that. I even created a "sybase" directory under the "WEBINF/config/database" directory and populated a sybase.properties file. But I can't seem to get back to the "install" page to implement it. I remember something about setting a field in a properties file (I think "installed=false" but I'm not sure) but can't find the appropriate file or wording. HELP!
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Forget the installer. Use manual installation for it. Much probably the installer should be updated to work with sybase, and this only worth effort after you want for sure that the implementation works 100%

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

So when you say to do it manually, I think that's what I started doing.
I created a database/sybase directory and created files sybase.properties, sybase_db_struct.sql, and sybase_data_dump.sql. I implemented the db_struct and data dump files successfully on my Sybase. Then I went into the config directory and modified the local version of the conf file (username.conf) after saving the original. In there I substituted the values that I have in the sybase.properties file. When I tried that it dumped the following error messages. So I apparently missed something.


(ForumException.java:85) at net.jforum.JForum.service(JForum.java:285) at javax.servlet.http.HttpServlet.service(HttpServlet.java:90) at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:99) at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:163) at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:208) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:259) at com.caucho.server.port.TcpConnection.run(TcpConnection.java:332) at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:457) at com.caucho.util.ThreadPool.run(ThreadPool.java:398) at java.lang.Thread.run(Thread.java:595)
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

This exception tells nothing. Are you able to put a breakpoing and debug it to see where it is breaking? or, maybe, the server logs have the complete stack trace.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Appears it was the format of my URL connection string. I had to remove the two backslashes before the hostname.

Now I get the following when the web site appears:

java.lang.reflect.InvocationTargetException: Incorrect syntax near 'LIMIT'.

By the way, how should I modify the database so that the program recognizes my login as the administrator? I'm not familiar with hsql to view it to duplicate what's in there. But if I know which table to update, I can do that in Sybase.
[originally posted on jforum.net by Anonymous]