Win a copy of Fixing your Scrum this week in the Agile forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

Converting from HSQL to Sybase

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
I guess I've been abducted by space aliens. So unprofessional. They tried to probe me with this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic