Infoglue with Postgres & JBOSS

Hi All

New to hear, but I'm about to try and install infoglue on Jboss with a Postgres backend. Has anybody got any caveats I need to be on the lookout for?

Cheers

Hi,
I didn't try it with postgres + jboss but with oracle + jboss ... no major problem, just the usual configuration ...

Check that postgres jdbc connector is in WEB-INF/lib. Infoglue is packaged with different connectors : mysql, oracle, db2, sqlserver but not the psotgres one. Just drop it in WEB-INF/lib folder of each webapp.
Then, check for your database connection in each file where the connection is set in each webapp:
- WEB-INF/classes/database.xml
- WEB-INF/classes/hibernate.cfg.xml
- WEB-INF/classes/propertyset.xml

One thing to check in cms.properties :

#SET THIS TO TRUE IF YOU ARE RUNNING ORACLE OR DB2
useShortTableNames=@useShortTableNames@

If postgres works the same way as oracle ... you should set this property to the right value.

Hi thanks for that

Cheers

Hi All

It's been a while, but I'm having no luck getting infoglue to work with postgres

I've added the jdbc driver to WEB-INF/lib

Has anybody got any working copies for postgres of the following files please

WEB-INF/classes/database.xml
WEB-INF/classes/hibernate.cfg.xml
WEB-INF/classes/cms.properties
WEB-INF/classes/propertyset.xml

I've successfully amended the

oracle_infoglue_core_schema.sql
oracle_infoglue_initial_data.sql

Scripts to work with postgres, so I can successfully create the database.

Any help would be greatly appreciated.

Thanks

Tony

ignore that, can connect fine now. Just have now go back through and modify the my postgres_infoglue_core_schema.sql and quote the table, index, field identifiers, as I'm now getting issues with the case of the postgres tables, fields etc.

Yeay

Once I have it working, if anybody wants my modified sql scripts, I'll post them.

Cheers

Still not quite there

Here's the files that I've used, if anybody can pin point the last bits I'm doing wrong, I would be grateful.

Cheers

Next 3 files

This message was edited 1 time. Last update was at 20/08/2010 18:07:25

And the last 2

So if anybody has any other ideas, please let me know.

Cheers

Nobody?

Hello,

I tried to do the same thing some while ago and had the same problems

Check this post : http://sourceforge.net/projects/infoglue/forums/forum/281654/topic/1751793
I'm not sure it will work because i switched to mysql before having the suggestion, but you could give it a try

Regards
David

linuxyeti wrote:Nobody?

Can you post the exception you get - would help in understanding what is misconfigured.

Regards
Mattias Bogeblad