[Middlegen-user] getting started - sybase

[Lister, Tom (ANTS)]

Hi
I'm trying to work through the getting started using Sybase
When running create-tables I get an error
jdbc:sybase:Tds:ants503:4201/sabre

Although the airline-sybase.sql file can be run OK in SQLAdvantage.

If I move on to run middlegen against the database having created the tables
by hand then I get the error
BUILD FAILED
file:C:/middlegen-2.0-b1/samples/build.xml:86: middlegen.MiddlegenException:
Middlegen successfully connected to the database, but c
ouldn't find any tables. Perhaps the specified schema or catalog is wrong?
-Or maybe there aren't any tables in the database at all?
Even though tables are visible via other tools

Any ideas chaps

:-) Tom Lister
* ***@ants.co.uk
* 020 775 65014




***************************************************************************
This communication (including any attachments) contains confidential information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents. Please notify the sender immediately of the error.

Internet communications are not necessarily secure and may be intercepted or changed after they are sent. Abbey National Treasury Services plc does not accept liability for any loss you may suffer as a result of interception or any liability for such changes. If you wish to confirm the origin or content of this communication, please contact the sender by using an alternative means of communication.

This communication does not create or modify any contract and, unless otherwise stated, is not intended to be contractually binding.

Abbey National Treasury Services plc. Registered Office: Abbey National House, 2 Triton Square, Regents Place, London NW1 3AN. Registered in England under Company Registration Number: 2338548. Regulated by the Financial Services Authority (FSA).
***************************************************************************

[Lister, Tom (ANTS)]

Whoops

Create tables error is

BUILD FAILED

file:C:/middlegen-2.0-b1/samples/build.xml:66:
com.sybase.jdbc2.jdbc.SybSQLException: Incorrect syntax near 'go'.



:-) Tom Lister
* ***@ants.co.uk
* 020 775 65014

-----Original Message-----
From: Lister, Tom (ANTS) [mailto:***@ants.co.uk]
Sent: 30 October 2003 15:49
To: 'middlegen-***@lists.sourceforge.net'
Subject: [Middlegen-user] getting started - sybase



Hi

I'm trying to work through the getting started using Sybase

When running create-tables I get an error

jdbc:sybase:Tds:ants503:4201/sabre

Although the airline-sybase.sql file can be run OK in SQLAdvantage.

If I move on to run middlegen against the database having created the tables
by hand then I get the error

BUILD FAILED

file:C:/middlegen-2.0-b1/samples/build.xml:86: middlegen.MiddlegenException:
Middlegen successfully connected to the database, but c

ouldn't find any tables. Perhaps the specified schema or catalog is wrong?
-Or maybe there aren't any tables in the database at all?

Even though tables are visible via other tools

Any ideas chaps

:-) Tom Lister

* ***@ants.co.uk

* 020 775 65014



***************************************************************************
This communication (including any attachments) contains confidential
information. If you are not the intended recipient and you have received
this communication in error, you should destroy it without copying,
disclosing or otherwise using its contents. Please notify the sender
immediately of the error.

Internet communications are not necessarily secure and may be intercepted or
changed after they are sent. Abbey National Treasury Services plc does not
accept liability for any loss you may suffer as a result of interception or
any liability for such changes. If you wish to confirm the origin or content
of this communication, please contact the sender by using an alternative
means of communication.

This communication does not create or modify any contract and, unless
otherwise stated, is not intended to be contractually binding.

Abbey National Treasury Services plc. Registered Office: Abbey National
House, 2 Triton Square, Regents Place, London NW1 3AN. Registered in England
under Company Registration Number: 2338548. Regulated by the Financial
Services Authority (FSA).
***************************************************************************



***************************************************************************
This communication (including any attachments) contains confidential information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents. Please notify the sender immediately of the error.

Internet communications are not necessarily secure and may be intercepted or changed after they are sent. Abbey National Treasury Services plc does not accept liability for any loss you may suffer as a result of interception or any liability for such changes. If you wish to confirm the origin or content of this communication, please contact the sender by using an alternative means of communication.

This communication does not create or modify any contract and, unless otherwise stated, is not intended to be contractually binding.

Abbey National Treasury Services plc. Registered Office: Abbey National House, 2 Triton Square, Regents Place, London NW1 3AN. Registered in England under Company Registration Number: 2338548. Regulated by the Financial Services Authority (FSA).
***************************************************************************

[Eivind Waaler]

I'm guessing that the schema or catalog settings are incorrect. Try
setting these in the sybase.xml file.

Also make sure, in the samples/build.xml file, that the attributes from
the database xml file are used:

<middlegen
appname="${name}"
prefsdir="${src.dir}"
gui="${gui}"
databaseurl="${database.url}"
initialContextFactory="${java.naming.factory.initial}"
providerURL="${java.naming.provider.url}"
datasourceJNDIName="${name}.database"
driver="${database.driver}"
username="${database.userid}"
password="${database.password}"
schema="${database.schema}"
catalog="${database.catalog}"
You could also try with removing the schema and/or catalog params to the
<middlegen> task in the build.xml file. This has been known to cause
problems, apparently for some drivers there's a different if the get "" or
null specified as schema/catalog.

.eivind

Post by Lister, Tom (ANTS)
Hi
I'm trying to work through the getting started using Sybase
When running create-tables I get an error
jdbc:sybase:Tds:ants503:4201/sabre
Although the airline-sybase.sql file can be run OK in SQLAdvantage.
If I move on to run middlegen against the database having created the tables
by hand then I get the error
BUILD FAILED
Middlegen successfully connected to the database, but c
ouldn't find any tables. Perhaps the specified schema or catalog is wrong?
-Or maybe there aren't any tables in the database at all?
Even though tables are visible via other tools
Any ideas chaps
:-) Tom Lister
* 020 775 65014
***************************************************************************
This communication (including any attachments) contains confidential information. If you are not the intended recipient and you have received this communication in error, you should destroy it without copying, disclosing or otherwise using its contents. Please notify the sender immediately of the error.
Internet communications are not necessarily secure and may be intercepted or changed after they are sent. Abbey National Treasury Services plc does not accept liability for any loss you may suffer as a result of interception or any liability for such changes. If you wish to confirm the origin or content of this communication, please contact the sender by using an alternative means of communication.
This communication does not create or modify any contract and, unless otherwise stated, is not intended to be contractually binding.
Abbey National Treasury Services plc. Registered Office: Abbey National House, 2 Triton Square, Regents Place, London NW1 3AN. Registered in England under Company Registration Number: 2338548. Regulated by the Financial Services Authority (FSA).
***************************************************************************