IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / That's where I got the idea
Post #81,016
by tjsinclair
2/11/03 8:40:32 PM
Reply
New That's where I got the idea
There are actually a lot of resources for hooking up MySQL to OOo, but very few for doing the same with PostgreSQL.

As a result, some of the settings I'm using are based at least partially on guesswork.

My current suspicion is that the URL or classpath settings may be at fault.

The hunt continues....
Tom Sinclair

"Everybody is someone else's weirdo."
- E. Dijkstra
Post #81,101
by morganek
2/12/03 8:05:14 AM
Reply
New Re: That's where I got the idea
In your personal OpenOffice.org1.0/user/config directory, there is a file named javarc. Have you tried putting your jdbc jar filename in the CLASSPATH defined there?

Sorry if you've already tried this as this is just a guess.

-Mike
Post #81,114
by tjsinclair
2/12/03 9:20:22 AM
Reply
New I set the class path in Tools->Options->Security
But I'll check on javarc to be sure.

No offense taken. After all, I'm just trying to learn more about this.

Tom Sinclair

"Everybody is someone else's weirdo."
- E. Dijkstra
Post #81,302
by tjsinclair
2/12/03 10:31:12 PM
Reply
New Got another clue
By digging into the error logs, I found that OOo thinks that Java isn't installed.

Yeah, that would do it.

The problem is that this is on OS X and it doesn't run the setup like the Windows or Linux versions do. I'll try running the setup manually.


More news as it happens...
Tom Sinclair

"Everybody is someone else's weirdo."
- E. Dijkstra
Post #81,305
by folkert
Picture of folkert
2/12/03 10:44:05 PM
Reply
New That'd do it...
I had to put 5 different versions on my linux box and keep switching the jvm until it saw it... ick.
b4k4^2
[link|mailto:curley95@attbi.com|greg] - Grand-Master Artist in IT
[link|http://www.iwethey.org/ed_curry/|REMEMBER ED CURRY!]   [link|http://pascal.rockford.com:8888/SSK@kQMsmc74S0Tw3KHQiRQmDem0gAIPAgM/edcurry/1//|ED'S GHOST SPEAKS!]
[link|http://www.eweek.com/article2/0,3959,857673,00.asp|Writing on wall, Microsoft to develop apps for Linux by 2004]
Heimatland Geheime Staatspolizei reminds:
These [link|http://www.whitehouse.gov/pcipb/cyberstrategy-draft.html|Civilian General Orders], please memorize them.
"Questions" will be asked at safety checkpoints.
Post #81,309
by tjsinclair
2/12/03 10:53:30 PM
Reply
New All righty now...
I ran the setup utility and tried to get it to setup Java support for me. Unfortunately, it looks like that piece is only supported in Solaris, HP-UX , Linux and others. OS X puts them in a non-standard location so OOo can't find it.

I think I'll try setting the classpath manually in a javarc file.

Meanwhile, I'm using Fink to install unixODBC so I can get some kind of connection going here. Besides, it's always good to learn something new.

Tom Sinclair

"Everybody is someone else's weirdo."
- E. Dijkstra
     OpenOffice.org/PostgreSQL/JDBC - (tjsinclair) - (7) - Feb. 11, 2003, 06:24:16 PM EST
         Synchronicity - (drewk) - (6) - Feb. 11, 2003, 07:26:34 PM EST
             That's where I got the idea - (tjsinclair) - (5) - Feb. 11, 2003, 08:40:32 PM EST
                 Re: That's where I got the idea - (morganek) - (4) - Feb. 12, 2003, 08:05:14 AM EST
                     I set the class path in Tools->Options->Security - (tjsinclair) - (3) - Feb. 12, 2003, 09:20:22 AM EST
                         Got another clue - (tjsinclair) - (2) - Feb. 12, 2003, 10:31:12 PM EST
                             That'd do it... - (folkert) - (1) - Feb. 12, 2003, 10:44:05 PM EST
                                 All righty now... - (tjsinclair) - Feb. 12, 2003, 10:53:30 PM EST

Is there an LRPDism competition going on for some reason?
82 ms