objectbridge-developers

[OJB-developers] db-setup.sql

[Chris G. <CGr...@de...>]

I modified the db-setup.sql file this weekend to add support for Microsoft
SQL Server.  If there aren't any problems, could it be included in the next
release?

It also works with the modified build script I submitted -- those scripts
will replace $JDBCDRIVER$ and $JDBCURL$ with the values from the
build.properties file, before using the ScriptTool.

Regards,

Chris Greenlee

[OJB-developers] db-setup.sql

[David S. T. <da...@bl...>]

Hi,

There is a strange (to me) format to the db-setup.sql file, prefixed
commands like:

e CREATE TABLE OJB_HL_SEQ (

Guessing there is some database-agnostic-script runner tool or
something...If so, how do I run it?
Is there documentation?

I've started to make my own database, and Im wondering how much of the
db-setup.sql file I will actually need.
Assuming I need everything from here down:

;;;;;;;;;;;;;;;;;;;;;;;;
;;;;;;;;;;;;;;;;;;;;;;;;
; OJB internal tables, do not modify !!!

Only added these two tables thus far, which were necessary for inserts
with autoincrement fields:

 CREATE TABLE OJB_SEQ (
 CREATE TABLE OJB_HL_SEQ (

Thanks,

David

Re: [OJB-developers] db-setup.sql

[Thomas M. <tho...@ho...>]

Hi David,

David Sean Taylor wrote:

 > Hi,
 >
 > There is a strange (to me) format to the db-setup.sql file, prefixed
 > commands like:
 >
 > e CREATE TABLE OJB_HL_SEQ (
 >
 > Guessing there is some database-agnostic-script runner tool or


right! DB setup is performed by build.sh tests


 > something...If so, how do I run it?
 > Is there documentation?
 >


please refer to the rdbms-support.html file in the src/doc folder

HTH,

Thomas


 > I've started to make my own database, and Im wondering how much of the
 > db-setup.sql file I will actually need.
 > Assuming I need everything from here down:
 >
 > ;;;;;;;;;;;;;;;;;;;;;;;;
 > ;;;;;;;;;;;;;;;;;;;;;;;;
 > ; OJB internal tables, do not modify !!!
 >
 > Only added these two tables thus far, which were necessary for inserts
 > with autoincrement fields:
 >
 >  CREATE TABLE OJB_SEQ (
 >  CREATE TABLE OJB_HL_SEQ (
 >
 > Thanks,
 >




 > David
 >
 >
 >
 > _______________________________________________
 > Objectbridge-developers mailing list
 > Obj...@li...
 > https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
 >
 >
 >
 >

[OJB-developers] db-setup.sql

[Georg S. <ge...@me...>]

Hi,

when checking out a fresh version from the repository and running
build.sh junit, I get the following error

BUILD FAILED

/people/georg/tmp/ojb/ojb-1-0/build.xml:205: Could not find file
/people/georg/tmp/ojb/ojb-1-0/target/src/test/setup/db-setup.sql to copy.

Where did that file go?

Cheers

Georg