Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Error creating ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 1970 of 2028
Post > Topic >>

Error creating connection using postgres

by sanjayt@[EMAIL PROTECTED] ("Sanjay Thomas") Jun 7, 2008 at 01:33 PM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8C875.08B9FE91
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable


Hi,

Iam trying to create a XA connection pool using postgres driver
(postgresql-8.3-603.jdbc3.jar) on Weblogic 8.1.6.0 from the Admin
Console.=0D



I have provided the following info in the JDBC config



Driver Class Name: org.postgresql.xa.PGXADataSource.=0D
JDBC URL: jdbc:postgresql://192.168.192.112:5432/sample1
UserName: postgres
Password: Postgres


When I click Test Driver Configuration. Iam getting the following error
"FATAL: database "null" does not exist"

if i change the Driver Class Name to "org.postgresql.Driver", it is
working fine. But as iam trying to create XA datasource i need to use
the XA Driver class name.

Can someone tell me how to resolve this issue?

The postgres version iam using is 8.3.1

=0D

Regards,

Sanjay



This email message and its attachments may contain CONFIDENTIAL AND=
 PRIVILEGED INFORMATION intended for the sole use of the addressee(s). If=
 you have received it in error, please contact the sender by return
email,=
 notify your system manager and destroy the original message and any
copies=
 thereof. Any review, use, disclosure or distribution is unlawful. Please=
 check this email and any attachments for the presence of viruses. The=
 Company accepts no  liability for any damage caused by any virus=
 transmitted by this email. The views or opinions presented in this
e-mail=
 are solely those of the author and do not necessarily represent those of=
 the company.
The Company reserves the right to monitor, review and store the content
of=
 all messages sent to or from this e-mail address.=0D

www.aztecsoft.com
------_=_NextPart_001_01C8C875.08B9FE91
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=
=3Dus-ascii">


<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Font Definitions */
 @[EMAIL PROTECTED]
 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Verdana;
	color:windowtext;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@[EMAIL PROTECTED]
 Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>Hi,</span></font></span><br>
<br>
<span class=3Dlw-text>Iam trying to create a XA connection pool using=
 postgres
driver (postgresql-8.3-603.jdbc3.jar) on Weblogic 8.1.6.0 from the Admin
Console. </span><br>
<br>
</p>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>I have provided the following info in the JDBC=
 config</span></font></span><br>
<br>
</p>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>Driver Class Name:=
 org.postgresql.xa.PGXADataSource. </span></font></span><br>
<span class=3Dlw-text>JDBC URL:=
 jdbc:postgresql://192.168.192.112:5432/sample1</span><br>
<span class=3Dlw-text>UserName: postgres</span><br>
<span class=3Dlw-text>Password: Postgres</span></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span style=
=3D'font-size:
12.0pt'><br>
<span class=3Dlw-text>When I click Test Driver Configuration. Iam getting=
 the
following error &quot;FATAL: database &quot;null&quot; does not=
 exist&quot;</span><br>
<br>
<span class=3Dlw-text>if i change the Driver Class Name to
&quot;org.postgresql.Driver&quot;, it is working fine. But as iam trying
to
create XA datasource i need to use the XA Driver class name.</span><br>
<br>
<span class=3Dlw-text>Can someone tell me how to resolve this=
 issue?</span><br>
<br>
<span class=3Dlw-text>The postgres version iam using is=
 8.3.1</span></span></font></p>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>&nbsp;</span></font></span></p>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>Regards,</span></font></span></p>

<p class=3DMsoNormal><span class=3Dlw-text><font size=3D3 face=3D"Times
New=
 Roman"><span
style=3D'font-size:12.0pt'>Sanjay</span></font></span></p>

</div>

</body>

</html>

<table><tr><td bgcolor=3D#ffffff><font color=3D#000000>This email message=
 and its attachments may contain CONFIDENTIAL AND PRIVILEGED INFORMATION=
 intended for the sole use of the addressee(s). If you have received it
in=
 error, please contact the sender by return email, notify your system=
 manager and destroy the original message and any copies thereof. Any=
 review, use, disclosure or distribution is unlawful. Please check this=
 email and any attachments for the presence of viruses. The Company
accepts=
 no  liability for any damage caused by any virus transmitted by this=
 email. The views or opinions presented in this e-mail are solely those
of=
 the author and do not necessarily represent those of the company.<br>
The Company reserves the right to monitor, review and store the content
of=
 all messages sent to or from this e-mail address. <br>
<br>
www.aztecsoft.com<br>
</font></td></tr></table>
------_=_NextPart_001_01C8C875.08B9FE91--
 




 1 Posts in Topic:
Error creating connection using postgres
sanjayt@[EMAIL PROTECTED]  2008-06-07 13:33:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Sep 7 6:46:02 CDT 2008.