newpowertech

Forbidden while accessing PI Server using PI JDBC

Discussion created by newpowertech on Sep 3, 2010
Latest reply on Sep 5, 2010 by hanyong

When I invoked the client that uses PI JDBC to access data, a dialog is asked to enter three piece of information:

 

Domain, username, and password.

 

As soon as I click OK, the SQLException is throw as below.

 

Sep 2, 2010 10:11:19 PM com.osisoft.jdbc.Driver connect
INFO: New Connection: jdbc:pisql://69.167.165.41/Data Source=bodopc; Integrated Security=SSPI
Sep 2, 2010 10:12:36 PM com.osisoft.jdbc.Driver connect
FINE: DAS Authentication with : RDSAAuth [69.167.165.41\energydata2/Administrator/********** ]

 

java.sql.SQLException: [PI SQL DAS gSOAP Channel] HTTP Error
Details: HTTP/1.1 403 Forbidden
 at com.osisoft.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:93)
 at com.osisoft.jdbc.Driver.connect(Driver.java:261)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at com.npt.pi.PIJDBCTest.main(PIJDBCTest.java:32)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)

Outcomes