Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XQuery Help and Discussion
»
postgresql
Topic
Prev Topic
Next Topic
next
Subject:
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
next
Subject:
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
top
Subject:
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
Prev Topic
Next Topic
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 to Conference:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
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.