XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
andy standleySubject: postgresql
Author: andy standley
Date: 07 Oct 2008 09:51 PM
Running build 1050g

I am trying to connect to postgresql using jdbc in xquery

In the RelationalDB in file explorer I create a new server

I use the classpath postgresql-8.0-322.jdbc3.jar

I enter the url (it becomes jdbc:postgres://XX.XX.X.XXX/mydb

and I get shown the database and schema and tables

but when I try and drag the schema into an xquery mapper I get

FATAL: database "mydb;DatabaseName=mydb" does not exist

so it looks like it is appending to the url wrongly as shown in the details:

org.postgresql.util.PSQLException: FATAL: database "mydb;DatabaseName=mydb" does not exist

at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:444)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:99)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)

at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)

at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:29)

at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:386)

at org.postgresql.Driver.connect(Driver.java:260)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:84)

at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:120)


I can get DB2 working fine!!

andy

Postnext
Ivan PedruzziSubject: postgresql
Author: Ivan Pedruzzi
Date: 08 Oct 2008 10:11 AM
Hi Andy,

If I remeber correclty the PostreSQL JDBC URL requires a question mark at the end. Could you try the following?

//XX.XX.X.XXX/mydb?

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
andy standleySubject: postgresql
Author: andy standley
Date: 08 Oct 2008 04:46 PM
Ivan - you are a marvel! Thanks, and sorry for not picking this up somewhere in the guides.

andy

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.